INSTITUTION_TBL (SQL Table)	Index Back
Institution Table The INSTITUTION_TBL defines the institutions that will be using this database (i.e. multiple institutions can operate out of the same database). Additional information specific to each institution is also captured here. Security within the database ensures that only information and prompt table values that are appropriate for a specific institution will be displayed.

INSTITUTION_TBL

(SQL Table)

Institution Table

The INSTITUTION_TBL defines the institutions that will be using this database (i.e. multiple institutions can operate out of the same database). Additional information specific to each institution is also captured here. Security within the database ensures that only information and prompt table values that are appropriate for a specific institution will be displayed.

Related Language Record: INSTITUTION_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Institution field to store institution information in campus solution system.

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
Default Value: INSTITUTION_TBL.DESCR

6 DESCRFORMAL Character(50) VARCHAR2(50) NOT NULL Formal Description field
Default Value: INSTITUTION_TBL.DESCR

7 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

8 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

9 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

10 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

11 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

12 CITY Character(30) VARCHAR2(30) NOT NULL City

13 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1

14 NUM2 Character(4) VARCHAR2(4) NOT NULL Number 2

15 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference

16 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1

17 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2

18 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3

19 COUNTY Character(30) VARCHAR2(30) NOT NULL County

20 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: %EDIT_STATE

21 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

22 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code

23 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
Y/N Table Edit
Default Value: Y

24 GRADING_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme

25 GRADING_BASIS Character(3) VARCHAR2(3) NOT NULL Grading Basis

26 GRADING_BASIS_SCH Character(3) VARCHAR2(3) NOT NULL School Grading Basis

27 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

28 STDNT_SPEC_PERM Character(1) VARCHAR2(1) NOT NULL Student Specific Permissions
Y/N Table Edit
Default Value: N

29 AUTO_ENRL_WAITLIST Character(1) VARCHAR2(1) NOT NULL Flag to indicate auto enrollment from waiting list.
Y/N Table Edit
Default Value: Y

30 RESIDENCY_REQ Character(1) VARCHAR2(1) NOT NULL Residency Coding required flag
Default Value: Y

31 FA_WDCAN_RSN Character(3) VARCHAR2(3) NOT NULL FA Withdraw Cancel Reason

32 ENRL_ACTION_REASON Character(4) VARCHAR2(4) NOT NULL This field is used to store the Enrollment Action reason.

33 FACILITY_CONFLICT Character(1) VARCHAR2(1) NOT NULL Status of Facility
Y/N Table Edit

34 NSLC_AGD_RULE Character(1) VARCHAR2(1) NOT NULL AGD Rule

35 NSLC_MONTH_FACTOR Number(3,0) SMALLINT NOT NULL NSLC Month Factor

36 STDNT_ATTR_COHORT Character(4) VARCHAR2(4) NOT NULL Student Attribute for Cohort

37 CLASS_MTG_ATND_TYP Character(4) VARCHAR2(4) NOT NULL Class Meeting Attendance Type

38 FICE_CD Character(6) VARCHAR2(6) NOT NULL FICE Code

39 LOAD_CALC_APPLY Character(1) VARCHAR2(1) NOT NULL Calculate Workload
Y/N Table Edit
Default Value: N

40 FULLTIME_LIMIT_PCT Number(6,2) DECIMAL(5,2) NOT NULL Full-Time Assignment Limit
Default Value: 100

41 FULLTIM_LIMIT_WARN Number(6,2) DECIMAL(5,2) NOT NULL Full Time Warning Limit.
Default Value: 100

42 PARTTIME_LIMIT_PCT Number(6,2) DECIMAL(5,2) NOT NULL Parttime limit
Default Value: 100

43 PARTTIM_LIMIT_WARN Number(6,2) DECIMAL(5,2) NOT NULL Part-Time Warning Limit
Default Value: 100

44 ASSIGN_TYPE Character(3) VARCHAR2(3) NOT NULL This field is used to store the Assignment Type value.

45 INSTRUCTOR_CLASS Character(6) VARCHAR2(6) NOT NULL Instructor Assignment Class value.

46 CRSE_CNTCT_HRS_PCT Number(3,0) SMALLINT NOT NULL Course Component Workload Hours

47 UNITS_ACAD_PRG_PCT Number(3,0) SMALLINT NOT NULL Academic Progress Units

48 LMS_FILE_TYPE Character(3) VARCHAR2(3) NOT NULL LMS extract file type: XML compliant, Blackboard specific, and WebCT specific

