SLN_BUSINESS_BROKERS

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SLN_BUSINESS_BROKERS_HIID BIGINT 8
2 ACTION_CODE CHARACTER(1) 1
3 BROKER_CODE CHARACTER VARYING(6) 6
4 BROKER_NAME CHARACTER VARYING(35) 35
5 AGGREGATOR_GROUP_CODE CHARACTER VARYING(6) 6
6 AGGREGATOR_GROUP_DESC CHARACTER VARYING(35) 35
7 ACCRED_BROKER_CODE CHARACTER VARYING(2) 2
8 ACCRED_BROKER_NAME CHARACTER VARYING(35) 35
9 RELN_MGR_CODE CHARACTER VARYING(6) 6
10 RELN_MGR_NAME CHARACTER VARYING(35) 35
11 STATE CHARACTER VARYING(3) 3
12 DELTA_TYPE CHARACTER VARYING(1) 1
13 EFFECTIVE_STRT_DT TIMESTAMP 8
14 EFFECTIVE_END_DT TIMESTAMP 8
15 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
16 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
17 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
18 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8