CAN_RPT_PLN_TBL (SQL Table)	Index Back
USIS Plan Mapping Table SACE98-D NEW: SR40 Cdn Reporting Requirements - USIS Plan Mapping Table SAC-R75-19990831

CAN_RPT_PLN_TBL

(SQL Table)

USIS Plan Mapping Table

SACE98-D NEW: SR40 Cdn Reporting Requirements - USIS Plan Mapping Table SAC-R75-19990831

# 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
Prompt Table: INSTITUTION_TBL

2 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
Prompt Table: ACAD_PLAN_TBL

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

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

5 CAN_QUALIF Character(2) VARCHAR2(2) NOT NULL Qualifications being sought
Prompt Table: CAN_RPT_QUALIF

6 CAN_FIN_QUALIF Character(2) VARCHAR2(2) NOT NULL Qualification Being Sought
Prompt Table: CAN_RPT_QUALIF

7 CAN_AWABOD Character(1) VARCHAR2(1) NOT NULL Awarding Body
1=Degree Granting Institution
2=Professional or Prov Granted
3=Degree Granting & Professional
8=Not Applicable
9=Not Reported

8 CAN_QUACOD Character(3) VARCHAR2(3) NOT NULL Title of qualification
Prompt Table: CAN_RPT_QUACOD

9 CAN_HONIND Character(1) VARCHAR2(1) NOT NULL Honors programme indicator
1=Single Honours
2=Double Combined/Joint Honours
3=Bachelor Degree - Honours
4=Bachelor Degree - No Honours
8=Not in Bachelor Degree

10 CAN_SPEMAJ Character(5) VARCHAR2(5) NOT NULL Major field of study
Prompt Table: CAN_RPT_SPEMAJ
Set Control Field: CAN_SPEMAJ

11 CAN_SESTYP Character(2) VARCHAR2(2) NOT NULL Type of session
01=Calendar Year
03=Calendar Months
11=Academic Year
22=Semester
32=Trimester
44=Summer Session
80=Other

12 CAN_SESTOT Number(2,0) SMALLINT NOT NULL Number of Sessions.

13 CAN_NORMCR Number(4,0) SMALLINT NOT NULL Normal Requirements

14 CAN_FORPOS Number(3,0) SMALLINT NOT NULL Cdn Reporting - Forpos
Prompt Table: CAN_RPT_FORPOS

15 CAN_BIU_WEIGHT Signed Number(6,3) DECIMAL(4,3) NOT NULL Cdn Reporting - Annual Weight

16 CAN_FT_LOAD Number(5,3) DECIMAL(4,3) NOT NULL Full Time Load

17 CAN_TERM_WGHT Number(5,3) DECIMAL(4,3) NOT NULL Cdn Reporting - Term Weight

18 CAN_MET_FORM_FEE Number(4,0) SMALLINT NOT NULL Cdn Reporting - MET Form Fee

19 CAN_MIN_BIU Signed Number(7,3) DECIMAL(5,3) NOT NULL Cdn Reporting - Minimum BIU

20 CAN_MAX_BIU Signed Number(7,3) DECIMAL(5,3) NOT NULL Cdn Reporting - Maximum BIU

21 CAN_INELIG_BIU Character(1) VARCHAR2(1) NOT NULL Cdn Rpt - Ineligible BIU fund
Y/N Table Edit
Default Value: N

22 CAN_OUAC_UPREG Character(3) VARCHAR2(3) NOT NULL Univ & Program Registered

23 CAN_PROG_CRED_TYP Character(2) VARCHAR2(2) NOT NULL SAC-R75-19990831
01=General Equivalency
02=Certificate
03=Diploma
04=Degree
05=Declaration of Achievement
06=Other PostSecondary
07=Other Non-PostSecondary
08=Other Undergraduate Level
09=Other Graduate Level
10=Attest and Other Short Prog
11=Associate Degree
96=Other Type of Credential
97=Other Type of Credential
98=Not Applicable

