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