RETURN TO DIMENSION TABLE REPORTS LIST
Administrator Star  Application Rating Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_ADMINISTRATOR_ROLE

Description Administrator role dimension provides data for person who have been identified with an administrator role. The administrator role may be to rate an applicant for admissions or assigned as a recruiter for a prospective student.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ADMINISTRATOR_ROLE Role for the administrator who assigned this rating. VARCHAR2(63)

ADMISSIONS_RATING

ADMINISTRATOR_ROLE

NO

NO ADMINISTRATOR, APPLICATION RATING
ADMINISTRATOR_ROLE_KEY Key for the administrator role dimension. NUMBER

ETL GENERATED

NA

NO

NO ADMINISTRATOR, APPLICATION RATING
ADMINISTRATOR_ROLE_LD Administrator's role description. VARCHAR2(255)

ADMISSIONS_RATING

ADMINISTRATOR_ROLE_DESC

NO

NO ADMINISTRATOR, APPLICATION RATING
ADMINISTRATOR_ROLE_SD Administrator's role description. VARCHAR2(255)

ADMISSIONS_RATING

ADMINISTRATOR_ROLE_DESC

NO

NO ADMINISTRATOR, APPLICATION RATING
RATER_IND Identifies this administrator role is one of a rater. VARCHAR2(63)

ETL GENERATED

NA

NO

NO ADMINISTRATOR, APPLICATION RATING
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

ETL GENERATED

NA

NO

NO ADMINISTRATOR, APPLICATION RATING
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL GENERATED

NA

NO

NO ADMINISTRATOR, APPLICATION RATING


Ver: 8.1