Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
APPOINTMENT_PERCENTAGE	Percent of the budget assigned to this position.	NUMBER	POSITION_DEFINITION	POSITION_APPOINTMENT_PCT	NO	NO	EMPLOYEE POSITION, EMPLOYMENT APPLICATION
POSITION	Position for an employment requisition or an employment assigned by the institution Human Resource department.	VARCHAR2(63)	POSITION_DEFINITION	POSITION	NO	NO	EMPLOYMENT APPLICATION
POSITION_CAMPUS	Campus code that identifies the location for the employment.	VARCHAR2(63)	POSITION_DEFINITION	POSITION_LOCATION	NO	NO	EMPLOYMENT APPLICATION
POSITION_CAMPUS_LD	Long name of the campus.	VARCHAR2(255)	POSITION_DEFINITION	POSITION_LOCATION	NO	NO	EMPLOYMENT APPLICATION
POSITION_CAMPUS_SD	Short name of the campus.	VARCHAR2(255)	POSITION_DEFINITION	POSITION_LOCATION	NO	NO	EMPLOYMENT APPLICATION
POSITION_CLASS	Position class associated with this position.	VARCHAR2(63)	POSITION_DEFINITION	POSITION_CLASS	NO	NO	EMPLOYEE POSITION, EMPLOYMENT APPLICATION
POSITION_CLASS_LD	Long description for the position class.	VARCHAR2(255)	POSITION_DEFINITION	POSITION_CLASS_DESC	NO	NO	EMPLOYEE POSITION, EMPLOYMENT APPLICATION
POSITION_CLASS_SD	Short description for the position class.	VARCHAR2(255)	POSITION_DEFINITION	POSITION_CLASS_DESC	NO	NO	EMPLOYEE POSITION, EMPLOYMENT APPLICATION
POSITION_CONTRACT_TYPE	Indicates whether this is the primary, secondary, or overload type of employment.	VARCHAR2(63)	EMPLOYEE_POSITION	POSITION_CONTRACT_TYPE	NO	NO	EMPLOYEE POSITION, EMPLOYMENT APPLICATION
POSITION_CONTRACT_TYPE_LD	Long description of the contract type.	VARCHAR2(255)	EMPLOYEE_POSITION	POSITION_CONTRACT_TYPE	NO	NO	EMPLOYEE POSITION, EMPLOYMENT APPLICATION
POSITION_CONTRACT_TYPE_SD	Short description of the contract type.	VARCHAR2(255)	EMPLOYEE_POSITION	POSITION_CONTRACT_TYPE	NO	NO	EMPLOYEE POSITION, EMPLOYMENT APPLICATION
POSITION_EEO_SKILL	Codes for reporting as defined by the federal government that identifies the skill group for the position.	VARCHAR2(63)	POSITION_DEFINITION	EEO_SKILL	NO	NO	EMPLOYEE POSITION, EMPLOYMENT APPLICATION
POSITION_EEO_SKILL_LD	Long description of the EEO skill.	VARCHAR2(255)	POSITION_DEFINITION	EEO_SKILL_DESC	NO	NO	EMPLOYEE POSITION, EMPLOYMENT APPLICATION
POSITION_EEO_SKILL_SD	Short description of the EEO skill.	VARCHAR2(255)	POSITION_DEFINITION	EEO_SKILL_DESC	NO	NO	EMPLOYEE POSITION, EMPLOYMENT APPLICATION
POSITION_KEY	Key for the position dimension.	NUMBER	ETL GENERATED	NA	NO	NO	EMPLOYEE POSITION, EMPLOYMENT APPLICATION
POSITION_LD	Long description for the position.	VARCHAR2(255)	POSITION_DEFINITION	POSITION_TITLE	NO	NO	EMPLOYMENT APPLICATION
POSITION_SD	Short description for the position.	VARCHAR2(255)	POSITION_DEFINITION	POSITION_TITLE	NO	NO	EMPLOYMENT APPLICATION
POSITION_STATUS	Status of the position.	VARCHAR2(63)	POSITION_DEFINITION	POSITION_STATUS	NO	NO	EMPLOYMENT APPLICATION
POSITION_STATUS_LD	Long description of the status for the position.	VARCHAR2(255)	POSITION_DEFINITION	POSITION_STATUS_DESC	NO	NO	EMPLOYMENT APPLICATION
POSITION_STATUS_SD	Short description of the status for the position.	VARCHAR2(255)	POSITION_DEFINITION	POSITION_STATUS_DESC	NO	NO	EMPLOYMENT APPLICATION
PROGRAM_CLASSIFICATION	Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting.	VARCHAR2(63)	NA	NA	NO	NO	EMPLOYMENT APPLICATION
PROGRAM_CLASSIFICATION_LD	Long text describing the area of study. For example description associated with the CIP codes used in Integrated Postsecondary Education Data System (IPEDS) reporting in the US.	VARCHAR2(255)	NA	NA	NO	NO	EMPLOYMENT APPLICATION
PROGRAM_CLASSIFICATION_SD	Short text describing the area of study. For example description associated with the CIP codes used in Integrated Postsecondary Education Data System (IPEDS) reporting in the US.	VARCHAR2(255)	NA	NA	NO	NO	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 POSITION, EMPLOYMENT APPLICATION
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	EMPLOYEE POSITION, EMPLOYMENT APPLICATION

Ver: 9.0