HS_INCSUM_VW(SQL View) |
Index Back |
|---|---|
Health/Safety Inc Summary ViewView used by crystal report OHS010-- Incident Summary |
| SELECT a.incident_nbr , a.incident_type , a.incident_dt , a.incident_time , a.hs_timezone1 , a.result_injury_ill , a.recurrence , a.employer_premises , a.location , a.location_name , b.emplid , b.non_employee_id , b.reportable_case , b.case_nbr_ger , b.case_nbr_ger , b.case_nbr_usa FROM ps_incident_data a , PS_INJURY_ILL b WHERE a.incident_nbr = b.incident_nbr |
| # | 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 | TIME_REPORTED | Time(15) | TIMESTAMP | Time Reported |
| 5 | HS_TIMEZONE1 | Character(9) | VARCHAR2(9) NOT NULL | Health and Safety Time Zone Field 1 |
| 6 | RESULT_INJURY_ILL | Character(1) | VARCHAR2(1) NOT NULL | Resulted in Injury or Illness |
| 7 | RECURRENCE | Character(1) | VARCHAR2(1) NOT NULL | Is This a Recurrence |
| 8 | EMPLOYER_PREMISES | Character(1) | VARCHAR2(1) NOT NULL | Occurred on Employer Premises |
| 9 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 10 | LOCATION_NAME | Character(30) | VARCHAR2(30) NOT NULL | Location Name |
| 11 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 12 | NON_EMPLOYEE_ID | Character(11) | VARCHAR2(11) NOT NULL | Non-Employee ID |
| 13 | REPORTABLE_CASE | Character(1) | VARCHAR2(1) NOT NULL | Reportable Case |
| 14 | CASE_NBR | Character(5) | VARCHAR2(5) NOT NULL | Case Number |
| 15 | CASE_NBR_GER | Character(5) | VARCHAR2(5) NOT NULL | Case Number |
| 16 | CASE_NBR_USA | Character(5) | VARCHAR2(5) NOT NULL | Case Number |