Reporting View Target: PAST_EMPLOYMENT

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

SGHE 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 Definition Database Data Type Source Name Source Column

ACTIVITY_DATE Date record was inserted or updated. DATE
NA

SYSDATE

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 at this position. NUMBER
PPREXPE

PPREXPE_CURR_HOURLY

CURRENT_HOURLY_RATE2 Current hourly rate at this position. NUMBER
PPREXPE

PPREXPE_CURR_HOURLY

CURRENT_HOURLY_RATE3 Current hourly rate at this position. NUMBER
PPREXPE

PPREXPE_CURR_HOURLY

CURRENT_HOURLY_RATE4 Current hourly rate at this position. NUMBER
PPREXPE

PPREXPE_CURR_HOURLY

CURRENT_SALARY1 Current salary at this position. NUMBER
PPREXPE

PPREXPE_CURR_SALARY

CURRENT_SALARY2 Current salary at this position. NUMBER
PPREXPE

PPREXPE_CURR_SALARY

CURRENT_SALARY3 Current salary at this position. NUMBER
PPREXPE

PPREXPE_CURR_SALARY

CURRENT_SALARY4 Current salary at this position. NUMBER
PPREXPE

PPREXPE_CURR_SALARY

EMPLOYEES_SUPERVISED1 Number of employees applicant supervised. NUMBER
PPREXPE

PPREXPE_EMPS_SUPERVISE

EMPLOYEES_SUPERVISED2 Number of employees applicant supervised. NUMBER
PPREXPE

PPREXPE_EMPS_SUPERVISE

EMPLOYEES_SUPERVISED3 Number of employees applicant supervised. NUMBER
PPREXPE

PPREXPE_EMPS_SUPERVISE

EMPLOYEES_SUPERVISED4 Number of employees applicant supervised. NUMBER
PPREXPE

PPREXPE_EMPS_SUPERVISE

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

PPREXPE_EMPR_NAME
SPRIDEN_LAST_NAME

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

PPREXPE_EMPR_NAME
SPRIDEN_LAST_NAME

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

PPREXPE_EMPR_NAME
SPRIDEN_LAST_NAME

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

PPREXPE_EMPR_NAME
SPRIDEN_LAST_NAME

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

APREHIS_SICC_CODE

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

APREHIS_SICC_CODE

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

APREHIS_SICC_CODE

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

APREHIS_SICC_CODE

EMPLOYER_TYPE_DESC1 Standard industry code (sic) description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

EMPLOYER_TYPE_DESC2 Standard industry code (sic) description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

EMPLOYER_TYPE_DESC3 Standard industry code (sic) description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

EMPLOYER_TYPE_DESC4 Standard industry code (sic) description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

END_DATE1 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 for the period of time during which this experience was obtained. DATE
APREHIS
PPREXPE

APREHIS_FROM_DATE
PPREXPE_END_DATE

END_DATE3 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 for the period of time during which this experience was obtained. DATE
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. VARCHAR2(63)
NA

NA

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

NA

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

APREHIS_PIDM
PPREXPE_PIDM

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

APREHIS_EMPL_POSITION
PPREXPE_POSN_TITLE

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

APREHIS_EMPL_POSITION
PPREXPE_POSN_TITLE

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

APREHIS_EMPL_POSITION
PPREXPE_POSN_TITLE

POSITION_TITLE4 Title of the position occupied while obtain this experience. VARCHAR2(63)
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. VARCHAR2(255)
NA

NA

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

PPREXPE_REASON_LEFT

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

PPREXPE_REASON_LEFT

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

PPREXPE_REASON_LEFT

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

PPREXPE_REASON_LEFT

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

APREHIS_TO_DATE
PPREXPE_START_DATE

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

APREHIS_TO_DATE
PPREXPE_START_DATE

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

APREHIS_TO_DATE
PPREXPE_START_DATE

START_DATE4 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 Indicates if this supervisor may be contacted. VARCHAR2(1)
PPREXPE

PPREXPE_CONTACT_IND

SUPERVISOR_CONTACT_IND2 Indicates if this supervisor may be contacted. VARCHAR2(1)
PPREXPE

PPREXPE_CONTACT_IND

SUPERVISOR_CONTACT_IND3 Indicates if this supervisor may be contacted. VARCHAR2(1)
PPREXPE

PPREXPE_CONTACT_IND

SUPERVISOR_CONTACT_IND4 Indicates if this supervisor may be contacted. VARCHAR2(1)
PPREXPE

PPREXPE_CONTACT_IND

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

PPREXPE_SUPER_NAME

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

PPREXPE_SUPER_NAME

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

PPREXPE_SUPER_NAME

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

PPREXPE_SUPER_NAME

SUPERVISOR_PHONE_AREA1 Supervisors area code. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_PHONE_AREA

