CFD_TCFDW_BRANCH_REGION

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BRANCH_CODE CHARACTER VARYING(4) 4
2 BRANCH_NAME CHARACTER VARYING(40) 40
3 REGION_CODE CHARACTER VARYING(4) 4
4 CHANNEL_CODE CHARACTER VARYING(4) 4
5 MAPPED_BRANCH_CODE CHARACTER VARYING(4) 4
6 BRANCH_GRADE CHARACTER VARYING(1) 1
7 INSURE_SERVCTR CHARACTER VARYING(4) 4
8 SNPSHT_DATE TIMESTAMP 8
9 DATA_LOAD_DATE TIMESTAMP 8
10 LOAD_ID DOUBLE PRECISION 8
11 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
12 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
13 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
14 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8