CAN_ESIS_PLAN

(SQL Table)
 Index Back

ESIS Plan Mapping Table

SACE98-D NEW: SR40 Cdn Reporting Requirements - ESIS Plan Mapping Table

# 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 NOT NULL 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_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
6 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
7 CAN_PROG_PROG_LVL Character(2) VARCHAR2(2) NOT NULL SAC-R75-19990831
8 CAN_PROG_JOINT_LVL Character(2) VARCHAR2(2) NOT NULL SAC-R75-19990831
9 CAN_PROV_FUND_CD Character(6) VARCHAR2(6) NOT NULL * Sac-r75-19990831

Prompt Table: CAN_PROV_FUND

10 CAN_PROV_PROG_CAT Character(8) VARCHAR2(8) NOT NULL * Sac-r75-19990831

Prompt Table: CAN_PROV_PROG

11 CAN_PROG_CAPACITY Number(5,0) INTEGER NOT NULL Sac-r75-19990831
12 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)
13 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

14 CAN_PROG_CREDIT Number(9,2) DECIMAL(8,2) NOT NULL SAC-R75-19990831
15 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

16 CAN_PROG_DURATION Number(7,2) DECIMAL(6,2) NOT NULL Program Duration SAC-R75-19990831
17 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
18 CAN_PROG_HOURS Number(5,0) INTEGER NOT NULL SAC-R75-19990831
19 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
20 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)
21 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
22 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)
23 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)
24 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)
25 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)
26 CAN_PROG_MAN_PD Number(9,2) DECIMAL(8,2) NOT NULL Sac-r75-19990831
27 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

28 CAN_PROG_MAN_UPD Number(9,2) DECIMAL(8,2) NOT NULL Sac-r75-19990831
29 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

30 CAN_PROG_OPT_PD Number(9,2) DECIMAL(8,2) NOT NULL Opt Paid OJT Dur Sac-r75-19990831
31 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

32 CAN_PROG_OPT_UPD Number(9,2) DECIMAL(8,2) NOT NULL Sac-r75-19990831
33 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

34 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

35 CAN_PROV_APPR_CD Character(6) VARCHAR2(6) NOT NULL Prov Approval Code Sac-r75-19990831

Prompt Table: CAN_PROV_APPR

36 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)
37 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)
38 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)
39 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
40 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)
41 CAN_ESIS_CONT_ED Character(1) VARCHAR2(1) NOT NULL Continuing Education
1=Yes
2=No
9=Unknown