INT_WCOM_POLTERM_POLCIDTL

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 LATEST_PER_POLICY_TERM_FLAG BIGINT 8
2 POLICYKEY BIGINT 8
3 POLICY INTEGER 4
4 COMPANY SMALLINT 2
5 QTEPRDUCT CHARACTER(3) 3
6 POLCIDTLPRD CHARACTER(3) 3
7 TRANCNT SMALLINT 2
8 POLICY_TERMSTART INTEGER 4
9 POLICY_DUE_DATE INTEGER 4
10 EFFECTDTE INTEGER 4
11 CEDFLAG CHARACTER(1) 1
12 CEDTYPE CHARACTER(1) 1
13 CEDREFPCT INTEGER 4
14 CEDPRMPCT INTEGER 4
15 MAXCEDREF INTEGER 4
16 IBNRIBNER INTEGER 4
17 POLICY_TERM_OFFERING CHARACTER(4) 4
18 CLAIM_BASIS CHARACTER(1) 1
19 INTERIM_ADJ_FACTOR1 SMALLINT 2
20 INTERIM_ADJ_FACTOR2 SMALLINT 2
21 FINAL_ADJ_FACTOR1 SMALLINT 2
22 FINAL_ADJ_FACTOR2 SMALLINT 2
23 NO_OF_YEARS SMALLINT 2
24 CALL_UP_FREQUENCY CHARACTER(1) 1
25 MAX_PREMIUM NUMERIC(11,0) 19
26 MAX_RATE NUMERIC(5,2) 19
27 MIN_PREMIUM NUMERIC(11,0) 19
28 MIN_RATE NUMERIC(5,2) 19
29 RISK_MGMT_TYPE CHARACTER(1) 1
30 INCENTIVE_OFFERED INTEGER 4
31 INCENTIVE_PAID INTEGER 4
32 INCENTIVE_EARNED INTEGER 4
33 PRMOVRRSN CHARACTER(2) 2
34 MULTIYEAR CHARACTER(2) 2
35 RENLIKEIND CHARACTER(1) 1
36 CATEGORYCD CHARACTER(1) 1
37 TERM_RN_LAST BIGINT 8
38 LATEST_TERM_FLAG BIGINT 8