DIM_CUST_SOURCE_CUST_AUX_CLMS

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRDT_SYS_CUST_NUM CHARACTER VARYING(30) 30
2 PRDT_SYS_CODE CHARACTER VARYING(3) 3
4 PRDT_SYS_CODE_CDI CHARACTER VARYING(3) 3
5 PRDT_SYS_CUST_NUM_CDI CHARACTER VARYING(30) 30
6 CLMS_GRP_NUM CHARACTER VARYING(6) 6
7 BRCH_CODE CHARACTER VARYING(5) 5
8 OCCUP_NAM CHARACTER VARYING(30) 30
9 CLIENT_TIER_CODE CHARACTER VARYING(2) 2
10 NXT_RVW_TYP_CODE CHARACTER VARYING(2) 2
11 NXT_RVW_DATE TIMESTAMP 8
12 NXT_RVW_CMNT CHARACTER VARYING(30) 30
13 LST_RVW_DATE TIMESTAMP 8
14 CRGS_CQR CHARACTER VARYING(2) 2
15 CRGS_SR CHARACTER VARYING(1) 1
16 CRGS_CRC CHARACTER VARYING(1) 1
17 BORR_LIM_AMT NUMERIC(8,0) 19
18 CRGS_DATE TIMESTAMP 8
19 SRC_SYS_ID CHARACTER VARYING(3) 3