CAN_PROG_TBL(SQL Table) |
Index Back |
---|---|
USIS Plan Mapping TableSACE98-D NEW: SR40 Cdn Reporting Requirements - USIS Plan Mapping Table Sac-r75-1990831: Added new fields (see Technical Design for details). |
# | 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_PROG | Character(5) | VARCHAR2(5) NOT NULL |
Academic Program
Prompt Table: ACAD_PROG_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_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
|
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) |