49 PHONE_TYPE Character(4) VARCHAR2(4) NOT NULL phone type field to store value of phone type.
BUSN=Business Phone
CAMP=Campus
CELL=Cellular Phone
DFLT=Default
DORM=Dormitory
FAX=FAX
HOME=Home Phone
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work

50 ADDR_USAGE Character(10) VARCHAR2(10) NOT NULL This field is used to store the Address/Email/Phone Usage values.

51 REPEAT_ENRL_CTL Character(1) VARCHAR2(1) NOT NULL This field is used to store the Process Enrollment value.
Default Value: N

52 REPEAT_ENRL_SUSP Character(1) VARCHAR2(1) NOT NULL Temprory Suspension Rpeat Check on Enrolment Flag
Y/N Table Edit
Default Value: N

53 REPEAT_GRD_CK Character(1) VARCHAR2(1) NOT NULL Repeat Grade Check

54 REPEAT_GRD_SUSP Character(1) VARCHAR2(1) NOT NULL Temprory Suspension Rpeat check on Grading
Y/N Table Edit
Default Value: N

55 GRAD_NAME_CHG Character(1) VARCHAR2(1) NOT NULL This field is being added to the INSTITUTION_TBL to allow institutions to control whether or not students are allowed to change their degree name on-line. The Degree name is the name printed on their degrees.
Y/N Table Edit
Default Value: N

56 PRINT_NID Character(1) VARCHAR2(1) NOT NULL Print National ID
Y/N Table Edit
Default Value: Y

57 REPEAT_CHK_TOPIC Character(1) VARCHAR2(1) NOT NULL Field used to store the value to Repeat Check at Topic Level.
Y/N Table Edit
Default Value: N

58 SCC_AUS_DEST Character(1) VARCHAR2(1) NOT NULL Enable Australia Features
Y/N Table Edit
Default Value: N

59 SCC_CAN_GOV_RPT Character(1) VARCHAR2(1) NOT NULL Enable Canada Features
Y/N Table Edit
Default Value: N

60 SCC_NZL_ENR Character(1) VARCHAR2(1) NOT NULL Enable New Zealand Features
Y/N Table Edit
Default Value: N

61 SCC_NZL_NZQA Character(1) VARCHAR2(1) NOT NULL Enable New Zealand features.
Y/N Table Edit
Default Value: N

62 SSR_USE_WEEKS Character(1) VARCHAR2(1) NOT NULL Use weeks in faculty workload calculations.
Y/N Table Edit
Default Value: Y

63 SSR_ENBL_ACAD_PROG Character(1) VARCHAR2(1) NOT NULL This field is used to select the Academic Program during Enrollment.
Y/N Table Edit
Default Value: N

64 SSR_CLASS_CANC_ENR Character(1) VARCHAR2(1) NOT NULL Drop Related Components value.
Y/N Table Edit
Default Value: Y

65 SSR_CLASS_CANC_NON Character(1) VARCHAR2(1) NOT NULL Drop Related Components.
Y/N Table Edit
Default Value: Y

66 EXT_USERID_OPT Character(1) VARCHAR2(1) NOT NULL Field to store the User ID Extract Option values.

67 LMS_PROVIDER Character(30) VARCHAR2(30) NOT NULL This field is used to store the Provider value.

68 E_ADDR_TYPE Character(4) VARCHAR2(4) NOT NULL Address type field used in HD_360_RESPONSE_SYNC message.
BUSN=Business
CAMP=Campus
DORM=Dorm
HOME=Home
OTHR=Other

69 SCC_HE_USED_NLD Character(1) VARCHAR2(1) NOT NULL Higher Education
Y/N Table Edit
Default Value: N

70 SSR_RPT_MATCH_OPT Character(1) VARCHAR2(1) NOT NULL Repeat Check Grade Matching Option

71 SSR_RPT_TRF_OPT Character(1) VARCHAR2(1) NOT NULL Transfer Credit run option
Y/N Table Edit
Default Value: Y

72 SAD_SL_PARTICIPANT Character(1) VARCHAR2(1) NOT NULL Studielink Participant
Y/N Table Edit
Default Value: N

73 SAA_AARPT_TYPE Character(5) VARCHAR2(5) NOT NULL The field is used to track the specific advising report type used for student self service advisement reports.

74 SAA_PLNRRPT_TYPE Character(5) VARCHAR2(5) NOT NULL The field is used to track the specific advising report type used for student self service planner reports.