24 CAN_PROG_JOINT_TYP Character(2) VARCHAR2(2) NOT NULL SAC-R75-19990831
01=General Equivalency
02=Certificate
03=Diploma
04=Degree
05=Declaration of Achievement
06=Other PostSecondary
07=Other Non PostSecondary
08=Other Undergraduate Level
09=Other Graduate Level
10=Attest and Other Short Prog
11=Associate Degree
96=Other Type of Credential
97=Other Type of Credential
98=Not Applicable

25 CAN_PROG_PROG_LVL Character(2) VARCHAR2(2) NOT NULL SAC-R75-19990831

26 CAN_PROG_JOINT_LVL Character(2) VARCHAR2(2) NOT NULL SAC-R75-19990831

27 CAN_PROG_SESS_TYPE Character(2) VARCHAR2(2) NOT NULL SAC-R75-19990831
05=Summer Sessions Only
07=Intersessions Only
08=Weeks
09=Months
10=Quarters
15=Semesters or Trimesters
25=Academic Years(8 months)
30=Years (12 months)
96=Other
98=Not Applicable

28 CAN_PROV_FUND_CD Character(6) VARCHAR2(6) NOT NULL * Sac-r75-19990831
Prompt Table: CAN_PROV_FUND

29 CAN_PROV_PROG_CAT Character(8) VARCHAR2(8) NOT NULL * Sac-r75-19990831
Prompt Table: CAN_PROV_PROG

30 CAN_PROG_CAPACITY Number(5,0) INTEGER NOT NULL Sac-r75-19990831

31 CAN_PROG_CONTRACT Character(1) VARCHAR2(1) NOT NULL Contract Delivery Sac-r75-19990831
1=Yes
2=No
8=Not Applicable
9=Unknown
N=No (A)
U=Unknown (A)
W=Not Applicable (A)
Y=Yes (A)

32 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
Default Value: BUS_UNIT_TBL_RP.CAN_PROG_CRED_UNIT

33 CAN_PROG_CREDIT Number(9,2) DECIMAL(8,2) NOT NULL SAC-R75-19990831

34 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
Default Value: BUS_UNIT_TBL_RP.CAN_PROG_DUR_UNIT

35 CAN_PROG_DURATION Number(7,2) DECIMAL(6,2) NOT NULL Program Duration SAC-R75-19990831

36 CAN_PROG_FULL_PART Character(1) VARCHAR2(1) NOT NULL SAC-R75-19990831
1=Offered on FullTime Basis Only
2=Offered on PartTime Basis Only
3=Offered Full Time or Part Time
8=Not Applicable
9=Unknown

37 CAN_PROG_HOURS Number(5,0) INTEGER NOT NULL SAC-R75-19990831

38 CAN_PROG_LIM_ENRL Character(1) VARCHAR2(1) NOT NULL Sac-r75-19990831
1=Yes-Institution Set Limit
2=Yes-Professional Org Set Limit
3=Yes-Government Set Limit
6=No
8=Not Applicable
9=Unknown

39 CAN_PROG_APT_ENT Character(1) VARCHAR2(1) NOT NULL Sac-r75-19990831
1=Yes
2=No
8=Not Applicable
9=Unknown
N=No (A)
U=Unknown (A)
W=Not Applicable (A)
Y=Yes (A)

40 CAN_PROG_EDU_ENT Character(2) VARCHAR2(2) NOT NULL SAC-R75-19990831
13=High School Diploma
14=High School Matriculation
18=Some Secondary Education
19=Primary/Elementary Education
21=Registered Apprenticeship
22=Trade/Vocational Certificate
23=College PostSecond Certificate
24=College PostSecondary Diploma
28=Other College Level
29=Non-Prof Health Certif
41=Bachelor's Degree
42=First Prof Degree
46=Undergraduate Certificate
47=Undergraduate Dilpoma
48=Other Undergraduate Credential
49=Some Udergraduate Level
51=Master's Degree
52=Graduate Level Certificate
53=Graduate Level Diploma
54=Ph.D
55=Equivalent Earned Doctorate
58=Other Graduate Credential
59=Some Graduate Level
96=Other Level
98=No Entrance Requirement
99=Unknown

