Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ALUMNUS_IND	System determined by the existence of ACADEMIC_OUTCOME reporting view with a GRADUATED_IND equal to YES and it will set this indicator to'Y', applicant is an alumnus of this institution.	VARCHAR2(63)	CONSTITUENT	FUNCTION	NO	NO	EMPLOYMENT APPLICATION
CURRENT_EMPLOYEE_IND	System determined by the existence of an EMPLOYEE reporting view with a POSITION_BEGIN_DATE and POSITION_END_DATE that includes the date of the extract.	VARCHAR2(63)	EMPLOYEE	FUNCTION	NO	NO	EMPLOYMENT APPLICATION
HR_APPLICANT_KEY	Key for the HR applicant dimension.	NUMBER	ETL GENERATED	NA	NO	NO	EMPLOYMENT APPLICATION
SOURCE	Source where the applicant learned about the position such as newspaper ad, friend, job board, internet, etc.	VARCHAR2(63)	HR_APPLICATION	SOURCE	NO	NO	EMPLOYMENT APPLICATION
SOURCE_LD	Long name of the source that the applicant learned of the position.	VARCHAR2(255)	HR_APPLICATION	SOURCE_DESC	NO	NO	EMPLOYMENT APPLICATION
SOURCE_SD	Short name of the source that the applicant learned of the position.	VARCHAR2(255)	HR_APPLICATION	SOURCE_DESC	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	EMPLOYMENT APPLICATION
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	EMPLOYMENT APPLICATION

Ver: 9.0