Dimension Table Target: WDT

	RETURN TO BANNER EDW META DATA 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

CAMPUS Campus associated with the employee (staff, employee, student employee, etc.). VARCHAR2(63)
EMPLOYEE

CAMPUS

NO
NO EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION

CAMPUS_LD Long description of the campus associated with the employee. VARCHAR2(255)
EMPLOYEE

CAMPUS_DESC

NO
NO EMPLOYEE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION

CAMPUS_SD Description of the campus associated with the employee. VARCHAR2(255)
EMPLOYEE

CAMPUS_DESC

NO
NO EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION

COLLEGE College associated with the employee (staff, faculty, student employee, etc.). VARCHAR2(63)
EMPLOYEE

COLLEGE

NO
NO EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION

COLLEGE_LD Long description of the college associated with the employee. VARCHAR2(255)
EMPLOYEE

COLLEGE_DESC

NO
NO EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION

COLLEGE_SD Description of the college associated with the employee. VARCHAR2(255)
EMPLOYEE

COLLEGE_DESC

NO
NO EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION

DIVISION Division associated with the employee (staff, faculty, student employee, etc.). VARCHAR2(63)
EMPLOYEE

DIVISION

NO
NO EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION

DIVISION_LD Long description of the division or district associated with the employee. VARCHAR2(255)
EMPLOYEE

DIVISION_DESC

NO
NO EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION

DIVISION_SD Description of the division or district associated with the employee. VARCHAR2(255)
EMPLOYEE

DIVISION_DESC

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

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
CAMPUS	Campus associated with the employee (staff, employee, student employee, etc.).	VARCHAR2(63)	EMPLOYEE	CAMPUS	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION
CAMPUS_LD	Long description of the campus associated with the employee.	VARCHAR2(255)	EMPLOYEE	CAMPUS_DESC	NO	NO	EMPLOYEE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION
CAMPUS_SD	Description of the campus associated with the employee.	VARCHAR2(255)	EMPLOYEE	CAMPUS_DESC	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION
COLLEGE	College associated with the employee (staff, faculty, student employee, etc.).	VARCHAR2(63)	EMPLOYEE	COLLEGE	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION
COLLEGE_LD	Long description of the college associated with the employee.	VARCHAR2(255)	EMPLOYEE	COLLEGE_DESC	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION
COLLEGE_SD	Description of the college associated with the employee.	VARCHAR2(255)	EMPLOYEE	COLLEGE_DESC	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION
DIVISION	Division associated with the employee (staff, faculty, student employee, etc.).	VARCHAR2(63)	EMPLOYEE	DIVISION	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION
DIVISION_LD	Long description of the division or district associated with the employee.	VARCHAR2(255)	EMPLOYEE	DIVISION_DESC	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION
DIVISION_SD	Description of the division or district associated with the employee.	VARCHAR2(255)	EMPLOYEE	DIVISION_DESC	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