EMPLIDINCIDENT_DT1=Usual Work Center
2=Taken Journey
3=In Itinere
4=Other Work Center
0=Other Accident
1=Car Accident
XML_DLT_PLC_VW(SQL View) |
Index Back |
|---|---|
View Delt@ Place DataView Delta Place Data, in case of accident in itinere or in journey. |
| SELECT A.EMPLID , C.INCIDENT_DT , A.DLT_PLACE_CODE_ESP , D.DLT_CAR_INC_ESP , C.COUNTRY , C.STATE , C.CITY , C.ADDRESS1 , A.DLT_VIAKM_ESP , A.DLT_OTH_ADDR_ESP FROM PS_INJURY_ILL_ESP A , PS_INCIDENT_DATA C , PS_INCDNT_DATA_ESP D WHERE A.INCIDENT_NBR = C.INCIDENT_NBR AND A.INCIDENT_NBR = D.INCIDENT_NBR AND A.DLT_PLACE_CODE_ESP IN ('2', '3') |
| # | 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 | DLT_PLACE_CODE_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Place Code
1=Usual Work Center 2=Taken Journey 3=In Itinere 4=Other Work Center |
| 4 | DLT_CAR_INC_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Car Incident
0=Other Accident 1=Car Accident |
| 5 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 6 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 7 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 8 | ADDRESS100 | Character(100) | VARCHAR2(100) NOT NULL | Address 1 |
| 9 | DLT_VIAKM_ESP | Character(40) | VARCHAR2(40) NOT NULL | Place Code |
| 10 | DLT_OTH_ADDR_ESP | Character(40) | VARCHAR2(40) NOT NULL | Place Code |