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

Ver: