RETURN TO REPORTING VIEW REPORTS LIST
(EDW Source Report)
Common Reporting View Reports

SGHE 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
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

COUNTY County for this address. VARCHAR2(63)

NA

NA

COUNTY_DESC County name for the address. VARCHAR2(255)

NA

NA

CURRENT_HOURLY_RATE Current hourly rate at this position. NUMBER

PPREXPE

PPREXPE_CURR_HOURLY

CURRENT_SALARY Current salary at this position. NUMBER

PPREXPE

PPREXPE_CURR_SALARY

EMPLOYEES_SUPERVISED Number of employees applicant supervised. NUMBER

PPREXPE

PPREXPE_EMPS_SUPERVISE

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

APREHIS

PPREXPE

APREHIS_JOBC_CODE

PPREXPE_EMTY_CODE

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

APREHIS

APREHIS_JOBC_CODE2

EMPLOYER_CATEGORY2_DESC Employer category description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

APREHIS

APREHIS_JOBC_CODE3

EMPLOYER_CATEGORY3_DESC Employer category description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

APREHIS

APREHIS_JOBC_CODE4

EMPLOYER_CATEGORY4_DESC Employer category description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

EMPLOYER_CATEGORY_DESC Employer category description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

EMPLOYER_COMMENT Free form text comment for this employer. VARCHAR2(4000)

APREHIS

APREHIS_COMMENT

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

FUNCTION

GOKODSF.F_GET_DESC

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

APREHIS

APREHIS_SICC_CODE

EMPLOYER_NAME Employer's name. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

APREHIS

APREHIS_EMPR_PIDM

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

APREHIS

APREHIS_SEQ_NO

EMPLOYMENT_STATUS Employment status code. VARCHAR2(63)

APREHIS

APREHIS_EMPS_CODE

EMPLOYMENT_STATUS_ACTIVE_IND Status active indicator. VARCHAR2(1)

ATVEMPS

ATVEMPS_ACTIVE_IND

EMPLOYMENT_STATUS_DESC Employment status code description. VARCHAR2(255)

ATVEMPS

ATVEMPS_DESC

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 Person's or organization's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

NA

NA

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(APREHIS_TO_DATE,SYSDATE),APREHIS_FROM_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

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

PPREXPE

PPREXPE_NATN_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

APREHIS

PPREXPE

APREHIS_PIDM

PPREXPE_PIDM

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

APREHIS

PPREXPE

APREHIS_EMPL_POSITION

PPREXPE_POSN_TITLE

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

APREHIS

APREHIS_PRIMARY_IND

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

NA

NA

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

PPREXPE

PPREXPE_STAT_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

PPREXPE

PPREXPE_REASON_LEFT

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 Telephone number of the supervisor. VARCHAR2(63)

NA

NA

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

PPREXPE

PPREXPE_SUPER_COMMENT

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

PPREXPE

PPREXPE_CONTACT_IND

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

PPREXPE

PPREXPE_SUPER_NAME

SUPERVISOR_PHONE_AREA Supervisors area code. VARCHAR2(63)

PPREXPE

PPREXPE_SUPER_PHONE_AREA

SUPERVISOR_PHONE_EXTENSION Supervisors extension. VARCHAR2(63)

PPREXPE

PPREXPE_SUPER_PHONE_EXT

SUPERVISOR_PHONE_NUMBER Supervisors phone number. VARCHAR2(63)

PPREXPE

PPREXPE_SUPER_PHONE_NUMBER

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

APREHIS

APREHIS_WKLY_HOURS



Ver: 3.1