|
Stores the information for claiming the insurance. |
|
Name |
Code |
Class Name |
|
Reference |
||
|
Reference |
|
Name |
Code |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the benefit code for the insurance. It holds the primary key for the InsurBenefit table. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
Yes |
|
A system generated identity. It is blind to the user. This is also the primary key for the InsurClaim table. |
|
Name |
|
|
Code |
|
|
Data Type |
char(30) |
|
Mandatory |
No |
|
Shows the reference number for the insurance claim. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
Shows the date of refund of the claim. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
Shows the date of the claim for the insurance. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the submitted amount for the claim. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the amount to be claimed from insurance. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Shows if the claim has been approved. |
|
Name |
|
|
Code |
|
|
Data Type |
char(100) |
|
Mandatory |
No |
|
Store remarks. |
|
|
|