KEEPME_HCIS_HST_CUST_X_ACCT_TB_20210129

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CUST_CO_NBR NUMERIC(5,0) 19
2 CUST_ID CHARACTER VARYING(9) 9
3 CUST_TIE_BRKR SMALLINT 2
4 ACCT_CO_NBR NUMERIC(5,0) 19
5 ACCT_PRDCT_CD CHARACTER VARYING(3) 3
6 ACCT_ID CHARACTER VARYING(23) 23
7 CUAC_REL_CD CHARACTER VARYING(3) 3
8 PRIM_CUST_IND CHARACTER VARYING(1) 1
9 RPM_ANALYSIS_IND CHARACTER VARYING(1) 1
10 RPM_PRICING_IND CHARACTER VARYING(1) 1
11 COMBINED_STMT_IND CHARACTER VARYING(1) 1
12 PCS_PLAN_IND CHARACTER VARYING(1) 1
13 TFN_TYPE_IND CHARACTER VARYING(1) 1
14 LINK_TYPE_IND CHARACTER VARYING(1) 1
15 OWNED_PCNT NUMERIC(7,4) 19
16 ACCT_ID_NBR NUMERIC(16,0) 19
17 CUST_NBR NUMERIC(15,0) 19
18 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
19 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
20 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
21 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8