Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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(11, 2)		PPREXPE	PPREXPE_CURR_HOURLY
CURRENT_SALARY		Current salary at this position.	NUMBER(11, 2)		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(4)		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(8)		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	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	Supervisor Phone Area	Supervisors area code.	VARCHAR2(6)		PPREXPE	PPREXPE_SUPER_PHONE_AREA
SUPERVISOR_PHONE_EXTENSION	Supervisor Phone Extension	Supervisors extension.	VARCHAR2(10)		PPREXPE	PPREXPE_SUPER_PHONE_EXT
SUPERVISOR_PHONE_NUMBER	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: