| # |
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 |
CS_PRI_NAME_PREFIX |
Character(4) |
VARCHAR2(4) NOT NULL |
CS_PRI_NAME_PREFIXis used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 3 |
CS_PRI_FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
CS_PRI_FIRST_NAME is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 4 |
CS_PRI_MIDDLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
CS_PRI_MIDDLE_NAMEis used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 5 |
CS_PRI_LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
CS_PRI_LAST_NAME is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 6 |
CS_PRI_NAME_SUFFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
CS_PRI_NAME_SUFFIXis used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 7 |
CS_ALT_NAME_PREFIX |
Character(4) |
VARCHAR2(4) NOT NULL |
CS_ALT_NAME_PREFIXis used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 8 |
CS_ALT_FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
CS_ALT_FIRST_NAME is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 9 |
CS_ALT_MIDDLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
CS_ALT_MIDDLE_NAMEis used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 10 |
CS_ALT_LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
CS_ALT_LAST_NAME is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 11 |
CS_ALT_NAME_SUFFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
CS_ALT_NAME_SUFFIXis used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 12 |
CS_GENDER |
Character(1) |
VARCHAR2(1) NOT NULL |
CS_GENDER is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 13 |
CS_PRI_ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1 is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 14 |
CS_PRI_ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2 is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 15 |
CS_PRI_ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3 is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 16 |
CS_PRI_ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4 is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 17 |
CS_PRI_ADDR_NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
CS_PRI_ADDR_NUM1 is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 18 |
CS_PRI_ADDR_NUM2 |
Character(4) |
VARCHAR2(4) NOT NULL |
CS_PRI_ADDR_NUM2 is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 19 |
CS_PRI_HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
CS_PRI_HOUSE_TYPE is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 20 |
CS_PRI_CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
CS_PRI_CITY is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 21 |
CS_PRI_STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
CS_PRI_STATE is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 22 |
CS_PRI_POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
CS_PRI_POSTAL is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 23 |
CS_PRI_COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
CS_PRI_COUNTY is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 24 |
CS_PRI_COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
CS_PRI_COUNTRY is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 25 |
CS_PRI_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
CS_PRI_PHONE is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 26 |
CS_ALT_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
CS_ALT_PHONE is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 27 |
CS_EMAIL_ADDRESS |
Character(70) |
VARCHAR2(70) NOT NULL |
CS_EMAIL_ADDRESS is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 28 |
CS_RELIGIOUS_PREF |
Character(4) |
VARCHAR2(4) NOT NULL |
CS_RELIGIOUS_PREF is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 29 |
CS_SSN |
Character(20) |
VARCHAR2(20) NOT NULL |
CS_SSN is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 30 |
CS_BIRTH_DATE |
Date(10) |
DATE |
CS_BIRTH_DATE is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 31 |
CS_BIRTH_PLACE |
Character(30) |
VARCHAR2(30) NOT NULL |
CS_BIRTH_PLACE is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 32 |
CS_BIRTH_STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
CS_BIRTH_STATE is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 33 |
CS_BIRTH_COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
CS_BIRTH_COUNTRY is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 34 |
CS_CITIZEN_COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
CS_CITIZEN_COUNTRYis used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 35 |
CS_ALT_ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
CS_ALT_ADDRESS1 is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 36 |
CS_ALT_ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
CS_ALT_ADDRESS2 is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 37 |
CS_ALT_ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
CS_ALT_ADDRESS3 is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 38 |
CS_ALT_ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
CS_ALT_ADDRESS4 is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 39 |
CS_ALT_ADDR_NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
CS_ALT_ADDR_NUM1 is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 40 |
CS_ALT_ADDR_NUM2 |
Character(4) |
VARCHAR2(4) NOT NULL |
CS_ALT_ADDR_NUM2 is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 41 |
CS_ALT_HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
CS_ALT_HOUSE_TYPE is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 42 |
CS_ALT_CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
CS_ALT_CITY is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 43 |
CS_ALT_STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
CS_ALT_STATE is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 44 |
CS_ALT_POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
CS_ALT_POSTAL is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 45 |
CS_ALT_COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
CS_ALT_COUNTY is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 46 |
CS_ALT_COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
CS_ALT_COUNTRY is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 47 |
CS_ETHNIC_GROUP |
Character(1) |
VARCHAR2(1) NOT NULL |
CS_ETHNIC_GROUP is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 48 |
CS_CITIZEN_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
CS_CITIZEN_STATUS is used in OLM Profile student admin Dialog for OLM/SA Integration.
|
| 49 |
CS_ETHNIC_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
|
| 50 |
CS_REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
REG_REGION field used in the CS / CRM sync Application Messages.
|
| 51 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 52 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 53 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 54 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 55 |
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.
|
| 56 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|