CFD_TCFDD_FINANCIAL_DATE_DIM

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DATE_ID DOUBLE PRECISION 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 DOUBLE PRECISION 8
8 MTH_NUM_WITH_YR CHARACTER VARYING(10) 10
9 MTH_LST_DAY_IND CHARACTER VARYING(1) 1
10 CAL_YR DOUBLE PRECISION 8
11 FIN_YR DOUBLE PRECISION 8
12 QUARTER CHARACTER VARYING(10) 10
13 QUARTER_WITH_YR CHARACTER VARYING(20) 20
14 QUARTER_LST_DAY_IND CHARACTER VARYING(1) 1
15 YR_LST_DAY_IND CHARACTER VARYING(1) 1
16 HALF_YR CHARACTER VARYING(10) 10
17 HALF_YR_WITH_YR CHARACTER VARYING(20) 20
18 WK_NUM_IN_MTH DOUBLE PRECISION 8
19 WK_NUM_IN_YR DOUBLE PRECISION 8
20 DAY_NUM_IN_WK DOUBLE PRECISION 8
21 DAY_NUM_IN_MTH DOUBLE PRECISION 8
22 DAY_NUM_IN_YR DOUBLE PRECISION 8
23 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
24 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
25 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
26 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8