41 CAN_PROG_EXP_ENT Character(1) VARCHAR2(1) NOT NULL Experience Requirement Sac-r75-19990831
1=Yes
2=No
8=Not Applicable
9=Unknown
N=No (A)
U=Unknown (A)
W=Not Applicable (A)
Y=Yes (A)

42 CAN_PROG_LEG_ENT Character(1) VARCHAR2(1) NOT NULL SAC-R75-19990831
1=Yes
2=No
8=No Applicable
9=Unknown
N=No (A)
U=Unknown (A)
W=Not Applicable (A)
Y=Yes (A)

43 CAN_PROG_MED_ENT Character(1) VARCHAR2(1) NOT NULL SAC-R75-19990831
1=Yes
2=No
8=No Applicable
9=Unknown
N=No (A)
U=Unknown (A)
W=Not Applicable (A)
Y=Yes (A)

44 CAN_PROG_OTH_ENT Character(1) VARCHAR2(1) NOT NULL Other Requirement Sac-r75-19990831
1=Yes
2=No
8=Not Applicable
9=Unknown
N=No (A)
U=Unknown (A)
W=Not Applicable (A)
Y=Yes (A)

45 CAN_PROG_MAN_PD Number(9,2) DECIMAL(8,2) NOT NULL Sac-r75-19990831

46 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
Default Value: BUS_UNIT_TBL_RP.CAN_PROG_MAN_UNIT

47 CAN_PROG_MAN_UPD Number(9,2) DECIMAL(8,2) NOT NULL Sac-r75-19990831

48 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
Default Value: BUS_UNIT_TBL_RP.CAN_PROG_MANU_UNIT

49 CAN_PROG_OPT_PD Number(9,2) DECIMAL(8,2) NOT NULL Opt Paid OJT Dur Sac-r75-19990831

50 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
Default Value: BUS_UNIT_TBL_RP.CAN_PROG_OPT_UNIT

51 CAN_PROG_OPT_UPD Number(9,2) DECIMAL(8,2) NOT NULL Sac-r75-19990831

52 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
Default Value: BUS_UNIT_TBL_RP.CAN_PROG_OPTU_UNIT

53 CAN_PROV_MAJOR Character(8) VARCHAR2(8) NOT NULL Sac-r75-1990831: The field of study code assigned by the provincial ministry or other administrative body to identify the program. Leave this element blank if your institution does not report this information to the provincial ministry or other agency.
Prompt Table: CAN_PROV_MAJOR

54 CAN_PROV_APPR_CD Character(6) VARCHAR2(6) NOT NULL Prov Approval Code Sac-r75-19990831
Prompt Table: CAN_PROV_APPR

55 CAN_ESIS_CR_PROG Character(1) VARCHAR2(1) NOT NULL Cost Recovery Program * Sac-r75-19990831
1=Yes
2=No
9=Unknown
N=No (A)
U=Unknown (A)
Y=Yes (A)

56 CAN_ESIS_COOP Character(1) VARCHAR2(1) NOT NULL Sac-r75-19990831
1=Yes
2=No
8=Not Applicable
9=Unknown
N=No (A)
U=Unknown (A)
W=Not Applicable (A)
Y=Yes (A)

57 CAN_ESIS_ARTC_PROG Character(1) VARCHAR2(1) NOT NULL Sac-r75-19990831
1=Yes
2=No
8=Not Applicable
9=Unknown
N=No (A)
U=Unknown (A)
W=Not Applicable (A)
Y=Yes (A)

58 CAN_ESIS_BROK_PROG Character(1) VARCHAR2(1) NOT NULL Sac-r75-19990831
1=Yes-Institution is Sponsor
2=Yes-Institution is Host
3=No
8=Not Applicable
9=Unknown

59 CAN_ESIS_COLL_PROG Character(1) VARCHAR2(1) NOT NULL Sac-r75-19990831
1=Yes
2=No
8=Not Applicable
9=Unknown
N=No (A)
U=Unknown (A)
W=Not Applicable (A)
Y=Yes (A)

