INJURY_ILL_CLM(SQL View) |
Index Back |
|---|---|
Injury/Illness Claims FiledINJURY_ILL_CLM is a view of INJURY_CLM_MGMT used in Health and Safety to sort claim records by employee or non-employee. Claim data can be updated either from the claim panels or by person involved via this view. |
| SELECT EMPLID ,EMPL_RCD ,NON_EMPLOYEE_ID ,INCIDENT_NBR ,CLAIM_NBR ,CLAIM_STATUS ,OPEN_DT ,CLOSE_DT ,PROVIDER_CLAIM_NBR ,PROVIDER_DESCR ,ASSESSMENT_DT ,CASE_DISPOSITION FROM PS_INJURY_CLM_MGMT WHERE INCIDENT_NBR <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Prompt Table: PER_ORG_ASGN_VW |
| 3 | NON_EMPLOYEE_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Non-Employee ID
Prompt Table: NE_INCIDNT_SRCH |
| 4 | INCIDENT_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Incident Number
Prompt Table: INJ_CLM_INCD_VW |
| 5 | CLAIM_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Claim Number
Prompt Table: INJURY_CLM_MGMT |
| 6 | CLAIM_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Claim Status
A=Approved D=Denied P=Pending W=Withdrawn |
| 7 | OPEN_DT | Date(10) | DATE NOT NULL | Created |
| 8 | CLOSE_DT | Date(10) | DATE | Date Closed |
| 9 | PROVIDER_CLAIM_NBR | Character(10) | VARCHAR2(10) NOT NULL | Provider Claim Nbr |
| 10 | PROVIDER_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Provider Description |
| 11 | ASSESSMENT_DT | Date(10) | DATE | Assessment Date |
| 12 | 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 |