| BANKING Data Model |
Description | Calendar Date identifies the dates of the Gregorian calendar and is used to assist analysis by time dimension at day level.Calendar month, quarter and year could also be designed as separate entities to allow more flexibility to join the time dimension to fact tables where the grain is day, month, quarter, or year. However, having such separate dimensions prevents the combination of measures stored in different fact tables at different levels of granularity. The sole Calendar Date dimension, with its "Month Row", "Quarter Row" and so on Flags avoids this inconvenience.Other examples of potential aggregation hierarchies from the Calendar day or date include:- Calendar date, Season- Calendar date, Week number in calendar year- Calendar date, Week number in calendar month.Creating a view that joins the Calendar Date Dimension table and the Period Outrigger table allows the support of ad hoc measurement periods in a transparent way for business users. |
Primary Key | |
![]() |
Indexes | |
![]() |
Column Details |
Description | The unique identifier of the Calendar Date Dimension. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | true |
Is Identity | true |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Calendar Date indicates the date expressed in the standard format of the modeled organization. For example; 21/05/2014. |
Data Type | DATE |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Calendar Month indicates the number of calendar months which have elapsed since the start of the calendar year till the calendar date. For example; 4. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Calendar Month Row Flag classifies rows of the Calendar Date Dimension based on whether the Calendar Date is used as the reference for the Calendar Month in the hierarchy of Calendar Date. Typically, the last day of the month is often used by Financial Institutions as the reference for the month. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Calendar Month Name indicates the name of the calendar month. For example; May. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Calendar Quarter indicates the textual name of each of the four calendar months periods in which a calendar year can be divided. For example; Q2, Second quarter (April to June). |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Calendar Quarter Row Flag classifies rows of the Calendar Date Dimension based on whether the Calendar Date is used as the reference for the Calendar Quarter in the hierarchy of Calendar Date. Typically, the last day of the quarter is often used by Financial Institutions as the reference for the quarter. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Calendar Week Number indicates the calendar week of the calendar date. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Calendar Year indicates the Gregorian calendar year number of the Calendar Date. One calendar year is made of 12 calendar months. For example; 2014. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Calendar Year Row Flag classifies rows of the Calendar Date Dimension based on whether the Calendar Date is used as the reference for the Calendar Year in the hierarchy of Calendar Date. Typically, the last day of the year is often used by Financial Institutions as the reference for the year. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Company Holiday Flag classifies Calendar Dates based on whether or not they are a holiday for the entire modeled organization. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Day Number In Calendar Month indicates the number of calendar days which have elapsed since the start of the calendar month till the calendar date. For example; 21. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Day Number In Calendar Year indicates the number of calendar days which have elapsed since the start of the calendar year till the calendar date. For example; 141. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Day Of Week indicates the name of the calendar day in the week. For example; Wednesday. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Fiscal Month indicates the fiscal month to which the calendar date belongs.The modeled organization may use a fiscal period as an accounting period. A fiscal period is used when it does not correspond to calendar periods. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Fiscal Month Row Flag classifies rows of the Calendar Date Dimension based on whether the Calendar Date is used as the reference for the Fiscal Month in the hierarchy of Calendar Date. Typically, the last day of the fiscal month is often used by Financial Institutions as the reference for the fiscal month. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Fiscal Quarter indicates the fiscal quarter to which the calendar date belongs.The modeled organization may use a fiscal period as an accounting period. A fiscal period is used when it does not correspond to calendar periods |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Fiscal Quarter Row Flag classifies rows of the Calendar Date Dimension based on whether the Calendar Date is used as the reference for the Fiscal Quarter in the hierarchy of Calendar Date. Typically, the last day of the fiscal quarter is often used by Financial Institutions as the reference for the fiscal quarter. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Fiscal Week indicates the fiscal week to which the calendar date belongs.The modeled organization may use a fiscal period as an accounting period. A fiscal period is used when it does not correspond to calendar periods |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Fiscal Week Number indicates the fiscal week of the calendar date. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Fiscal Year indicates the fiscal year to which the calendar date belongs.The modeled organization may use a fiscal period as an accounting period. A fiscal period is used when it does not correspond to calendar periods. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Fiscal Year Row Flag classifies rows of the Calendar Date Dimension based on whether the Calendar Date is used as the reference for the Fiscal Year in the hierarchy of Calendar Date. Typically, the last day of the fiscal year is often used by Financial Institutions as the reference for the fiscal year. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Last Day In Calendar Month classifies Calendar dates based on whether or not the calendar date is the last day of the calendar month. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Public Holiday Flag classifies Calendar Dates based on whether (1) or not (0) the day is a holiday available to the general population. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Season indicates each of the four periods of time in a calendar year that are defined by the equinoxes and solstices. For example; Spring. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Weekday Flag classifies Calendar Dates based on whether they are a day of the week or a day of the weekend. The flag is set to '1' for Monday, Tuesday, Wednesday, Thursday and Friday. The flag is set to '0' for Saturday and Sunday. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Week Number In Calendar Month indicates the number of calendar weeks which have elapsed since the start of the calendar month till the calendar date. The week number is comprised between 1 and 5. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Week Number In Calendar Year indicates the number of calendar weeks which have elapsed since the start of the calendar year till the calendar date. For example; 21. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Primary Key Details |
Member | CALENDAR_DATE_DIMENSION_ID [BIGINT] |
Index Details |
Is Unique | true |
Is Clustered | false |
Member | CALENDAR_DATE_DIMENSION_ID [BIGINT] Ascending |
| BANKING Data Model |