Reporting View Target: PAST_EMPLOYMENT

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Common Reporting View Reports

Banner Operational Data Store
Reporting View Target: PAST_EMPLOYMENT_SLOT

Description Uses data from the EMPLOYMENT_HISTORY view, displays up to 4 sets of data pertaining to previous employers in order of descending start date.
Key & Frequency One row per person.
Recommended Search Columns PERSON_UID
ACTIVITY_DATE

Target Column Business Name Business Definition Database Data Type Source Name Source Column

ACTIVITY_DATE Activity Date Date record was inserted or updated. DATE
NA

SYSDATE

ADMINISTRATIVE_GROUP Administrative Group Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

CURRENT_HOURLY_RATE1 Current Hourly Rate 1 Current hourly rate at this position. NUMBER
PPREXPE

PPREXPE_CURR_HOURLY

CURRENT_HOURLY_RATE2 Current Hourly Rate 2 Current hourly rate at this position. NUMBER
PPREXPE

PPREXPE_CURR_HOURLY

CURRENT_HOURLY_RATE3 Current Hourly Rate 3 Current hourly rate at this position. NUMBER
PPREXPE

PPREXPE_CURR_HOURLY

CURRENT_HOURLY_RATE4 Current Hourly Rate 4 Current hourly rate at this position. NUMBER
PPREXPE

PPREXPE_CURR_HOURLY

CURRENT_SALARY1 Current Salary 1 Current salary at this position. NUMBER
PPREXPE

PPREXPE_CURR_SALARY

CURRENT_SALARY2 Current Salary 2 Current salary at this position. NUMBER
PPREXPE

PPREXPE_CURR_SALARY

CURRENT_SALARY3 Current Salary 3 Current salary at this position. NUMBER
PPREXPE

PPREXPE_CURR_SALARY

CURRENT_SALARY4 Current Salary 4 Current salary at this position. NUMBER
PPREXPE

PPREXPE_CURR_SALARY

EMPLOYEES_SUPERVISED1 Employees Supervised 1 Number of employees applicant supervised. NUMBER
PPREXPE

PPREXPE_EMPS_SUPERVISE

EMPLOYEES_SUPERVISED2 Employees Supervised 2 Number of employees applicant supervised. NUMBER
PPREXPE

PPREXPE_EMPS_SUPERVISE

EMPLOYEES_SUPERVISED3 Employees Supervised 3 Number of employees applicant supervised. NUMBER
PPREXPE

PPREXPE_EMPS_SUPERVISE

EMPLOYEES_SUPERVISED4 Employees Supervised 4 Number of employees applicant supervised. NUMBER
PPREXPE

PPREXPE_EMPS_SUPERVISE

EMPLOYER_NAME1 Employer Name 1 Employer's name. VARCHAR2(63)
PPREXPE
SPRIDEN

PPREXPE_EMPR_NAME
SPRIDEN_LAST_NAME

EMPLOYER_NAME2 Employer Name 2 Employer's name. VARCHAR2(63)
PPREXPE
SPRIDEN

PPREXPE_EMPR_NAME
SPRIDEN_LAST_NAME

EMPLOYER_NAME3 Employer Name 3 Employer's name. VARCHAR2(63)
PPREXPE
SPRIDEN

PPREXPE_EMPR_NAME
SPRIDEN_LAST_NAME

EMPLOYER_NAME4 Employer Name 4 Employer's name. VARCHAR2(63)
PPREXPE
SPRIDEN

PPREXPE_EMPR_NAME
SPRIDEN_LAST_NAME

EMPLOYER_TYPE1 Employer Type 1 Standard industrial code of the employer. VARCHAR2(63)
APREHIS

APREHIS_SICC_CODE

EMPLOYER_TYPE2 Employer Type 2 Standard industrial code of the employer. VARCHAR2(63)
APREHIS

APREHIS_SICC_CODE

EMPLOYER_TYPE3 Employer Type 3 Standard industrial code of the employer. VARCHAR2(63)
APREHIS

APREHIS_SICC_CODE

EMPLOYER_TYPE4 Employer Type 4 Standard industrial code of the employer. VARCHAR2(63)
APREHIS

APREHIS_SICC_CODE

EMPLOYER_TYPE_DESC1 Employer Type Description 1 Standard industry code (sic) description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

EMPLOYER_TYPE_DESC2 Employer Type Description 2 Standard industry code (sic) description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

EMPLOYER_TYPE_DESC3 Employer Type Description 3 Standard industry code (sic) description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

