INT_CTP_CVN

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BRAND_ID CHARACTER(3) 3
2 COMPANY SMALLINT 2
3 POLICY INTEGER 4
4 POLICY_INCEPTION_DATE_KEY INTEGER 4
5 POLICY_NUMBER CHARACTER VARYING(12) 12
6 POLICY_STAGE_LEVEL1 CHARACTER VARYING(20) 20
7 POLICY_STAGE_LEVEL2 CHARACTER VARYING(20) 20
8 POLICY_TERMSTART INTEGER 4
9 PRODUCT CHARACTER(3) 3
10 REVERSAL_TIMESTAMP TIMESTAMP 8
11 TRANSACTION_COUNT INTEGER 4
12 TRANSACTION_DATE_KEY INTEGER 4
13 USER_ID CHARACTER(8) 8
14 PREVIOUS_POLICY_NUMBER BIGINT 8
15 ROW_RANK BIGINT 8
16 CLIENT INTEGER 4
17 NOMINATION_STAGE_LEVEL1 CHARACTER VARYING(20) 20
18 SOURCE_AGENT INTEGER 4