| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TEST_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Test ID
|
| 2 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 3 |
TEST_REC_NBR |
Number(9,0) |
DECIMAL(9) NOT NULL |
Test Type Record Nbr
|
| 4 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 5 |
NAME_PREFIX |
Character(4) |
VARCHAR2(4) NOT NULL |
Name Prefix
|
| 6 |
NAME_SUFFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Suffix
|
| 7 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 8 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 9 |
MIDDLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
MIDDLE_NAME
|
| 10 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 11 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
|
| 12 |
MAR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed
|
| 13 |
NATIONAL_ID_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
National ID Type
|
| 14 |
NATIONAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID
|
| 15 |
CAMPUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Campus
|
| 16 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
|
| 17 |
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
|
| 18 |
RECRUITING_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Recruiting Status
APPL=Applicant
INAC=Inactive
INQR=Inquiry
PAPL=Pre-Applicant
PROS=Prospect
SUSP=Suspect
|
| 19 |
ADDRESS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Type
|
| 20 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 21 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 22 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 23 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 24 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 25 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 26 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 27 |
CITIZENSHIP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Citizenship Status
|
| 28 |
PHONE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Phone Type
BUSN=Business
CAMP=Campus
CELL=Mobile
DORM=Dormitory
FAX=FAX
HOME=Home
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work
|
| 29 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 30 |
E_ADDR_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Email Address Type.
Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR.
BUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
OTHR=Other
|
| 31 |
EMAIL_ADDR |
Character(70) |
VARCHAR2(70) NOT NULL |
Email Address
|
| 32 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 33 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
|
| 34 |
ETHNIC_GRP_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Ethnic group code
|
| 35 |
ADMIT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Admit Type
|
| 36 |
ADMIT_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Admit Term
Prompt Table:
TERM_TBL
|
| 37 |
ACADEMIC_LEVEL |
Character(3) |
VARCHAR2(3) NOT NULL |
Academic Level
00=Not Set
01=First Year
02=Second Year
03=Third Year
04=Fourth Year
05=Fifth Year
06=Sixth Year
10=Freshman
20=Sophomore
30=Junior
40=Senior
50=Post-Bacc Undergraduate
GR=Graduate
GRA=Graduate AUS
HON=Honours
IE=Industrial Experience
MAS=Masters
P1=Professional Year 1
P2=Professional Year 2
P3=Professional Year 3
P4=Professional Year 4
PHD=PhD
|
| 38 |
ADM_REFRL_SRCE |
Character(4) |
VARCHAR2(4) NOT NULL |
Referral Source
|
| 39 |
LAST_SCH_ATTEND |
Character(11) |
VARCHAR2(11) NOT NULL |
Last School Attended
Prompt Table:
EXT_ORGSCHL_VW
|
| 40 |
GRADUATION_DT |
Date(10) |
DATE |
Graduation Date
|
| 41 |
FIN_AID_INTEREST |
Character(1) |
VARCHAR2(1) NOT NULL |
Financial Aid Interest
|
| 42 |
HOUSING_INTEREST |
Character(1) |
VARCHAR2(1) NOT NULL |
Housing Interest
C=Commuter
F=Off Campus Housing
H=On Campus Housing
|
| 43 |
RELIGIOUS_PREF |
Character(4) |
VARCHAR2(4) NOT NULL |
Religious Preference
Prompt Table:
REL_PREF_TBL
|