BUS_UNIT_TBL_RP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTION_TBL
4	CAN_GOV_SCHOOL_CD	Character(15)	VARCHAR2(15) NOT NULL	Institution Code Sac-r75-19990831 Prompt Table: CAN_GOV_SCHOOL
5	PROVINCE	Character(6)	VARCHAR2(6) NOT NULL	Province Prompt Table: PROVINCE_VW
6	CAN_PROG_DUR_UNIT	Character(2)	VARCHAR2(2) NOT NULL	Duration Units SAC-R75-19990831 08=Weeks 09=Months 10=Half-Semesters 15=Semesters or Trimesters 25=Academic Years 30=Years 98=Not Applicable
7	CAN_PROG_CRED_UNIT	Character(2)	VARCHAR2(2) NOT NULL	SAC-R75-19990831 01=Credits 02=Credit Hours 03=Semester Hours 04=Course Hours 05=Credit Points 06=Courses 07=Student Contact Hours 96=Other Units 98=Not Applicable
8	CAN_PROG_MAN_UNIT	Character(2)	VARCHAR2(2) NOT NULL	Sac-r75-19990831 06=Hours 07=Days 08=Weeks 09=Months 10=Half-Semesters 15=Semesters or Trimesters 25=Academic Years 30=Years 96=Other Units 97=OJT Category Unknown 98=Not Applicable 99=Duration Unknown
9	CAN_PROG_OPT_UNIT	Character(2)	VARCHAR2(2) NOT NULL	Sac-r75-19990831 06=Hours 07=Days 08=Weeks 09=Months 10=Half-Semesters 15=Semesters or Trimesters 25=Academic Years 30=Years 96=Other Units 97=OJT Category Unknown 98=Not Applicable 99=Duration Unknown
10	CAN_PROG_MANU_UNIT	Character(2)	VARCHAR2(2) NOT NULL	Man. Unpaid OJT Duration Units Sac-r75-19990831 06=Hours 07=Days 08=Weeks 09=Months 10=Half-Semesters 15=Semesters or Trimesters 25=Academic Years 30=Years 96=Other Units 97=OJT Category Unknown 98=Not Applicable 99=Duration Unknown
11	CAN_PROG_OPTU_UNIT	Character(2)	VARCHAR2(2) NOT NULL	Optional Unpaid OJT Dur Units Sac-r75-19990831 06=Hours 07=Days 08=Weeks 09=Months 10=Half-Semesters 15=Semesters or Trimesters 25=Academic Years 30=Years 96=Other Units 97=OJT Duration Unknown 98=Not Applicable 99=Duration unknown
12	CAN_CRSE_DUR_UNIT	Character(2)	VARCHAR2(2) NOT NULL	Duration Units Sac-r75-19990831 06=Hours 07=Days 08=Weeks 09=Months 10=Half-Semesters 15=Semesters or Trimesters 25=Academic Years 30=Years 96=Other units 98=Not Applicable
13	CAN_CRSE_CRED_UNIT	Character(2)	VARCHAR2(2) NOT NULL	Course Credits Sac-r75-19990831 01=Credits 02=Credit Hours 03=Semester Hours 04=Course Hours 05=Credit Points 06=Courses 07=Student Contact Hours 96=Other Units 98=Not Applicable
14	CAN_CRSE_LAB_UNIT	Character(2)	VARCHAR2(2) NOT NULL	Sac-r75-19990831 06=Hours 07=Days 08=Weeks 09=Months 10=Half-Semesters 15=Semesters or Trimesters 25=Academic Years 30=Years 96=Other Units or No Set Duration 97=Unknown if Course Includes Lab 98=Not Applicable 99=Duration Unknown
15	CAN_CRSE_OJT_UNIT	Character(2)	VARCHAR2(2) NOT NULL	Sac-r75-19990831 06=Hours 07=Days 08=Weeks 09=Months 10=Half-Semesters 15=Semesters or Trimesters 25=Academic Years 30=Years 96=Other Units or No Set Duration 97=Unknown if Course Includes OJT 98=Not Applicable 99=Duration Unknown
16	CAN_ESIS_TYP_STUD	Character(2)	VARCHAR2(2) NOT NULL	ID Type Sac-r75-19990831 01=Assigned by Institution 02=Provincial student ID number 96=Other
17	CAN_ESIS_REC_TYP	Character(2)	VARCHAR2(2) NOT NULL	Sac-r75-19990831 03=Receiving Instit Course Code 04=Receiving Instit Program Code 05=Block Transfer Code 08=Non-Standard Target Course 09=Non-Standard Target Program 10=Unspecified Block Transfer 96=Other Type of Code
18	CAN_ESIS_HONOR	Character(1)	VARCHAR2(1) NOT NULL	Sac-r75-19990831 Y/N Table Edit Default Value: N
19	CAN_ESIS_SND_TYP	Character(2)	VARCHAR2(2) NOT NULL	Course Type Sac-r75-19990831 01=Sending Institutions Course Cd 02=Sending Institutions Prog Cd 05=Block Transfer Code 06=Unspecified Course Credit 07=Unspecified Prog Credit 10=Unspecified Block Transfer 96=Other Type of Code
20	CAN_ESIS_INST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Institution Type C=Community College T=Trade and Vocational Inst U=University Default Value: U