| # |
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 |
RA_ATTRIB_SEQ |
Number(31,0) |
DECIMAL(31) NOT NULL |
Profile / attribute sequence numbers
|
| 3 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 4 |
BIRTHPLACE |
Character(90) |
VARCHAR2(90) NOT NULL |
The location or place where a person was born.
|
| 5 |
BIRTHCOUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
The country where a person was born.
|
| 6 |
BIRTHSTATE |
Character(6) |
VARCHAR2(6) NOT NULL |
The state where a person was born.
|
| 7 |
DT_OF_DEATH |
Date(10) |
DATE |
This is the Date of Death field.
|
| 8 |
HIGHEST_EDUC_LVL |
Character(2) |
VARCHAR2(2) NOT NULL |
This is the highest education level field.
|
| 9 |
FT_STUDENT |
Character(1) |
VARCHAR2(1) NOT NULL |
This is the full-time student field.
|
| 10 |
PER_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Person type.
C=Cobra Participant
D=GP Dependent/Beneficiary
E=Leased Worker
I=Independent Contractor
L=Time & Labor Contractor
M=Temporary Worker
N=Non HR Administered Employee
O=Other Non-Employee
P=Pension Payee
S=Stock Non-Employee
T=Training Non-Employee
U=Succession Candidate Non-Emplo
|
| 11 |
MAR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status field used in HD_360_RESPONSE_SYNC message.
A=Annulled
B=Living Together
C=Common-Law
D=Divorced
E=Separated
F=Living Apart
G=Maintained
H=Head of Household
I=Interlocutory
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed
X=Widowed With Pension
Y=Polygamous
|
| 12 |
MILITARY_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Military Status
1=Not Indicated
2=No Military Service
3=Vietnam Era Veteran
4=Other Veteran
5=Active Reserve
6=Inactive Reserve
7=Retired
8=Veteran (VA Ineligible)
9=Vietnam & Other Protected Vet
A=Armed Forces Service Medal Vet
B=Pre-Vietnam-Era Veteran
N=Not a Vietnam-Era Veteran
O=Service Medal & Other Vet
P=Post-Vietnam-Era Veteran
V=Vietnam-Era Veteran
X=Not a Veteran
|
| 13 |
CITIZEN_PROOF1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Citizenship (Proof 1)
|
| 14 |
CITIZEN_PROOF2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Citizenship (Proof 2)
|
| 15 |
CS_CAMPUS_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
CS_CAMPUS_ID is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 16 |
CS_DEATH_CERT_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
Death Certificate Number
|
| 17 |
CS_FERPA |
Character(1) |
VARCHAR2(1) NOT NULL |
CS_FERPA is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 18 |
CS_PLACE_OF_DEATH |
Character(30) |
VARCHAR2(30) NOT NULL |
CS_PLACE_OF_DEATH is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 19 |
DISABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a dependent is a disabled.
|
| 20 |
DISABLED_VET |
Character(1) |
VARCHAR2(1) NOT NULL |
DISABLED_VET is a field used in PERSON_COMPETENCY_SYNC.
|
| 21 |
CS_WAIVE_DATA_PROT |
Character(1) |
VARCHAR2(1) NOT NULL |
CS_WAIVE_DATA_PROTis used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 22 |
CS_CAN_ABORIGINAL |
Character(1) |
VARCHAR2(1) NOT NULL |
CS_CAN_ABORIGINAL is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 23 |
CS_CAN_VIS_MINOR |
Character(1) |
VARCHAR2(1) NOT NULL |
CS_CAN_VIS_MINOR is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 24 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 25 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 26 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 27 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 28 |
SYNCID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
|
| 29 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|