EMPLIDPrompt Table: PEOPLE_SRCH
TEST_DTN=No Personal Data Impact
U=Caused Personal Data Update
Y=Caused Personal Data Creation
Default Value: N
SAD_EOS_CD(SQL Table) |
Index Back |
|---|---|
EOS SPS Data FileEOS SPS Data File |
| # | 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 | TEST_DT |
Date(10) | DATE NOT NULL | Test Date |
| 3 | CAUSE_CREATION | Character(1) | VARCHAR2(1) NOT NULL |
Personal Data Impacts
N=No Personal Data Impact U=Caused Personal Data Update Y=Caused Personal Data Creation Default Value: N |
| 4 | SAD_LAST_NAME_LD | Character(32) | VARCHAR2(32) NOT NULL | Admissions Last Name from Test Load |
| 5 | SAD_FIRST_NAME_LD | Character(30) | VARCHAR2(30) NOT NULL | Admissions First Name from Test Load |
| 6 | SAD_MID_INIT_LD | Character(1) | VARCHAR2(1) NOT NULL | Admissions Middle Initial from Test Load |
| 7 | SAD_SSN_LD | Character(9) | VARCHAR2(9) NOT NULL | Admissions Test Load SSN |
| 8 | SAD_BIRTHDATE_LD | Character(10) | VARCHAR2(10) NOT NULL | Admissions Birthdate from Test Load |
| 9 | SAD_SEX_LD | Character(1) | VARCHAR2(1) NOT NULL | Test Load Gender |
| 10 | SAD_ADDRESS1_LD | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 11 | SAD_CITY_LD | Character(40) | VARCHAR2(40) NOT NULL | Test Load City |
| 12 | SAD_STATE_LD | Character(60) | VARCHAR2(60) NOT NULL | Test Load State |
| 13 | SAD_POSTAL_LD | Character(15) | VARCHAR2(15) NOT NULL | Test Load Postal Code |
| 14 | SAD_COUNTRY_LD | Character(30) | VARCHAR2(30) NOT NULL | Test Load Country |
| 15 | HS_CODE_EOS | Character(6) | VARCHAR2(6) NOT NULL | High School Code |
| 16 | INTEND_MAJOR_EOS | Character(3) | VARCHAR2(3) NOT NULL | Intended Major |
| 17 | OCCUPAT_CHOICE_EOS | Character(3) | VARCHAR2(3) NOT NULL | Occupational Choice |
| 18 | GRADE_CLASS_EOS | Character(2) | VARCHAR2(2) NOT NULL | Grade Classification |
| 19 | STATE_CODE_EOS | Character(2) | VARCHAR2(2) NOT NULL | Numeric State Code |
| 20 | BATCH_PROC_NBR_EOS | Character(4) | VARCHAR2(4) NOT NULL | Batch Processing Number |
| 21 | GRAD_YR_EOS | Character(4) | VARCHAR2(4) NOT NULL | Graduation Year |
| 22 | POSTAL_CORRECT_EOS | Character(1) | VARCHAR2(1) NOT NULL | Postal Correction |
| 23 | POSTAL_DEL_PNT_EOS | Character(2) | VARCHAR2(2) NOT NULL | Postal Delivery Point |
| 24 | INST_CD_EOS | Character(4) | VARCHAR2(4) NOT NULL | Institution Code |
| 25 | SUFX_INDICATOR_EOS | Character(4) | VARCHAR2(4) NOT NULL | Suffix Indicator |
| 26 | SAD_ETHNICITY_LD | Character(2) | VARCHAR2(2) NOT NULL | Ethnicity |
| 27 | SAD_EMAIL_LD | Character(70) | VARCHAR2(70) NOT NULL | EMail Address |
| 28 | HS_GRAD_DT | Date(10) | DATE | Highschool graduation date |
| 29 | SAD_EOS_PUR_ID | Character(6) | VARCHAR2(6) NOT NULL | EOS Purchase ID |
| 30 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 31 | SAD_EOS_CAN_PRVNC | Character(2) | VARCHAR2(2) NOT NULL | EOS Purchase ID |
| 32 | SAD_EOS_CAN_POSTAL | Character(18) | VARCHAR2(18) NOT NULL | EOS Purchase ID |
| 33 | SAD_EOS_MOBL_IDX | Character(4) | VARCHAR2(4) NOT NULL | EOS Purchase ID |
| 34 | SAD_EOS_MOBL_RANK | Character(2) | VARCHAR2(2) NOT NULL | EOS Purchase ID |
| 35 | SAD_EOS_INST_IDX | Character(4) | VARCHAR2(4) NOT NULL | EOS Purchase ID |
| 36 | SAD_EOS_INST_RANK | Character(2) | VARCHAR2(2) NOT NULL | EOS Purchase ID |
| 37 | SAD_EOS_SLCT_IDX | Character(3) | VARCHAR2(3) NOT NULL | EOS Purchase ID |
| 38 | SAD_EOS_SLCT_RANK | Character(2) | VARCHAR2(2) NOT NULL | EOS Purchase ID |
| 39 | SAD_EOS_SIZE_IDX | Character(3) | VARCHAR2(3) NOT NULL | EOS Purchase ID |
| 40 | SAD_EOS_SIZE_RANK | Character(2) | VARCHAR2(2) NOT NULL | EOS Purchase ID |