ZZ_NONEMP_INC(SQL View) |
Index Back |
|---|---|
Non-Employee IncidentsView of INJURY_ILL of all nonemployees in Incidents - Used in Query OHS003 |
| SELECT a.incident_nbr , a.incident_type , a.incident_dt , a.location , a.location_name , c.non_employee_id , c.name , b.injury_illness FROM PS_INCIDENT_DATA a , PS_NE_PERS_NM_VW c , ps_injury_ill_vw b WHERE a.incident_nbr = b.incident_nbr AND c.non_employee_id = b.non_employee_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INCIDENT_NBR | Character(8) | VARCHAR2(8) NOT NULL | Incident Number |
| 2 | INCIDENT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Incident Type
A=Accident B=Industrial Accident C=Contamination D=Industrial Accident (Official) E=Exposure H=Hazardous Condition I=Incident L=Illness N=Injury O=Dangerous Occurrence P=Unsafe Practice S=Safety Violation V=Vehicle/Equipment Accident |
| 3 | INCIDENT_DT | Date(10) | DATE | Incident Date |
| 4 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 5 | LOCATION_NAME | Character(30) | VARCHAR2(30) NOT NULL | Location Name |
| 6 | NON_EMPLOYEE_ID | Character(11) | VARCHAR2(11) NOT NULL | Non-Employee ID |
| 7 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 8 | INJURY_ILLNESS | Character(1) | VARCHAR2(1) NOT NULL |
Primarily Injury/Illness
D=Death L=Illness N=Injury |