EMPLIDINCIDENT_DTXML_DLTCTA_VW(SQL View) |
Index Back |
|---|---|
ESP Delta Contract DataView to load Contract in Delta XML file |
| SELECT CT.EMPLID ,INCIDENT_DT ,CONTRACT_TYPE FROM PS_XML_JOB_ESP_VW A ,PS_WKF_CNT_TYPE CT WHERE A.EMPLID=CT.EMPLID AND A.CONTRACT_NUM=CT.CONTRACT_NUM AND CT.EFFDT<=A.INCIDENT_DT AND CT.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_WKF_CNT_TYPE A_ED WHERE CT.EMPLID = A_ED.EMPLID AND CT.CONTRACT_NUM = A_ED.CONTRACT_NUM) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | INCIDENT_DT |
Date(10) | DATE | Incident Date |
| 3 | CONTRACT_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Contract Type |