EMPLIDDefault Value: PERSON.EMPLID
Prompt Table: PERSON
EFFDTDefault Value: %date
0=Not Applicable
1=Service Done
2=Exempt from Service
3=Service
4=Conscientious Objector
9=No Information
PERS_DATA_ESP(SQL Table) |
Index Back |
|---|---|
Extension of PERSON for ESPExtension of the PERSON object for Spanish specific fields with EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: PERSON.EMPLID Prompt Table: PERSON |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | MILIT_SITUATN_ESP | Character(3) | VARCHAR2(3) NOT NULL |
Military Status
0=Not Applicable 1=Service Done 2=Exempt from Service 3=Service 4=Conscientious Objector 9=No Information |
| 4 | SOC_SEC_AFF_DT | Date(10) | DATE | Social Security Affiliation Dt |