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

Ver: 9.1