INSTITUTION_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION
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(6)	VARCHAR2(6) 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: STATE_TBL
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
24	GRADING_SCHEME	Character(3)	VARCHAR2(3) NOT NULL	Grading Scheme
25	GRADING_BASIS	Character(3)	VARCHAR2(3) NOT NULL	Grading Basis ANC=ABC/NC Grading AUD=Audit BMT=Multi-Term Course: Not Graded CNC=Credit / No Credit EQV=Equivalent GRD=Graded HSC=Hundred Point Scale (NLD) LAW=Law MED=Medical School Grades NOG=No Grade Associated NON=Non-Graded Component NQF=NQF Scale OPT=Student Option PNP=Pass/Not Pass SUS=Satisfactory/Unsatisfactory TRN=Transfer Grading Basis TSC=Ten Point Scale (NLD)
26	GRADING_BASIS_SCH	Character(3)	VARCHAR2(3) NOT NULL	School Grading Basis
27	CAMPUS	Character(5)	VARCHAR2(5) NOT NULL	Campus Prompt Table: CAMPUS_TBL
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	Auto Enroll from Wait List Y/N Table Edit Default Value: Y
30	RESIDENCY_REQ	Character(1)	VARCHAR2(1) NOT NULL	Requires Residency Coding N=Not Required Y=Required 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	Enrollment Action Reason
33	FACILITY_CONFLICT	Character(1)	VARCHAR2(1) NOT NULL	Status of Facility Y/N Table Edit Default Value: INSTALLATION_SA.FACILITY_CONFLICT
34	NSLC_AGD_RULE	Character(1)	VARCHAR2(1) NOT NULL	AGD Rule E=Use Expected Grad Term T=Use Term End Date Default Value: E
35	NSLC_MONTH_FACTOR	Number(3,0)	SMALLINT NOT NULL	NSC 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 Assigned FTE % 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	Part-Time Assigned FTE % 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	Assignment Type NON=Not Included in Workload
45	INSTRUCTOR_CLASS	Character(6)	VARCHAR2(6) NOT NULL	Instructor Assignment Class
46	CRSE_CNTCT_HRS_PCT	Number(3,0)	SMALLINT NOT NULL	Course Component Workload Hrs%
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 BKB=Blackboard CourseInfo 4 WCT=API Input (old WebCT format) XML=XML V1.1 (req to authenticate)
49	PHONE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Phone Type BUSN=Business CAMP=Campus CELL=Mobile DORM=Dormitory FAX=FAX HOME=Home MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex WORK=Work
50	ADDR_USAGE	Character(10)	VARCHAR2(10) NOT NULL	Address Usage
51	REPEAT_ENRL_CTL	Character(1)	VARCHAR2(1) NOT NULL	Process on Enrollment N=No Y=Yes Default Value: N
52	REPEAT_ENRL_SUSP	Character(1)	VARCHAR2(1) NOT NULL	Temp Susp Rpt Ck on Enrl Y/N Table Edit Default Value: N
53	REPEAT_GRD_CK	Character(1)	VARCHAR2(1) NOT NULL	Repeat Grade Check A=All Courses N=Never O=Only Repeat Candidates Default Value: A
54	REPEAT_GRD_SUSP	Character(1)	VARCHAR2(1) NOT NULL	Temp Susp Rpt Ck 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 on Enrl. Ver Y/N Table Edit Default Value: Y
57	REPEAT_CHK_TOPIC	Character(1)	VARCHAR2(1) NOT NULL	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	NZQA 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	Select Acad Prog During Enroll Y/N Table Edit Default Value: N
64	SSR_CLASS_CANC_ENR	Character(1)	VARCHAR2(1) NOT NULL	Drop Related Components 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	UserID Extract Option E=EmplID U=UserID
67	LMS_PROVIDER	Character(30)	VARCHAR2(30) NOT NULL	Provider for Authentication
68	E_ADDR_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Email Type BUSN=Business CAMP=Campus DORM=Dormitory 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 B=Best grade W=Worst grade Default Value: B
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	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