| # |
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_ESIS_TYP_STUD |
Character(2) |
VARCHAR2(2) NOT NULL |
ID Type
Sac-r75-19990831
01=Assigned by Institution
02=Provincial student ID number
96=Other
|
| 12 |
CAN_ESIS_SIN |
Character(9) |
VARCHAR2(9) NOT NULL |
Sac-r75-19990831
|
| 13 |
CAN_ESIS_NSN |
Character(30) |
VARCHAR2(30) NOT NULL |
Sac-r75-19990831
|
| 14 |
CAN_ESIS_FRST_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Sac-r75-19990831
|
| 15 |
CAN_ESIS_MDDL_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Sac-r75-19990831
|
| 16 |
CAN_ESIS_LAST_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Sac-r75-19990831
|
| 17 |
CAN_ESIS_PREV_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Sac-r75-19990831
|
| 18 |
CAN_ESIS_POSTAL |
Character(10) |
VARCHAR2(10) NOT NULL |
Sac-r75-19990831
|
| 19 |
CAN_ESIS_CNTRY_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Sac-r75-19990831
Prompt Table:
CAN_GOV_COUNTRY
|
| 20 |
CAN_ESIS_CNTRY_TXT |
Character(30) |
VARCHAR2(30) NOT NULL |
Sac-r75-19990831
|
| 21 |
CAN_ESIS_PHONE |
Character(20) |
VARCHAR2(20) NOT NULL |
Sac-r75-19990831
|
| 22 |
CAN_ESIS_EMAIL |
Character(80) |
VARCHAR2(80) NOT NULL |
Sac-r75-19990831
|
| 23 |
CAN_ESIS_PRM_ADDR1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address
Sac-r75-19990831
|
| 24 |
CAN_ESIS_PRM_ADDR2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address
Sac-r75-19990831
|
| 25 |
CAN_ESIS_PRM_ADDR3 |
Character(30) |
VARCHAR2(30) NOT NULL |
Address
Sac-r75-19990831
|
| 26 |
CAN_ESIS_PRM_ADDR4 |
Character(30) |
VARCHAR2(30) NOT NULL |
Address
Sac-r75-19990831
|
| 27 |
CAN_ESIS_PRM_ADDR5 |
Character(30) |
VARCHAR2(30) NOT NULL |
Address
Sac-r75-19990831
|
| 28 |
CAN_ESIS_PRM_CITY |
Character(35) |
VARCHAR2(35) NOT NULL |
City
Sac-r75-19990831
|
| 29 |
CAN_ESIS_PRM_CNTY |
Character(4) |
VARCHAR2(4) NOT NULL |
County
Sac-r75-19990831
|
| 30 |
CAN_ESIS_PRM_CTXT |
Character(35) |
VARCHAR2(35) NOT NULL |
County (Txt)
Sac-r75-19990831
|
| 31 |
CAN_ESIS_PRM_STATE |
Character(2) |
VARCHAR2(2) NOT NULL |
Province
Sac-r75-19990831
Prompt Table:
STATE_NAMES_VW
|
| 32 |
CAN_ESIS_PRM_GEOCD |
Character(35) |
VARCHAR2(35) NOT NULL |
Sac-r75-19990831
|
| 33 |
CAN_ESIS_PRM_CNTRY |
Character(5) |
VARCHAR2(5) NOT NULL |
Country
Sac-r75-19990831
Prompt Table:
CAN_GOV_COUNTRY
|
| 34 |
CAN_ESIS_PRM_CNTXT |
Character(30) |
VARCHAR2(30) NOT NULL |
Country Text
Sac-r75-19990831
|
| 35 |
CAN_ESIS_PRM_POSTL |
Character(10) |
VARCHAR2(10) NOT NULL |
Postal Code
Sac-r75-19990831
|
| 36 |
CAN_ESIS_PRM_PHONE |
Character(20) |
VARCHAR2(20) NOT NULL |
Phone Number
Sac-r75-19990831
|
| 37 |
CAN_ESIS_SENS_REC |
Character(1) |
VARCHAR2(1) NOT NULL |
Sac-r75-19990831
1=Yes
2=No
N=No (A)
Y=Yes (A)
|
| 38 |
CAN_ESIS_ABO_VIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Sac-r75-19990831
1=Visible minority
2=North American aboriginal
3=Not a minority
9=Unknown
|
| 39 |
CAN_ESIS_DISABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Sac-r75-19990831
1=Yes
2=No
9=Unknown
N=No (A)
U=Unknown (A)
Y=Yes (A)
|
| 40 |
CAN_ESIS_RES_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Sac-r75-19990831
1=Yes
2=No
9=Unknown
N=No (A)
U=Unknown (A)
Y=Yes (A)
|
| 41 |
CAN_ESIS_BIRTH_DT |
Date(10) |
DATE |
Sac-r75-19990831
|
| 42 |
CAN_ESIS_GENDER |
Character(1) |
VARCHAR2(1) NOT NULL |
Sac-r75-19990831
1=Male
2=Female
9=Unknown
F=Female (A)
M=Male (A)
U=Unknown (A)
|
| 43 |
CAN_ESIS_TONGUE |
Character(3) |
VARCHAR2(3) NOT NULL |
Sac-r75-19990831
Prompt Table:
CAN_GOV_LANG
|
| 44 |
CAN_PROV_FUND_CITZ |
Character(6) |
VARCHAR2(6) NOT NULL |
Funding Class By Citiz
Sac-r75-19990831: Classifies students by citizenship for grant purposes in accordance with the funding agency's policy. Leave this element blank if your institution does not report this information to the provincial ministry or other agency.
Prompt Table:
CAN_PROV_CITZ
|
| 45 |
CAN_ESIS_FEE_CAT |
Character(2) |
VARCHAR2(2) NOT NULL |
Fee Category
Sac-r75-19990831
01=Std in-province domestic
02=Std out-of-province domestic
03=Std international
04=Full cost recovery
05=Senior citizen
06=Staff
07=Staff dependent
96=Other
|
| 46 |
CAN_ESIS_STUD_TUIT |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Tuition Fees
Sac-r75-19990831
|
| 47 |
CAN_ESIS_TUIT_TOT |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Other Fees
Sac-r75-19990831
|
| 48 |
CAN_ESIS_CITIZ |
Character(5) |
VARCHAR2(5) NOT NULL |
Sac-r75-19990831
Prompt Table:
CAN_GOV_COUNTRY
|
| 49 |
CAN_ESIS_CITIZ_TXT |
Character(30) |
VARCHAR2(30) NOT NULL |
Country Text
Sac-r75-19990831
|
| 50 |
CAN_ESIS_IMM_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Immigration Status
Sac-r75-19990831
0=Canadian citizen
1=Permanent resident
2=Student visa
3=Other visa
4=Non-Canadian, status unknown
5=Non-Canadian, no visa status
|
| 51 |
CAN_ESIS_PRV_CNTRY |
Character(5) |
VARCHAR2(5) NOT NULL |
Sac-r75-19990831
Prompt Table:
CAN_GOV_COUNTRY
|
| 52 |
CAN_ESIS_PRV_CNTXT |
Character(30) |
VARCHAR2(30) NOT NULL |
Country Text
Sac-r75-19990831
|
| 53 |
CAN_ESIS_OUTSIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Studying Outside Canada
Sac-r75-19990831
1=Yes
2=No
9=Unknown
N=No (A)
U=Unknown (A)
Y=Yes (A)
|
| 54 |
CAN_ESIS_SEC_EDU |
Character(2) |
VARCHAR2(2) NOT NULL |
Sac-r75-19990831
00=None
01=Completed grade K to 1
02=Completed grade 2
03=Completed grade 3
04=Completed grade 4
05=Completed grade 5
06=Completed grade 6
07=Completed grade 7
08=Completed grade 8
09=Completed grade 9
10=Completed grade 10
11=Completed grade 11
12=General Equivalency Diploma
13=Completed grade 12 gen diploma
14=Completed grade 12 matriculat
15=Completed grade 13
30=Completed 11+ years outside NA
40=Completed some elem school
50=Completed some sec school
96=Other
99=Unknown
|
| 55 |
CAN_ESIS_SEC_DATE |
Date(10) |
DATE |
Date Last Attended
Sac-r75-19990831
|
| 56 |
CAN_ESIS_SEC_CNTRY |
Character(5) |
VARCHAR2(5) NOT NULL |
Country Last Attended
Sac-r75-19990831
Prompt Table:
CAN_GOV_COUNTRY
|
| 57 |
CAN_ESIS_SEC_CNTXT |
Character(30) |
VARCHAR2(30) NOT NULL |
Country Text
Sac-r75-19990831
|
| 58 |
CAN_ESIS_SEC_PROV |
Character(2) |
VARCHAR2(2) NOT NULL |
Prov/St Last Attend
Sac-r75-19990831
Prompt Table:
STATE_NAMES_VW
|
| 59 |
CAN_ESIS_SEC_INST |
Character(14) |
VARCHAR2(14) NOT NULL |
School Last Attended
Sac-r75-19990831
Prompt Table:
CAN_GOV_SCHOOL
|
| 60 |
CAN_ESIS_PREV_ACT |
Character(2) |
VARCHAR2(2) NOT NULL |
SAC-R75-19990831
|
| 61 |
CAN_ESIS_PREV_CRED |
Character(2) |
VARCHAR2(2) NOT NULL |
SAC-R75-19990831
01=General Equivalancy Diploma
02=Certificate
03=Diploma
04=Degree
05=Declaration of Achievement
06=Other College PostSecondary
07=Other College Non-PostSecond
08=Other Undergraduate Credential
09=Other Graduate Credential
96=Other Type of Credential
98=Not Applicable
99=Unknown
|
| 62 |
CAN_ESIS_PREV_LFA |
Character(8) |
VARCHAR2(8) NOT NULL |
Sac-r75-19990831
|
| 63 |
CAN_ESIS_PERMPROV1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Province First Declared
|