RETURN TO DIMENSION TABLE REPORTS LIST
Employee Star Employee Degree Star Employee Position Star Employment Application Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_ADMINISTRATION

Description Administration Dimension table provides information for the person and their reporting structure within the institution. This information includes employer code, home organization and home chart of accounts. 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
ADMINISTRATION_KEY Key for the administration dimension. NUMBER

ETL GENERATED

NA

NO

NO

EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION

EMPLOYER_CODE Employer identification for the hiring entity at the institution. Sometimes there are multiple employers for example, the university, the foundation, etc. VARCHAR2(63)

EMPLOYEE_POSITION

EMPLOYER_CODE

NO

NO

EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION

EMPLOYER_CODE_LD Long name for the employer. VARCHAR2(255)

EMPLOYEE_POSITION

EMPLOYER_DESC

NO

NO

EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION

EMPLOYER_CODE_SD Short name for the employer. VARCHAR2(255)

EMPLOYEE_POSITION

EMPLOYER_DESC

NO

NO

EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION

HOME_ORGANIZATION Home organization or department for the employee. VARCHAR2(63)

EMPLOYEE

HOME_ORGANIZATION

NO

NO

EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION

HOME_ORGANIZATION_CHART Institutional defined value for the Chart of Accounts. VARCHAR2(63)

EMPLOYEE

HOME_ORGANIZATION_CHART

NO

NO

EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION

HOME_ORGANIZATION_CHART_LD Long name for the chart of accounts VARCHAR2(255)

EMPLOYEE

HOME_ORGANIZATION_CHART_DESC

NO

NO

EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION

HOME_ORGANIZATION_CHART_SD Name of the chart of accounts. VARCHAR2(255)

EMPLOYEE

HOME_ORGANIZATION_CHART_DESC

NO

NO

EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION

HOME_ORGANIZATION_LD Long name of for the home organization code of the employee. VARCHAR2(255)

EMPLOYEE

HOME_ORGANIZATION_DESC

NO

NO

EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION

HOME_ORGANIZATION_SD Short name of for the home organization code of the employee. VARCHAR2(255)

EMPLOYEE

HOME_ORGANIZATION_DESC

NO

NO

EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION

SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

ETL GENERATED

NA

NO

NO

EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION

SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL GENERATED

NA

NO

NO

EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION



Ver: 3.1