| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CAN_RPT_PERIOD |
Character(8) |
VARCHAR2(8) NOT NULL |
Canadian Report Period
|
| 2 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table:
INSTITUTION_TBL
|
| 3 |
CRSE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Course ID
|
| 4 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 5 |
CAN_RPT_ESIS_CRSE |
Character(20) |
VARCHAR2(20) NOT NULL |
Sac-r75-19990831
|
| 6 |
CAN_GOV_SCHOOL_CD |
Character(15) |
VARCHAR2(15) NOT NULL |
Institution Code
Sac-r75-19990831
Prompt Table:
CAN_GOV_SCHOOL
|
| 7 |
CAN_ESIS_START_YR |
Number(4,0) |
SMALLINT NOT NULL |
Report Start Year
SAC-R75-19990831
|
| 8 |
CAN_RPT_CRSE_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
Sac-r75-19990831
|
| 9 |
CAN_CRSE_CONTRCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Sac-r75-19990831
1=Yes
2=No
9=Unknown
N=No (A)
U=Unknown (A)
Y=Yes (A)
|
| 10 |
CAN_CRSE_WORK |
Character(1) |
VARCHAR2(1) NOT NULL |
Sac-r75-19990831
1=Yes
2=No
9=Unknown
N=No (A)
U=Unknown (A)
Y=Yes (A)
|
| 11 |
CAN_CRSE_DURATION |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Sac-r75-19990831
|
| 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_CREDIT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Course Credits
Sac-r75-19990831
|
| 14 |
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
|
| 15 |
CAN_CRSE_LAB_DUR |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Sac-r75-19990831
|
| 16 |
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
|
| 17 |
CAN_CRSE_OJT_DUR |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Sac-r75-19990831
|
| 18 |
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
|
| 19 |
CAN_PROV_FUND_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
* Sac-r75-19990831
Prompt Table:
CAN_PROV_FNDCRS
|