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

Ver: 9.0