EMPLOYER_TYPE_DESC4 Employer Type Description 4 Standard industry code (sic) description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

END_DATE1 End Date 1 End date for the period of time during which this experience was obtained. DATE
APREHIS
PPREXPE

APREHIS_FROM_DATE
PPREXPE_END_DATE

END_DATE2 End Date 2 End date for the period of time during which this experience was obtained. DATE
APREHIS
PPREXPE

APREHIS_FROM_DATE
PPREXPE_END_DATE

END_DATE3 End Date 3 End date for the period of time during which this experience was obtained. DATE
APREHIS
PPREXPE

APREHIS_FROM_DATE
PPREXPE_END_DATE

END_DATE4 End Date 4 End date for the period of time during which this experience was obtained. DATE
APREHIS
PPREXPE

APREHIS_FROM_DATE
PPREXPE_END_DATE

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER
APREHIS
PPREXPE

APREHIS_PIDM
PPREXPE_PIDM

POSITION_TITLE1 Position Title 1 Title of the position occupied while obtain this experience. VARCHAR2(255)
APREHIS
PPREXPE

APREHIS_EMPL_POSITION
PPREXPE_POSN_TITLE

POSITION_TITLE2 Position Title 2 Title of the position occupied while obtain this experience. VARCHAR2(255)
APREHIS
PPREXPE

APREHIS_EMPL_POSITION
PPREXPE_POSN_TITLE

POSITION_TITLE3 Position Title 3 Title of the position occupied while obtain this experience. VARCHAR2(255)
APREHIS
PPREXPE

APREHIS_EMPL_POSITION
PPREXPE_POSN_TITLE

POSITION_TITLE4 Position Title 4 Title of the position occupied while obtain this experience. VARCHAR2(255)
APREHIS
PPREXPE

APREHIS_EMPL_POSITION
PPREXPE_POSN_TITLE

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

REASON_LEFT1 Reason Left 1 Reason the employee left that position. VARCHAR2(63)
PPREXPE

PPREXPE_REASON_LEFT

REASON_LEFT2 Reason Left 2 Reason the employee left that position. VARCHAR2(63)
PPREXPE

PPREXPE_REASON_LEFT

REASON_LEFT3 Reason Left 3 Reason the employee left that position. VARCHAR2(63)
PPREXPE

PPREXPE_REASON_LEFT

REASON_LEFT4 Reason Left 4 Reason the employee left that position. VARCHAR2(63)
PPREXPE

PPREXPE_REASON_LEFT

START_DATE1 Start Date 1 Starting date of the period of time during which this experience was obtained. DATE
APREHIS
PPREXPE

APREHIS_TO_DATE
PPREXPE_START_DATE

START_DATE2 Start Date 2 Starting date of the period of time during which this experience was obtained. DATE
APREHIS
PPREXPE

APREHIS_TO_DATE
PPREXPE_START_DATE

START_DATE3 Start Date 3 Starting date of the period of time during which this experience was obtained. DATE
APREHIS
PPREXPE

APREHIS_TO_DATE
PPREXPE_START_DATE

START_DATE4 Start Date 4 Starting date of the period of time during which this experience was obtained. DATE
APREHIS
PPREXPE

APREHIS_TO_DATE
PPREXPE_START_DATE

SUPERVISOR_CONTACT_IND1 Supervisor Contact Indicator 1 Indicates if this supervisor may be contacted. VARCHAR2(1)
PPREXPE

PPREXPE_CONTACT_IND

SUPERVISOR_CONTACT_IND2 Supervisor Contact Indicator 2 Indicates if this supervisor may be contacted. VARCHAR2(1)
PPREXPE

PPREXPE_CONTACT_IND

SUPERVISOR_CONTACT_IND3 Supervisor Contact Indicator 3 Indicates if this supervisor may be contacted. VARCHAR2(1)
PPREXPE

PPREXPE_CONTACT_IND

SUPERVISOR_CONTACT_IND4 Supervisor Contact Indicator 4 Indicates if this supervisor may be contacted. VARCHAR2(1)
PPREXPE

PPREXPE_CONTACT_IND

SUPERVISOR_NAME1 Supervisor Name 1 Name of the previous or current employer at which this experience was obtained. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_NAME

SUPERVISOR_NAME2 Supervisor Name 2 Name of the previous or current employer at which this experience was obtained. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_NAME

SUPERVISOR_NAME3 Supervisor Name 3 Name of the previous or current employer at which this experience was obtained. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_NAME

