Dimensional Warehouse Model Data Model

Entity

Entity Tenant Calendar Array

Description

The tenant-specific calendar, which is at the grain of a single day. It provides for aggregation at the month, quarter and year level. The tenant's fiscal year, quarter and month, as well as business days and holidays may be defined, if known.

Attributes
AWM Load Info Sk
Business Day Ind
Calendar Date Abbr
Calendar Date Full Nm
Calendar Dk
Calendar Dt
Current Ind
Day Of Month Num
Day Of Week Abbr
Day Of Week Nm
Day Of Week Num
Day Of Year Num
DWM Load Info Sk
Effective From Dt
Effective To Dt
Fiscal Month Abbr
Fiscal Month Begin Dt
Fiscal Month End Dt
Fiscal Month Nm
Fiscal Month Num
Fiscal Quarter Abbr
Fiscal Quarter Begin Dt
Fiscal Quarter End Dt
Fiscal Quarter Num
Fiscal Year Begin Dt
Fiscal Year End Dt
Fiscal Year Num
Holiday Ind
Month And Year Abbr
Month And Year Nm
Month And Year Num
Month Of Year Abbr
Month Of Year Nm
Month Of Year Num
Prior Fiscal Month Abbr
Prior Fiscal Month Begin Dt
Prior Fiscal Month End Dt
Prior Fiscal Month Nm
Prior Fiscal Month Num
Prior Fiscal Quarter Abbr
Prior Fiscal Quarter Begin Dt
Prior Fiscal Quarter End Dt
Prior Fiscal Quarter Num
Prior Fiscal Year Begin Dt
Prior Fiscal Year End Dt
Prior Fiscal Year Num
Prior Month And Year Abbr
Prior Month And Year Nm
Prior Month And Year Num
Prior Month Of Year Abbr
Prior Month Of Year Nm
Prior Month Of Year Num
Prior Quarter And Year Abbr
Prior Quarter And Year Num
Prior Quarter Of Year Abbr
Prior Quarter Of Year Num
Prior Year Num
Quarter And Year Abbr
Quarter And Year Num
Quarter Of Year Abbr
Quarter Of Year Num
Source Code Sk
Tenant Sk
Valid From Ts
Valid To Ts
Year Num

Relationship
Tenant Calendar_Calendar_FK

Primary Key
Tenant Calendar Array PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

AWM Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Business Day Ind

Description	Flag indicating if the calendar dimension occurrence is a business day.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Calendar Date Abbr

