R_OSH015_VW

(SQL View)
 Index Back

View to generate OSH015--

View to generate OSH015 -- Used by Crystal report OHS015

SELECT B.EMPLID , A.INCIDENT_NBR , A.INCIDENT_TYPE , A.INCIDENT_DT , B.CLAIM_NBR , B.OPEN_DT , B.CLOSE_DT , B.CLAIM_STATUS , F.NAME , B.CONTACT_ID , G.NAME , B.PROVIDER_DESCR , B.PROVIDER_CLAIM_NBR , B.CLAIMS_MANAGER , B.ASSESSMENT_DT , B.CASE_DISPOSITION , E.INJURY_CHARGE_TYPE , E.CHARGE_DT , E.INJURY_CHARGE_AMT , B.COMMENTS FROM PS_INCIDENT_DATA A ,PS_INJURY_CLM_MGMT B , PS_INJURY_CLM_COST E , PS_PERSON_NAME F , PS_PERSON_NAME G WHERE E.CLAIM_NBR = B.CLAIM_NBR AND A.INCIDENT_NBR = B.INCIDENT_NBR AND B.EMPLID = F.EMPLID AND B.CONTACT_ID = G.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number
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
4 INCIDENT_DT Date(10) DATE Incident Date
5 CLAIM_NBR Character(8) VARCHAR2(8) NOT NULL Claim Number
6 OPEN_DT Date(10) DATE Created
7 CLOSE_DT Date(10) DATE Date Closed
8 CLAIM_STATUS Character(1) VARCHAR2(1) NOT NULL Claim Status
A=Approved
D=Denied
P=Pending
W=Withdrawn
9 NAME Character(50) VARCHAR2(50) NOT NULL Name
10 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

Prompt Table: PERSON

11 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name
12 PROVIDER_DESCR Character(30) VARCHAR2(30) NOT NULL Provider Description
13 PROVIDER_CLAIM_NBR Character(10) VARCHAR2(10) NOT NULL Provider Claim Nbr
14 CLAIMS_MANAGER Character(40) VARCHAR2(40) NOT NULL Claims Manager
15 ASSESSMENT_DT Date(10) DATE Assessment Date
16 CASE_DISPOSITION Character(2) VARCHAR2(2) NOT NULL Disposition
FR=Full return to work
LD=Long Term Disability
NF=Not fit to return at present
RR=Return with work restrictions
VR=Vocational rehabilitation
17 INJURY_CHARGE_TYPE Character(2) VARCHAR2(2) NOT NULL Type of Charge
MD=Medical Costs
OT=Other Costs
WG=Wage Loss
18 CHARGE_DT Date(10) DATE Charge Date
19 INJURY_CHARGE_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Charge Amount
20 COMMENTS Long Character CLOB Comment