SUPERVISOR_PHONE_AREA2 Supervisors area code. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_PHONE_AREA

SUPERVISOR_PHONE_AREA3 Supervisors area code. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_PHONE_AREA

SUPERVISOR_PHONE_AREA4 Supervisors area code. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_PHONE_AREA

SUPERVISOR_PHONE_EXTENSION1 Supervisors extension. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_PHONE_EXT

SUPERVISOR_PHONE_EXTENSION2 Supervisors extension. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_PHONE_EXT

SUPERVISOR_PHONE_EXTENSION3 Supervisors extension. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_PHONE_EXT

SUPERVISOR_PHONE_EXTENSION4 Supervisors extension. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_PHONE_EXT

SUPERVISOR_PHONE_NUMBER1 Supervisors phone number. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_PHONE_NUMBER

SUPERVISOR_PHONE_NUMBER2 Supervisors phone number. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_PHONE_NUMBER

SUPERVISOR_PHONE_NUMBER3 Supervisors phone number. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_PHONE_NUMBER

SUPERVISOR_PHONE_NUMBER4 Supervisors phone number. VARCHAR2(63)
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. NUMBER
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. NUMBER
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. NUMBER
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. NUMBER
CALCULATION

MONTHS_BETWEEN(NVL(APREHIS_TO_DATE,SYSDATE),APREHIS_FROM_DATE)

