Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Common Composite View Reports

SGHE Banner 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.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
COUNTY County for this address.    

NA

NA

 
COUNTY_DESC County name for the address.    

NA

NA

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

NA

SYSDATE

 
CURRENT_HOURLY_RATE Current hourly rate at this position.    

PPREXPE

PPREXPE_CURR_HOURLY

 
CURRENT_SALARY Current salary at this position.    

PPREXPE

PPREXPE_CURR_SALARY

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

NA

NA

 
EMPLOYEES_SUPERVISED Number of employees applicant supervised.    

PPREXPE

PPREXPE_EMPS_SUPERVISE

 
EMPLOYER_NAME Name of the previous or current employer at which this experience was obtained.    

PPREXPE

PPREXPE_SUPER_NAME

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

PPREXPE

PPREXPE_EMTY_CODE

 
EMPLOYER_TYPE_DESC Employer type description.    

FUNCTION

GOKODSF.F_GET_DESC

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

PPREXPE

PPREXPE_END_DATE

 
MIF_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

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

NA

NA

 
NATION Nation/country of previous employer.    

PPREXPE

PPREXPE_NATN_CODE

 
NATION_DESC Address nation/country description.    

FUNCTION

GOKODSF.F_GET_DESC

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

PPREXPE

PPREXPE_PIDM

 
POSITION_TITLE Title of the position occupied while obtaining this experience.    

PPREXPE

PPREXPE_POSN_TITLE

 
REASON_LEFT Reason the employee left that position.    

PPREXPE

PPREXPE_REASON_LEFT

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

PPREXPE

PPREXPE_START_DATE

 
STATE State/Province of previous employer.    

PPREXPE

PPREXPE_STAT_CODE

 
STATE_DESC State/province name.    

FUNCTION

GOKODSF.F_GET_DESC

 
SUPERVISOR_COMBINED_PHONE Combination of phone area, number and extension.    

CALCULATION

PPREXPE_SUPER_PHONE_AREA||PPREXPE_SUPER_PHONE_NUMBER||PPREXPE_SUPER_PHONE_EXT

 
SUPERVISOR_COMMENT Any comments the supervisor may have given.    

PPREXPE

PPREXPE_SUPER_COMMENT

 
SUPERVISOR_CONTACT_IND Indicates if this supervisor may be contacted.    

PPREXPE

PPREXPE_CONTACT_IND

 
SUPERVISOR_NAME Name of the previous or current employer at which this experience was obtained.    

PPREXPE

PPREXPE_SUPER_NAME

 
SUPERVISOR_PHONE_AREA Supervisors area code.    

PPREXPE

PPREXPE_SUPER_PHONE_AREA

 
SUPERVISOR_PHONE_EXTENSION Supervisors extension.    

PPREXPE

PPREXPE_SUPER_PHONE_EXT

 
SUPERVISOR_PHONE_NUMBER Supervisors phone number.    

PPREXPE

PPREXPE_SUPER_PHONE_NUMBER

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

CALCULATION

MONTHS_BETWEEN

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

NA

NA

 


Ver: 8.3