Description	The abbreviated text that represents the Calendar Date, e.g. Dec 7, 2011.
Data Type	Standards - Data Domains.ddm/Data Domains/Abbreviation [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Calendar Date Full Nm

Description	The full descriptive text that represents the Calendar Date, e.g. December 7, 2011.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Calendar Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Calendar Dt

Description	The date for the Calendar row. This is a DATE column using the database's native date format.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Current Ind

Description	Set to 'Y' if this is the most recent row of a group having the same Surrogate Key.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Day Of Month Num

Description	The numeric representation of day of the month corresponding to the Calendar Date. This is an integer between 1 and 31.
Data Type	Standards - Data Domains.ddm/Data Domains/Month Day Number [SHORT]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Day Of Week Abbr

Description	The abbreviated day of the week, e.g., 'Mon'.
Data Type	Standards - Data Domains.ddm/Data Domains/Abbreviation [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Day Of Week Nm

Description	The name of the day of the week corresponding to the Calendar Date, e.g., 'Monday'.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Day Of Week Num

Description	An integer between 1 and 7 that represents the day of the week. In the Unites States, 1 represents Sunday.
Data Type	Standards - Data Domains.ddm/Data Domains/Week Day Number [SHORT]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Day Of Year Num

Description	The numeric day of the year corresponding to the Calendar Date. It is constrained to integers between 1 and 366.
Data Type	Standards - Data Domains.ddm/Data Domains/Year Day Number [SHORT]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

DWM Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Effective From Dt

Description	Establishes a period where a set of attributes are true according to the business.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Effective To Dt

Description	Ends a period of effectivity.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Fiscal Month Abbr

Description	The Month Abbreviation corresponding to the Fiscal Calendar, expressed as a three-character string. For example, 'Dec' for the fiscal month of December.
Data Type	Standards - Data Domains.ddm/Data Domains/Abbreviation [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Fiscal Month Begin Dt

Description	The date on which the Fiscal month begins.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Fiscal Month End Dt

Description	The date on which the Fiscal month ends.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Fiscal Month Nm

Description	The name of the current Fiscal month.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Fiscal Month Num

Description	The Month Number corresponding to the Fiscal Calendar, expressed as a two-digit integer between 1 and 12.
Data Type	Standards - Data Domains.ddm/Data Domains/Month Number [SHORT]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Fiscal Quarter Abbr

Description	The Quarter Abbreviation corresponding to the Fiscal Calendar, expressed as a two-character string. For example 'Q4' for the fourth fiscal quarter.
Data Type	Standards - Data Domains.ddm/Data Domains/Abbreviation [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Fiscal Quarter Begin Dt

Description	The calendar date on which the Fiscal Quarter begins.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Fiscal Quarter End Dt

Description	The calendar date on which the Fiscal Quarter ends.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Fiscal Quarter Num

Description	The Quarter Number corresponding to the Fiscal Calendar, expressed as a one-digit integer between 1 and 4.
Data Type	Standards - Data Domains.ddm/Data Domains/Quarter Number [SHORT]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Fiscal Year Begin Dt

Description	The date on which the Fiscal Calendar Year begins. This is a DATE column using the database's native date format.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Fiscal Year End Dt

Description	The date on which the Fiscal Calendar Year ends. This is a DATE column using the database's native date format.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Fiscal Year Num

Description	The year corresponding to the Fiscal Calendar, expressed as a four-digit integer.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Holiday Ind

Description	Identifies which Calendar Days are considered to be Holidays by the organization.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Month And Year Abbr

Description	An abbreviated representation of the month and year corresponding to the Calendar Date. For example, Dec 2011 for a date in December, 2011.
Data Type	Standards - Data Domains.ddm/Data Domains/Abbreviation [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Month And Year Nm

Description	A representation of the month and year corresponding to the Calendar Date. For example, December 2011 for a date in December, 2011.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Month And Year Num

Description	A numeric representation of the month and year corresponding to the Calendar Date. For example, 201112 for a date in December, 2011.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Month Of Year Abbr

Description	The month of the year corresponding to the Calendar Date, expressed an abbreviation, such as 'Dec'.
Data Type	Standards - Data Domains.ddm/Data Domains/Abbreviation [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Month Of Year Nm

Description	The name of the month of the year corresponding to the Calendar Date, e.g., December.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Month Of Year Num

Description	The month of the year corresponding to the Calendar Date, expressed as an integer between 1 and 12.
Data Type	Standards - Data Domains.ddm/Data Domains/Month Number [SHORT]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Prior Fiscal Month Abbr

Description	The previous Month Abbreviation corresponding to the Fiscal Calendar, expressed as a three-character string. For example, 'Dec' for the fiscal month of December.
Data Type	Standards - Data Domains.ddm/Data Domains/Abbreviation [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Prior Fiscal Month Begin Dt

Description	The date on which the previous Fiscal month began.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Prior Fiscal Month End Dt

Description	The date on which the previous Fiscal month ended.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Prior Fiscal Month Nm

Description	The name of the previous Fiscal month.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Prior Fiscal Month Num

Description	The previous Month Number corresponding to the Fiscal Calendar, expressed as a two-digit integer between 1 and 12.
Data Type	Standards - Data Domains.ddm/Data Domains/Month Number [SHORT]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Prior Fiscal Quarter Abbr

Description	The previous Quarter Abbreviation corresponding to the Fiscal Calendar, expressed as a two-character string. For example 'Q4' for the fourth fiscal quarter.
Data Type	Standards - Data Domains.ddm/Data Domains/Abbreviation [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Prior Fiscal Quarter Begin Dt

Description	The calendar date on which the previous Fiscal Quarter began.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Prior Fiscal Quarter End Dt

Description	The calendar date on which the previous Fiscal Quarter ended.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Prior Fiscal Quarter Num

Description	The previous Quarter Number corresponding to the Fiscal Calendar, expressed as a one-digit integer between 1 and 4.
Data Type	Standards - Data Domains.ddm/Data Domains/Quarter Number [SHORT]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Prior Fiscal Year Begin Dt

Description	The date on which the previous Fiscal Calendar Year began. This is a DATE column using the database's native date format.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Prior Fiscal Year End Dt

Description	The date on which the previous Fiscal Calendar Year ended. This is a DATE column using the database's native date format.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Prior Fiscal Year Num

Description	The previous year corresponding to the Fiscal Calendar, expressed as a four-digit integer.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Prior Month And Year Abbr

Description	An abbreviated representation of the previous month and year corresponding to the Calendar Date. For example, Nov 2011 for a current date in December, 2011.
Data Type	Standards - Data Domains.ddm/Data Domains/Abbreviation [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Prior Month And Year Nm

Description	A representation of the previous month and year corresponding to the Calendar Date. For example, November 2011 for a current date in December, 2011.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Prior Month And Year Num

Description	A numeric representation of the previous month and year corresponding to the Calendar Date. For example, 201111 for a current date in December, 2011.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Prior Month Of Year Abbr

Description	The previous month of the year corresponding to the Calendar Date, expressed an abbreviation, such as 'NOV' if the current month is DEC.
Data Type	Standards - Data Domains.ddm/Data Domains/Abbreviation [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Prior Month Of Year Nm

Description	The name of the previous month of the year corresponding to the Calendar Date, e.g., November if the current month is December.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Prior Month Of Year Num

Description	The previous month of the year corresponding to the Calendar Date, expressed as an integer between 1 and 12. If the current month is 12, this will be 11.
Data Type	Standards - Data Domains.ddm/Data Domains/Month Number [SHORT]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Prior Quarter And Year Abbr

Description	An alpha-numeric representation of the previous quarter and year corresponding to the Calendar Date, expressed as an integer, e.g. 2011 Q3 for a current date in the fourth quarter of 2011.
Data Type	Standards - Data Domains.ddm/Data Domains/Abbreviation [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Prior Quarter And Year Num

Description	A numeric representation of the previous quarter and year corresponding to the Calendar Date, expressed as an integer, e.g. 20113 for a current date in the fourth quarter of 2011.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Prior Quarter Of Year Abbr

Description	The previous quarter of the year corresponding to the Calendar Date, expressed an abbreviation, such as 'Q3' if the current date falls in Q4.
Data Type	Standards - Data Domains.ddm/Data Domains/Abbreviation [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Prior Quarter Of Year Num

Description	The name of the previous quarter of the year corresponding to the Calendar Date, e.g., Q3 if the current quarter is Q4.
Data Type	Standards - Data Domains.ddm/Data Domains/Quarter Number [SHORT]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Prior Year Num

Description	The year corresponding to the Prior Year, expressed as a four-digit integer.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Quarter And Year Abbr

Description	An alpha-numeric representation of the quarter and year corresponding to the Calendar Date, expressed as an integer, e.g. 2011 Q4 for the fourth quarter of 2011.
Data Type	Standards - Data Domains.ddm/Data Domains/Abbreviation [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Quarter And Year Num

Description	A numeric representation of the quarter and year corresponding to the Calendar Date, expressed as an integer, e.g. 20114 for the fourth quarter of 2011.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Quarter Of Year Abbr

Description	The quarter of the year corresponding to the Calendar Date, expressed an abbreviation, such as 'Q4'.
Data Type	Standards - Data Domains.ddm/Data Domains/Abbreviation [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Quarter Of Year Num

Description	The quarter of the year corresponding to the Calendar Date, expressed as an integer.
Data Type	Standards - Data Domains.ddm/Data Domains/Quarter Number [SHORT]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Source Code Sk

Description	The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Tenant Sk

Description	The surrogate key of the entry identifying the legal owner of the data.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Valid From Ts

Description	Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Valid To Ts

Description	Ends a period of validity.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Year Num

Description	The year corresponding to the Calendar Date, expressed as a four-digit integer.
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier Numeric [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Relationship Details

Tenant Calendar_Calendar_FK

Is Identifying Relationship	true
Child Table	Tenant Calendar Array
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Calendar Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Tenant Calendar Array PK

Key Attribute	Calendar Dk
Key Attribute	Tenant Sk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model