RETURN TO DIMENSION TABLE REPORTS LIST
Grant And Project Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_GRANT_TYPE

Description Grant Type Dimension table provides specific details for the purpose of the grant. This information includes the grant type, location, category and subcatergory research purposes. It uses the cleansing rules in the EDW for the short and long descriptions.

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_TITLE

NO

NO

GRANT AND PROJECT

LOCATION_SD Short description or title for the location. VARCHAR2(255)

GRANT_VIEW

LOCATION_TITLE

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: 3.1