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

Banner Operational Data Store
Reporting View Target: EMPLOYMENT_HISTORY

Description Contains data related to a person's employment history. This is employment experiences captured external to any position and jobs held at this institution. Data may include details for an employment applicant, for an alumnus or an admissions applicant.
Key & Frequency One row per person per employer.
Recommended Search Columns PERSON_UID
EMPLOYER_UID

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

NO

NO
COUNTY County for this address. VARCHAR2(63)

NA

NA

NO

NO
COUNTY_DESC County name for the address. VARCHAR2(255)

NA

NA

NO

NO
CURRENT_HOURLY_RATE Current hourly rate at this position. NUMBER

PPREXPE

PPREXPE_CURR_HOURLY

NO

NO
CURRENT_SALARY Current salary at this position. NUMBER

PPREXPE

PPREXPE_CURR_SALARY

NO

NO
EMPLOYEES_SUPERVISED Number of employees applicant supervised. NUMBER

PPREXPE

PPREXPE_EMPS_SUPERVISE

NO

NO
EMPLOYER_CATEGORY Identifies the employer type (for example, Higher Education, Government, Commercial). VARCHAR2(63)

APREHIS

PPREXPE

APREHIS_JOBC_CODE

PPREXPE_EMTY_CODE

NO

NO

NO
EMPLOYER_CATEGORY2 A code identifying the job category or employer type. VARCHAR2(63)

APREHIS

APREHIS_JOBC_CODE2

NO

NO
EMPLOYER_CATEGORY2_DESC Employer category description. VARCHAR2(255)

ATVJOBC

ATVJOBC_DESC

NO

NO
EMPLOYER_CATEGORY3 A code identifying the job category or employer type. VARCHAR2(63)

APREHIS

APREHIS_JOBC_CODE3

NO

NO
EMPLOYER_CATEGORY3_DESC Employer category description. VARCHAR2(255)

ATVJOBC

ATVJOBC_DESC

NO

NO
EMPLOYER_CATEGORY4 A code identifying the job category or employer type. VARCHAR2(63)

APREHIS

APREHIS_JOBC_CODE4

NO

NO
EMPLOYER_CATEGORY4_DESC Employer category description. VARCHAR2(255)

ATVJOBC

ATVJOBC_DESC

NO

NO
EMPLOYER_CATEGORY_DESC Employer category description. VARCHAR2(255)

ATVJOBC

ATVJOBC_DESC

NO

NO
EMPLOYER_COMMENT Free form text comment for this employer. CLOB

APREHIS

APREHIS_COMMENT

NO

NO
EMPLOYER_ID Employer's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
EMPLOYER_INDUSTRIAL_DESC Standard industry code (sic) description. VARCHAR2(255)

ATVSICC

ATVSICC_DESC

NO

NO
EMPLOYER_INDUSTRIAL_TYPE Standard industrial code of the employer. VARCHAR2(63)

APREHIS

APREHIS_SICC_CODE

NO

NO
EMPLOYER_NAME Employer's name. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
EMPLOYER_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER

APREHIS

APREHIS_EMPR_PIDM

NO

NO
EMPLOYMENT_ORDER Internal sequence number when available for the order of the positions. NUMBER

APREHIS

APREHIS_SEQ_NO

NO

NO
EMPLOYMENT_STATUS Employment status code. VARCHAR2(63)

APREHIS

APREHIS_EMPS_CODE

NO

NO
EMPLOYMENT_STATUS_ACTIVE_IND Status active indicator. VARCHAR2(1)

ATVEMPS

ATVEMPS_ACTIVE_IND

NO

NO
EMPLOYMENT_STATUS_DESC Employment status code description. VARCHAR2(255)

ATVEMPS

ATVEMPS_DESC

NO

NO
END_DATE End date for the period of time during which this experience was obtained. DATE

APREHIS

PPREXPE

APREHIS_FROM_DATE

PPREXPE_END_DATE

NO

NO

NO
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

NO

NO
ID_SOURCE Name of the source system that provided the value in the ID_NUMBER field. VARCHAR2(10)

NA

NA

NO

NO
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)

NO

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

NA

NA

NO

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

NA

NA

NO

NO
NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
NATION Nation/country of previous employer. VARCHAR2(63)

PPREXPE

PPREXPE_NATN_CODE

NO

NO
NATION_DESC Description for the nation/country associated with the address. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

APREHIS

PPREXPE

APREHIS_PIDM

PPREXPE_PIDM

NO

NO

NO
POSITION_TITLE Title of the position occupied while obtain this experience. VARCHAR2(63)

APREHIS

PPREXPE

APREHIS_EMPL_POSITION

PPREXPE_POSN_TITLE

NO

NO

NO
PRIMARY_EMPLOYMENT_IND Indicates whether the record is the primary employment record. VARCHAR2(1)

APREHIS

APREHIS_PRIMARY_IND

NO

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

NA

NA

NO

NO
PROVINCE_STATE State/Province of previous employer. VARCHAR2(63)

PPREXPE

PPREXPE_STAT_CODE

NO

NO
PROVINCE_STATE_DESC Name of the State/Province for this address. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
REASON_LEFT Reason the employee left that position. VARCHAR2(63)

PPREXPE

PPREXPE_REASON_LEFT

NO

NO
START_DATE Starting date of the period of time during which this experience was obtained. DATE

APREHIS

PPREXPE

APREHIS_TO_DATE

PPREXPE_START_DATE

NO

NO

NO
SUPERVISOR_COMBINED_PHONE Telephone number of the supervisor. VARCHAR2(63)

NA

NA

NO

NO
SUPERVISOR_COMMENT Any comments the supervisor may have given. VARCHAR2(4000)

PPREXPE

PPREXPE_SUPER_COMMENT

NO

NO
SUPERVISOR_CONTACT_IND Indicates if this supervisor may be contacted. VARCHAR2(1)

PPREXPE

PPREXPE_CONTACT_IND

NO

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

PPREXPE

PPREXPE_SUPER_NAME

NO

NO
SUPERVISOR_PHONE_AREA Supervisors area code. VARCHAR2(63)

PPREXPE

PPREXPE_SUPER_PHONE_AREA

NO

NO
SUPERVISOR_PHONE_EXTENSION Supervisors extension. VARCHAR2(63)

PPREXPE

PPREXPE_SUPER_PHONE_EXT

NO

NO
SUPERVISOR_PHONE_NUMBER Supervisors phone number. VARCHAR2(63)

PPREXPE

PPREXPE_SUPER_PHONE_NUMBER

NO

NO
WEEKLY_HOURS Hours per week for parttime employee used for matching gift qualification. NUMBER

APREHIS

APREHIS_WKLY_HOURS

NO

NO


Ver: 9.2