#	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 Prompt Table: INSTITUTION_TBL
2	ACAD_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Academic Plan Prompt Table: ACAD_PLAN_TBL
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	CAN_QUALIF	Character(2)	VARCHAR2(2) NOT NULL	Qualifications being sought Prompt Table: CAN_RPT_QUALIF
6	CAN_FIN_QUALIF	Character(2)	VARCHAR2(2) NOT NULL	Qualification Being Sought Prompt Table: CAN_RPT_QUALIF
7	CAN_AWABOD	Character(1)	VARCHAR2(1) NOT NULL	Awarding Body 1=Degree Granting Institution 2=Professional or Prov Granted 3=Degree Granting & Professional 8=Not Applicable 9=Not Reported
8	CAN_QUACOD	Character(3)	VARCHAR2(3) NOT NULL	Title of qualification Prompt Table: CAN_RPT_QUACOD
9	CAN_HONIND	Character(1)	VARCHAR2(1) NOT NULL	Honors programme indicator 1=Single Honours 2=Double Combined/Joint Honours 3=Bachelor Degree - Honours 4=Bachelor Degree - No Honours 8=Not in Bachelor Degree
10	CAN_SPEMAJ	Character(5)	VARCHAR2(5) NOT NULL	Major field of study Prompt Table: CAN_RPT_SPEMAJ Set Control Field: CAN_SPEMAJ
11	CAN_SESTYP	Character(2)	VARCHAR2(2) NOT NULL	Type of session 01=Calendar Year 03=Calendar Months 11=Academic Year 22=Semester 32=Trimester 44=Summer Session 80=Other
12	CAN_SESTOT	Number(2,0)	SMALLINT NOT NULL	Number of Sessions.
13	CAN_NORMCR	Number(4,0)	SMALLINT NOT NULL	Normal Requirements
14	CAN_FORPOS	Number(3,0)	SMALLINT NOT NULL	Cdn Reporting - Forpos Prompt Table: CAN_RPT_FORPOS
15	CAN_BIU_WEIGHT	Signed Number(6,3)	DECIMAL(4,3) NOT NULL	Cdn Reporting - Annual Weight
16	CAN_FT_LOAD	Number(5,3)	DECIMAL(4,3) NOT NULL	Full Time Load
17	CAN_TERM_WGHT	Number(5,3)	DECIMAL(4,3) NOT NULL	Cdn Reporting - Term Weight
18	CAN_MET_FORM_FEE	Number(4,0)	SMALLINT NOT NULL	Cdn Reporting - MET Form Fee
19	CAN_MIN_BIU	Signed Number(7,3)	DECIMAL(5,3) NOT NULL	Cdn Reporting - Minimum BIU
20	CAN_MAX_BIU	Signed Number(7,3)	DECIMAL(5,3) NOT NULL	Cdn Reporting - Maximum BIU
21	CAN_INELIG_BIU	Character(1)	VARCHAR2(1) NOT NULL	Cdn Rpt - Ineligible BIU fund Y/N Table Edit Default Value: N
22	CAN_OUAC_UPREG	Character(3)	VARCHAR2(3) NOT NULL	Univ & Program Registered
23	CAN_PROG_CRED_TYP	Character(2)	VARCHAR2(2) NOT NULL	SAC-R75-19990831 01=General Equivalency 02=Certificate 03=Diploma 04=Degree 05=Declaration of Achievement 06=Other PostSecondary 07=Other Non-PostSecondary 08=Other Undergraduate Level 09=Other Graduate Level 10=Attest and Other Short Prog 11=Associate Degree 96=Other Type of Credential 97=Other Type of Credential 98=Not Applicable
24	CAN_PROG_JOINT_TYP	Character(2)	VARCHAR2(2) NOT NULL	SAC-R75-19990831 01=General Equivalency 02=Certificate 03=Diploma 04=Degree 05=Declaration of Achievement 06=Other PostSecondary 07=Other Non PostSecondary 08=Other Undergraduate Level 09=Other Graduate Level 10=Attest and Other Short Prog 11=Associate Degree 96=Other Type of Credential 97=Other Type of Credential 98=Not Applicable
25	CAN_PROG_PROG_LVL	Character(2)	VARCHAR2(2) NOT NULL	SAC-R75-19990831
26	CAN_PROG_JOINT_LVL	Character(2)	VARCHAR2(2) NOT NULL	SAC-R75-19990831
27	CAN_PROG_SESS_TYPE	Character(2)	VARCHAR2(2) NOT NULL	SAC-R75-19990831 05=Summer Sessions Only 07=Intersessions Only 08=Weeks 09=Months 10=Quarters 15=Semesters or Trimesters 25=Academic Years(8 months) 30=Years (12 months) 96=Other 98=Not Applicable
28	CAN_PROV_FUND_CD	Character(6)	VARCHAR2(6) NOT NULL	* Sac-r75-19990831 Prompt Table: CAN_PROV_FUND
29	CAN_PROV_PROG_CAT	Character(8)	VARCHAR2(8) NOT NULL	* Sac-r75-19990831 Prompt Table: CAN_PROV_PROG
30	CAN_PROG_CAPACITY	Number(5,0)	INTEGER NOT NULL	Sac-r75-19990831
31	CAN_PROG_CONTRACT	Character(1)	VARCHAR2(1) NOT NULL	Contract Delivery Sac-r75-19990831 1=Yes 2=No 8=Not Applicable 9=Unknown N=No (A) U=Unknown (A) W=Not Applicable (A) Y=Yes (A)
32	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 Default Value: BUS_UNIT_TBL_RP.CAN_PROG_CRED_UNIT
33	CAN_PROG_CREDIT	Number(9,2)	DECIMAL(8,2) NOT NULL	SAC-R75-19990831
34	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 Default Value: BUS_UNIT_TBL_RP.CAN_PROG_DUR_UNIT
35	CAN_PROG_DURATION	Number(7,2)	DECIMAL(6,2) NOT NULL	Program Duration SAC-R75-19990831
36	CAN_PROG_FULL_PART	Character(1)	VARCHAR2(1) NOT NULL	SAC-R75-19990831 1=Offered on FullTime Basis Only 2=Offered on PartTime Basis Only 3=Offered Full Time or Part Time 8=Not Applicable 9=Unknown
37	CAN_PROG_HOURS	Number(5,0)	INTEGER NOT NULL	SAC-R75-19990831
38	CAN_PROG_LIM_ENRL	Character(1)	VARCHAR2(1) NOT NULL	Sac-r75-19990831 1=Yes-Institution Set Limit 2=Yes-Professional Org Set Limit 3=Yes-Government Set Limit 6=No 8=Not Applicable 9=Unknown
39	CAN_PROG_APT_ENT	Character(1)	VARCHAR2(1) NOT NULL	Sac-r75-19990831 1=Yes 2=No 8=Not Applicable 9=Unknown N=No (A) U=Unknown (A) W=Not Applicable (A) Y=Yes (A)
40	CAN_PROG_EDU_ENT	Character(2)	VARCHAR2(2) NOT NULL	SAC-R75-19990831 13=High School Diploma 14=High School Matriculation 18=Some Secondary Education 19=Primary/Elementary Education 21=Registered Apprenticeship 22=Trade/Vocational Certificate 23=College PostSecond Certificate 24=College PostSecondary Diploma 28=Other College Level 29=Non-Prof Health Certif 41=Bachelor's Degree 42=First Prof Degree 46=Undergraduate Certificate 47=Undergraduate Dilpoma 48=Other Undergraduate Credential 49=Some Udergraduate Level 51=Master's Degree 52=Graduate Level Certificate 53=Graduate Level Diploma 54=Ph.D 55=Equivalent Earned Doctorate 58=Other Graduate Credential 59=Some Graduate Level 96=Other Level 98=No Entrance Requirement 99=Unknown
41	CAN_PROG_EXP_ENT	Character(1)	VARCHAR2(1) NOT NULL	Experience Requirement Sac-r75-19990831 1=Yes 2=No 8=Not Applicable 9=Unknown N=No (A) U=Unknown (A) W=Not Applicable (A) Y=Yes (A)
42	CAN_PROG_LEG_ENT	Character(1)	VARCHAR2(1) NOT NULL	SAC-R75-19990831 1=Yes 2=No 8=No Applicable 9=Unknown N=No (A) U=Unknown (A) W=Not Applicable (A) Y=Yes (A)
43	CAN_PROG_MED_ENT	Character(1)	VARCHAR2(1) NOT NULL	SAC-R75-19990831 1=Yes 2=No 8=No Applicable 9=Unknown N=No (A) U=Unknown (A) W=Not Applicable (A) Y=Yes (A)
44	CAN_PROG_OTH_ENT	Character(1)	VARCHAR2(1) NOT NULL	Other Requirement Sac-r75-19990831 1=Yes 2=No 8=Not Applicable 9=Unknown N=No (A) U=Unknown (A) W=Not Applicable (A) Y=Yes (A)
45	CAN_PROG_MAN_PD	Number(9,2)	DECIMAL(8,2) NOT NULL	Sac-r75-19990831
46	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 Default Value: BUS_UNIT_TBL_RP.CAN_PROG_MAN_UNIT
47	CAN_PROG_MAN_UPD	Number(9,2)	DECIMAL(8,2) NOT NULL	Sac-r75-19990831
48	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 Default Value: BUS_UNIT_TBL_RP.CAN_PROG_MANU_UNIT
49	CAN_PROG_OPT_PD	Number(9,2)	DECIMAL(8,2) NOT NULL	Opt Paid OJT Dur Sac-r75-19990831
50	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 Default Value: BUS_UNIT_TBL_RP.CAN_PROG_OPT_UNIT
51	CAN_PROG_OPT_UPD	Number(9,2)	DECIMAL(8,2) NOT NULL	Sac-r75-19990831
52	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 Default Value: BUS_UNIT_TBL_RP.CAN_PROG_OPTU_UNIT
53	CAN_PROV_MAJOR	Character(8)	VARCHAR2(8) NOT NULL	Sac-r75-1990831: The field of study code assigned by the provincial ministry or other administrative body to identify the program. Leave this element blank if your institution does not report this information to the provincial ministry or other agency. Prompt Table: CAN_PROV_MAJOR
54	CAN_PROV_APPR_CD	Character(6)	VARCHAR2(6) NOT NULL	Prov Approval Code Sac-r75-19990831 Prompt Table: CAN_PROV_APPR
55	CAN_ESIS_CR_PROG	Character(1)	VARCHAR2(1) NOT NULL	Cost Recovery Program * Sac-r75-19990831 1=Yes 2=No 9=Unknown N=No (A) U=Unknown (A) Y=Yes (A)
56	CAN_ESIS_COOP	Character(1)	VARCHAR2(1) NOT NULL	Sac-r75-19990831 1=Yes 2=No 8=Not Applicable 9=Unknown N=No (A) U=Unknown (A) W=Not Applicable (A) Y=Yes (A)
57	CAN_ESIS_ARTC_PROG	Character(1)	VARCHAR2(1) NOT NULL	Sac-r75-19990831 1=Yes 2=No 8=Not Applicable 9=Unknown N=No (A) U=Unknown (A) W=Not Applicable (A) Y=Yes (A)
58	CAN_ESIS_BROK_PROG	Character(1)	VARCHAR2(1) NOT NULL	Sac-r75-19990831 1=Yes-Institution is Sponsor 2=Yes-Institution is Host 3=No 8=Not Applicable 9=Unknown
59	CAN_ESIS_COLL_PROG	Character(1)	VARCHAR2(1) NOT NULL	Sac-r75-19990831 1=Yes 2=No 8=Not Applicable 9=Unknown N=No (A) U=Unknown (A) W=Not Applicable (A) Y=Yes (A)