FCT_WCOM_CLAIM_DT_INSIGHT

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 POLICY INTEGER 4
3 PRODUCT CHARACTER(3) 3
4 POLICYNUMBER CHARACTER VARYING(12) 12
5 CLAIM_COUNT INTEGER 4
6 CLAIM_ID BIGINT 8
7 CLAIMNUMBER CHARACTER VARYING(40) 40
8 LOSSDATE TIMESTAMP 8
9 CREATETIME TIMESTAMP 8
10 CLOSEDATE TIMESTAMP 8
11 DATEREPORTED TIMESTAMP 8
12 REOPENDATE TIMESTAMP 8
13 CC_POLICYNUMBER CHARACTER VARYING(40) 40
14 CHDRSTATUS CHARACTER VARYING(1) 1
15 NATUREOFINJURY CHARACTER VARYING(50) 50
16 INJURYBODYLOCATION CHARACTER VARYING(50) 50
17 HOURSWORKEDPERWEEK NUMERIC(10,2) 19
18 WEEKLYRATE NUMERIC(10,2) 19
19 AGENCYOFINJURY CHARACTER VARYING(50) 50
20 MECHANISMOFINJURY CHARACTER VARYING(50) 50
21 AGENCYBREAKDOWN CHARACTER VARYING(50) 50
22 CLAIMTYPE CHARACTER VARYING(4) 4
23 EVENTCLM INTEGER 4
24 SOURCE INTEGER 4
25 PAIDTODATE NUMERIC(38,2) 19
26 RECOVERTODATE NUMERIC(38,2) 19
27 GROSSRESERVE NUMERIC(38,2) 19
28 INCURTODATE NUMERIC(38,2) 19
29 NON_ZERO INTEGER 4
30 CLAWINVOLVEMENT CHARACTER VARYING(1) 1
31 LIABILITY_STATUS CHARACTER VARYING(256) 256
32 CLAIM_STATE CHARACTER VARYING(256) 256
33 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
34 BODY_LOCATION_NAME CHARACTER VARYING(2000) 2000
35 AGENCY_BREAKDOWN_NAME CHARACTER VARYING(2000) 2000
36 MECHANISM_OF_INJURY_NAME CHARACTER VARYING(2000) 2000
37 NATURE_OF_INJURY_NAME CHARACTER VARYING(2000) 2000
38 AGENCY_OF_INJURY_NAME CHARACTER VARYING(2000) 2000
39 UPDATE_TIME TIMESTAMP 8
40 LAST_EST_DATE TIMESTAMP 8
41 DEVELOPED_CLAIMS_COST NUMERIC(38,7) 19
42 LARGE_CLAIM_COUNT INTEGER 4
43 DEVELOPED_LARGE_CLAIMS_COST NUMERIC(38,7) 19
44 POLICYKEY BIGINT 8
45 POLICY_TERMSTART_KEY INTEGER 4
46 POLICY_TRANSACTION_DATE_KEY INTEGER 4
47 POLICY_EXPIRY_DATE INTEGER 4
48 INFORCE_TO_DATE_KEY INTEGER 4
49 POLICY_STAGE_LEVEL1_KEY BIGINT 8
50 POLICY_STAGE_LEVEL1 CHARACTER VARYING(25) 25
51 ITEM_RISKSTATE_KEY INTEGER 4
52 ITEM_RISKSTATE_NAME CHARACTER(10) 10
53 PREM_BAND_KEY INTEGER 4
54 PREM_SEGMENT_KEY INTEGER 4
55 HAZARD_INDEX_KEY INTEGER 4
56 PREV_INSURANCE_YEARS_KEY INTEGER 4
57 EXTENSION_LEVEL2_KEY BIGINT 8
58 ANZSICCD_1993_KEY BIGINT 8
59 ANZSICCD_2006_KEY BIGINT 8
60 ANZSICIR_2006_KEY BIGINT 8
61 MULTIANZSIC_FLAG_KEY INTEGER 4
62 POLICY_CANCEL_REASON_KEY CHARACTER VARYING(4) 4
63 BUSINESS_SOURCE_OF_SALES_KEY CHARACTER VARYING(20) 20
64 PRIORCLM_KEY INTEGER 4
65 MIN_PREM_FLAG_POL_KEY INTEGER 4
66 SCHEME_KEY BIGINT 8
67 INSTALFRQ CHARACTER(2) 2
68 POLICY_DURATION_KEY INTEGER 4
69 MULTIYEAR_KEY INTEGER 4
70 ITEM_CANCEL_REASON_KEY CHARACTER VARYING(4) 4
71 ITEM_DISTRIBUTION_CHANNEL_LEVEL1_KEY BIGINT 8
72 ITEM_DISTRIBUTION_CHANNEL_LEVEL2_KEY BIGINT 8
73 EXTENSION_LEVEL1_KEY INTEGER 4
74 GROUP_OFFERING_KEY BIGINT 8
75 POLICY_TERM_OFFERING_KEY BIGINT 8
76 GAZETTEPLUS75_KEY INTEGER 4
77 ITEM_SUBCLASS_KEY BIGINT 8
78 RENLIKEIND_KEY CHARACTER VARYING(4) 4
79 CAT_C_KEY CHARACTER VARYING(2) 2
80 ISSUEDSTATE_KEY INTEGER 4
81 PREVIOUS_INSURER_KEY BIGINT 8
82 CANCEL_ON_INCEPTION_KEY INTEGER 4
83 UNDERWRITER_KEY BIGINT 8
84 UW_CODE CHARACTER VARYING(8) 8
85 AGENT INTEGER 4
86 PREV_INSURER_GROUP_KEY BIGINT 8
87 DEVELOPED_LOSS_RATIO NUMERIC(13,2) 19
88 LOSSRATIOBAND CHARACTER VARYING(12) 12
89 LR_BAND_KEY BIGINT 8
90 POLICY_INFORCE_KEY INTEGER 4