Data Management & Meta Data | Meta Data Demo Cases | Meta Data Management (MeDM Voorbeeld) | MeDM Elementen | RDBMS Dataentiteiten | Calendar |

Calendar

Package RDBMS Dataentiteiten
Auteur Bert Dingemans
Alias
Stereotypes table

Attributes

Name Type Cardinality Description
DW_Id bigint #mincard# - #maxcard#
DateValue datetime #mincard# - #maxcard#
DisplayDate varchar #mincard# - #maxcard#
DayOfMonth int #mincard# - #maxcard#
DayName varchar #mincard# - #maxcard#
DayOfWeek int #mincard# - #maxcard#
IsWeekDay int #mincard# - #maxcard#
DayOfQuarter int #mincard# - #maxcard#
DayOfWeekInYear int #mincard# - #maxcard#
DayOfYear int #mincard# - #maxcard#
WeekKey int #mincard# - #maxcard#
Week int #mincard# - #maxcard#
WeekName varchar #mincard# - #maxcard#
YearWeekName varchar #mincard# - #maxcard#
WeekOfMonth int #mincard# - #maxcard#
WeekOfQuarter int #mincard# - #maxcard#
WeekOfYear int #mincard# - #maxcard#
MonthKey int #mincard# - #maxcard#
Month int #mincard# - #maxcard#
MonthName varchar #mincard# - #maxcard#
YearMonthName varchar #mincard# - #maxcard#
QuarterKey int #mincard# - #maxcard#
Quarter int #mincard# - #maxcard#
QuarterName varchar #mincard# - #maxcard#
HalfYearKey int #mincard# - #maxcard#
HalfYear int #mincard# - #maxcard#
HalfYearName varchar #mincard# - #maxcard#
YearHalfYearName varchar #mincard# - #maxcard#
YearQuarterName varchar #mincard# - #maxcard#
Year int #mincard# - #maxcard#
YearName varchar #mincard# - #maxcard#
FirstDayOfMonth datetime #mincard# - #maxcard#
LastDayOfMonth datetime #mincard# - #maxcard#
FirstDayOfQuarter datetime #mincard# - #maxcard#
LastDayOfQuarter datetime #mincard# - #maxcard#
FirstDayOfYear datetime #mincard# - #maxcard#
LastDayOfYear datetime #mincard# - #maxcard#
YearIndex int #mincard# - #maxcard#
QuarterIndex int #mincard# - #maxcard#
MonthIndex int #mincard# - #maxcard#
WeekIndex int #mincard# - #maxcard#
DW_Batch bigint #mincard# - #maxcard#
DW_SourceCode varchar #mincard# - #maxcard#
DW_TimeStamp datetime #mincard# - #maxcard#

Links 2 Tags

Archimate Assessment Dama Data architectuur Data governance Data kwaliteit Data management rolprofiel Data security Logisch applicatie model Master data Maturity model Meta data Metadata Modelleren Repository Soa Vragenlijst Webvideo