EMPLIDINCIDENT_DTXML_DLT_LBR_VW(SQL View) |
Index Back |
|---|---|
Labor Agreement Delta XMLAllow load Labor Agreement to Xml Delta file |
| SELECT A.EMPLID ,INCIDENT_DT ,DESCR FROM PS_XML_JOB_ESP_VW A ,PS_HR_LABOR_AGRMNT LA WHERE A.LABOR_AGREEMENT=LA.LABOR_AGREEMENT AND LA.EFFDT<=A.INCIDENT_DT AND LA.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_HR_LABOR_AGRMNT A_ED WHERE LA.LABOR_AGREEMENT=A_ED.LABOR_AGREEMENT) AND LA.EFF_STATUS='A' AND LA.SETID='ESP' |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |