FCT_CTP_RISKS_AND_PREMIUMS

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 TRANSACTION_ACCOUNTING_MONTH_KEY INTEGER 4
2 TRANSACTION_ACCOUNTING_MONTH_LABEL CHARACTER VARYING(15) 15
3 SCHEME_LICENCE_STATE CHARACTER VARYING(30) 30
4 PRODUCT_STRUCT6 CHARACTER VARYING(50) 50
5 BRAND_NAME CHARACTER VARYING(60) 60
6 POLICY_STAGE_LEVEL1 CHARACTER VARYING(20) 20
7 DEVELOPING_RATE NUMERIC(38,6) 19
8 current net full term paid policy premium NUMERIC(38,2) 19
9 current full term paid policy count BIGINT 8
10 pcp net full term paid policy premium NUMERIC(38,2) 19
11 pcp net full term paid policy count BIGINT 8
12 current budget total paid policy premium NUMERIC(38,2) 19
13 current budget total paid policy count BIGINT 8
14 current forecast total paid policy premium NUMERIC(38,2) 19
15 current forecast total paid policy count BIGINT 8
16 current premium budget variance NUMERIC(38,6) 19
17 current premium forecast variance NUMERIC(38,6) 19
18 current premium pcp variance NUMERIC(38,6) 19
19 current risks budget variance NUMERIC(38,6) 19
20 current risks forecast variance NUMERIC(38,6) 19
21 current risks pcp variance NUMERIC(38,6) 19
22 ytd net full term paid policy premium NUMERIC(38,2) 19
23 ytd net full term paid policy count BIGINT 8
24 pcp ytd net full term paid policy premium NUMERIC(38,2) 19
25 pcp ytd net full term paid policy count BIGINT 8
26 ytd budget total paid policy premium NUMERIC(38,2) 19
27 ytd budget total paid policy count BIGINT 8
28 ytd forecast total paid policy premium NUMERIC(38,2) 19
29 ytd forecast total paid policy count BIGINT 8
30 ytd premium budget variance NUMERIC(38,6) 19
31 ytd premium forecast variance NUMERIC(38,6) 19
32 ytd premium pcp variance NUMERIC(38,6) 19
33 ytd risks budget variance NUMERIC(38,6) 19
34 ytd risks forecast variance NUMERIC(38,6) 19
35 ytd risks pcp variance NUMERIC(38,6) 19
36 current average premium NUMERIC(38,6) 19
37 current budget average premium NUMERIC(38,6) 19
38 current budget average premium variance NUMERIC(38,6) 19
39 current forecast average premium NUMERIC(38,6) 19
40 current forecast average premium variance NUMERIC(38,6) 19
41 pcp average premium NUMERIC(38,6) 19
42 current pcp average premium variance NUMERIC(38,6) 19
43 ytd average premium NUMERIC(38,6) 19
44 ytd budget average premium NUMERIC(38,6) 19
45 ytd budget average premium variance NUMERIC(38,6) 19
46 ytd forecast average premium NUMERIC(38,6) 19
47 ytd forecast average premium variance NUMERIC(38,6) 19
48 ytd pcp average premium NUMERIC(38,6) 19
49 ytd pcp average premium variance NUMERIC(38,6) 19
50 current retention rate NUMERIC(38,6) 19
51 pcp retention rate NUMERIC(38,6) 19
52 pcp retention rate variance NUMERIC(38,6) 19
53 ytd retention rate NUMERIC(38,6) 19
54 pcp ytd retention rate NUMERIC(38,6) 19
55 pcp ytd retention rate variance NUMERIC(38,6) 19
56 RETENTION_BUDGETS NUMERIC(15,6) 19
57 YTD_RETENTION_BUDGETS NUMERIC(38,6) 19
58 BUDGET_RETENTION_RATE_VARIANCE NUMERIC(38,6) 19
59 YTD_BUDGET_RETENTION_RATE_VARIANCE NUMERIC(38,6) 19
60 RETENTION_FORECASTS NUMERIC(15,6) 19
61 YTD_RETENTION_FORECASTS NUMERIC(38,6) 19
62 FORECAST_RETENTION_RATE_VARIANCE NUMERIC(38,6) 19
63 YTD_FORECAST_RETENTION_RATE_VARIANCE NUMERIC(38,6) 19
64 current net renewal NUMERIC(38,6) 19
65 current issued renewal BIGINT 8
66 ytd issued renewal BIGINT 8
67 ytd net renewal NUMERIC(38,6) 19
68 pcp net renewal BIGINT 8
69 pcp issued renewal BIGINT 8
70 pcp ytd net renewal BIGINT 8
71 pcp ytd issued renewal BIGINT 8