RETURN TO BANNER EDW META DATA 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 Identifies the administrator role assigned to the administrator to group them into raters, recruiters, advisors, etc. 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 Long description for the administrator role. VARCHAR2(255)

ADMISSIONS_RATING

ADMINISTRATOR_ROLE_DESC

NO

NO ADMINISTRATOR, APPLICATION RATING
ADMINISTRATOR_ROLE_SD Short description for the administrator role. VARCHAR2(255)

ADMISSIONS_RATING

ADMINISTRATOR_ROLE_DESC

NO

NO ADMINISTRATOR, APPLICATION RATING
RATER_IND Idicates this administrator is a rater because the associated administrator role was identified with the role 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: 9.0