Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVITY_DATE	Date record was inserted or updated.	DATE	NA	SYSDATE	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
CURRENT_HOURLY_RATE1	Current hourly rate at this position.	NUMBER	PPREXPE	PPREXPE_CURR_HOURLY	NO	NO
CURRENT_HOURLY_RATE2	Current hourly rate at this position.	NUMBER	PPREXPE	PPREXPE_CURR_HOURLY	NO	NO
CURRENT_HOURLY_RATE3	Current hourly rate at this position.	NUMBER	PPREXPE	PPREXPE_CURR_HOURLY	NO	NO
CURRENT_HOURLY_RATE4	Current hourly rate at this position.	NUMBER	PPREXPE	PPREXPE_CURR_HOURLY	NO	NO
CURRENT_SALARY1	Current salary at this position.	NUMBER	PPREXPE	PPREXPE_CURR_SALARY	NO	NO
CURRENT_SALARY2	Current salary at this position.	NUMBER	PPREXPE	PPREXPE_CURR_SALARY	NO	NO
CURRENT_SALARY3	Current salary at this position.	NUMBER	PPREXPE	PPREXPE_CURR_SALARY	NO	NO
CURRENT_SALARY4	Current salary at this position.	NUMBER	PPREXPE	PPREXPE_CURR_SALARY	NO	NO
EMPLOYEES_SUPERVISED1	Number of employees applicant supervised.	NUMBER	PPREXPE	PPREXPE_EMPS_SUPERVISE	NO	NO
EMPLOYEES_SUPERVISED2	Number of employees applicant supervised.	NUMBER	PPREXPE	PPREXPE_EMPS_SUPERVISE	NO	NO
EMPLOYEES_SUPERVISED3	Number of employees applicant supervised.	NUMBER	PPREXPE	PPREXPE_EMPS_SUPERVISE	NO	NO
EMPLOYEES_SUPERVISED4	Number of employees applicant supervised.	NUMBER	PPREXPE	PPREXPE_EMPS_SUPERVISE	NO	NO
EMPLOYER_NAME1	Employer's name.	VARCHAR2(63)	PPREXPE SPRIDEN	PPREXPE_EMPR_NAME SPRIDEN_LAST_NAME	NO NO	NO
EMPLOYER_NAME2	Employer's name.	VARCHAR2(63)	PPREXPE SPRIDEN	PPREXPE_EMPR_NAME SPRIDEN_LAST_NAME	NO NO	NO
EMPLOYER_NAME3	Employer's name.	VARCHAR2(63)	PPREXPE SPRIDEN	PPREXPE_EMPR_NAME SPRIDEN_LAST_NAME	NO NO	NO
EMPLOYER_NAME4	Employer's name.	VARCHAR2(63)	PPREXPE SPRIDEN	PPREXPE_EMPR_NAME SPRIDEN_LAST_NAME	NO NO	NO
EMPLOYER_TYPE1	Standard industrial code of the employer.	VARCHAR2(63)	APREHIS	APREHIS_SICC_CODE	NO	NO
EMPLOYER_TYPE2	Standard industrial code of the employer.	VARCHAR2(63)	APREHIS	APREHIS_SICC_CODE	NO	NO
EMPLOYER_TYPE3	Standard industrial code of the employer.	VARCHAR2(63)	APREHIS	APREHIS_SICC_CODE	NO	NO
EMPLOYER_TYPE4	Standard industrial code of the employer.	VARCHAR2(63)	APREHIS	APREHIS_SICC_CODE	NO	NO
EMPLOYER_TYPE_DESC1	Standard industry code (sic) description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
EMPLOYER_TYPE_DESC2	Standard industry code (sic) description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
EMPLOYER_TYPE_DESC3	Standard industry code (sic) description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
EMPLOYER_TYPE_DESC4	Standard industry code (sic) description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
END_DATE1	End date for the period of time during which this experience was obtained.	DATE	APREHIS PPREXPE	APREHIS_FROM_DATE PPREXPE_END_DATE	NO NO	NO
END_DATE2	End date for the period of time during which this experience was obtained.	DATE	APREHIS PPREXPE	APREHIS_FROM_DATE PPREXPE_END_DATE	NO NO	NO
END_DATE3	End date for the period of time during which this experience was obtained.	DATE	APREHIS PPREXPE	APREHIS_FROM_DATE PPREXPE_END_DATE	NO NO	NO
END_DATE4	End date for the period of time during which this experience was obtained.	DATE	APREHIS PPREXPE	APREHIS_FROM_DATE PPREXPE_END_DATE	NO NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	APREHIS PPREXPE	APREHIS_PIDM PPREXPE_PIDM	NO NO	NO
POSITION_TITLE1	Title of the position occupied while obtain this experience.	VARCHAR2(63)	APREHIS PPREXPE	APREHIS_EMPL_POSITION PPREXPE_POSN_TITLE	NO NO	NO
POSITION_TITLE2	Title of the position occupied while obtain this experience.	VARCHAR2(63)	APREHIS PPREXPE	APREHIS_EMPL_POSITION PPREXPE_POSN_TITLE	NO NO	NO
POSITION_TITLE3	Title of the position occupied while obtain this experience.	VARCHAR2(63)	APREHIS PPREXPE	APREHIS_EMPL_POSITION PPREXPE_POSN_TITLE	NO NO	NO
POSITION_TITLE4	Title of the position occupied while obtain this experience.	VARCHAR2(63)	APREHIS PPREXPE	APREHIS_EMPL_POSITION PPREXPE_POSN_TITLE	NO NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
REASON_LEFT1	Reason the employee left that position.	VARCHAR2(63)	PPREXPE	PPREXPE_REASON_LEFT	NO	NO
REASON_LEFT2	Reason the employee left that position.	VARCHAR2(63)	PPREXPE	PPREXPE_REASON_LEFT	NO	NO
REASON_LEFT3	Reason the employee left that position.	VARCHAR2(63)	PPREXPE	PPREXPE_REASON_LEFT	NO	NO
REASON_LEFT4	Reason the employee left that position.	VARCHAR2(63)	PPREXPE	PPREXPE_REASON_LEFT	NO	NO
START_DATE1	Starting date of the period of time during which this experience was obtained.	DATE	APREHIS PPREXPE	APREHIS_TO_DATE PPREXPE_START_DATE	NO NO	NO
START_DATE2	Starting date of the period of time during which this experience was obtained.	DATE	APREHIS PPREXPE	APREHIS_TO_DATE PPREXPE_START_DATE	NO NO	NO
START_DATE3	Starting date of the period of time during which this experience was obtained.	DATE	APREHIS PPREXPE	APREHIS_TO_DATE PPREXPE_START_DATE	NO NO	NO
START_DATE4	Starting date of the period of time during which this experience was obtained.	DATE	APREHIS PPREXPE	APREHIS_TO_DATE PPREXPE_START_DATE	NO NO	NO
SUPERVISOR_CONTACT_IND1	Indicates if this supervisor may be contacted.	VARCHAR2(1)	PPREXPE	PPREXPE_CONTACT_IND	NO	NO
SUPERVISOR_CONTACT_IND2	Indicates if this supervisor may be contacted.	VARCHAR2(1)	PPREXPE	PPREXPE_CONTACT_IND	NO	NO
SUPERVISOR_CONTACT_IND3	Indicates if this supervisor may be contacted.	VARCHAR2(1)	PPREXPE	PPREXPE_CONTACT_IND	NO	NO
SUPERVISOR_CONTACT_IND4	Indicates if this supervisor may be contacted.	VARCHAR2(1)	PPREXPE	PPREXPE_CONTACT_IND	NO	NO
SUPERVISOR_NAME1	Name of the previous or current employer at which this experience was obtained.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_NAME	NO	NO
SUPERVISOR_NAME2	Name of the previous or current employer at which this experience was obtained.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_NAME	NO	NO
SUPERVISOR_NAME3	Name of the previous or current employer at which this experience was obtained.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_NAME	NO	NO
SUPERVISOR_NAME4	Name of the previous or current employer at which this experience was obtained.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_NAME	NO	NO
SUPERVISOR_PHONE_AREA1	Supervisors area code.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_AREA	NO	NO
SUPERVISOR_PHONE_AREA2	Supervisors area code.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_AREA	NO	NO
SUPERVISOR_PHONE_AREA3	Supervisors area code.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_AREA	NO	NO
SUPERVISOR_PHONE_AREA4	Supervisors area code.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_AREA	NO	NO
SUPERVISOR_PHONE_EXTENSION1	Supervisors extension.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_EXT	NO	NO
SUPERVISOR_PHONE_EXTENSION2	Supervisors extension.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_EXT	NO	NO
SUPERVISOR_PHONE_EXTENSION3	Supervisors extension.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_EXT	NO	NO
SUPERVISOR_PHONE_EXTENSION4	Supervisors extension.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_EXT	NO	NO
SUPERVISOR_PHONE_NUMBER1	Supervisors phone number.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_NUMBER	NO	NO
SUPERVISOR_PHONE_NUMBER2	Supervisors phone number.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_NUMBER	NO	NO
SUPERVISOR_PHONE_NUMBER3	Supervisors phone number.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_NUMBER	NO	NO
SUPERVISOR_PHONE_NUMBER4	Supervisors phone number.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_NUMBER	NO	NO
YEARS_MONTHS_IN_POSITION1	Years and months the person was in this previous employment position. Calculated by using the position start and end dates.	NUMBER	CALCULATION	MONTHS_BETWEEN(NVL(APREHIS_TO_DATE,SYSDATE),APREHIS_FROM_DATE)	NO	NO
YEARS_MONTHS_IN_POSITION2	Years and months the person was in this previous employment position. Calculated by using the position start and end dates.	NUMBER	CALCULATION	MONTHS_BETWEEN(NVL(APREHIS_TO_DATE,SYSDATE),APREHIS_FROM_DATE)	NO	NO
YEARS_MONTHS_IN_POSITION3	Years and months the person was in this previous employment position. Calculated by using the position start and end dates.	NUMBER	CALCULATION	MONTHS_BETWEEN(NVL(APREHIS_TO_DATE,SYSDATE),APREHIS_FROM_DATE)	NO	NO
YEARS_MONTHS_IN_POSITION4	Years and months the person was in this previous employment position. Calculated by using the position start and end dates.	NUMBER	CALCULATION	MONTHS_BETWEEN(NVL(APREHIS_TO_DATE,SYSDATE),APREHIS_FROM_DATE)	NO	NO

Ver: 9.2