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

Ver: 8.3