EMPLIDINCIDENT_DTXML_DLT_INSR_VW(SQL View) |
Index Back |
|---|---|
Delta Insurance DataDelta Insurance Company Data View |
| SELECT A.EMPLID ,B.INCIDENT_DT ,C.DLT_INSURNC_ID_ESP FROM PS_INJURY_ILL_ESP A , PS_INCIDENT_DATA B , PS_INSUR_COMP_ESP C WHERE A.INCIDENT_NBR = B.INCIDENT_NBR AND A.INSUR_COMP_CD_ESP = C.INSUR_COMP_CD_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 | DLT_INSURNC_ID_ESP | Character(4) | VARCHAR2(4) NOT NULL | Insurance Company Code |