CLAIM_NBRPrompt Table: INJURY_CLM_MGMT
INJURY_CHARGE_TYPEMD=Medical Costs
OT=Other Costs
WG=Wage Loss
CHARGE_DTDefault Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY
Prompt Table: CURRENCY_CD_TBL
Prompt Table: MEDCARE_ITM_AUS
INJURY_CLM_COST(SQL Table) |
Index Back |
|---|---|
Injury Claims CostsThis is one of several records used in the Health and Safety module to record details about claims filed by employees or non-employees relating to a health/safety-related incident in the workplace. Use INJURY_CLM_MGMT, INJURY_CLM_CHRG, and INJURY_CLM_COST to record the details of the claim. INJURY_CLM_COST contains line-item costs associated with the claim. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CLAIM_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Claim Number
Prompt Table: INJURY_CLM_MGMT |
| 2 | INJURY_CHARGE_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Type of Charge
MD=Medical Costs OT=Other Costs WG=Wage Loss |
| 3 | CHARGE_DT |
Date(10) | DATE NOT NULL | Charge Date |
| 4 | INJURY_CHARGE_AMT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Charge Amount |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 6 | MEDICARE_ITM_AUS | Character(6) | VARCHAR2(6) NOT NULL |
Medicare Item ID
Prompt Table: MEDCARE_ITM_AUS |
| 7 | START_DT | Date(10) | DATE | Start Date |
| 8 | END_DT | Date(10) | DATE | end date |