CFD_TCFDR_DATE

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DATE_ID BIGINT 8
2 DATE_VAL TIMESTAMP 8
3 MTH_SHRT_NAM CHARACTER VARYING(5) 5
4 MTH_NAM CHARACTER VARYING(10) 10
5 MTH_SHRT_NAM_WITH_YR CHARACTER VARYING(20) 20
6 MTH_LONG_NAM_WITH_YR CHARACTER VARYING(20) 20
7 MTH_NUM_IN_YR BIGINT 8
8 MTH_NUM_WITH_YR CHARACTER VARYING(10) 10
9 MTH_LST_DAY_IND CHARACTER VARYING(1) 1
10 YR BIGINT 8
11 QUARTER CHARACTER VARYING(10) 10
12 QUARTER_WITH_YR CHARACTER VARYING(20) 20
13 QUARTER_LST_DAY_IND CHARACTER VARYING(1) 1
14 HALF_YR CHARACTER VARYING(10) 10
15 HALF_YR_WITH_YR CHARACTER VARYING(20) 20
16 WK_NUM_IN_MTH BIGINT 8
17 WK_NUM_IN_YR BIGINT 8
18 DAY_NUM_IN_WK BIGINT 8
19 DAY_NUM_IN_MTH BIGINT 8
20 DAY_NUM_IN_YR BIGINT 8
21 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
22 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
23 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
24 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8