75 SAA_WHIFRPT_TYPE Character(5) VARCHAR2(5) NOT NULL The field is used to track the specific advising report type used for student self service what-if reports.

76 SSR_RPT_DATE_ENRL Character(1) VARCHAR2(1) NOT NULL This flag is used in Institution to indicate On Enrollment Process
Y/N Table Edit
Default Value: Y

77 SSR_RPT_DATE_PROC Character(1) VARCHAR2(1) NOT NULL On Repeat Process
Y/N Table Edit
Default Value: N

78 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

79 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

80 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

81 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

82 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

83 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Institution field to store institution information in campus solution system.
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: INSTITUTION_TBL.DESCR
6	DESCRFORMAL	Character(50)	VARCHAR2(50) NOT NULL	Formal Description field Default Value: INSTITUTION_TBL.DESCR
7	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
8	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
9	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
10	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
11	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
12	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
13	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
14	NUM2	Character(4)	VARCHAR2(4) NOT NULL	Number 2
15	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat Reference WW=House Trailer Reference
16	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
17	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
18	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
19	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
20	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: %EDIT_STATE
21	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
22	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
23	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit Default Value: Y
24	GRADING_SCHEME	Character(3)	VARCHAR2(3) NOT NULL	Grading Scheme
25	GRADING_BASIS	Character(3)	VARCHAR2(3) NOT NULL	Grading Basis
26	GRADING_BASIS_SCH	Character(3)	VARCHAR2(3) NOT NULL	School Grading Basis
27	CAMPUS	Character(5)	VARCHAR2(5) NOT NULL	Campus
28	STDNT_SPEC_PERM	Character(1)	VARCHAR2(1) NOT NULL	Student Specific Permissions Y/N Table Edit Default Value: N
29	AUTO_ENRL_WAITLIST	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate auto enrollment from waiting list. Y/N Table Edit Default Value: Y
30	RESIDENCY_REQ	Character(1)	VARCHAR2(1) NOT NULL	Residency Coding required flag Default Value: Y
31	FA_WDCAN_RSN	Character(3)	VARCHAR2(3) NOT NULL	FA Withdraw Cancel Reason
32	ENRL_ACTION_REASON	Character(4)	VARCHAR2(4) NOT NULL	This field is used to store the Enrollment Action reason.
33	FACILITY_CONFLICT	Character(1)	VARCHAR2(1) NOT NULL	Status of Facility Y/N Table Edit
34	NSLC_AGD_RULE	Character(1)	VARCHAR2(1) NOT NULL	AGD Rule
35	NSLC_MONTH_FACTOR	Number(3,0)	SMALLINT NOT NULL	NSLC Month Factor
36	STDNT_ATTR_COHORT	Character(4)	VARCHAR2(4) NOT NULL	Student Attribute for Cohort
37	CLASS_MTG_ATND_TYP	Character(4)	VARCHAR2(4) NOT NULL	Class Meeting Attendance Type
38	FICE_CD	Character(6)	VARCHAR2(6) NOT NULL	FICE Code
39	LOAD_CALC_APPLY	Character(1)	VARCHAR2(1) NOT NULL	Calculate Workload Y/N Table Edit Default Value: N
40	FULLTIME_LIMIT_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Full-Time Assignment Limit Default Value: 100
41	FULLTIM_LIMIT_WARN	Number(6,2)	DECIMAL(5,2) NOT NULL	Full Time Warning Limit. Default Value: 100
42	PARTTIME_LIMIT_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Parttime limit Default Value: 100
43	PARTTIM_LIMIT_WARN	Number(6,2)	DECIMAL(5,2) NOT NULL	Part-Time Warning Limit Default Value: 100
44	ASSIGN_TYPE	Character(3)	VARCHAR2(3) NOT NULL	This field is used to store the Assignment Type value.
45	INSTRUCTOR_CLASS	Character(6)	VARCHAR2(6) NOT NULL	Instructor Assignment Class value.
46	CRSE_CNTCT_HRS_PCT	Number(3,0)	SMALLINT NOT NULL	Course Component Workload Hours
47	UNITS_ACAD_PRG_PCT	Number(3,0)	SMALLINT NOT NULL	Academic Progress Units
48	LMS_FILE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	LMS extract file type: XML compliant, Blackboard specific, and WebCT specific
49	PHONE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	phone type field to store value of phone type. BUSN=Business Phone CAMP=Campus CELL=Cellular Phone DFLT=Default DORM=Dormitory FAX=FAX HOME=Home Phone MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex WORK=Work
50	ADDR_USAGE	Character(10)	VARCHAR2(10) NOT NULL	This field is used to store the Address/Email/Phone Usage values.
51	REPEAT_ENRL_CTL	Character(1)	VARCHAR2(1) NOT NULL	This field is used to store the Process Enrollment value. Default Value: N
52	REPEAT_ENRL_SUSP	Character(1)	VARCHAR2(1) NOT NULL	Temprory Suspension Rpeat Check on Enrolment Flag Y/N Table Edit Default Value: N
53	REPEAT_GRD_CK	Character(1)	VARCHAR2(1) NOT NULL	Repeat Grade Check
54	REPEAT_GRD_SUSP	Character(1)	VARCHAR2(1) NOT NULL	Temprory Suspension Rpeat check on Grading Y/N Table Edit Default Value: N
55	GRAD_NAME_CHG	Character(1)	VARCHAR2(1) NOT NULL	This field is being added to the INSTITUTION_TBL to allow institutions to control whether or not students are allowed to change their degree name on-line. The Degree name is the name printed on their degrees. Y/N Table Edit Default Value: N
56	PRINT_NID	Character(1)	VARCHAR2(1) NOT NULL	Print National ID Y/N Table Edit Default Value: Y
57	REPEAT_CHK_TOPIC	Character(1)	VARCHAR2(1) NOT NULL	Field used to store the value to Repeat Check at Topic Level. Y/N Table Edit Default Value: N
58	SCC_AUS_DEST	Character(1)	VARCHAR2(1) NOT NULL	Enable Australia Features Y/N Table Edit Default Value: N
59	SCC_CAN_GOV_RPT	Character(1)	VARCHAR2(1) NOT NULL	Enable Canada Features Y/N Table Edit Default Value: N
60	SCC_NZL_ENR	Character(1)	VARCHAR2(1) NOT NULL	Enable New Zealand Features Y/N Table Edit Default Value: N
61	SCC_NZL_NZQA	Character(1)	VARCHAR2(1) NOT NULL	Enable New Zealand features. Y/N Table Edit Default Value: N
62	SSR_USE_WEEKS	Character(1)	VARCHAR2(1) NOT NULL	Use weeks in faculty workload calculations. Y/N Table Edit Default Value: Y
63	SSR_ENBL_ACAD_PROG	Character(1)	VARCHAR2(1) NOT NULL	This field is used to select the Academic Program during Enrollment. Y/N Table Edit Default Value: N
64	SSR_CLASS_CANC_ENR	Character(1)	VARCHAR2(1) NOT NULL	Drop Related Components value. Y/N Table Edit Default Value: Y
65	SSR_CLASS_CANC_NON	Character(1)	VARCHAR2(1) NOT NULL	Drop Related Components. Y/N Table Edit Default Value: Y
66	EXT_USERID_OPT	Character(1)	VARCHAR2(1) NOT NULL	Field to store the User ID Extract Option values.
67	LMS_PROVIDER	Character(30)	VARCHAR2(30) NOT NULL	This field is used to store the Provider value.
68	E_ADDR_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address type field used in HD_360_RESPONSE_SYNC message. BUSN=Business CAMP=Campus DORM=Dorm HOME=Home OTHR=Other
69	SCC_HE_USED_NLD	Character(1)	VARCHAR2(1) NOT NULL	Higher Education Y/N Table Edit Default Value: N
70	SSR_RPT_MATCH_OPT	Character(1)	VARCHAR2(1) NOT NULL	Repeat Check Grade Matching Option
71	SSR_RPT_TRF_OPT	Character(1)	VARCHAR2(1) NOT NULL	Transfer Credit run option Y/N Table Edit Default Value: Y
72	SAD_SL_PARTICIPANT	Character(1)	VARCHAR2(1) NOT NULL	Studielink Participant Y/N Table Edit Default Value: N
73	SAA_AARPT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	The field is used to track the specific advising report type used for student self service advisement reports.
74	SAA_PLNRRPT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	The field is used to track the specific advising report type used for student self service planner reports.
75	SAA_WHIFRPT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	The field is used to track the specific advising report type used for student self service what-if reports.
76	SSR_RPT_DATE_ENRL	Character(1)	VARCHAR2(1) NOT NULL	This flag is used in Institution to indicate On Enrollment Process Y/N Table Edit Default Value: Y
77	SSR_RPT_DATE_PROC	Character(1)	VARCHAR2(1) NOT NULL	On Repeat Process Y/N Table Edit Default Value: N
78	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
79	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
80	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
81	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
82	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
83	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time