| # |
Name |
Data Type |
Length |
| 1 |
MEMBER_ACCOUNT_ID |
INTEGER |
4 |
| 2 |
INSURANCE_COVER_ID |
INTEGER |
4 |
| 3 |
ENTITY_ID |
INTEGER |
4 |
| 4 |
PRODUCT_TYPE_ID |
INTEGER |
4 |
| 5 |
INSURER |
CHARACTER VARYING(60) |
60 |
| 6 |
INSURANCE_TYPE_NAME |
CHARACTER VARYING(40) |
40 |
| 7 |
INSURANCE_SUBTYPE_NAME |
CHARACTER VARYING(40) |
40 |
| 8 |
START_DATE |
TIMESTAMP |
8 |
| 9 |
END_DATE |
TIMESTAMP |
8 |
| 10 |
CLAIM_STATUS |
CHARACTER VARYING(24) |
24 |
| 11 |
TYPE_OF_COVER |
CHARACTER VARYING(10) |
10 |
| 12 |
INSURANCE_RENEWAL_DATE |
TIMESTAMP |
8 |
| 13 |
DATE_OF_NEXT_REVIEW |
DATE |
4 |
| 14 |
EMPLOYER_ID |
INTEGER |
4 |
| 15 |
EMPLOYER_NAME |
CHARACTER VARYING(60) |
60 |
| 16 |
EMPLOYER_GROUP_NAME |
CHARACTER VARYING(40) |
40 |
| 17 |
INSURED_NAME |
CHARACTER VARYING(162) |
162 |
| 18 |
AGE_NEXT |
INTEGER |
4 |
| 19 |
GENDER |
CHARACTER(1) |
1 |
| 20 |
CALCULATION_METHOD |
CHARACTER VARYING(52) |
52 |
| 21 |
SALARY_PERCENT |
NUMERIC(5,2) |
19 |
| 22 |
MULTIPLIER |
NUMERIC(7,4) |
19 |
| 23 |
CALCULATED_SUM_INSURED |
NUMERIC(18,2) |
19 |
| 24 |
ACTUAL_SUM_INSURED |
NUMERIC(18,2) |
19 |
| 25 |
BASE_PREMIUM |
NUMERIC(18,2) |
19 |
| 26 |
EMPLOYER_PRF |
CHARACTER VARYING(218) |
218 |
| 27 |
MANUAL_ADJUSTMENT |
CHARACTER VARYING(218) |
218 |
| 28 |
MEDICAL_LOADING |
CHARACTER VARYING(218) |
218 |
| 29 |
HAZ_OCCUPATION_LOADING |
CHARACTER VARYING(218) |
218 |
| 30 |
SMOKER_FLAG |
CHARACTER(1) |
1 |
| 31 |
LESS_AC_BALANCE_FLAG |
CHARACTER VARYING(1) |
1 |
| 32 |
SUPER_PREMIUM |
NUMERIC(18,2) |
19 |
| 33 |
STAMP_DUTY_AMOUNT |
NUMERIC(18,2) |
19 |
| 34 |
STAMP_DUTY |
NUMERIC(5,2) |
19 |
| 35 |
NONSUPER_BASE_PREMIUM |
NUMERIC(18,2) |
19 |
| 36 |
NONSUPER_PREMIUM |
NUMERIC(18,2) |
19 |
| 37 |
FORWARD_UW_LIMIT |
NUMERIC(18,2) |
19 |