Entity InsurClaim

Description of Entity InsurClaim

Stores the information for claiming the insurance.


List of all Dependencies of the Entity InsurClaim

Name

Code

Class Name

Relation_989083

Relation_989083

Reference

Relation_989082

Relation_989082

Reference


List of Attributes of the Entity InsurClaim

Name

Code

Insurance Benefit Code

InsurBenefitCode

InsurClaimSysId

InsurClaimSysId

Insurance Claim Reference No

InsurClaimRefNo

Refund Date

RefundDate

Claim Date

ClaimDate

Submit Amount

SubmitAmt

Claim Amount

ClaimAmt

Claim Appr

ClaimAppr

Remarks

Remarks


Entity Attribute Insurance Benefit Code of the Entity InsurClaim

Card of Attribute Insurance Benefit Code of the Entity InsurClaim

Name

Insurance Benefit Code

Code

InsurBenefitCode

Data Type

char(20)

Mandatory

No


Description of Attribute Insurance Benefit Code of the Entity InsurClaim

Shows the benefit code for the insurance. It holds the primary key for the InsurBenefit table.


Entity Attribute InsurClaimSysId of the Entity InsurClaim

Card of Attribute InsurClaimSysId of the Entity InsurClaim

Name

InsurClaimSysId

Code

InsurClaimSysId

Data Type

integer

Mandatory

Yes


Description of Attribute InsurClaimSysId of the Entity InsurClaim

A system generated identity. It is blind to the user. This is also the primary key for the InsurClaim table.


Entity Attribute Insurance Claim Reference No of the Entity InsurClaim

Card of Attribute Insurance Claim Reference No of the Entity InsurClaim

Name

Insurance Claim Reference No

Code

InsurClaimRefNo

Data Type

char(30)

Mandatory

No


Description of Attribute Insurance Claim Reference No of the Entity InsurClaim

Shows the reference number for the insurance claim.


Entity Attribute Refund Date of the Entity InsurClaim

Card of Attribute Refund Date of the Entity InsurClaim

Name

Refund Date

Code

RefundDate

Data Type

date

Mandatory

No


Description of Attribute Refund Date of the Entity InsurClaim

Shows the date of refund of the claim.
It is in the format: DD-MM-YYYY.


Entity Attribute Claim Date of the Entity InsurClaim

Card of Attribute Claim Date of the Entity InsurClaim

Name

Claim Date

Code

ClaimDate

Data Type

date

Mandatory

No


Description of Attribute Claim Date of the Entity InsurClaim

Shows the date of the claim for the insurance.
It is in the format: DD-MM-YYYY.


Entity Attribute Submit Amount of the Entity InsurClaim

Card of Attribute Submit Amount of the Entity InsurClaim

Name

Submit Amount

Code

SubmitAmt

Data Type

double

Mandatory

No


Description of Attribute Submit Amount of the Entity InsurClaim

Stores the submitted amount for the claim.


Entity Attribute Claim Amount of the Entity InsurClaim

Card of Attribute Claim Amount of the Entity InsurClaim

Name

Claim Amount

Code

ClaimAmt

Data Type

double

Mandatory

No


Description of Attribute Claim Amount of the Entity InsurClaim

Stores the amount to be claimed from insurance.


Entity Attribute Claim Appr of the Entity InsurClaim

Card of Attribute Claim Appr of the Entity InsurClaim

Name

Claim Appr

Code

ClaimAppr

Data Type

smallint

Mandatory

No


Description of Attribute Claim Appr of the Entity InsurClaim

Shows if the claim has been approved.


Entity Attribute Remarks of the Entity InsurClaim

Card of Attribute Remarks of the Entity InsurClaim

Name

Remarks

Code

Remarks

Data Type

char(100)

Mandatory

No


Description of Attribute Remarks of the Entity InsurClaim

Store remarks.