SDW_TSDMD_LEAGUE_LADDER_ROLE_MSR

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 LEAGUE_LADDER_ROLE_MSR_DIM_ID BIGINT 8
2 ROLE_CODE CHARACTER VARYING(30) 30
3 SOURCE_PRODUCT_LEVEL_1_CODE CHARACTER VARYING(100) 100
4 SOURCE_PRODUCT_LEVEL_2_CODE CHARACTER VARYING(100) 100
5 MEASURE CHARACTER VARYING(50) 50
6 EFFECTIVE_DATE TIMESTAMP 8
7 LOAD_STATUS_FLAG CHARACTER VARYING(1) 1
8 INSERT_RUN_AUDIT_ID NUMERIC(38,0) 19
9 UPDATE_RUN_AUDIT_ID NUMERIC(38,0) 19
10 END_DATE TIMESTAMP 8
11 CURRENT_FLAG CHARACTER VARYING(1) 1
12 MEASURE_TITLE CHARACTER VARYING(50) 50
13 LEAGUE_LADDER_PERCENTAGE NUMERIC(38,0) 19
14 DISPLAY_SORT_SEQUENCE NUMERIC(38,0) 19
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