| # |
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
|
| 3 |
STDNT_CAR_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Student Career Nbr
|
| 4 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 5 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 6 |
SEQ_NO |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
Default Value: 1
|
| 7 |
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)
|
| 8 |
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)
|
| 9 |
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)
|
| 10 |
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
|
| 11 |
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)
|
| 12 |
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)
|
| 13 |
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)
|
| 14 |
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)
|
| 15 |
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)
|
| 16 |
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
|
| 17 |
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
|