INJ_CLMCST_IND(SQL Table) |
Index Back |
|---|---|
claim Details RecordThe record captures the claim Details of the type fo claim payments made, claim dates and recipients. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  CLAIM_NBR |
Character(8) | VARCHAR2(8) NOT NULL | Claim Number |
| 2 | HS_PAYMNT_TYPE_IND |
Character(1) | VARCHAR2(1) NOT NULL |
Payment Type
1=Advance Payment 2=Claim Payment 3=Claim Deposit 4=Provisional Payment |
| 3 | PAYMENT_DT |
Date(10) | DATE NOT NULL |
Payment Date
Default Value: %Date |
| 4 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL |
Sequence
Default Value: 1 |
| 5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON_NAME |
| 6 | NON_EMPLOYEE_ID | Character(11) | VARCHAR2(11) NOT NULL |
Non-Employee ID
Prompt Table: NE_INCIDNT_SRCH |
| 7 | DEPENDENT_BENEF | Character(2) | VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default Prompt Table: DEPEND_IND_VW |
| 8 | PAYMENT_AMOUNT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount of payment. |
| 9 | HS_RECIP_TYPE_IND | Character(2) | VARCHAR2(2) NOT NULL |
Claim Recipient
1=Employee 2=Non-Employee 3=Dependent |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 11 | COMMENTS | Long Character | CLOB | Comment |