SDW_TCRPD_BORROWER

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BORROWER_DIM_ID BIGINT 8
2 SRC_STM_CODE CHARACTER VARYING(12) 12
3 BORROW_NUMBER CHARACTER VARYING(20) 20
4 LOAD_STATUS_FLAG CHARACTER VARYING(1) 1
5 INSERT_RUN_AUDIT_ID NUMERIC(38,0) 19
6 UPDATE_RUN_AUDIT_ID NUMERIC(38,0) 19
7 BORROWER_NAME CHARACTER VARYING(256) 256
8 IP_ID BIGINT 8
9 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
10 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
11 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
12 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8