CI_POT_FCT_OP_VERO_FULL

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
2 EFFECTIVE_DATE DATE 4
3 EXPOSURE DOUBLE PRECISION 8
4 INCLUDES_TWELVE_MONTHS_FLAG INTEGER 4
6 PACKAGETYPE CHARACTER VARYING(15) 15
7 PRODUCT_TYPE CHARACTER VARYING(80) 80
8 RISK_STATE CHARACTER VARYING(32) 32
9 FACTOR CHARACTER VARYING(17) 17
10 SEGMENT CHARACTER VARYING(100) 100
11 TOTAL_INCURREDSQUARE DOUBLE PRECISION 8
12 ULTIMATE_TOTAL_INCURREDSQUARE DOUBLE PRECISION 8
13 TOTAL_INCURRED DOUBLE PRECISION 8
14 WORKING_INCURRED DOUBLE PRECISION 8
15 ULTIMATE_TOTAL_INCURRED DOUBLE PRECISION 8
16 ULTIMATE_WORKING_INCURRED DOUBLE PRECISION 8
17 TOTAL_GEP DOUBLE PRECISION 8
18 TOTAL_RENEWED DOUBLE PRECISION 8
19 TOTAL_EXPIRING DOUBLE PRECISION 8
20 TOTAL_CONVERTED NUMERIC(38,0) 19
21 TOTAL_QUOTES NUMERIC(38,6) 19
22 SEGMENT_SIZE DOUBLE PRECISION 8
23 LOSS_RATIO DOUBLE PRECISION 8
24 LOSS_RATIO_WORKING DOUBLE PRECISION 8
25 ULTIMATE_LOSS_RATIO DOUBLE PRECISION 8
26 ULTIMATE_LOSS_RATIO_WORKING DOUBLE PRECISION 8
27 VARLOSSRATIO DOUBLE PRECISION 8
28 RETENTION_RATE DOUBLE PRECISION 8
29 VAR_RETENTION DOUBLE PRECISION 8
30 STRIKE_RATE NUMERIC(38,6) 19
31 VAR_STRIKERATE DOUBLE PRECISION 8
32 PORTFOLIO_TOTAL_INCURRED DOUBLE PRECISION 8
33 PORTFOLIO_TOTAL_GEP DOUBLE PRECISION 8
34 PORTFOLIO_TOTAL_RENEWED DOUBLE PRECISION 8
35 PORTFOLIO_TOTAL_EXPIRING DOUBLE PRECISION 8
36 PORTFOLIO_TOTAL_CONVERTED NUMERIC(38,0) 19
37 PORTFOLIO_TOTAL_QUOTES NUMERIC(38,6) 19
38 PORTFOLIO_LOSS_RATIO DOUBLE PRECISION 8
39 PORTFOLIO_LOSS_RATIO_WORKING DOUBLE PRECISION 8
40 PORTFOLIO_ULTIMATE_LOSS_RATIO DOUBLE PRECISION 8
41 PORTFOLIO_ULTIMATE_LOSS_RATIO_WORKING DOUBLE PRECISION 8
42 PORTFOLIO_RETENTION_RATE DOUBLE PRECISION 8
43 PORTFOLIO_STRIKE_RATE NUMERIC(38,6) 19
44 DISTANCE_METRIC_LRT_SCENARIO1 DOUBLE PRECISION 8
45 DISTANCE_METRIC_LRT_SCENARIO2 DOUBLE PRECISION 8
46 DISTANCE_METRIC_LRT_SCENARIO3 DOUBLE PRECISION 8
47 DISTANCE_METRIC_LRW_SCENARIO1 DOUBLE PRECISION 8
48 DISTANCE_METRIC_LRW_SCENARIO2 DOUBLE PRECISION 8
49 DISTANCE_METRIC_LRW_SCENARIO3 DOUBLE PRECISION 8
50 DISTANCE_METRIC_ULRT_SCENARIO1 DOUBLE PRECISION 8
51 DISTANCE_METRIC_ULRT_SCENARIO2 DOUBLE PRECISION 8
52 DISTANCE_METRIC_ULRT_SCENARIO3 DOUBLE PRECISION 8
53 DISTANCE_METRIC_ULRW_SCENARIO1 DOUBLE PRECISION 8
54 DISTANCE_METRIC_ULRW_SCENARIO2 DOUBLE PRECISION 8
55 DISTANCE_METRIC_ULRW_SCENARIO3 DOUBLE PRECISION 8
56 STATISTICAL_METRIC_LRT DOUBLE PRECISION 8
57 STATISTICAL_METRIC_LRW DOUBLE PRECISION 8
58 STATISTICAL_METRIC_ULRT DOUBLE PRECISION 8
59 STATISTICAL_METRIC_ULRW DOUBLE PRECISION 8
60 PREVIOUS_MARGIN_LRT DOUBLE PRECISION 8
61 NEW_MARGIN_LRT DOUBLE PRECISION 8
62 OPPORTUNITY_VALUE_LRT DOUBLE PRECISION 8
63 PREVIOUS_MARGIN_LRW DOUBLE PRECISION 8
64 NEW_MARGIN_LRW DOUBLE PRECISION 8
65 OPPORTUNITY_VALUE_LRW DOUBLE PRECISION 8
66 PREVIOUS_MARGIN_ULRT DOUBLE PRECISION 8
67 NEW_MARGIN_ULRT DOUBLE PRECISION 8
68 OPPORTUNITY_VALUE_ULRT DOUBLE PRECISION 8
69 PREVIOUS_MARGIN_ULRW DOUBLE PRECISION 8
70 NEW_MARGIN_ULRW DOUBLE PRECISION 8
71 OPPORTUNITY_VALUE_ULRW DOUBLE PRECISION 8
72 EFFECTIVE_DATE_CONV DATE 4
73 BRAND_CONV CHARACTER VARYING(23) 23
74 RISK_STATE_CONV CHARACTER VARYING(50) 50
75 FACTOR_CONV CHARACTER VARYING(17) 17
76 SEGMENT_CONV CHARACTER VARYING(100) 100
77 TOTAL_GIPE_EXPECTED_CLAIMS NUMERIC(38,6) 19
78 TOTAL_GIPE_PREMIUMBASE NUMERIC(38,6) 19
79 EXPECTED_LOSS_RATIO NUMERIC(38,6) 19
80 PORTFOLIO_TOTAL_GIPE_EXPECTED_CLAIMS NUMERIC(38,6) 19
81 PORTFOLIO_TOTAL_GIPE_PREMIUMBASE NUMERIC(38,6) 19
82 PORTFOLIO_EXPECTED_LOSS_RATIO NUMERIC(38,6) 19
83 VAREXPECTED_LOSSRATIO DOUBLE PRECISION 8
84 DISTANCE_METRIC_EXPLR_SCENARIO1 DOUBLE PRECISION 8
85 DISTANCE_METRIC_EXPLR_SCENARIO2 DOUBLE PRECISION 8
86 DISTANCE_METRIC_EXPLR_SCENARIO3 DOUBLE PRECISION 8
87 STATISTICAL_METRIC_EXPLR DOUBLE PRECISION 8
88 OPPORTUNITY_VALUE_EXPLR NUMERIC(38,18) 19