RETURN TO COMPOSITE VIEW REPORTS LIST
Common Composite View Reports

SGHE Operational Data Store
Composite View Target: AP_PAST_EMPLOYMENT

Description Source composite view contains prior employment information for an employee or person applying for a position at the institution.

Target Column Business Definition Database Data Type Source Name Source Column
COUNTY County for this address. VARCHAR2(0)

NA

NA

COUNTY_DESC County name for the address. VARCHAR2(0)

NA

NA

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

CURRENT_HOURLY_RATE Current hourly rate at this position. NUMBER(11, 2)

PPREXPE

PPREXPE_CURR_HOURLY

CURRENT_SALARY Current salary at this position. NUMBER(11, 2)

PPREXPE

PPREXPE_CURR_SALARY

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

EMPLOYEES_SUPERVISED Number of employees applicant supervised. NUMBER(4)

PPREXPE

PPREXPE_EMPS_SUPERVISE

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

PPREXPE

PPREXPE_SUPER_NAME

EMPLOYER_TYPE A code identifying the employer type (for example, Higher Education, Government, Commercial). VARCHAR2(2)

PPREXPE

PPREXPE_EMTY_CODE

EMPLOYER_TYPE_DESC Employer type description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

PPREXPE

PPREXPE_END_DATE

MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

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

PPREXPE

PPREXPE_NATN_CODE

NATION_DESC Address nation/country description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

PPREXPE

PPREXPE_PIDM

POSITION_TITLE Title of the position occupied while obtaining this experience. VARCHAR2(30)

PPREXPE

PPREXPE_POSN_TITLE

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

PPREXPE

PPREXPE_REASON_LEFT

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

PPREXPE

PPREXPE_START_DATE

STATE State/Province of previous employer. VARCHAR2(3)

PPREXPE

PPREXPE_STAT_CODE

STATE_DESC State/province name. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

SUPERVISOR_COMBINED_PHONE Combination of phone area, number and extension. VARCHAR2(14)

CALCULATION

PPREXPE_SUPER_PHONE_AREA||PPREXPE_SUPER_PHONE_NUMBER||PPREXPE_SUPER_PHONE_EXT

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(60)

PPREXPE

PPREXPE_SUPER_NAME

SUPERVISOR_PHONE_AREA Supervisors area code. VARCHAR2(3)

PPREXPE

PPREXPE_SUPER_PHONE_AREA

SUPERVISOR_PHONE_EXTENSION Supervisors extension. VARCHAR2(4)

PPREXPE

PPREXPE_SUPER_PHONE_EXT

SUPERVISOR_PHONE_NUMBER Supervisors phone number. VARCHAR2(7)

PPREXPE

PPREXPE_SUPER_PHONE_NUMBER

YEARS_MONTHS_IN_POSITION Number of years / months this employee has been in the position. NUMBER

CALCULATION

MONTHS_BETWEEN

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

NA

NA



Ver: 3.1