CLM_SUMM_VW(SQL View) |
Index Back |
|---|---|
Claim Summary ViewView used by Crystal report OHS012-- Claim Summary |
| select a.claim_nbr, a.claim_status, a.open_dt, a.close_dt, a.emplid, a.non_employee_id, a.incident_nbr, b.injury_charge_type, b.injury_charge_amt from ps_injury_clm_mgmt a, PS_INJURY_CLM_COST b where a.claim_nbr = b.claim_nbr |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CLAIM_NBR | Character(8) | VARCHAR2(8) NOT NULL | Claim Number |
| 2 | CLAIM_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Claim Status
A=Approved D=Denied P=Pending W=Withdrawn |
| 3 | OPEN_DT | Date(10) | DATE | Created |
| 4 | CLOSE_DT | Date(10) | DATE | Date Closed |
| 5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 6 | NON_EMPLOYEE_ID | Character(11) | VARCHAR2(11) NOT NULL | Non-Employee ID |
| 7 | INCIDENT_NBR | Character(8) | VARCHAR2(8) NOT NULL | Incident Number |
| 8 | INJURY_CHARGE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Type of Charge
MD=Medical Costs OT=Other Costs WG=Wage Loss |
| 9 | INJURY_CHARGE_AMT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Charge Amount |