EMPLIDEMPL_RCDINCIDENT_NBRP=Industrial Acc. Sick Note
R=Industrial Acc. No Sick Note
XML_SEARCH_ESP(SQL View) |
Index Back |
|---|---|
Search Data DeltaAllow make the filter to Delta Views |
| SELECT B.EMPLID ,B.EMPL_RCD ,A.INCIDENT_NBR ,A.INCIDENT_DT ,B.ABS_BEGIN_DT ,B.INSUR_COMP_CD_ESP ,B.DLT_INC_TYPE_ESP FROM PS_INCIDENT_DATA A ,PS_INJURY_ILL_ESP B WHERE A.INCIDENT_NBR=B.INCIDENT_NBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | INCIDENT_NBR |
Character(8) | VARCHAR2(8) NOT NULL | Incident Number |
| 4 | INCIDENT_DT | Date(10) | DATE | Incident Date |
| 5 | ABS_BEGIN_DT | Date(10) | DATE | Absence Begin Date |
| 6 | INSUR_COMP_CD_ESP | Character(5) | VARCHAR2(5) NOT NULL | Insurance Company Code |
| 7 | DLT_INC_TYPE_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Incident Type Esp
P=Industrial Acc. Sick Note R=Industrial Acc. No Sick Note |