Reporting View Target: EMPLOYMENT

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

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

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

NA

COUNTY County County for this address. VARCHAR2(63)
NA

NA

COUNTY_DESC County Description County name for the address. VARCHAR2(255)
NA

NA

CURRENT_HOURLY_RATE Current Hourly Rate Current hourly rate at this position. NUMBER
PPREXPE

PPREXPE_CURR_HOURLY

CURRENT_SALARY Current Salary Current salary at this position. NUMBER
PPREXPE

PPREXPE_CURR_SALARY

EMPLOYEES_SUPERVISED Employees Supervised Number of employees applicant supervised. NUMBER
PPREXPE

PPREXPE_EMPS_SUPERVISE

EMPLOYER_CATEGORY Employer Category Identifies the employer type (for example, Higher Education, Government, Commercial). VARCHAR2(63)
APREHIS
PPREXPE

APREHIS_JOBC_CODE
PPREXPE_EMTY_CODE

EMPLOYER_CATEGORY2 Employer Category 2 A code identifying the job category or employer type. VARCHAR2(63)
APREHIS

APREHIS_JOBC_CODE2

EMPLOYER_CATEGORY2_DESC Employer Category 2 Description Employer category description. VARCHAR2(255)
ATVJOBC

ATVJOBC_DESC

EMPLOYER_CATEGORY3 Employer Category 3 A code identifying the job category or employer type. VARCHAR2(63)
APREHIS

APREHIS_JOBC_CODE3

EMPLOYER_CATEGORY3_DESC Employer Category 3 Description Employer category description. VARCHAR2(255)
ATVJOBC

ATVJOBC_DESC

EMPLOYER_CATEGORY4 Employer Category 4 A code identifying the job category or employer type. VARCHAR2(63)
APREHIS

APREHIS_JOBC_CODE4

EMPLOYER_CATEGORY4_DESC Employer Category 4 Description Employer category description. VARCHAR2(255)
ATVJOBC

ATVJOBC_DESC

EMPLOYER_CATEGORY_DESC Employer Category Description Employer category description. VARCHAR2(255)
ATVJOBC

ATVJOBC_DESC

EMPLOYER_COMMENT Employer Comment Free form text comment for this employer. CLOB
APREHIS

APREHIS_COMMENT

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

MGKFUNC.F_GET_PERSON_INFO

EMPLOYER_INDUSTRIAL_DESC Employer Industrial Description Standard industry code (sic) description. VARCHAR2(255)
ATVSICC

ATVSICC_DESC

EMPLOYER_INDUSTRIAL_TYPE Employer Industrial Type Standard industrial code of the employer. VARCHAR2(63)
APREHIS

APREHIS_SICC_CODE

EMPLOYER_NAME Employer Name Employer's name. VARCHAR2(255)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

APREHIS_EMPR_PIDM

EMPLOYMENT_ORDER Employment Order Internal sequence number when available for the order of the positions. NUMBER
APREHIS

APREHIS_SEQ_NO

EMPLOYMENT_STATUS Employment Status Employment status code. VARCHAR2(63)
APREHIS

APREHIS_EMPS_CODE

EMPLOYMENT_STATUS_ACTIVE_IND Employment Status Active Indicator Status active indicator. VARCHAR2(1)
ATVEMPS

ATVEMPS_ACTIVE_IND

EMPLOYMENT_STATUS_DESC Employment Status Description Employment status code description. VARCHAR2(255)
ATVEMPS

ATVEMPS_DESC

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

APREHIS_FROM_DATE
PPREXPE_END_DATE

ID ID Person's or organization's current identification number. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

NA

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

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

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

MGKFUNC.F_GET_PERSON_INFO

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

PPREXPE_NATN_CODE

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

GOKODSF.F_GET_DESC

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

APREHIS_PIDM
PPREXPE_PIDM

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

APREHIS_EMPL_POSITION
PPREXPE_POSN_TITLE

PRIMARY_EMPLOYMENT_IND Primary Employment Indicator Indicates whether the record is the primary employment record. VARCHAR2(1)
APREHIS

APREHIS_PRIMARY_IND

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

NA

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

PPREXPE_STAT_CODE

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

GOKODSF.F_GET_DESC

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

PPREXPE_REASON_LEFT

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

APREHIS_TO_DATE
PPREXPE_START_DATE

SUPERVISOR_COMBINED_PHONE Supervisor Combined Phone Telephone number of the supervisor. VARCHAR2(63)
NA

NA

SUPERVISOR_COMMENT Supervisor Comment Any comments the supervisor may have given. VARCHAR2(4000)
PPREXPE

PPREXPE_SUPER_COMMENT

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

PPREXPE_CONTACT_IND

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

PPREXPE_SUPER_NAME

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

PPREXPE_SUPER_PHONE_AREA

SUPERVISOR_PHONE_EXTENSION Supervisor Phone Extension Supervisors extension. VARCHAR2(63)
PPREXPE

PPREXPE_SUPER_PHONE_EXT

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

PPREXPE_SUPER_PHONE_NUMBER

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

APREHIS_WKLY_HOURS

Ver: 9.0

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