Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
COUNTY	County for this address.	VARCHAR2(63)	NA	NA	NO	NO
COUNTY_DESC	County name for the address.	VARCHAR2(255)	NA	NA	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
EMPLOYEES_SUPERVISED	Number of employees applicant supervised.	NUMBER	PPREXPE	PPREXPE_EMPS_SUPERVISE	NO	NO
EMPLOYER_CATEGORY	Identifies the employer type (for example, Higher Education, Government, Commercial).	VARCHAR2(63)	APREHIS PPREXPE	APREHIS_JOBC_CODE PPREXPE_EMTY_CODE	NO NO	NO
EMPLOYER_CATEGORY2	A code identifying the job category or employer type.	VARCHAR2(63)	APREHIS	APREHIS_JOBC_CODE2	NO	NO
EMPLOYER_CATEGORY2_DESC	Employer category description.	VARCHAR2(255)	ATVJOBC	ATVJOBC_DESC	NO	NO
EMPLOYER_CATEGORY3	A code identifying the job category or employer type.	VARCHAR2(63)	APREHIS	APREHIS_JOBC_CODE3	NO	NO
EMPLOYER_CATEGORY3_DESC	Employer category description.	VARCHAR2(255)	ATVJOBC	ATVJOBC_DESC	NO	NO
EMPLOYER_CATEGORY4	A code identifying the job category or employer type.	VARCHAR2(63)	APREHIS	APREHIS_JOBC_CODE4	NO	NO
EMPLOYER_CATEGORY4_DESC	Employer category description.	VARCHAR2(255)	ATVJOBC	ATVJOBC_DESC	NO	NO
EMPLOYER_CATEGORY_DESC	Employer category description.	VARCHAR2(255)	ATVJOBC	ATVJOBC_DESC	NO	NO
EMPLOYER_COMMENT	Free form text comment for this employer.	CLOB	APREHIS	APREHIS_COMMENT	NO	NO
EMPLOYER_ID	Employer's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
EMPLOYER_INDUSTRIAL_DESC	Standard industry code (sic) description.	VARCHAR2(255)	ATVSICC	ATVSICC_DESC	NO	NO
EMPLOYER_INDUSTRIAL_TYPE	Standard industrial code of the employer.	VARCHAR2(63)	APREHIS	APREHIS_SICC_CODE	NO	NO
EMPLOYER_NAME	Employer's name.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
EMPLOYER_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	APREHIS	APREHIS_EMPR_PIDM	NO	NO
EMPLOYMENT_ORDER	Internal sequence number when available for the order of the positions.	NUMBER	APREHIS	APREHIS_SEQ_NO	NO	NO
EMPLOYMENT_STATUS	Employment status code.	VARCHAR2(63)	APREHIS	APREHIS_EMPS_CODE	NO	NO
EMPLOYMENT_STATUS_ACTIVE_IND	Status active indicator.	VARCHAR2(1)	ATVEMPS	ATVEMPS_ACTIVE_IND	NO	NO
EMPLOYMENT_STATUS_DESC	Employment status code description.	VARCHAR2(255)	ATVEMPS	ATVEMPS_DESC	NO	NO
END_DATE	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
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
ID_SOURCE	Name of the source system that provided the value in the ID_NUMBER field.	VARCHAR2(10)	NA	NA	NO	NO
MONTHS_IN_POSITION	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(PPREXPE_END_DATE,SYSDATE),PPREXPE_START_DATE)	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
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
NATION	Nation/country of previous employer.	VARCHAR2(63)	PPREXPE	PPREXPE_NATN_CODE	NO	NO
NATION_DESC	Description for the nation/country associated with the address.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	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_TITLE	Title of the position occupied while obtain this experience.	VARCHAR2(63)	APREHIS PPREXPE	APREHIS_EMPL_POSITION PPREXPE_POSN_TITLE	NO NO	NO
PRIMARY_EMPLOYMENT_IND	Indicates whether the record is the primary employment record.	VARCHAR2(1)	APREHIS	APREHIS_PRIMARY_IND	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
PROVINCE_STATE	State/Province of previous employer.	VARCHAR2(63)	PPREXPE	PPREXPE_STAT_CODE	NO	NO
PROVINCE_STATE_DESC	Name of the State/Province for this address.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
REASON_LEFT	Reason the employee left that position.	VARCHAR2(63)	PPREXPE	PPREXPE_REASON_LEFT	NO	NO
START_DATE	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_COMBINED_PHONE	Telephone number of the supervisor.	VARCHAR2(63)	NA	NA	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(63)	PPREXPE	PPREXPE_SUPER_NAME	NO	NO
SUPERVISOR_PHONE_AREA	Supervisors area code.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_AREA	NO	NO
SUPERVISOR_PHONE_EXTENSION	Supervisors extension.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_EXT	NO	NO
SUPERVISOR_PHONE_NUMBER	Supervisors phone number.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_NUMBER	NO	NO
WEEKLY_HOURS	Hours per week for parttime employee used for matching gift qualification.	NUMBER	APREHIS	APREHIS_WKLY_HOURS	NO	NO

Ver: 9.2