Dimension Table Target: WDT_FISCAL

	RETURN TO BANNER EDW META DATA REPORTS LIST
	Analyze Fundraising Star Manage Prospect Pipeline Star Manage Prospect Pipeline A Star Manage Prospect Pipeline B Star Rqpp Entity Star Rqpp Yearly Des Coll Star Rqpp Yearly Des Dept Star Rqpp Yearly Institution Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_FISCAL_DATE

Description The Fiscal Date Dimension table provides information on the time frame for which the rest of the associated dimension and fact tables are storing the information in the star.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name

FISCAL_DATE Fiscal date. DATE
MGKUTIL.F_GETCALENDARRECORDS

FISCAL_DATE

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

FISCAL_MONTH_DATE Fiscal month date. DATE
MGKUTIL.F_GETCALENDARRECORDS

FISCAL_MONTH_DATE

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

FISCAL_PERIOD Fiscal period. VARCHAR2(63)
MGKUTIL.F_GETCALENDARRECORDS

FISCAL_PERIOD

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

FISCAL_PERIOD_LD Fiscal period short description. VARCHAR2(255)
MGKUTIL.F_GETCALENDARRECORDS

FISCAL_PERIOD_LD

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

FISCAL_PERIOD_SD Fiscal period long description. VARCHAR2(255)
MGKUTIL.F_GETCALENDARRECORDS

FISCAL_PERIOD_SD

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

FISCAL_QUARTER Fiscal quarter. VARCHAR2(63)
MGKUTIL.F_GETCALENDARRECORDS

FISCAL_QUARTER

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

FISCAL_YEAR Fiscal year. VARCHAR2(63)
MGKUTIL.F_GETCALENDARRECORDS

FISCAL_YEAR

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

FISCAL_YEAR_LD Fiscal year short description. VARCHAR2(255)
MGKUTIL.F_GETCALENDARRECORDS

FISCAL_YEAR_LD

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

FISCAL_YEAR_SD Fiscal year long description. VARCHAR2(255)
MGKUTIL.F_GETCALENDARRECORDS

FISCAL_YEAR_SD

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)
SYSTEM_LOAD_PROCESS

'CALENDAR_DATE_D3'

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE
MGKUTIL.F_GETCALENDARRECORDS

SYSTEM_LOAD_TMSTMP

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

USER_ATTRIBUTE_01 VARCHAR2(63)
NO SOURCE

NO SOURCE

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

USER_ATTRIBUTE_01_LD VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

USER_ATTRIBUTE_01_SD VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

USER_ATTRIBUTE_02 VARCHAR2(63)
NO SOURCE

NO SOURCE

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

USER_ATTRIBUTE_02_LD VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

USER_ATTRIBUTE_02_SD VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

USER_ATTRIBUTE_03 VARCHAR2(63)
NO SOURCE

NO SOURCE

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

USER_ATTRIBUTE_03_LD VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

USER_ATTRIBUTE_03_SD VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

USER_ATTRIBUTE_04 VARCHAR2(63)
NO SOURCE

NO SOURCE

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

USER_ATTRIBUTE_04_LD VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

USER_ATTRIBUTE_04_SD VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

USER_ATTRIBUTE_05 VARCHAR2(63)
NO SOURCE

NO SOURCE

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

USER_ATTRIBUTE_05_LD VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

USER_ATTRIBUTE_05_SD VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION

Ver: 9.0

Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
FISCAL_DATE	Fiscal date.	DATE	MGKUTIL.F_GETCALENDARRECORDS	FISCAL_DATE	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
FISCAL_MONTH_DATE	Fiscal month date.	DATE	MGKUTIL.F_GETCALENDARRECORDS	FISCAL_MONTH_DATE	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
FISCAL_PERIOD	Fiscal period.	VARCHAR2(63)	MGKUTIL.F_GETCALENDARRECORDS	FISCAL_PERIOD	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
FISCAL_PERIOD_LD	Fiscal period short description.	VARCHAR2(255)	MGKUTIL.F_GETCALENDARRECORDS	FISCAL_PERIOD_LD	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
FISCAL_PERIOD_SD	Fiscal period long description.	VARCHAR2(255)	MGKUTIL.F_GETCALENDARRECORDS	FISCAL_PERIOD_SD	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
FISCAL_QUARTER	Fiscal quarter.	VARCHAR2(63)	MGKUTIL.F_GETCALENDARRECORDS	FISCAL_QUARTER	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
FISCAL_YEAR	Fiscal year.	VARCHAR2(63)	MGKUTIL.F_GETCALENDARRECORDS	FISCAL_YEAR	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
FISCAL_YEAR_LD	Fiscal year short description.	VARCHAR2(255)	MGKUTIL.F_GETCALENDARRECORDS	FISCAL_YEAR_LD	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
FISCAL_YEAR_SD	Fiscal year long description.	VARCHAR2(255)	MGKUTIL.F_GETCALENDARRECORDS	FISCAL_YEAR_SD	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	SYSTEM_LOAD_PROCESS	'CALENDAR_DATE_D3'	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	MGKUTIL.F_GETCALENDARRECORDS	SYSTEM_LOAD_TMSTMP	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
USER_ATTRIBUTE_01		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
USER_ATTRIBUTE_01_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
USER_ATTRIBUTE_01_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
USER_ATTRIBUTE_02		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
USER_ATTRIBUTE_02_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
USER_ATTRIBUTE_02_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
USER_ATTRIBUTE_03		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
USER_ATTRIBUTE_03_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
USER_ATTRIBUTE_03_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
USER_ATTRIBUTE_04		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
USER_ATTRIBUTE_04_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
USER_ATTRIBUTE_04_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
USER_ATTRIBUTE_05		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
USER_ATTRIBUTE_05_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
USER_ATTRIBUTE_05_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION