CI_POT_FCT_OP_COGEN_RES_FULL_AGGREGATE

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BRAND CHARACTER VARYING(30) 30
2 LSP_FLAG CHARACTER VARYING(25) 25
3 DISTANCE_METRIC_EXPLR_SCENARIO1 DOUBLE PRECISION 8
4 DISTANCE_METRIC_EXPLR_SCENARIO2 DOUBLE PRECISION 8
5 DISTANCE_METRIC_EXPLR_SCENARIO3 DOUBLE PRECISION 8
6 DISTANCE_METRIC_ULRT_SCENARIO1 DOUBLE PRECISION 8
7 DISTANCE_METRIC_ULRT_SCENARIO2 DOUBLE PRECISION 8
8 DISTANCE_METRIC_ULRT_SCENARIO3 DOUBLE PRECISION 8
9 DISTANCE_METRIC_ULRW_SCENARIO1 DOUBLE PRECISION 8
10 DISTANCE_METRIC_ULRW_SCENARIO2 DOUBLE PRECISION 8
11 DISTANCE_METRIC_ULRW_SCENARIO3 DOUBLE PRECISION 8
12 EFFECTIVE_DATE DATE 4
13 EXPECTED_LOSS_RATIO NUMERIC(38,6) 19
14 FACTOR CHARACTER VARYING(17) 17
15 OPPORTUNITY_VALUE_EXPLR NUMERIC(38,18) 19
16 OPPORTUNITY_VALUE_ULRW DOUBLE PRECISION 8
17 PACKAGETYPE CHARACTER VARYING(15) 15
18 PORTFOLIO_EXPECTED_LOSS_RATIO NUMERIC(38,6) 19
19 PORTFOLIO_LOSS_RATIO_WORKING DOUBLE PRECISION 8
20 PORTFOLIO_RETENTION_RATE DOUBLE PRECISION 8
21 PORTFOLIO_STRIKE_RATE NUMERIC(38,6) 19
22 PORTFOLIO_TOTAL_GEP DOUBLE PRECISION 8
23 PORTFOLIO_ULTIMATE_LOSS_RATIO DOUBLE PRECISION 8
24 PORTFOLIO_ULTIMATE_LOSS_RATIO_WORKING DOUBLE PRECISION 8
25 PRODUCT_TYPE CHARACTER VARYING(80) 80
26 RETENTION_RATE DOUBLE PRECISION 8
27 RISK_STATE CHARACTER VARYING(32) 32
28 SEGMENT CHARACTER VARYING(100) 100
29 SEGMENT_SIZE DOUBLE PRECISION 8
30 STATISTICAL_METRIC_EXPLR DOUBLE PRECISION 8
31 STATISTICAL_METRIC_ULRW DOUBLE PRECISION 8
32 STRIKE_RATE NUMERIC(38,6) 19
33 TOTAL_CONVERTED NUMERIC(38,0) 19
34 TOTAL_GEP DOUBLE PRECISION 8
35 TOTAL_QUOTES NUMERIC(38,0) 19
36 ULTIMATE_LOSS_RATIO_WORKING DOUBLE PRECISION 8