| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BO_ID |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Business Object ID
|
| 2 |
PERSON_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Person ID
|
| 3 |
NAME_PREFIX |
Character(4) |
VARCHAR2(4) NOT NULL |
Name Prefix
|
| 4 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 5 |
MIDDLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Middle Name
|
| 6 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 7 |
NAME_SUFFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Suffix
|
| 8 |
BIRTHDATE |
Date(10) |
DATE |
Birthdate of the person.
|
| 9 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender of the person.
F=Female
M=Male
U=Unknown
|
| 10 |
MARITAL_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Marital Status
1=Single
2=Married
3=Married but Separated
4=Divorced
5=Widow
|
| 11 |
NATIONAL_ID_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
National ID Type
|
| 12 |
NATIONAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID
|
| 13 |
NATIONAL_ID_FORMAT |
Character(20) |
VARCHAR2(20) NOT NULL |
National Identifier Formatting Field
|
| 14 |
ADDRESS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address type field to store address type information.
BUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
LEGL=Legal
MAIL=Mailing
OTHR=Other
|
| 15 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 16 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 17 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 18 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 19 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 20 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 21 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 22 |
E_ADDR_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address type field used in HD_360_RESPONSE_SYNC message.
BUSN=Business
CAMP=Campus
DORM=Dorm
HOME=Home
OTHR=Other
|
| 23 |
EMAIL_ADDR |
Character(70) |
VARCHAR2(70) NOT NULL |
Email address to store the address of email.
|
| 24 |
PHONE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
phone type field to store value of phone type.
BUSN=Business Phone
CAMP=Campus
CELL=Cellular Phone
DFLT=Default
DORM=Dormitory
FAX=FAX
HOME=Home Phone
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work
|
| 25 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
This field stores the Telephone number.
|
| 26 |
CITIZENSHIP_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
DMO
NRA=Non-Resident Alien
PRA=Permanent Resident Alien
RA=Resident Alien
USC=U.S. Citizen
|
| 27 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Institution field to store institution information in campus solution system.
|
| 28 |
ACAD_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic career field coming from campus solution system.
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
|
| 29 |
CAMPUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Campus
|
| 30 |
RECRUITING_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Recruiting Status
APPL=Applicant
INAC=Inactive
INQR=Inquiry
PROS=Prospect
SUSP=Suspect
|
| 31 |
ADM_REFRL_SRCE |
Character(4) |
VARCHAR2(4) NOT NULL |
Referral Source
|
| 32 |
ADMIT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Admit type stores information about the type of admission.
|
| 33 |
ADMIT_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
stores information about term attending.
|
| 34 |
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
|
| 35 |
LAST_SCH_ATTEND |
Character(11) |
VARCHAR2(11) NOT NULL |
Last school attended
|
| 36 |
GRADUATION_DT |
Date(10) |
DATE |
Enter the graduation date information.
|
| 37 |
FIN_AID_INTEREST |
Character(1) |
VARCHAR2(1) NOT NULL |
Financial Aid Interest
Y/N Table Edit
|
| 38 |
HOUSING_INTEREST |
Character(1) |
VARCHAR2(1) NOT NULL |
Housing interest
C=Commuter
F=Off Campus Housing
H=On Campus Housing
|
| 39 |
RELIGIOUS_PREF |
Character(4) |
VARCHAR2(4) NOT NULL |
This field stores the religious preference of an individual.
|
| 40 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
REG_REGION field used in the HCM / CRM sync Application Messages.
|
| 41 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|