GP Views - Fiscal Period Map

/****** Object:  View [dbo].[BI_FYPeriods]    Script Date: 9/5/2019 3:54:04 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[BI_FYPeriods]
AS
SELECT DISTINCT PERIODID AS FPeriod, YEAR(PERIODDT) AS PYr, MONTH(PERIODDT) AS PMth, YEAR1 AS FYr, RIGHT('00' + CAST(MONTH(PERIODDT) AS varchar), 2) AS PMth0
FROM            dbo.SY40100
WHERE        (PERIODID > 0)
GO