HS_AWETRX_VW

(SQL View)
 Index Back

Incident Report Approvals

HS incident report approvals transactions.

SELECT HS.EMPLID , HS.ACTION_DT_SS , HS.EFFSEQ , HS.INCIDENT_NBR , HS.INCIDENT_TYPE , HS.INCIDENT_DT , HS.RESULT_INJURY_ILL , HS.ORIGINATORID , STP.EOAWSTEP_STATUS , STP.OPRID , XRF.EOAWPRCS_ID FROM PS_HS_SS_INCDT_DAT HS , PS_HS_AWE_XREF XRF , PS_EOAW_STEP_VW STP WHERE HS.EMPLID = XRF.EMPLID AND HS.ACTION_DT_SS = XRF.ACTION_DT_SS AND HS.EFFSEQ = XRF.EFFSEQ AND HS.INCIDENT_NBR = XRF.INCIDENT_NBR AND STP.EOAWPRCS_ID = XRF.EOAWPRCS_ID AND STP.EOAWDEFN_ID = XRF.EOAWDEFN_ID AND STP.EOAWTHREAD_ID = XRF.EOAWTHREAD_ID AND STP.EOAWSTEP_STATUS IN ('A','B','P')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 ACTION_DT_SS Date(10) DATE Termination Date
3 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
4 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number
5 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
6 INCIDENT_DT Date(10) DATE Incident Date
7 RESULT_INJURY_ILL Character(1) VARCHAR2(1) NOT NULL Resulted in Injury or Illness
8 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
9 EOAWSTEP_STATUS Character(1) VARCHAR2(1) NOT NULL Step Instance Status
A=Approved
B=Pushed back
C=Auto Approved
D=Denied
E=Administrator denied
F=Deleted
G=Bypassed
H=On Hold
I=No Action Taken
K=Skipped
L=Terminated
M=Administrator approved
N=Not Active
P=Pending
R=No longer in role
T=Terminated
U=Auto approved
X=Deleted
Z=Pending Denial
10 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
11 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID