SDW_TSDMF_SALES_OFFICER_BDGT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 PERIOD_DATE TIMESTAMP 8
3 BUSINESS_LOAD_DIM_ID BIGINT 8
4 BUSINESS_LOAD_DATE TIMESTAMP 8
5 PERIOD_TYPE_DIM_ID BIGINT 8
6 SALES_MEASURES_DIM_ID BIGINT 8
7 SALES_OFFICER_DIM_ID BIGINT 8
8 SALES_OFFICER_CODE CHARACTER VARYING(24) 24
9 ROLE_DIM_ID BIGINT 8
10 COST_CENTRE_DIM_ID BIGINT 8
11 SOURCE_PD_LVLS_12_DIM_ID BIGINT 8
12 BDGT_AMT_WK NUMERIC(38,0) 19
13 BDGT_AMT_MTD NUMERIC(38,0) 19
14 BDGT_AMT_QTD NUMERIC(38,0) 19
15 BDGT_AMT_FIN_YTD NUMERIC(38,0) 19
16 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
17 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
18 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
19 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8