INJ_CLMMGT_IND (SQL Table)	Index Back
Claims details for India The record is created as an associate record to capture Claims details for India

INJ_CLMMGT_IND

(SQL Table)

Claims details for India

The record is created as an associate record to capture Claims details for India

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CLAIM_NBR Character(8) VARCHAR2(8) NOT NULL Claim Number

2 CERTIFIED Character(1) VARCHAR2(1) NOT NULL Certified
Y/N Table Edit
Default Value: N

3 HS_CERTIFY_DT_IND Date(10) DATE Medical Certification Date

4 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
01=default
Prompt Table: DEPEND_IND_VW

5 HS_CLAIM_DT_IND Date(10) DATE Claims Date
Default Value: %Date

6 HS_CLMRECVD_DT_IND Date(10) DATE Claim Received Date

7 HS_CLM_AMT_IND Signed Number(20,3) DECIMAL(18,3) NOT NULL Claimed Amount

8 HS_RECD_AMT_IND Signed Number(20,3) DECIMAL(18,3) NOT NULL Claim Received Amount

9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

10 COMMENTS Long Character CLOB Comment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CLAIM_NBR	Character(8)	VARCHAR2(8) NOT NULL	Claim Number
2	CERTIFIED	Character(1)	VARCHAR2(1) NOT NULL	Certified Y/N Table Edit Default Value: N
3	HS_CERTIFY_DT_IND	Date(10)	DATE	Medical Certification Date
4	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default Prompt Table: DEPEND_IND_VW
5	HS_CLAIM_DT_IND	Date(10)	DATE	Claims Date Default Value: %Date
6	HS_CLMRECVD_DT_IND	Date(10)	DATE	Claim Received Date
7	HS_CLM_AMT_IND	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Claimed Amount
8	HS_RECD_AMT_IND	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Claim Received Amount
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
10	COMMENTS	Long Character	CLOB	Comment