HGN_TCIST_CORRESP_HIST

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CUST_NBR NUMERIC(15,0) 19
2 ACCT_CO_NBR NUMERIC(5,0) 19
3 ACCT_PRDCT_CD CHARACTER VARYING(3) 3
4 ACCT_ID CHARACTER VARYING(23) 23
5 CORRESP_START_DATE DATE 4
6 CORRESP_END_DATE DATE 4
7 CORRESP_TYPE CHARACTER VARYING(10) 10
8 IMAGE_ID CHARACTER VARYING(60) 60
9 VIEWED_TIMESTAMP TIMESTAMP 8
10 PRINT_ARCH_FLAG CHARACTER VARYING(1) 1
11 E_DELIVERY_FLAG CHARACTER VARYING(1) 1
12 STMT_NBR NUMERIC(7,0) 19
13 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
14 RECORD_TYPE CHARACTER VARYING(16) 16
15 COMMIT_TIMESTAMP TIMESTAMP 8
16 EXTRACT_TIMESTAMP TIMESTAMP 8