RETURN TO DIMENSION TABLE REPORTS LIST
Grant And Project Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_GRANT_DEMOGRAPHIC

Description Grant Demographic Dimension table provides specific to the internal and external responsibility for management of the grant. This information includes the responsible internal organization and external agency and subagency as well as the principal investigator name. 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
AGENCY_NAME Name of the agency sponsoring the grant whose unique identifier is stored on the GRANT VIEW. VARCHAR2(255)

ORGANIZATION_ENTITY

NAME

NO

NO

GRANT AND PROJECT

GRANT_DEMOGRAPHIC_KEY Key for the grant demographic dimension. NUMBER

ETL GENERATED

NA

NO

NO

GRANT AND PROJECT

PRINCIPAL_INVESTIGATOR_NAME Name of the principal investigator for this grant whose unique identifier is stored on the GRANT VIEW. VARCHAR2(255)

GRANT_VIEW

PRINCIPAL_INVESTIGATOR_UID

NO

NO

GRANT AND PROJECT

RESPONSIBLE_ORGANIZATION Institution organization responsible for the administrative of this grant. VARCHAR2(63)

GRANT_VIEW

ORGANIZATION_CODE

NO

NO

GRANT AND PROJECT

RESPONSIBLE_ORGANIZATION_LD Long name of title of the organization entity. VARCHAR2(255)

GRANT_VIEW

ORGANIZATION_DESC

NO

NO

GRANT AND PROJECT

RESPONSIBLE_ORGANIZATION_SD Short name of title of the organization entity. VARCHAR2(255)

GRANT_VIEW

ORGANIZATION_DESC

NO

NO

GRANT AND PROJECT

SUBAGENCY_NAME Name of the sub-agency sponsoring the grant whose unique identifier is stored on the GRANT VIEW. VARCHAR2(255)

ORGANIZATION_ENTITY

NAME

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