|
SELECT %subrec(HS_INC_DATA_SBR,A) , CASE WHEN A.RECURRENCE = ' ' THEN 'N' ELSE A.RECURRENCE END , CASE WHEN A.RESULT_INJURY_ILL = ' ' THEN 'N' ELSE A.RESULT_INJURY_ILL END , CASE WHEN A.INVESTIGATED = ' ' THEN 'N' ELSE A.INVESTIGATED END , CASE WHEN A.EMPLOYER_PREMISES = ' ' THEN 'Y' ELSE A.EMPLOYER_PREMISES END , COALESCE (( SELECT RR.DESCR50 FROM PS_REG_REGION_TBL RR WHERE RR.REG_REGION = A.REG_REGION), ' ') , COALESCE(( SELECT A5.DESCR FROM PS_LOCATION_TBL A5 WHERE A.SETID_LOCATION = A5.SETID AND A.LOCATION = A5.LOCATION AND %EffdtCheck(LOCATION_TBL A51, A5, %CurrentDateIn)), ' ') , COALESCE(( SELECT A12.DESCR FROM PS_ESTAB_TBL A12 WHERE A12.ESTABID = A.ESTABID AND A12.EFF_STATUS = 'A' AND %EffdtCheck(ESTAB_TBL A121, A12, %CurrentDateIn)), ' ') , COALESCE(B.LASTUPDDTTM,%DateTimeIn('1900-01-01-00.00.00.000000')) FROM PS_INCIDENT_DATA A LEFT OUTER JOIN PS_INCIDENT_STATUS B ON 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
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 |
EXACT_LOCATION |
Character(240) |
VARCHAR2(240) NOT NULL |
Exact Location
|
| 25 |
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
|
| 26 |
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
|
| 27 |
HS_RECURRENCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Is This a Recurrence
N=No
Y=Yes
Default Value: N
|
| 28 |
HS_RSLT_INJURY_ILL |
Character(1) |
VARCHAR2(1) NOT NULL |
Resulted in Injury or Illness
N=No
Y=Yes
Default Value: N
|
| 29 |
HS_INVESTIGATED |
Character(1) |
VARCHAR2(1) NOT NULL |
Investigated
N=No
Y=Yes
Default Value: N
|
| 30 |
HS_EMPLYR_PREMISES |
Character(1) |
VARCHAR2(1) NOT NULL |
Occurred on Employer Premises
N=No
Y=Yes
Default Value: Y
|
| 31 |
REG_REGION_DESCR |
Character(50) |
VARCHAR2(50) NOT NULL |
Regulatory Region
|
| 32 |
LOCATION_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Location Description
|
| 33 |
ESTAB_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 34 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|