DIM_DATE_FISCALPERIOD_STAGE

Intermediate storage table for fiscal period information

Fields

Field	Field Type	Null	Notes	Description
GLFISCALYEAR	nvarchar(12)	yes		[dbo].[GLFISCALYEAR].[YEARID]
GLFISCALYEARDESCRIPTION	nvarchar(60)	yes		[dbo].[GLFISCALYEAR].[DESCRIPTION]
GLFISCALYEARSTATUS	nvarchar(10)	yes		[dbo].[GLFISCALYEAR].[STATUS]
GLFISCALPERIOD	int	yes		[dbo].[GLFISCALPERIOD].[SEQUENCE]
GLFISCALPERIODCLOSED	bit	yes		[dbo].[GLFISCALPERIOD].[CLOSED]
STARTDATE	datetime	yes		[dbo].[GLFISCALPERIOD].[STARTDATE]
STARTDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[GLFISCALPERIOD].[STARTDATE]
ENDDATE	datetime	yes		[dbo].[GLFISCALPERIOD].[ENDDATE]
ENDDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[GLFISCALPERIOD].[ENDDATE]
ISINCLUDED	bit	yes		Flag indicating when data should be included in results
ETLCONTROLID	int	yes		ID generated through the ETL process.
SOURCEDIMID	int	yes		Source system used.
GLFISCALYEARSTARTDATE	datetime	yes		The first [dbo].[GLFISCALPERIOD].[STARTDATE] for the GL fiscal year
GLFISCALYEARENDDATE	datetime	yes		The last [dbo].[GLFISCALPERIOD].[ENDDATE] for the GL fiscal year
GLFISCALYEARSEQUENCE	int	yes		[dbo].[GLFISCALYEAR].[FISCALPERIODSINYEAR]
GLFISCALPERIODSINYEAR	int	yes		[dbo].[GLFISCALPERIOD].[SEQUENCE]
GLFISCALPERIODSEQUENCE	int	yes		Sequence for GL fiscal periods defined