Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
COUNTY	County for this address.	VARCHAR2(0)	NA	NA	NO	NO
COUNTY_DESC	County name for the address.	VARCHAR2(0)	NA	NA	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
CURRENT_HOURLY_RATE	Current hourly rate at this position.	NUMBER	PPREXPE	PPREXPE_CURR_HOURLY	NO	NO
CURRENT_SALARY	Current salary at this position.	NUMBER	PPREXPE	PPREXPE_CURR_SALARY	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
EMPLOYEES_SUPERVISED	Number of employees applicant supervised.	NUMBER	PPREXPE	PPREXPE_EMPS_SUPERVISE	NO	NO
EMPLOYER_NAME	Name of the previous or current employer at which this experience was obtained.	VARCHAR2(30)	PPREXPE	PPREXPE_SUPER_NAME	NO	NO
EMPLOYER_TYPE	A code identifying the employer type (for example, Higher Education, Government, Commercial).	VARCHAR2(2)	PPREXPE	PPREXPE_EMTY_CODE	NO	NO
EMPLOYER_TYPE_DESC	Employer type description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
END_DATE	End date for the period of time during which this experience was obtained.	DATE	PPREXPE	PPREXPE_END_DATE	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
NATION	Nation/country of previous employer.	VARCHAR2(5)	PPREXPE	PPREXPE_NATN_CODE	NO	NO
NATION_DESC	Address nation/country description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	PPREXPE	PPREXPE_PIDM	NO	NO
POSITION_TITLE	Title of the position occupied while obtaining this experience.	VARCHAR2(30)	PPREXPE	PPREXPE_POSN_TITLE	NO	NO
REASON_LEFT	Reason the employee left that position.	VARCHAR2(60)	PPREXPE	PPREXPE_REASON_LEFT	NO	NO
START_DATE	Starting date of the period of time during which this experience was obtained.	DATE	PPREXPE	PPREXPE_START_DATE	NO	NO
STATE	State/Province of previous employer.	VARCHAR2(3)	PPREXPE	PPREXPE_STAT_CODE	NO	NO
STATE_DESC	State/province name.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SUPERVISOR_COMBINED_PHONE	Combination of phone area, number and extension.	VARCHAR2(28)	CALCULATION	PPREXPE_SUPER_PHONE_AREA||PPREXPE_SUPER_PHONE_NUMBER||PPREXPE_SUPER_PHONE_EXT	NO	NO
SUPERVISOR_COMMENT	Any comments the supervisor may have given.	VARCHAR2(4000)	PPREXPE	PPREXPE_SUPER_COMMENT	NO	NO
SUPERVISOR_CONTACT_IND	Indicates if this supervisor may be contacted.	VARCHAR2(1)	PPREXPE	PPREXPE_CONTACT_IND	NO	NO
SUPERVISOR_NAME	Name of the previous or current employer at which this experience was obtained.	VARCHAR2(60)	PPREXPE	PPREXPE_SUPER_NAME	NO	NO
SUPERVISOR_PHONE_AREA	Supervisors area code.	VARCHAR2(6)	PPREXPE	PPREXPE_SUPER_PHONE_AREA	NO	NO
SUPERVISOR_PHONE_EXTENSION	Supervisors extension.	VARCHAR2(10)	PPREXPE	PPREXPE_SUPER_PHONE_EXT	NO	NO
SUPERVISOR_PHONE_NUMBER	Supervisors phone number.	VARCHAR2(12)	PPREXPE	PPREXPE_SUPER_PHONE_NUMBER	NO	NO
YEARS_MONTHS_IN_POSITION	Number of years / months this employee has been in the position.	NUMBER	CALCULATION	MONTHS_BETWEEN	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: