INCIDENT_NBRNON_EMPLOYEE_IDDefault Value: OSHA301_SRCH_NE.DT_FILED_USA
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: OSHA301_SRCH_NE.HOSPITAL_IN_PT
Default Value: OSHA301_SRCH_NE.COMMENTS
OSHA_301_RPT_NE(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INCIDENT_NBR |
Character(8) | VARCHAR2(8) NOT NULL | Incident Number |
| 2 | NON_EMPLOYEE_ID |
Character(11) | VARCHAR2(11) NOT NULL | Non-Employee ID |
| 3 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 4 | TITLE | Character(35) | VARCHAR2(35) NOT NULL | Title |
| 5 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 6 | DATE_FILED | Date(10) | DATE |
Date Filed
Default Value: OSHA301_SRCH_NE.DT_FILED_USA |
| 7 | PHYSICIAN_NAME | Character(50) | VARCHAR2(50) NOT NULL | Physician Name |
| 8 | HOSPITAL | Character(30) | VARCHAR2(30) NOT NULL | Hospital Name |
| 9 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 10 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 11 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 12 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 13 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 14 | EMER_CARE_GIVEN | Character(1) | VARCHAR2(1) NOT NULL |
Emergency Care Given?
Y/N Table Edit Default Value: N |
| 15 | HOSPITAL_IN_PT | Character(1) | VARCHAR2(1) NOT NULL |
Patient Hospitalized Overnight
Y/N Table Edit Default Value: OSHA301_SRCH_NE.HOSPITAL_IN_PT |
| 16 | TIME_BEGAN_WK | Time(15) | TIMESTAMP | Time Employee Began Work |
| 17 | INCIDENT_TIME | Time(15) | TIMESTAMP | Incident Time |
| 18 | DT_OF_DEATH | Date(10) | DATE | Date of Death |
| 19 | WHAT_OBJECT_CAUSED | Character(254) | VARCHAR2(254) NOT NULL | What Object Caused Harm |
| 20 | ACTIVITY_BEFORE_IN | Character(254) | VARCHAR2(254) NOT NULL | Doing Before Incident Occurred |
| 21 | NATURE_OF_INJ_ILL | Character(254) | VARCHAR2(254) NOT NULL | Nature of Injury or Illness |
| 22 | WHAT_HAPPENED | Character(254) | VARCHAR2(254) NOT NULL |
What Happened?
Default Value: OSHA301_SRCH_NE.COMMENTS |