| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CAN_RPT_PERIOD |
Character(8) |
VARCHAR2(8) NOT NULL |
Canadian Report Period
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSONAL_DATA
|
| 3 |
ACAD_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
Prompt Table:
ACAD_CAR_TBL
|
| 4 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table:
INSTITUTION_TBL
|
| 5 |
ACAD_PROG |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Program
Prompt Table:
ACAD_PROG_TBL
|
| 6 |
ACAD_PLAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Academic Plan
Prompt Table:
ACAD_PLAN_TBL
|
| 7 |
CAN_ESIS_START_YR |
Number(4,0) |
SMALLINT NOT NULL |
Report Start Year
SAC-R75-19990831
|
| 8 |
CAN_GOV_SCHOOL_CD |
Character(15) |
VARCHAR2(15) NOT NULL |
Institution Code
Sac-r75-19990831
Prompt Table:
CAN_GOV_SCHOOL
|
| 9 |
CAN_ESIS_REP_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Type
SAC-R75-19990831
F=Final (Full Year) Report
P=Preliminary (January) Report
|
| 10 |
CAN_ESIS_EMPLID |
Character(14) |
VARCHAR2(14) NOT NULL |
Sac-r75-19990831
|
| 11 |
CAN_RPT_ESIS_PROG |
Character(20) |
VARCHAR2(20) NOT NULL |
SAC-R75-19990831
|
| 12 |
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
|
| 13 |
CAN_PROG_START_DT |
Date(10) |
DATE |
Program Start Date
Sac-r75-19990831
|
| 14 |
CAN_ESIS_MAJOR1 |
Character(10) |
VARCHAR2(10) NOT NULL |
First Major
Sac-r75-19990831
|
| 15 |
CAN_ESIS_MAJOR2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Second Major
Sac-r75-19990831
|
| 16 |
CAN_ESIS_MAJOR3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Third Major
Sac-r75-19990831
|
| 17 |
CAN_PROV_MAJOR1 |
Character(8) |
VARCHAR2(8) NOT NULL |
Prov Major 1
Sac-r75-19990831
Prompt Table:
CAN_PROV_MAJOR
|
| 18 |
CAN_PROV_MAJOR2 |
Character(8) |
VARCHAR2(8) NOT NULL |
Prov Major 2
Sac-r75-19990831
Prompt Table:
CAN_PROV_MAJOR
|
| 19 |
CAN_PROV_STUD_APPR |
Character(6) |
VARCHAR2(6) NOT NULL |
Funding Approved
Sac-r75-19990831
Prompt Table:
CAN_PROV_APPR
|
| 20 |
CAN_PROG_CREDENT |
Character(60) |
VARCHAR2(60) NOT NULL |
Sac-r75-19990831
|
| 21 |
CAN_PROG_JOINT_CRD |
Character(60) |
VARCHAR2(60) NOT NULL |
Joint Credential
Sac-r75-19990831
|
| 22 |
CAN_ESIS_NORM_ENT |
Character(2) |
VARCHAR2(2) NOT NULL |
SAC-R75-19990831
01=Student Met Normal Requirement
02=Student Did Not Meet Reqmt
98=Not applicable
99=Unknown
|
| 23 |
CAN_PROV_SPEC_INIT |
Character(6) |
VARCHAR2(6) NOT NULL |
Special Initiative
Sac-r75-19990831: The Special initiative code associated with the student in the program, as specified by the provincial ministry, institution or other agency. If no codeset is specified by the provincial ministry or other agency and the institution does not record Special initiative codes, leave this element blank.
Prompt Table:
CAN_PROV_SP_INT
|
| 24 |
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)
|
| 25 |
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)
|
| 26 |
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
|
| 27 |
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)
|
| 28 |
CAN_ESIS_GRAD_JUN1 |
Character(2) |
VARCHAR2(2) NOT NULL |
June 1
Sac-r75-19990831
01=Full-time graduate student
02=Part-time graduate student
98=Not Applicable
|
| 29 |
CAN_ESIS_GRAD_AUG1 |
Character(2) |
VARCHAR2(2) NOT NULL |
August 1
Sac-r75-19990831
01=Full-time graduate student
02=Part-time graduate student
98=Not Applicable
|
| 30 |
CAN_ESIS_GRAD_DEC1 |
Character(2) |
VARCHAR2(2) NOT NULL |
December 1
Sac-r75-19990831
01=Full-time graduate student
02=Part-time graduate student
98=Not Applicable
|
| 31 |
CAN_ESIS_GRAD_APR1 |
Character(2) |
VARCHAR2(2) NOT NULL |
April 1
Sac-r75-19990831
01=Full-time graduate student
02=Part-time graduate student
98=Not Applicable
|
| 32 |
CAN_PROG_END_DT |
Date(10) |
DATE |
Program End Date
Sac-r75-19990831
|
| 33 |
CAN_ESIS_END_PROG |
Character(2) |
VARCHAR2(2) NOT NULL |
Status at End
Sac-r75-19990831
01=Elig to enroll in next phase
02=Successsfully completed
03=Still enrolled in program
04=Graduated from program
05=Not eligible to enroll in prog
06=Withdrew from prog or instit
07=Not eligible to enroll at inst
08=Student deceased
96=Other
98=Not applicable (non-program)
99=Unknown
|
| 34 |
CAN_ESIS_GRAD_DT |
Date(10) |
DATE |
Graduation Date
Sac-r75-19990831
|
| 35 |
CAN_ESIS_ACAD_EXCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Acad Excellence
Sac-r75-19990831
1=Yes, attained acad excellence
2=No, did not attain acad excell
8=Not Applicable
9=Unknown
N=No (A)
U=Unknown (A)
W=Not Applicable (A)
Y=Yes (A)
|
| 36 |
CAN_ESIS_MAN_PD |
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)
|
| 37 |
CAN_ESIS_OPT_PD |
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_MAN_UPD |
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_OPT_UPD |
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_ESIS_PROG_TUIT |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Tuition Fees
Sac-r75-19990831
|
| 41 |
CAN_ESIS_PROG_FEES |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Other Fees
Sac-r75-19990831
|
| 42 |
CAN_ESIS_COST_REC |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Recovery
Sac-r75-19990831
1=Yes
2=No
9=Unknown
N=No (A)
U=Unknown (A)
Y=Yes (A)
|
| 43 |
CAN_ESIS_SCHLSHP |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Sac-r75-19990831
|
| 44 |
CAN_ESIS_TOT_TRANS |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Sac-r75-19990831
|
| 45 |
CAN_ESIS_TOT_CRED |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Cumulative Credits
Sac-r75-19990831
|
| 46 |
CAN_ESIS_REGSTAT |
Character(2) |
VARCHAR2(2) NOT NULL |
Registration Status
01=Full-time student
02=Part-time student
98=Not Applicable
|
| 47 |
CAN_ESIS_CONT_ED |
Character(1) |
VARCHAR2(1) NOT NULL |
Continuing Education
1=Yes
2=No
9=Unknown
|