PERSON_NID_ESPCNT_BGN_DT_ESPDefault Value: %date
XML_CTTA_RESPVW(SQL View) |
Index Back |
|---|---|
View Contrat@ DataView Contrat@ Data |
| SELECT D.NATIONAL_ID , A.EFFDT , A.EMPLID , A.EFFDT , A.CONTRACT_NUM FROM PS_WKF_CNT_TYP_ESP A , PS_PERS_NID D WHERE A.EMPLID = D.EMPLID AND D.NATIONAL_ID_TYPE = 'SSN' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_NID_ESP |
Character(20) | VARCHAR2(20) NOT NULL | Occupational Code |
| 2 | CNT_BGN_DT_ESP |
Date(10) | DATE | Contract Begin Dt |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract Number |