Ver: 8.5

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 Definition	Database Data Type	Source Name	Source Column
ACTIVITY_DATE	Date record was inserted or updated.	DATE	NA	SYSDATE
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 at this position.	NUMBER	PPREXPE	PPREXPE_CURR_HOURLY
CURRENT_HOURLY_RATE2	Current hourly rate at this position.	NUMBER	PPREXPE	PPREXPE_CURR_HOURLY
CURRENT_HOURLY_RATE3	Current hourly rate at this position.	NUMBER	PPREXPE	PPREXPE_CURR_HOURLY
CURRENT_HOURLY_RATE4	Current hourly rate at this position.	NUMBER	PPREXPE	PPREXPE_CURR_HOURLY
CURRENT_SALARY1	Current salary at this position.	NUMBER	PPREXPE	PPREXPE_CURR_SALARY
CURRENT_SALARY2	Current salary at this position.	NUMBER	PPREXPE	PPREXPE_CURR_SALARY
CURRENT_SALARY3	Current salary at this position.	NUMBER	PPREXPE	PPREXPE_CURR_SALARY
CURRENT_SALARY4	Current salary at this position.	NUMBER	PPREXPE	PPREXPE_CURR_SALARY
EMPLOYEES_SUPERVISED1	Number of employees applicant supervised.	NUMBER	PPREXPE	PPREXPE_EMPS_SUPERVISE
EMPLOYEES_SUPERVISED2	Number of employees applicant supervised.	NUMBER	PPREXPE	PPREXPE_EMPS_SUPERVISE
EMPLOYEES_SUPERVISED3	Number of employees applicant supervised.	NUMBER	PPREXPE	PPREXPE_EMPS_SUPERVISE
EMPLOYEES_SUPERVISED4	Number of employees applicant supervised.	NUMBER	PPREXPE	PPREXPE_EMPS_SUPERVISE
EMPLOYER_NAME1	Employer's name.	VARCHAR2(63)	PPREXPE SPRIDEN	PPREXPE_EMPR_NAME SPRIDEN_LAST_NAME
EMPLOYER_NAME2	Employer's name.	VARCHAR2(63)	PPREXPE SPRIDEN	PPREXPE_EMPR_NAME SPRIDEN_LAST_NAME
EMPLOYER_NAME3	Employer's name.	VARCHAR2(63)	PPREXPE SPRIDEN	PPREXPE_EMPR_NAME SPRIDEN_LAST_NAME
EMPLOYER_NAME4	Employer's name.	VARCHAR2(63)	PPREXPE SPRIDEN	PPREXPE_EMPR_NAME SPRIDEN_LAST_NAME
EMPLOYER_TYPE1	Standard industrial code of the employer.	VARCHAR2(63)	APREHIS	APREHIS_SICC_CODE
EMPLOYER_TYPE2	Standard industrial code of the employer.	VARCHAR2(63)	APREHIS	APREHIS_SICC_CODE
EMPLOYER_TYPE3	Standard industrial code of the employer.	VARCHAR2(63)	APREHIS	APREHIS_SICC_CODE
EMPLOYER_TYPE4	Standard industrial code of the employer.	VARCHAR2(63)	APREHIS	APREHIS_SICC_CODE
EMPLOYER_TYPE_DESC1	Standard industry code (sic) description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
EMPLOYER_TYPE_DESC2	Standard industry code (sic) description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
EMPLOYER_TYPE_DESC3	Standard industry code (sic) description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
EMPLOYER_TYPE_DESC4	Standard industry code (sic) description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
END_DATE1	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 for the period of time during which this experience was obtained.	DATE	APREHIS PPREXPE	APREHIS_FROM_DATE PPREXPE_END_DATE
END_DATE3	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 for the period of time during which this experience was obtained.	DATE	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.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	APREHIS PPREXPE	APREHIS_PIDM PPREXPE_PIDM
POSITION_TITLE1	Title of the position occupied while obtain this experience.	VARCHAR2(63)	APREHIS PPREXPE	APREHIS_EMPL_POSITION PPREXPE_POSN_TITLE
POSITION_TITLE2	Title of the position occupied while obtain this experience.	VARCHAR2(63)	APREHIS PPREXPE	APREHIS_EMPL_POSITION PPREXPE_POSN_TITLE
POSITION_TITLE3	Title of the position occupied while obtain this experience.	VARCHAR2(63)	APREHIS PPREXPE	APREHIS_EMPL_POSITION PPREXPE_POSN_TITLE
POSITION_TITLE4	Title of the position occupied while obtain this experience.	VARCHAR2(63)	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.	VARCHAR2(255)	NA	NA
REASON_LEFT1	Reason the employee left that position.	VARCHAR2(63)	PPREXPE	PPREXPE_REASON_LEFT
REASON_LEFT2	Reason the employee left that position.	VARCHAR2(63)	PPREXPE	PPREXPE_REASON_LEFT
REASON_LEFT3	Reason the employee left that position.	VARCHAR2(63)	PPREXPE	PPREXPE_REASON_LEFT
REASON_LEFT4	Reason the employee left that position.	VARCHAR2(63)	PPREXPE	PPREXPE_REASON_LEFT
START_DATE1	Starting date of the period of time during which this experience was obtained.	DATE	APREHIS PPREXPE	APREHIS_TO_DATE PPREXPE_START_DATE
START_DATE2	Starting date of the period of time during which this experience was obtained.	DATE	APREHIS PPREXPE	APREHIS_TO_DATE PPREXPE_START_DATE
START_DATE3	Starting date of the period of time during which this experience was obtained.	DATE	APREHIS PPREXPE	APREHIS_TO_DATE PPREXPE_START_DATE
START_DATE4	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	Indicates if this supervisor may be contacted.	VARCHAR2(1)	PPREXPE	PPREXPE_CONTACT_IND
SUPERVISOR_CONTACT_IND2	Indicates if this supervisor may be contacted.	VARCHAR2(1)	PPREXPE	PPREXPE_CONTACT_IND
SUPERVISOR_CONTACT_IND3	Indicates if this supervisor may be contacted.	VARCHAR2(1)	PPREXPE	PPREXPE_CONTACT_IND
SUPERVISOR_CONTACT_IND4	Indicates if this supervisor may be contacted.	VARCHAR2(1)	PPREXPE	PPREXPE_CONTACT_IND
SUPERVISOR_NAME1	Name of the previous or current employer at which this experience was obtained.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_NAME
SUPERVISOR_NAME2	Name of the previous or current employer at which this experience was obtained.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_NAME
SUPERVISOR_NAME3	Name of the previous or current employer at which this experience was obtained.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_NAME
SUPERVISOR_NAME4	Name of the previous or current employer at which this experience was obtained.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_NAME
SUPERVISOR_PHONE_AREA1	Supervisors area code.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_AREA
SUPERVISOR_PHONE_AREA2	Supervisors area code.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_AREA
SUPERVISOR_PHONE_AREA3	Supervisors area code.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_AREA
SUPERVISOR_PHONE_AREA4	Supervisors area code.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_AREA
SUPERVISOR_PHONE_EXTENSION1	Supervisors extension.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_EXT
SUPERVISOR_PHONE_EXTENSION2	Supervisors extension.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_EXT
SUPERVISOR_PHONE_EXTENSION3	Supervisors extension.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_EXT
SUPERVISOR_PHONE_EXTENSION4	Supervisors extension.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_EXT
SUPERVISOR_PHONE_NUMBER1	Supervisors phone number.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_NUMBER
SUPERVISOR_PHONE_NUMBER2	Supervisors phone number.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_NUMBER
SUPERVISOR_PHONE_NUMBER3	Supervisors phone number.	VARCHAR2(63)	PPREXPE	PPREXPE_SUPER_PHONE_NUMBER
SUPERVISOR_PHONE_NUMBER4	Supervisors phone number.	VARCHAR2(63)	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.	NUMBER	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.	NUMBER	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.	NUMBER	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.	NUMBER	CALCULATION	MONTHS_BETWEEN(NVL(APREHIS_TO_DATE,SYSDATE),APREHIS_FROM_DATE)