Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
CATEGORY	Category used to group sponsored programs such as Federal or Non- Federal.	VARCHAR2(63)	GRANT_VIEW	CATEGORY	NO	NO	GRANT AND PROJECT
CATEGORY_LD	Long description for the category code.	VARCHAR2(255)	GRANT_VIEW	CATEGORY	NO	NO	GRANT AND PROJECT
CATEGORY_SD	Short description for the category code.	VARCHAR2(255)	GRANT_VIEW	CATEGORY	NO	NO	GRANT AND PROJECT
GRANT_TYPE	Type that reflects if this is a grant, contract, cooperative agreement, etc.	VARCHAR2(63)	GRANT_VIEW	GRANT_TYPE	NO	NO	GRANT AND PROJECT
GRANT_TYPE_KEY	Key for the grant type dimension.	NUMBER	ETL GENERATED	NA	NO	NO	GRANT AND PROJECT
GRANT_TYPE_LD	Long description of the grant type.	VARCHAR2(255)	GRANT_VIEW	GRANT_TYPE_DESC	NO	NO	GRANT AND PROJECT
GRANT_TYPE_SD	Short description of the grant type.	VARCHAR2(255)	GRANT_VIEW	GRANT_TYPE_DESC	NO	NO	GRANT AND PROJECT
LOCATION	Sponsored research location such as on campus, off campus or both on and off campus.	VARCHAR2(63)	GRANT_VIEW	LOCATION	NO	NO	GRANT AND PROJECT
LOCATION_LD	Long description or title for the location.	VARCHAR2(255)	GRANT_VIEW	LOCATION_DESC	NO	NO	GRANT AND PROJECT
LOCATION_SD	Short description or title for the location.	VARCHAR2(255)	GRANT_VIEW	LOCATION_DESC	NO	NO	GRANT AND PROJECT
ON_CAMPUS_IND	Identifies if the research location is on campus. This is decoded from the ODS ON_OFF_CAMPUS value in the GRANT VIEW. When on campus is indicated, this is set to a'Y' and if not on campus then it is set to'N'.	VARCHAR2(63)	GRANT_VIEW	ON_OFF_CAMPUS	NO	NO	GRANT AND PROJECT
RESEARCH_PURPOSE	Purpose recorded for the grant.	VARCHAR2(63)	GRANT_VIEW	RESEARCH_PURPOSE	NO	NO	GRANT AND PROJECT
RESEARCH_PURPOSE_LD	Long description given as the purpose or reason for the research grant.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	GRANT AND PROJECT
RESEARCH_PURPOSE_SD	Short description given as the purpose or reason for the research grant.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	GRANT AND PROJECT
SUBCATEGORY	Sub-category for the grant classification such as Corporation, Foundation, State, etc.	VARCHAR2(63)	GRANT_VIEW	SUBCATEGORY	NO	NO	GRANT AND PROJECT
SUBCATEGORY_LD	Long hierarchy description or title appropriate for this level.	VARCHAR2(255)	GRANT_VIEW	SUBCATEGORY	NO	NO	GRANT AND PROJECT
SUBCATEGORY_SD	Short hierarchy description or title appropriate for this level.	VARCHAR2(255)	GRANT_VIEW	SUBCATEGORY	NO	NO	GRANT AND PROJECT
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	GRANT AND PROJECT
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	GRANT AND PROJECT

Ver: 9.0