HDDA_DRIVER_ACCOUNT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 KEY_COID CHARACTER VARYING(5) 5
2 KEY_PROD CHARACTER VARYING(3) 3
3 KEY_ACCT BIGINT 8
4 DRVR_TYPE CHARACTER VARYING(2) 2
5 DRVR_SEQ_NO INTEGER 4
6 DRVR_BAL_CD CHARACTER VARYING(1) 1
7 DRVR_DAILY_LIMIT NUMERIC(16,2) 19
8 DRVR_DATE_LST_MNTD TIMESTAMP 8
9 DRVR_DATE_RELATED TIMESTAMP 8
10 DRVR_INSTR_CD CHARACTER VARYING(1) 1
11 DRVR_OWNER_CD CHARACTER VARYING(1) 1
12 DRVR_REL_ACCT BIGINT 8
13 DRVR_REL_ACCT_STAT CHARACTER VARYING(1) 1
14 DRVR_REL_PRDCT CHARACTER VARYING(3) 3
15 DRVR_REL_SEQ_NO INTEGER 4
16 DRVR_ACTY_CNT_CTD BIGINT 8
17 DRVR_ACTY_CNT_YTD BIGINT 8
18 DRVR_AMT_LAST_XFER NUMERIC(16,2) 19
19 DRVR_AMT_XFER_CTD NUMERIC(19,2) 19
20 DRVR_AMT_XFER_YTD NUMERIC(19,2) 19
21 DRVR_DT_LAST_XFER TIMESTAMP 8
22 DRVR_TOT_AT_OD_CNT BIGINT 8
23 DRVR_TOT_AT_TB_CNT BIGINT 8
24 DRVR_XFER_AMT NUMERIC(16,2) 19
25 DRVR_XFER_INC NUMERIC(12,2) 19
26 DATA_DATE TIMESTAMP 8
27 LOAD_ID INTEGER 4
28 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
29 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
30 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
31 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8