| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PEOPLE_SRCH
|
| 2 |
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
|
| 3 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table:
INSTITUTION_TBL
|
| 4 |
ACAD_PROG |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Program
Prompt Table:
ACAD_PROG_TBL
|
| 5 |
ACAD_PLAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Academic Plan
Prompt Table:
ACAD_PLAN_TBL
|
| 6 |
CAN_CIS_SUBMISSION |
Number(1,0) |
SMALLINT NOT NULL |
Submission Type
|
| 7 |
CAN_CIS_PROVINCE |
Number(2,0) |
SMALLINT NOT NULL |
Institution Province
Prompt Table:
CAN_RPT_PROV_VW
|
| 8 |
CAN_CIS_INSTIT |
Number(2,0) |
SMALLINT NOT NULL |
CIS Institution
|
| 9 |
CAN_CIS_CAMPUS |
Number(2,0) |
SMALLINT NOT NULL |
Campus of Registration
|
| 10 |
CAN_CIS_SESSION |
Character(1) |
VARCHAR2(1) NOT NULL |
CIS Session
1=Spr/Sum (U) Summer (CTI)
2=Fall Session
3=Winter Session
4=Spring Session (CTI)
5=Updated Recs (Session 1)
6=Updated Recs (Session 2)
7=Full Year Sessions
9=Updated Recs (Prev Yr)
|
| 11 |
CAN_CIS_STUDID |
Character(9) |
VARCHAR2(9) NOT NULL |
Student ID
|
| 12 |
CAN_CIS_MARIST |
Number(1,0) |
SMALLINT NOT NULL |
Marital Status
|
| 13 |
CAN_CIS_STATUS |
Number(1,0) |
SMALLINT NOT NULL |
Legal Status in Canada
|
| 14 |
CAN_CIS_CURSTAT |
Character(1) |
VARCHAR2(1) NOT NULL |
CIS Current Status
1=Continuing Student
2=Returning Student
3=New Student
4=Freshman Student
5=Post-Secondary Transfer
|
| 15 |
CAN_CIS_REGSTAT |
Character(1) |
VARCHAR2(1) NOT NULL |
CIS Registration
F=Enrolled Full Time
H=Cont Regist Inactive Stdnt
L=Not Enrolled in pgm in comp yr
N=Not Enrolled in pgm completed
P=Enrolled Part Time
W=Withdrawn Without Acad Penalty
|
| 16 |
CAN_CIS_REGTYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
CIS Registration Type
1=Regular Day
2=Evening Credit
3=Continuing Ed for Credit
5=Credit Outreach
6=Consortium Credit
7=Extramural
8=Other
9=Not Reported
D=Distance Delivery
X=On Work Experience
|
| 17 |
CAN_CIS_PROGID |
Character(9) |
VARCHAR2(9) NOT NULL |
CIS Program ID
|
| 18 |
CAN_CIS_YRSTUD |
Character(1) |
VARCHAR2(1) NOT NULL |
Year of Study
0=Course Less than Year
1=First Year
2=Second Year
3=Third Year
4=Fourth Year
5=Fifth Year (Ugrad)
6=Special or Unclassified
7=Grad Study (crse/thesis)
8=Grad Study (Thesis)
9=Other / N/A
A=Grad Study (Crsewrk)
|
| 19 |
CAN_CIS_WEEKS |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Weeks Student Attended
|
| 20 |
CAN_CIS_CONTACT |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
CIS Contact Hours
|
| 21 |
CAN_CIS_SHORTDAYS |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
CIS Short Days
|
| 22 |
CAN_CIS_SHORTHRS |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
CIS - Short Hours
|
| 23 |
CAN_CIS_YEAREND |
Character(1) |
VARCHAR2(1) NOT NULL |
CIS - Completion Status
0=Eligible to Continue
1=Graduated
2=Withdrew
3=Ineligible to Continue
4=Eligible for Practicum
9=Default
|
| 24 |
CAN_CIS_SPONSOR |
Character(2) |
VARCHAR2(2) NOT NULL |
Financial Sponsorship of Stdnt
02=Student Loan or Grant
03=Alberta Heritage Scholarship
04=Vocational Rehabilitation
05=Skills Development Program
06=Other Depts of Alberta Govt
07=Human Resources Development
08=Indian, Northern Affairs
09=Other Federal Govt Suport
10=Employer
11=Provincial Government
12=Student Current Institution
19=Other
98=No Outside Support
99=Not Reported/Unknown
|
| 25 |
CAN_CIS_SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
CIS - Sex
F=Female
M=Male
|
| 26 |
CAN_CIS_BIRTHDATE |
Date(10) |
DATE |
CIS - Birthdate
|
| 27 |
CAN_CIS_LANGUAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
CIS - Language First Spoken
1=English
2=French
3=German
4=Ukrainian
5=North, South American Native
6=Dutch/Scandinavian
7=Oriental
8=Other
9=Not Reported/Unknown
A=Northern Africa/Middle Eastern
B=Italian, Portuguese, Spanish
C=Japanese, Korean
D=S.E. Asian
E=Indo-Iranian
F=Indonesian
G=Other African
H=Northern European, Asian
I=Other Indo-European
|
| 28 |
CAN_CIS_COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
CIS Country Code
Prompt Table:
CAN_RPT_CTRYVW1
|
| 29 |
CAN_CIS_ENTRYD |
Date(10) |
DATE |
CIS - Date of Entry to Canada
|
| 30 |
CAN_CIS_ENTRYD_DEF |
Number(6,0) |
INTEGER NOT NULL |
CIS - Default Date of Entry
|
| 31 |
CAN_CIS_CONRES |
Number(3,0) |
SMALLINT NOT NULL |
CIS - Source Country
Prompt Table:
CAN_RPT_CTRYVW1
|
| 32 |
CAN_CIS_PCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
CIS - Source Postal Code
|
| 33 |
CAN_CIS_ADYEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
CIS - Admission Year
|
| 34 |
CAN_CIS_ADSTAT |
Character(1) |
VARCHAR2(1) NOT NULL |
CIS - CIS Admission Status
1=Advanced Standing
2=Norm Req and HS Matric
3=Norm Req and HS Diploma
4=Normal Requirements
5=Non matric Adult/Mature
6=Special Admission Status
7=Other
9=Not Reported / Unknown
|
| 35 |
CAN_CIS_PREVACT |
Character(1) |
VARCHAR2(1) NOT NULL |
CIS - Previous Activity
1=Student
2=In the Labour Force
3=Other Activity
9=Not Reported / Unknown
|
| 36 |
CAN_CIS_PREVLOC |
Character(1) |
VARCHAR2(1) NOT NULL |
CIS Previous Location
1=In Alberta
2=In other Provinces
3=Outside Canada
9=Not Reported / Unknown
|
| 37 |
CAN_CIS_ATTAINMENT |
Number(3,0) |
SMALLINT NOT NULL |
CIS - Educational Attainment
|
| 38 |
CAN_CIS_LASTINSTYP |
Character(1) |
VARCHAR2(1) NOT NULL |
CIS - Last Institutional Type
0=Elementary School
1=High School
2=Public College
3=Private Vocational School
4=Technical School
5=Vocational College
6=University
7=Private University/College
8=Other
9=Not Reported/Unknown
|
| 39 |
CAN_CIS_LASTINSYR |
Character(4) |
VARCHAR2(4) NOT NULL |
CIS - Year Attended Last Institution
|
| 40 |
CAN_CIS_LSTINSPROV |
Character(2) |
VARCHAR2(2) NOT NULL |
Province of Last Institution
10=Newfoundland
11=Prince Edward Island
12=Nova Scotia
13=New Brunswick
24=Quebec
35=Ontario
46=Manitoba
47=Saskatchewan
48=Alberta
59=Britiosh Columbia
60=Yukon Territory
61=Northwest Territories
97=Canada province Unknown
98=Not a Resident
99=Not Reported/Unknown
|
| 41 |
CAN_CIS_LASTSECGRD |
Character(2) |
VARCHAR2(2) NOT NULL |
Last Secondary Grade Completed
01=Grade 1
02=Grade 2
03=Grade 3
04=Grade 4
05=Grade 5
06=Grade 6
07=Grade 7
08=Grade 8
09=Grade 9
10=Grade 10
11=Grade 11
12=Grade 12
13=Grade 13
99=Not reported/Unknown
|
| 42 |
CAN_CIS_LASTSECYR |
Character(4) |
VARCHAR2(4) NOT NULL |
Year Last Secondary Grade Comp
|
| 43 |
CAN_CIS_LASTSECCMP |
Character(4) |
VARCHAR2(4) NOT NULL |
CIS - Secondary School Last Comp
Prompt Table:
CAN_GOV_SCH_VW1
|
| 44 |
CAN_CIS_POSTSEC |
Character(2) |
VARCHAR2(2) NOT NULL |
CIS - Last Post Secdry
Prompt Table:
CAN_GOV_SCH_VW2
|
| 45 |
CAN_CIS_ACAD_YR |
Number(4,0) |
SMALLINT NOT NULL |
CIS - Academic Year
|
| 46 |
CAN_CIS_CONTHRS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
CIS - Actual Contact Hrs
|
| 47 |
CAN_CIS_AB_STUDID |
Character(15) |
VARCHAR2(15) NOT NULL |
CIS - Alberta Student Id
|
| 48 |
CAN_CIS_MAJOR1 |
Character(35) |
VARCHAR2(35) NOT NULL |
CIS - Major Field 1
|
| 49 |
CAN_CIS_MAJOR2 |
Character(35) |
VARCHAR2(35) NOT NULL |
CIS - Major Field 2
|