ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ACTIVITY_DATE	Date record was inserted or updated			NA	SYSDATE
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
CURRENT_HOURLY_RATE1	Current hourly rate at this position.			PPREXPE	PPREXPE_CURR_HOURLY
CURRENT_HOURLY_RATE2	Current hourly rate at this position.			PPREXPE	PPREXPE_CURR_HOURLY
CURRENT_HOURLY_RATE3	Current hourly rate at this position.			PPREXPE	PPREXPE_CURR_HOURLY
CURRENT_HOURLY_RATE4	Current hourly rate at this position.			PPREXPE	PPREXPE_CURR_HOURLY
CURRENT_SALARY1	Current salary at this position.			PPREXPE	PPREXPE_CURR_SALARY
CURRENT_SALARY2	Current salary at this position.			PPREXPE	PPREXPE_CURR_SALARY
CURRENT_SALARY3	Current salary at this position.			PPREXPE	PPREXPE_CURR_SALARY
CURRENT_SALARY4	Current salary at this position.			PPREXPE	PPREXPE_CURR_SALARY
EMPLOYEES_SUPERVISED1	Number of employees applicant supervised.			PPREXPE	PPREXPE_EMPS_SUPERVISE
EMPLOYEES_SUPERVISED2	Number of employees applicant supervised.			PPREXPE	PPREXPE_EMPS_SUPERVISE
EMPLOYEES_SUPERVISED3	Number of employees applicant supervised.			PPREXPE	PPREXPE_EMPS_SUPERVISE
EMPLOYEES_SUPERVISED4	Number of employees applicant supervised.			PPREXPE	PPREXPE_EMPS_SUPERVISE
EMPLOYER_NAME1	Employer's name.			PPREXPE SPRIDEN	PPREXPE_EMPR_NAME SPRIDEN_LAST_NAME
EMPLOYER_NAME2	Employer's name.			PPREXPE SPRIDEN	PPREXPE_EMPR_NAME SPRIDEN_LAST_NAME
EMPLOYER_NAME3	Employer's name.			PPREXPE SPRIDEN	PPREXPE_EMPR_NAME SPRIDEN_LAST_NAME
EMPLOYER_NAME4	Employer's name.			PPREXPE SPRIDEN	PPREXPE_EMPR_NAME SPRIDEN_LAST_NAME
EMPLOYER_TYPE1	Standard industrial code of the employer.			APREHIS	APREHIS_SICC_CODE
EMPLOYER_TYPE2	Standard industrial code of the employer.			APREHIS	APREHIS_SICC_CODE
EMPLOYER_TYPE3	Standard industrial code of the employer.			APREHIS	APREHIS_SICC_CODE
EMPLOYER_TYPE4	Standard industrial code of the employer.			APREHIS	APREHIS_SICC_CODE
EMPLOYER_TYPE_DESC1	Standard industry code (sic) description.			FUNCTION	GOKODSF.F_GET_DESC
EMPLOYER_TYPE_DESC2	Standard industry code (sic) description.			FUNCTION	GOKODSF.F_GET_DESC
EMPLOYER_TYPE_DESC3	Standard industry code (sic) description.			FUNCTION	GOKODSF.F_GET_DESC
EMPLOYER_TYPE_DESC4	Standard industry code (sic) description.			FUNCTION	GOKODSF.F_GET_DESC
END_DATE1	End date for the period of time during which this experience was obtained.			APREHIS PPREXPE	APREHIS_FROM_DATE PPREXPE_END_DATE
END_DATE2	End date for the period of time during which this experience was obtained.			APREHIS PPREXPE	APREHIS_FROM_DATE PPREXPE_END_DATE
END_DATE3	End date for the period of time during which this experience was obtained.			APREHIS PPREXPE	APREHIS_FROM_DATE PPREXPE_END_DATE
END_DATE4	End date for the period of time during which this experience was obtained.			APREHIS PPREXPE	APREHIS_FROM_DATE PPREXPE_END_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
PERSON_UID	System generated, unique, internal identification number assigned to this person.			APREHIS PPREXPE	APREHIS_PIDM PPREXPE_PIDM
POSITION_TITLE1	Title of the position occupied while obtain this experience.			APREHIS PPREXPE	APREHIS_EMPL_POSITION PPREXPE_POSN_TITLE
POSITION_TITLE2	Title of the position occupied while obtain this experience.			APREHIS PPREXPE	APREHIS_EMPL_POSITION PPREXPE_POSN_TITLE
POSITION_TITLE3	Title of the position occupied while obtain this experience.			APREHIS PPREXPE	APREHIS_EMPL_POSITION PPREXPE_POSN_TITLE
POSITION_TITLE4	Title of the position occupied while obtain this experience.			APREHIS PPREXPE	APREHIS_EMPL_POSITION PPREXPE_POSN_TITLE
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
REASON_LEFT1	Reason the employee left that position.			PPREXPE	PPREXPE_REASON_LEFT
REASON_LEFT2	Reason the employee left that position.			PPREXPE	PPREXPE_REASON_LEFT
REASON_LEFT3	Reason the employee left that position.			PPREXPE	PPREXPE_REASON_LEFT
REASON_LEFT4	Reason the employee left that position.			PPREXPE	PPREXPE_REASON_LEFT
START_DATE1	Starting date of the period of time during which this experience was obtained.			APREHIS PPREXPE	APREHIS_TO_DATE PPREXPE_START_DATE
START_DATE2	Starting date of the period of time during which this experience was obtained.			APREHIS PPREXPE	APREHIS_TO_DATE PPREXPE_START_DATE
START_DATE3	Starting date of the period of time during which this experience was obtained.			APREHIS PPREXPE	APREHIS_TO_DATE PPREXPE_START_DATE
START_DATE4	Starting date of the period of time during which this experience was obtained.			APREHIS PPREXPE	APREHIS_TO_DATE PPREXPE_START_DATE
SUPERVISOR_CONTACT_IND1	Indicates if this supervisor may be contacted.			PPREXPE	PPREXPE_CONTACT_IND
SUPERVISOR_CONTACT_IND2	Indicates if this supervisor may be contacted.			PPREXPE	PPREXPE_CONTACT_IND
SUPERVISOR_CONTACT_IND3	Indicates if this supervisor may be contacted.			PPREXPE	PPREXPE_CONTACT_IND
SUPERVISOR_CONTACT_IND4	Indicates if this supervisor may be contacted.			PPREXPE	PPREXPE_CONTACT_IND
SUPERVISOR_NAME1	Name of the previous or current employer at which this experience was obtained.			PPREXPE	PPREXPE_SUPER_NAME
SUPERVISOR_NAME2	Name of the previous or current employer at which this experience was obtained.			PPREXPE	PPREXPE_SUPER_NAME
SUPERVISOR_NAME3	Name of the previous or current employer at which this experience was obtained.			PPREXPE	PPREXPE_SUPER_NAME
SUPERVISOR_NAME4	Name of the previous or current employer at which this experience was obtained.			PPREXPE	PPREXPE_SUPER_NAME
SUPERVISOR_PHONE_AREA1	Supervisors area code.			PPREXPE	PPREXPE_SUPER_PHONE_AREA
SUPERVISOR_PHONE_AREA2	Supervisors area code.			PPREXPE	PPREXPE_SUPER_PHONE_AREA
SUPERVISOR_PHONE_AREA3	Supervisors area code.			PPREXPE	PPREXPE_SUPER_PHONE_AREA
SUPERVISOR_PHONE_AREA4	Supervisors area code.			PPREXPE	PPREXPE_SUPER_PHONE_AREA
SUPERVISOR_PHONE_EXTENSION1	Supervisors extension.			PPREXPE	PPREXPE_SUPER_PHONE_EXT
SUPERVISOR_PHONE_EXTENSION2	Supervisors extension.			PPREXPE	PPREXPE_SUPER_PHONE_EXT
SUPERVISOR_PHONE_EXTENSION3	Supervisors extension.			PPREXPE	PPREXPE_SUPER_PHONE_EXT
SUPERVISOR_PHONE_EXTENSION4	Supervisors extension.			PPREXPE	PPREXPE_SUPER_PHONE_EXT
SUPERVISOR_PHONE_NUMBER1	Supervisors phone number.			PPREXPE	PPREXPE_SUPER_PHONE_NUMBER
SUPERVISOR_PHONE_NUMBER2	Supervisors phone number.			PPREXPE	PPREXPE_SUPER_PHONE_NUMBER
SUPERVISOR_PHONE_NUMBER3	Supervisors phone number.			PPREXPE	PPREXPE_SUPER_PHONE_NUMBER
SUPERVISOR_PHONE_NUMBER4	Supervisors phone number.			PPREXPE	PPREXPE_SUPER_PHONE_NUMBER
YEARS_MONTHS_IN_POSITION1	Years and months the person was in this previous employment position. Calculated by using the position start and end dates.			CALCULATION	MONTHS_BETWEEN(NVL(APREHIS_TO_DATE,SYSDATE),APREHIS_FROM_DATE)
YEARS_MONTHS_IN_POSITION2	Years and months the person was in this previous employment position. Calculated by using the position start and end dates.			CALCULATION	MONTHS_BETWEEN(NVL(APREHIS_TO_DATE,SYSDATE),APREHIS_FROM_DATE)
YEARS_MONTHS_IN_POSITION3	Years and months the person was in this previous employment position. Calculated by using the position start and end dates.			CALCULATION	MONTHS_BETWEEN(NVL(APREHIS_TO_DATE,SYSDATE),APREHIS_FROM_DATE)
YEARS_MONTHS_IN_POSITION4	Years and months the person was in this previous employment position. Calculated by using the position start and end dates.			CALCULATION	MONTHS_BETWEEN(NVL(APREHIS_TO_DATE,SYSDATE),APREHIS_FROM_DATE)

Ver: 8.3