INT_TEMP_PROFITSUMMARY_VERO

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 EFFECTIVE_DATE DATE 4
2 EXPOSURE DOUBLE PRECISION 8
3 BRAND CHARACTER VARYING(30) 30
4 PRODUCT_TYPE CHARACTER VARYING(80) 80
5 LSP_FLAG CHARACTER VARYING(25) 25
6 RISK_STATE CHARACTER VARYING(32) 32
7 FACTOR CHARACTER VARYING(17) 17
8 SEGMENT CHARACTER VARYING(100) 100
9 TOTAL_INCURREDSQUARE DOUBLE PRECISION 8
10 ULTIMATE_TOTAL_INCURREDSQUARE DOUBLE PRECISION 8
11 TOTAL_INCURRED DOUBLE PRECISION 8
12 WORKING_INCURRED DOUBLE PRECISION 8
13 ULTIMATE_TOTAL_INCURRED DOUBLE PRECISION 8
14 ULTIMATE_WORKING_INCURRED DOUBLE PRECISION 8
15 TOTAL_GEP DOUBLE PRECISION 8
16 TOTAL_GIPE_EXPECTED_CLAIMSSQUARE DOUBLE PRECISION 8
17 TOTAL_GIPE_EXPECTED_CLAIMS NUMERIC(38,6) 19
18 TOTAL_GIPE_PREMIUMBASE NUMERIC(38,6) 19
19 INCLUDES_TWELVE_MONTHS_FLAG INTEGER 4
20 DATASET CHARACTER VARYING(4) 4
21 LOSS_RATIO DOUBLE PRECISION 8
22 LOSS_RATIO_WORKING DOUBLE PRECISION 8
23 ULTIMATE_LOSS_RATIO DOUBLE PRECISION 8
24 ULTIMATE_LOSS_RATIO_WORKING DOUBLE PRECISION 8
25 PORTFOLIO_TOTAL_INCURRED DOUBLE PRECISION 8
26 PORTFOLIO_WORKING_INCURRED DOUBLE PRECISION 8
27 PORTFOLIO_ULTIMATE_INCURRED DOUBLE PRECISION 8
28 PORTFOLIO_ULTIMATE_INCURRED_WORKING DOUBLE PRECISION 8
29 PORTFOLIO_TOTAL_GEP DOUBLE PRECISION 8
30 PORTFOLIO_LOSS_RATIO DOUBLE PRECISION 8
31 PORTFOLIO_LOSS_RATIO_WORKING DOUBLE PRECISION 8
32 PORTFOLIO_ULTIMATE_LOSS_RATIO DOUBLE PRECISION 8
33 PORTFOLIO_ULTIMATE_LOSS_RATIO_WORKING DOUBLE PRECISION 8
34 EXPECTED_LOSS_RATIO NUMERIC(38,6) 19
35 PORTFOLIO_TOTAL_GIPE_EXPECTED_CLAIMS NUMERIC(38,6) 19
36 PORTFOLIO_TOTAL_GIPE_PREMIUMBASE NUMERIC(38,6) 19
37 PORTFOLIO_EXPECTED_LOSS_RATIO NUMERIC(38,6) 19