SUPERVISOR_NAME4 Supervisor Name 4 Name of the previous or current employer at which this experience was obtained. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_NAME

SUPERVISOR_PHONE_AREA1 Supervisor Phone Area 1 Supervisors area code. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_PHONE_AREA

SUPERVISOR_PHONE_AREA2 Supervisor Phone Area 2 Supervisors area code. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_PHONE_AREA

SUPERVISOR_PHONE_AREA3 Supervisor Phone Area 3 Supervisors area code. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_PHONE_AREA

SUPERVISOR_PHONE_AREA4 Supervisor Phone Area 4 Supervisors area code. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_PHONE_AREA

SUPERVISOR_PHONE_EXTENSION1 Supervisor Phone Extension 1 Supervisors extension. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_PHONE_EXT

SUPERVISOR_PHONE_EXTENSION2 Supervisor Phone Extension 2 Supervisors extension. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_PHONE_EXT

SUPERVISOR_PHONE_EXTENSION3 Supervisor Phone Extension 3 Supervisors extension. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_PHONE_EXT

SUPERVISOR_PHONE_EXTENSION4 Supervisor Phone Extension 4 Supervisors extension. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_PHONE_EXT

SUPERVISOR_PHONE_NUMBER1 Supervisor Phone Number 1 Supervisors phone number. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_PHONE_NUMBER

SUPERVISOR_PHONE_NUMBER2 Supervisor Phone Number 2 Supervisors phone number. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_PHONE_NUMBER

SUPERVISOR_PHONE_NUMBER3 Supervisor Phone Number 3 Supervisors phone number. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_PHONE_NUMBER

SUPERVISOR_PHONE_NUMBER4 Supervisor Phone Number 4 Supervisors phone number. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_PHONE_NUMBER

YEARS_MONTHS_IN_POSITION1 Years Months IN Position 1 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(APREHIS_TO_DATE,SYSDATE),APREHIS_FROM_DATE)

YEARS_MONTHS_IN_POSITION2 Years Months IN Position 2 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(APREHIS_TO_DATE,SYSDATE),APREHIS_FROM_DATE)

YEARS_MONTHS_IN_POSITION3 Years Months IN Position 3 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(APREHIS_TO_DATE,SYSDATE),APREHIS_FROM_DATE)

YEARS_MONTHS_IN_POSITION4 Years Months IN Position 4 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(APREHIS_TO_DATE,SYSDATE),APREHIS_FROM_DATE)

Ver: 9.2

