HR_OSHA_301_TMP

(SQL Table)
 Index Back

Temp table for 301 Reports

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 NON_EMPLOYEE_ID Character(11) VARCHAR2(11) NOT NULL Non-Employee ID
4 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
6 TITLE Character(35) VARCHAR2(35) NOT NULL Title
7 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
8 DATE_FILED Date(10) DATE Date Filed
9 NAME Character(50) VARCHAR2(50) NOT NULL Name
10 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
11 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
12 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
13 CITY Character(30) VARCHAR2(30) NOT NULL City
14 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

15 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
16 BIRTHDATE Date(10) DATE Date of Birth
17 ORIG_HIRE_DT Date(10) DATE Original Start Date
18 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
19 PHYSICIAN_NAME Character(50) VARCHAR2(50) NOT NULL Physician Name
20 HOSPITAL Character(30) VARCHAR2(30) NOT NULL Hospital Name
21 ADDRESS1_OTHER Character(55) VARCHAR2(55) NOT NULL Address 1 Other
22 ADDRESS2_OTHER Character(55) VARCHAR2(55) NOT NULL Address 2 Other
23 CITY50 Character(50) VARCHAR2(50) NOT NULL City
24 STATE2 Character(6) VARCHAR2(6) NOT NULL State
25 POSTAL2 Character(12) VARCHAR2(12) NOT NULL Postal Code
26 EMER_CARE_GIVEN Character(1) VARCHAR2(1) NOT NULL Emergency Care Given?

Y/N Table Edit

27 HOSPITAL_IN_PT Character(1) VARCHAR2(1) NOT NULL Patient Hospitalized Overnight

Y/N Table Edit

28 CASE_NBR_USA Character(5) VARCHAR2(5) NOT NULL Case Number
29 INCIDENT_DT Date(10) DATE NOT NULL Incident Date
30 INCIDENT_TIME Time(15) TIMESTAMP Incident Time
31 TIME_BEGAN_WK Time(15) TIMESTAMP Time Employee Began Work
32 ACTIVITY_BEFORE_IN Character(254) VARCHAR2(254) NOT NULL Doing Before Incident Occurred
33 NATURE_OF_INJ_ILL Character(254) VARCHAR2(254) NOT NULL Nature of Injury or Illness
34 DT_OF_DEATH Date(10) DATE Date of Death
35 FATALITY_SW Character(1) VARCHAR2(1) NOT NULL Fatal Injuries Sustained
36 WHAT_OBJECT_CAUSED Character(254) VARCHAR2(254) NOT NULL What Object Caused Harm
37 WHAT_HAPPENED Character(254) VARCHAR2(254) NOT NULL What Happened?
38 PRIVACY_CASE Character(1) VARCHAR2(1) NOT NULL Privacy Case