INT_CI_CLAIM_EXPERIENCE_PRT

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 CLASS_DESCRIPTION CHARACTER VARYING(60) 60
11 SUBCLASS CHARACTER(3) 3
12 SUBCLASS_DESCRIPTION CHARACTER VARYING(60) 60
13 GL_BUSINESS_UNIT_CODE CHARACTER VARYING(50) 50
14 GL_BUSINESS_UNIT CHARACTER VARYING(50) 50
15 BUSINESS_UNIT CHARACTER VARYING(20) 20
16 MAJOR_CLASS_DSCR CHARACTER VARYING(60) 60
17 ITEMNO SMALLINT 2
18 CLAIMNO NUMERIC(11,0) 19
19 CLAIM_NUMBER NUMERIC(11,0) 19
20 CLAIM_STATUS_CODE CHARACTER(1) 1
21 CLAIM_STATUS CHARACTER(10) 10
22 CLAIM_LOSS_DATE DATE 4
23 CLAIM_REPORT_DATE DATE 4
24 CLAIM_CLOSED_DATE DATE 4
25 LOSS_DESCRIPTION CHARACTER(60) 60
26 RISK_STATE_CODE CHARACTER(2) 2
27 RISK_STATE CHARACTER(60) 60
28 COINSPC NUMERIC(5,3) 19
29 OCCUPATION_CODE CHARACTER VARYING(4) 4
30 CLAIM_COUNT INTEGER 4
31 GRS_INCRD NUMERIC(38,2) 19
32 GRS_PAID NUMERIC(38,2) 19
33 GRS_OS_EST NUMERIC(38,2) 19
34 GRS_DEDUC NUMERIC(38,2) 19
35 EXCESS NUMERIC(38,2) 19
36 GRS_SETTLEMENT NUMERIC(38,2) 19
37 GRS_EXPENSE NUMERIC(38,2) 19
38 GRS_RECOVERY NUMERIC(38,2) 19
39 INSURED_INITIAL CHARACTER VARYING(5) 5
40 INSURED_NAME CHARACTER VARYING(81) 81
41 CLIENT_RNK BIGINT 8
42 POLICY_STATE_CODE SMALLINT 2
43 POLICY_STATE CHARACTER(30) 30
44 BRKR_SYS_NUM INTEGER 4
45 BROKER_CODE INTEGER 4
46 BROKER_NAME CHARACTER VARYING(200) 200
47 BROKER_GROUP CHARACTER VARYING(100) 100
48 CUSTOMER_SEGMENT CHARACTER VARYING(50) 50
49 RELATIONSHIP_CONTACT CHARACTER VARYING(200) 200
50 SERVICE_SEGMENT CHARACTER VARYING(100) 100
51 ACCT_YEAR CHARACTER VARYING(4) 4
52 ACCT_MONTH CHARACTER VARYING(2) 2
53 ACCT_YEAR_MONTH INTEGER 4
54 ACCT_YEAR_MONTH_TXT CHARACTER VARYING(8) 8
55 PROP_RNK BIGINT 8