INT_CI_CLAIM_EXPERIENCE_CC

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 COMPANY_NAME CHARACTER VARYING(30) 30
3 POLICY INTEGER 4
4 POLICY_NUMBER INTEGER 4
5 PRODUCT_CODE CHARACTER(3) 3
6 TERMSTART INTEGER 4
7 POLICY_DUE_DATE DATE 4
8 PRODUCT_TYPE_DESC CHARACTER VARYING(60) 60
9 CLASS CHARACTER(3) 3
10 SUBCLASS CHARACTER(3) 3
11 GL_BUSINESS_UNIT_CODE CHARACTER VARYING(50) 50
12 GL_BUSINESS_UNIT CHARACTER VARYING(50) 50
13 BUSINESS_UNIT CHARACTER VARYING(20) 20
14 MAJOR_CLASS_DSCR CHARACTER VARYING(60) 60
15 ITEMNO SMALLINT 2
16 CLAIMNO BIGINT 8
17 CLAIM_NUMBER CHARACTER(10) 10
18 CLAIM_STATUS_CODE CHARACTER VARYING(1) 1
19 CLAIM_STATUS CHARACTER VARYING(512) 512
20 CLAIM_LOSS_DATE DATE 4
21 CLAIM_REPORT_DATE DATE 4
22 CLAIM_CLOSED_DATE DATE 4
23 LOSS_DESCRIPTION CHARACTER VARYING(512) 512
24 RISK_STATE_CODE BIGINT 8
25 RISK_STATE CHARACTER VARYING(512) 512
26 COINSPC CHARACTER VARYING(1) 1
27 OCCUPATION_CODE CHARACTER VARYING(10) 10
28 CLAIM_COUNT INTEGER 4
29 GRS_INCRD NUMERIC(38,2) 19
30 GRS_PAID NUMERIC(38,2) 19
31 GRS_OS_EST NUMERIC(38,2) 19
32 GRS_DEDUC NUMERIC(38,2) 19
33 GRS_SETTLEMENT NUMERIC(38,2) 19
34 GRS_EXPENSE NUMERIC(38,2) 19
35 GRS_RECOVERY NUMERIC(38,2) 19
36 INSURED_INITIAL CHARACTER VARYING(5) 5
37 INSURED_NAME CHARACTER VARYING(81) 81
38 CLIENT_RNK BIGINT 8
39 POLICY_STATE_CODE SMALLINT 2
40 POLICY_STATE CHARACTER(30) 30
41 BRKR_SYS_NUM INTEGER 4
42 BROKER_CODE INTEGER 4
43 BROKER_NAME CHARACTER VARYING(200) 200
44 BROKER_GROUP CHARACTER VARYING(100) 100
45 CUSTOMER_SEGMENT CHARACTER VARYING(50) 50
46 RELATIONSHIP_CONTACT CHARACTER VARYING(200) 200
47 SERVICE_SEGMENT CHARACTER VARYING(100) 100
48 ACCT_YEAR CHARACTER VARYING(4) 4
49 ACCT_MONTH CHARACTER VARYING(2) 2
50 ACCT_YEAR_MONTH INTEGER 4
51 ACCT_YEAR_MONTH_TXT CHARACTER VARYING(8) 8
52 PROP_RNK BIGINT 8
53 POL_RNK BIGINT 8