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 N=Injury O=Dangerous Occurrence P=Unsafe Practice 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 |