| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INCIDENT_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Incident Number
Default Value: 0
|
| 2 |
OSHA_UNDETERMINED |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Undetermined
Default Value: N
|
| 3 |
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
M=Near Miss
N=Injury
O=Dangerous Occurrence
P=Unsafe Practice
R=Environmental
S=Safety Violation
V=Vehicle/Equipment Accident
Default Value: I
|
| 4 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
Default Value: OPR_DEF_TBL_HR.REG_REGION
Prompt Table:
REG_HANDS_VW
|
| 5 |
DANGER_OCC_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Dangerous Occurrence Code
Prompt Table:
DANGER_OCC_TBL
|
| 6 |
INCIDENT_DT |
Date(10) |
DATE NOT NULL |
Incident Date
Default Value: %date
|
| 7 |
INCIDENT_TIME |
Time(15) |
TIMESTAMP |
Incident Time
|
| 8 |
HS_TIMEZONE1 |
Character(9) |
VARCHAR2(9) NOT NULL |
Health and Safety Time Zone Field 1
Prompt Table:
PSTIMEZONE
|
| 9 |
RECURRENCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Is This a Recurrence
Y/N Table Edit
Default Value: N
|
| 10 |
RESULT_INJURY_ILL |
Character(1) |
VARCHAR2(1) NOT NULL |
Resulted in Injury or Illness
Y/N Table Edit
Default Value: N
|
| 11 |
REPORTED_BY_EMPL |
Character(11) |
VARCHAR2(11) NOT NULL |
Reported By Empl ID
Prompt Table:
PERSON_NAME
|
| 12 |
REPORTED_BY_NONEMP |
Character(11) |
VARCHAR2(11) NOT NULL |
Reported By Non-Empl ID
Prompt Table:
NE_INCIDNT_SRCH
|
| 13 |
REPORTED_TO |
Character(11) |
VARCHAR2(11) NOT NULL |
Reported To Empl ID
Prompt Table:
PERSON_NAME
|
| 14 |
DT_REPORTED |
Date(10) |
DATE |
Date Reported
Default Value: %date
|
| 15 |
TIME_REPORTED |
Time(15) |
TIMESTAMP |
Time Reported
|
| 16 |
DT_RECORDED |
Date(10) |
DATE |
Date Recorded
Default Value: %date
|
| 17 |
TIME_RECORDED |
Time(15) |
TIMESTAMP |
Time Recorded
|
| 18 |
INVESTIGATED |
Character(1) |
VARCHAR2(1) NOT NULL |
Investigated
Y/N Table Edit
Default Value: N
|
| 19 |
EMPLOYER_PREMISES |
Character(1) |
VARCHAR2(1) NOT NULL |
Occurred on Employer Premises
Y/N Table Edit
Default Value: Y
|
| 20 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location Set ID
Prompt Table:
SETID_TBL
|
| 21 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
HS_LOCATION_VW
|
| 22 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table:
%EDITTABLE
|
| 23 |
LOCATION_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Location Name
|
| 24 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 25 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 26 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 27 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 28 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 29 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 30 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 31 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 32 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference
WW=House Trailer Reference
|
| 33 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 34 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 35 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 36 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 37 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 38 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 39 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 40 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 41 |
EXACT_LOCATION |
Character(240) |
VARCHAR2(240) NOT NULL |
Exact Location
|
| 42 |
ROAD_CONDITION |
Character(1) |
VARCHAR2(1) NOT NULL |
Road Condition
D=Dry
I=Icy
L=Loose Sand/Gravel
M=Muddy
N=Not Applicable
S=Snow
W=Wet
|
| 43 |
WEATHER_CONDITION |
Character(2) |
VARCHAR2(2) NOT NULL |
Weather Condition
CL=Cloudy
EQ=Earthquake
FF=Flash Flood
FL=Flood
FO=Foggy
HU=Hurricane
NA=Not Applicable
RA=Rain
SL=Sleet
SN=Snow
SU=Sunny/Clear
TO=Tornado
UN=Unclassified
|
| 44 |
INC_OUTCOME_CAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Incident Outcome
DO=Dangerous Occurence
FAT=Fatality
HCO=Health Care Only
RPO=Reported Only
STD=Short Term Disability
|
| 45 |
WCB_JURISDICT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
In WCB Jurisdiction
Y/N Table Edit
Default Value: Y
|
| 46 |
CLASS_SUBCLASS |
Number(6,0) |
INTEGER NOT NULL |
Class/Subclass
Prompt Table:
%EDITTABLE17
|
| 47 |
EXPOSURE_ST_DT |
Date(10) |
DATE |
Exposure Start Date
|
| 48 |
EXPOSURE_ST_TM |
Time(15) |
TIMESTAMP |
Exposure Start Time
|
| 49 |
HS_TIMEZONE2 |
Character(9) |
VARCHAR2(9) NOT NULL |
Health and Safety Time Zone Field 2
Default Value: INCIDENT_DATA.HS_TIMEZONE1
|
| 50 |
EXPOSURE_END_DT |
Date(10) |
DATE |
Exposure End Date
|
| 51 |
EXPOSURE_END_TM |
Time(15) |
TIMESTAMP |
Exposure End Time
|
| 52 |
BUSINESS_TYPE |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Type For Event
|
| 53 |
OCCURRENCE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Occurrence Type Code
Prompt Table:
DANGER_OCC_TBL
|
| 54 |
DATE_TIME_EXACT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Date and Time Exact
Y/N Table Edit
Default Value: N
|
| 55 |
INCDNT_OP_LOCN_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Incident At Operating Locn
Y/N Table Edit
Default Value: N
|
| 56 |
SCENE_DESCR |
Character(200) |
VARCHAR2(200) NOT NULL |
Description of Accident Scene
|
| 57 |
INCDNT_TMP_SITE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accident At Temporary Site
Y/N Table Edit
Default Value: N
|
| 58 |
CLAIM_CONTACT_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Claim Contact ID
|
| 59 |
HS_CONTACT_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Health && Safety Contact ID
Prompt Table:
PERSON_NAME
|
| 60 |
PAYROLL_CNCT_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Payroll Contact ID
Prompt Table:
PERSON_NAME
|
| 61 |
LOCN_SIZE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Location Size Code
A=A: Less than 6
B=B: 6 to 10
C=C: 11 to 15
D=D: 16 to 20
E=E: 21 to 49
F=F: 50 to 100
G=G: 101 to 200
H=H: More than 200
|
| 62 |
DISABLED_PROG_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Program For Disabled Indicator
Y/N Table Edit
Default Value: N
|
| 63 |
DIS_PROG_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Disabled Program Contact ID
Prompt Table:
PERSON_NAME
|
| 64 |
RTW_AVAILABLE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Return To Work Program Availab
Y/N Table Edit
|
| 65 |
WRKRS_INVLD_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether one or more employees (workers) were involved in the reported incident
valid codes
Y = yes
N = No
Y/N Table Edit
Default Value: N
|
| 66 |
INC_LOCN_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Code that identifies the loation where the injury/incident occurred
VALID CODES
OLC - operating location
TWS - temporary worksite
OEP - off employer premises
OLC=Operating Location
|
| 67 |
DAN_OCR_TYPE_CAN |
Character(2) |
VARCHAR2(2) NOT NULL |
A code that identifies the type of near miss/dangerous occurrence
Aliases:
Near Miss
Valid Codes
10 - Structural Failure or Collapse
20 - Release of Toxic or Hazardous Substance
30 - Blasting Accident
40 - Diving Accident
50 - Other Potential for Serious Injury
10=Structural Failure
|
| 68 |
WCB_EVNT_RPT_TYP |
Character(3) |
VARCHAR2(3) NOT NULL |
Event Report Type
MWO=Multiple Injured Workers
NWO=No Injured Workers
OFW=One Fatal Injured Worker
OIW=One Injured Worker
ONI=One Not Injured Worker
|
| 69 |
STREET_NBR |
Character(7) |
VARCHAR2(7) NOT NULL |
Street Number
|
| 70 |
STREET_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Street Name
|
| 71 |
STREET_UNIT_NBR |
Character(6) |
VARCHAR2(6) NOT NULL |
Street Unit_number
|
| 72 |
WCB_PO_BOX |
Character(5) |
VARCHAR2(5) NOT NULL |
P.O.Box (for WCB Purposes)
|
| 73 |
WCB_RR_NBR |
Character(4) |
VARCHAR2(4) NOT NULL |
Rural Route Number - WCB
|
| 74 |
INCIDENT_STAT_FRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Incident Status
CNU=Known
CST=Definite
|
| 75 |
INCIDENT_TYPE_FRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Incident Type - France
MAP=Occupational Illness
TRJ=Journey
TRV=Work
|
| 76 |
REP_BY_CLASS_FRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Reported By Whom
EMP=Employer
PRE=Supervisor
VIC=Victim
|
| 77 |
REP_POLICE_SW_FRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Police Report
Y/N Table Edit
|
| 78 |
REP_POLICE_NAM_FRA |
Character(30) |
VARCHAR2(30) NOT NULL |
Author of Police Report
|
| 79 |
LOCATION_CLASS_FRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Location Class
DEP=On Company Business
DOM=At Home
TRH=At Normal Place Of Work
TRJ=Commuting To/From Work
TRO=At Other Occasional Workplace
|
| 80 |
SIGNER_EMPLID_FRA |
Character(11) |
VARCHAR2(11) NOT NULL |
Signed Off By EmplID
Prompt Table:
PERSON_NAME
|
| 81 |
WHERE_REPORTED_FRA |
Character(30) |
VARCHAR2(30) NOT NULL |
Where Reported
|
| 82 |
LOCAL_AUTHORITY_UK |
Character(30) |
VARCHAR2(30) NOT NULL |
Local Authority
|
| 83 |
PUBLIC_PLACE_SW_UK |
Character(1) |
VARCHAR2(1) NOT NULL |
Public Place
Y/N Table Edit
|
| 84 |
MIX_COM_DET_MEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Mixed Committee Detail Mexico
Y/N Table Edit
Default Value: N
|
| 85 |
MIXED_COMM_ID_MEX |
Character(12) |
VARCHAR2(12) NOT NULL |
Mixed Committee ID
Prompt Table:
MIX_COM_TBL_MEX
|
| 86 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|