Time hierarchy

This hierarchy represents the calendar time used for tracking employee- and job-related processes. The attributes and relationships in the following figure represent the Time hierarchy.

Attribute	Description	Example
Date	Calendar date that is used to track the different processes and also used for entries in to the general ledger.	01/01/03
Month	Calendar month.	Jan 2003
Quarter	A period of 3 months.	Q1 2003
Year	Calendar year.	2002, 2003

The detailed definition of each attribute in the MicroStrategy metadata listed previously is shown in the following tables.

Date

Form	Form Expression	Lookup Table	Other Tables
ID	DATE_ID	L_CAL_DATE	F_EMP_QLFN

 

Children	Parents	Relationship Type	Table
None	Month	Many-to-one	L_CAL_DATE

Month

Form	Form Expression	Lookup Table	Other Tables
ID	MONTH_ID	L_CAL_MONTH	L_CAL_DATE, F_POSITION, F_EMP_HIST
DESC	MONTH_DESC	L_CAL_MONTH	None

 

Children	Parents	Relationship Type	Table
Date	None	One-to-many	L_CAL_DATE
None	Quarter	Many-to-one	L_CAL_MONTH

Quarter

Form	Form Expression	Lookup Table	Other Tables
ID	QTR_ID	L_CAL_QTR	L_CAL_DATE, L_CAL_MONTH, F_BENEFIT_QTR
DESC	QTR_DESC	L_CAL_QTR	None

 

Children	Parents	Relationship Type	Table
Month	None	One-to-many	L_CAL_MONTH
None	Year	Many-to-one	L_CAL_QTR

Year

Form	Form Expression	Lookup Table	Other Tables
ID	YEAR_ID	L_CAL_YEAR	L_CAL_DATE, L_CAL_MONTH, L_CAL_QTR, F_SURVEY, F_PERF, F_EMP_LEVEL, F_COMP, F_BONUS_PTNTL

 

Children	Parents	Relationship Type	Table
Quarter	None	One-to-many	L_CAL_QTR