SDW_TSDMD_FLOW_OF_FUNDS_MEASURES

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_SDW_TSDMD_FLOW_OF_FUNDS_MEASURES

SDSNZP05_BANK..CBP_SDW_TSDMD_FLOW_OF_FUNDS_MEASURES

Columns
# Name Data Type Length
1 FLOW_OF_FUNDS_MEASURES_DIM_ID BIGINT 8
2 CATEGORY CHARACTER VARYING(256) 256
3 CATEGORY_GROUP CHARACTER VARYING(256) 256
4 MEASURE_SEQUENCE NUMERIC(38,0) 19
5 CATEGORY_SEQUENCE NUMERIC(38,0) 19
6 CATEGORY_GROUP_SEQUENCE NUMERIC(38,0) 19
7 CLASSIFICATION CHARACTER VARYING(256) 256
8 REPYMT_EVENT_TYPE_DESC CHARACTER VARYING(256) 256
9 FINALISATION_TYPE CHARACTER VARYING(24) 24
10 EXCESS_SHORTFALL_STATUS CHARACTER VARYING(20) 20
11 MEASURE CHARACTER VARYING(256) 256
12 BUSINESS_LOAD_DATE TIMESTAMP 8
13 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
14 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
15 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
16 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8