FCT_CUST_HEALTH_PH

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRDT_HOLDNG_ID BIGINT 8
2 PRDT_ID BIGINT 8
3 PRDT_TYP_CODE CHARACTER VARYING(20) 20
4 PRDT_SYS_CODE CHARACTER VARYING(10) 10
5 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
6 POL_NUM CHARACTER VARYING(20) 20
7 PRDT_BRND_CODE CHARACTER VARYING(20) 20
8 CHNL_ID CHARACTER VARYING(20) 20
9 CHNL_CODE CHARACTER VARYING(20) 20
10 CHNL_TYP_CODE CHARACTER VARYING(20) 20
11 POL_START_DATE DATE 4
12 HEALTH_PRDT_HOLDNG_STRT_DATE TIMESTAMP 8
13 HEALTH_PRDT_HOLDNG_END_DATE TIMESTAMP 8
14 POL_ENROLMENT CHARACTER VARYING(50) 50
15 AMBULANCE_COVER_INDICATOR CHARACTER VARYING(3) 3
16 STATE CHARACTER VARYING(3) 3
17 SCALE CHARACTER VARYING(20) 20
18 RATE_CODE CHARACTER VARYING(3) 3
19 LHC_LOADING NUMERIC(4,2) 19
20 ANNUAL_PREMIUM NUMERIC(18,6) 19