HR_OSHA_300_TMP(SQL Table) |
Index Back |
|---|---|
OSHA 300/300A Report View |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  CASE_NBR_USA |
Character(5) | VARCHAR2(5) NOT NULL | Case Number |
| 2 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 3 | ESTABID |
Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 4 | YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Character field to represent a year |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 7 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 8 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 9 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 10 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 11 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 12 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 13 | JOB_TITLE | Character(10) | VARCHAR2(10) NOT NULL | Job Title |
| 14 | INCIDENT_DT | Date(10) | DATE | Incident Date |
| 15 | EXACT_LOCATION | Character(240) | VARCHAR2(240) NOT NULL | Exact Location |
| 16 | OSHA_200_DESCR | Character(60) | VARCHAR2(60) NOT NULL | Log Comments |
| 17 | FATALITY_SW | Character(1) | VARCHAR2(1) NOT NULL | Fatal Injuries Sustained |
| 18 | INJURY_ILLNESS | Character(1) | VARCHAR2(1) NOT NULL |
Primarily Injury/Illness
D=Death L=Illness N=Injury |
| 19 | AWAY_FROM_WORKDAYS | Number(4,0) | SMALLINT NOT NULL | Days Away From Work |
| 20 | RESTRICTD_WORKDAYS | Number(4,0) | SMALLINT NOT NULL | Restricted Workdays |
| 21 | TRANSFER_WORKDAYS | Number(4,0) | SMALLINT NOT NULL | Temp Transfer Work Days |
| 22 | OSHA_INJ_CLASS | Character(1) | VARCHAR2(1) NOT NULL |
OSHA Injury Classification
1=Injury 2=Skin Disorder 3=Respiratory Condition 4=Poisoning 5=Hearing Loss 6=All Other Illnesses |
| 23 | ILLNESS_RESULT | Character(1) | VARCHAR2(1) NOT NULL |
Illness Resulted In
N=Not Applicable T=Termination X=Transfer |
| 24 | PRIVACY_CASE | Character(1) | VARCHAR2(1) NOT NULL |
Privacy Case
Y/N Table Edit Default Value: N |
| 25 | BUS_ACTIVITY_LINE1 | Character(40) | VARCHAR2(40) NOT NULL | Business Activity |
| 26 | BUS_ACTIVITY_LINE2 | Character(40) | VARCHAR2(40) NOT NULL | Business Activity |
| 27 | BUS_ACTIVITY_LINE3 | Character(40) | VARCHAR2(40) NOT NULL | Business Activity |
| 28 | BUS_ACTIVITY_LINE4 | Character(40) | VARCHAR2(40) NOT NULL | Business Activity |
| 29 | SIC | Character(4) | VARCHAR2(4) NOT NULL | Standard Industrial Classif |
| 30 | NAICS | Character(6) | VARCHAR2(6) NOT NULL | North Amer Ind Class Sys |
| 31 | TOTAL_EE_COUNT | Number(12,3) | DECIMAL(11,3) NOT NULL |
Total Number of Employees
Default Value: 0 |
| 32 | TOTAL_EE_HRS | Number(11,2) | DECIMAL(10,2) NOT NULL |
Total Employee Hours
Default Value: 0 |