RETURN TO REPORTING VIEW REPORTS LIST
Common Reporting View Reports

SGHE 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 Organization-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(3)

PPREXPE

PPREXPE_SUPER_PHONE_AREA

SUPERVISOR_PHONE_AREA2 Supervisors area code. VARCHAR2(3)

PPREXPE

PPREXPE_SUPER_PHONE_AREA

SUPERVISOR_PHONE_AREA3 Supervisors area code. VARCHAR2(3)

PPREXPE

PPREXPE_SUPER_PHONE_AREA

SUPERVISOR_PHONE_AREA4 Supervisors area code. VARCHAR2(3)

PPREXPE

PPREXPE_SUPER_PHONE_AREA

SUPERVISOR_PHONE_EXTENSION1 Supervisors extension. VARCHAR2(4)

PPREXPE

PPREXPE_SUPER_PHONE_EXT

SUPERVISOR_PHONE_EXTENSION2 Supervisors extension. VARCHAR2(4)

PPREXPE

PPREXPE_SUPER_PHONE_EXT

SUPERVISOR_PHONE_EXTENSION3 Supervisors extension. VARCHAR2(4)

PPREXPE

PPREXPE_SUPER_PHONE_EXT

SUPERVISOR_PHONE_EXTENSION4 Supervisors extension. VARCHAR2(4)

PPREXPE

PPREXPE_SUPER_PHONE_EXT

SUPERVISOR_PHONE_NUMBER1 Supervisors phone number. VARCHAR2(7)

PPREXPE

PPREXPE_SUPER_PHONE_NUMBER

SUPERVISOR_PHONE_NUMBER2 Supervisors phone number. VARCHAR2(7)

PPREXPE

PPREXPE_SUPER_PHONE_NUMBER

SUPERVISOR_PHONE_NUMBER3 Supervisors phone number. VARCHAR2(7)

PPREXPE

PPREXPE_SUPER_PHONE_NUMBER

SUPERVISOR_PHONE_NUMBER4 Supervisors phone number. VARCHAR2(7)

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: 3.1