Description	Uses data from the EMPLOYMENT_HISTORY view, displays up to 4 sets of data pertaining to previous employers in order of descending start date.
Key & Frequency	One row per person.
Recommended Search Columns	PERSON_UID ACTIVITY_DATE

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACTIVITY_DATE	Activity Date	Date record was inserted or updated.	DATE	NA	SYSDATE
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
CURRENT_HOURLY_RATE1	Current Hourly Rate 1	Current hourly rate at this position.	NUMBER	PPREXPE	PPREXPE_CURR_HOURLY
CURRENT_HOURLY_RATE2	Current Hourly Rate 2	Current hourly rate at this position.	NUMBER	PPREXPE	PPREXPE_CURR_HOURLY
CURRENT_HOURLY_RATE3	Current Hourly Rate 3	Current hourly rate at this position.	NUMBER	PPREXPE	PPREXPE_CURR_HOURLY
CURRENT_HOURLY_RATE4	Current Hourly Rate 4	Current hourly rate at this position.	NUMBER	PPREXPE	PPREXPE_CURR_HOURLY
CURRENT_SALARY1	Current Salary 1	Current salary at this position.	NUMBER	PPREXPE	PPREXPE_CURR_SALARY
CURRENT_SALARY2	Current Salary 2	Current salary at this position.	NUMBER	PPREXPE	PPREXPE_CURR_SALARY
CURRENT_SALARY3	Current Salary 3	Current salary at this position.	NUMBER	PPREXPE	PPREXPE_CURR_SALARY
CURRENT_SALARY4	Current Salary 4	Current salary at this position.	NUMBER	PPREXPE	PPREXPE_CURR_SALARY
EMPLOYEES_SUPERVISED1	Employees Supervised 1	Number of employees applicant supervised.	NUMBER	PPREXPE	PPREXPE_EMPS_SUPERVISE
EMPLOYEES_SUPERVISED2	Employees Supervised 2	Number of employees applicant supervised.	NUMBER	PPREXPE	PPREXPE_EMPS_SUPERVISE
EMPLOYEES_SUPERVISED3	Employees Supervised 3	Number of employees applicant supervised.	NUMBER	PPREXPE	PPREXPE_EMPS_SUPERVISE
EMPLOYEES_SUPERVISED4	Employees Supervised 4	Number of employees applicant supervised.	NUMBER	PPREXPE	PPREXPE_EMPS_SUPERVISE
EMPLOYER_NAME1	Employer Name 1	Employer's name.	VARCHAR2(63)	PPREXPE SPRIDEN	PPREXPE_EMPR_NAME SPRIDEN_LAST_NAME
EMPLOYER_NAME2	Employer Name 2	Employer's name.	VARCHAR2(63)	PPREXPE SPRIDEN	PPREXPE_EMPR_NAME SPRIDEN_LAST_NAME
EMPLOYER_NAME3	Employer Name 3	Employer's name.	VARCHAR2(63)	PPREXPE SPRIDEN	PPREXPE_EMPR_NAME SPRIDEN_LAST_NAME
EMPLOYER_NAME4	Employer Name 4	Employer's name.	VARCHAR2(63)	PPREXPE SPRIDEN	PPREXPE_EMPR_NAME SPRIDEN_LAST_NAME
EMPLOYER_TYPE1	Employer Type 1	Standard industrial code of the employer.	VARCHAR2(63)	APREHIS	APREHIS_SICC_CODE
EMPLOYER_TYPE2	Employer Type 2	Standard industrial code of the employer.	VARCHAR2(63)	APREHIS	APREHIS_SICC_CODE
EMPLOYER_TYPE3	Employer Type 3	Standard industrial code of the employer.	VARCHAR2(63)	APREHIS	APREHIS_SICC_CODE
EMPLOYER_TYPE4	Employer Type 4	Standard industrial code of the employer.	VARCHAR2(63)	APREHIS	APREHIS_SICC_CODE
EMPLOYER_TYPE_DESC1	Employer Type Description 1	Standard industry code (sic) description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
EMPLOYER_TYPE_DESC2	Employer Type Description 2	Standard industry code (sic) description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
EMPLOYER_TYPE_DESC3	Employer Type Description 3	Standard industry code (sic) description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
EMPLOYER_TYPE_DESC4	Employer Type Description 4	Standard industry code (sic) description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
END_DATE1	End Date 1	End date for the period of time during which this experience was obtained.	DATE	APREHIS PPREXPE	APREHIS_FROM_DATE PPREXPE_END_DATE
END_DATE2	End Date 2	End date for the period of time during which this experience was obtained.	DATE	APREHIS PPREXPE	APREHIS_FROM_DATE PPREXPE_END_DATE
END_DATE3	End Date 3	End date for the period of time during which this experience was obtained.	DATE	APREHIS PPREXPE	APREHIS_FROM_DATE PPREXPE_END_DATE
END_DATE4	End Date 4	End date for the period of time during which this experience was obtained.	DATE	APREHIS PPREXPE	APREHIS_FROM_DATE PPREXPE_END_DATE
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	APREHIS PPREXPE	APREHIS_PIDM PPREXPE_PIDM
POSITION_TITLE1	Position Title 1	Title of the position occupied while obtain this experience.	VARCHAR2(255)	APREHIS PPREXPE	APREHIS_EMPL_POSITION PPREXPE_POSN_TITLE
POSITION_TITLE2	Position Title 2	Title of the position occupied while obtain this experience.	VARCHAR2(255)	APREHIS PPREXPE	APREHIS_EMPL_POSITION PPREXPE_POSN_TITLE
POSITION_TITLE3	Position Title 3	Title of the position occupied while obtain this experience.	VARCHAR2(255)	APREHIS PPREXPE	APREHIS_EMPL_POSITION PPREXPE_POSN_TITLE
POSITION_TITLE4	Position Title 4	Title of the position occupied while obtain this experience.	VARCHAR2(255)	APREHIS PPREXPE	APREHIS_EMPL_POSITION PPREXPE_POSN_TITLE
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
REASON_LEFT1	Reason Left 1	Reason the employee left that position.	VARCHAR2(63)	PPREXPE	PPREXPE_REASON_LEFT
REASON_LEFT2	Reason Left 2	Reason the employee left that position.	VARCHAR2(63)	PPREXPE	PPREXPE_REASON_LEFT
REASON_LEFT3	Reason Left 3	Reason the employee left that position.	VARCHAR2(63)	PPREXPE	PPREXPE_REASON_LEFT
REASON_LEFT4	Reason Left 4	Reason the employee left that position.	VARCHAR2(63)	PPREXPE	PPREXPE_REASON_LEFT
START_DATE1	Start Date 1	Starting date of the period of time during which this experience was obtained.	DATE	APREHIS PPREXPE	APREHIS_TO_DATE PPREXPE_START_DATE
START_DATE2	Start Date 2	Starting date of the period of time during which this experience was obtained.	DATE	APREHIS PPREXPE	APREHIS_TO_DATE PPREXPE_START_DATE
START_DATE3	Start Date 3	Starting date of the period of time during which this experience was obtained.	DATE	APREHIS PPREXPE	APREHIS_TO_DATE PPREXPE_START_DATE
START_DATE4	Start Date 4	Starting date of the period of time during which this experience was obtained.	DATE	APREHIS PPREXPE	APREHIS_TO_DATE PPREXPE_START_DATE
SUPERVISOR_CONTACT_IND1	Supervisor Contact Indicator 1	Indicates if this supervisor may be contacted.	VARCHAR2(1)	PPREXPE	PPREXPE_CONTACT_IND
SUPERVISOR_CONTACT_IND2	Supervisor Contact Indicator 2	Indicates if this supervisor may be contacted.	VARCHAR2(1)	PPREXPE	PPREXPE_CONTACT_IND
SUPERVISOR_CONTACT_IND3	Supervisor Contact Indicator 3	Indicates if this supervisor may be contacted.	VARCHAR2(1)	PPREXPE	PPREXPE_CONTACT_IND
SUPERVISOR_CONTACT_IND4	Supervisor Contact Indicator 4	Indicates if this supervisor may be contacted.	VARCHAR2(1)	PPREXPE	PPREXPE_CONTACT_IND
SUPERVISOR_NAME1	Supervisor Name 1	Name of the previous or current employer at which this experience was obtained.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_NAME
SUPERVISOR_NAME2	Supervisor Name 2	Name of the previous or current employer at which this experience was obtained.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_NAME
SUPERVISOR_NAME3	Supervisor Name 3	Name of the previous or current employer at which this experience was obtained.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_NAME
SUPERVISOR_NAME4	Supervisor Name 4	Name of the previous or current employer at which this experience was obtained.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_NAME
SUPERVISOR_PHONE_AREA1	Supervisor Phone Area 1	Supervisors area code.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_AREA
SUPERVISOR_PHONE_AREA2	Supervisor Phone Area 2	Supervisors area code.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_AREA
SUPERVISOR_PHONE_AREA3	Supervisor Phone Area 3	Supervisors area code.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_AREA
SUPERVISOR_PHONE_AREA4	Supervisor Phone Area 4	Supervisors area code.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_AREA
SUPERVISOR_PHONE_EXTENSION1	Supervisor Phone Extension 1	Supervisors extension.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_EXT
SUPERVISOR_PHONE_EXTENSION2	Supervisor Phone Extension 2	Supervisors extension.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_EXT
SUPERVISOR_PHONE_EXTENSION3	Supervisor Phone Extension 3	Supervisors extension.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_EXT
SUPERVISOR_PHONE_EXTENSION4	Supervisor Phone Extension 4	Supervisors extension.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_EXT
SUPERVISOR_PHONE_NUMBER1	Supervisor Phone Number 1	Supervisors phone number.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_NUMBER
SUPERVISOR_PHONE_NUMBER2	Supervisor Phone Number 2	Supervisors phone number.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_NUMBER
SUPERVISOR_PHONE_NUMBER3	Supervisor Phone Number 3	Supervisors phone number.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_NUMBER
SUPERVISOR_PHONE_NUMBER4	Supervisor Phone Number 4	Supervisors phone number.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_NUMBER
YEARS_MONTHS_IN_POSITION1	Years Months IN Position 1	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(APREHIS_TO_DATE,SYSDATE),APREHIS_FROM_DATE)
YEARS_MONTHS_IN_POSITION2	Years Months IN Position 2	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(APREHIS_TO_DATE,SYSDATE),APREHIS_FROM_DATE)
YEARS_MONTHS_IN_POSITION3	Years Months IN Position 3	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(APREHIS_TO_DATE,SYSDATE),APREHIS_FROM_DATE)
YEARS_MONTHS_IN_POSITION4	Years Months IN Position 4	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(APREHIS_TO_DATE,SYSDATE),APREHIS_FROM_DATE)