SDW_TSDMD_MSR_PRD_MONTH_DIM

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 MSR_PRD_DIM_ID BIGINT 8
2 ISRT_RUN_AUDT_ID NUMERIC(38,0) 19
3 UDT_RUN_AUDT_ID NUMERIC(38,0) 19
4 MSR_PRD_DT TIMESTAMP 8
5 MONTH_CALENDAR_START_DT TIMESTAMP 8
6 MONTH_CALENDAR_END_DT TIMESTAMP 8
7 LAST_DAY_MONTH_FL CHARACTER VARYING(1) 1
8 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
9 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
10 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
11 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8