RETURN TO REPORTING VIEW REPORTS LIST
Common Reporting View Reports

SGHE Operational Data Store
Reporting View Target: CURRENT_EMPLOYMENT

Description Contains the person's current employement information.
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 Institution value of the organization-oriented identifier for the record used to determine access authorization to this record. VARCHAR2(255)

NA

NA

CARRIER_ROUTE Address carrier route. VARCHAR2(63)

SPRADDR

SPRADDR_CARRIER_ROUTE

CITY Address, city, town or municipality of employee. VARCHAR2(63)

SPRADDR

SPRADDR_CITY

CORRECTION_DIGIT Address correction digit. NUMBER

SPRADDR

SPRADDR_CORRECTION_DIGIT

COUNTY County for this address record. VARCHAR2(63)

SPRADDR

SPRADDR_CNTY_CODE

COUNTY_DESC Name of the county in the address. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DELIVERY_POINT Address delivery point. NUMBER

SPRADDR

SPRADDR_DELIVERY_POINT

EMPLOYER_CATEGORY Employer type code (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 Job category or employer type code. VARCHAR2(63)

APREHIS

APREHIS_JOBC_CODE3

EMPLOYER_CATEGORY3_DESC Employer category description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

EMPLOYER_CATEGORY4 Job category or employer type code. 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(60)

APREHIS

PPREXPE

SPRIDEN

APREHIS_EMPR_NAME

PPREXPE_EMPR_NAME

SPRIDEN_LAST_NAME

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

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)

CONSTANT

'BAN-ALUMNI'

'BAN-HR'

MATCHING_GIFT_COMPANY_ID Entity's identification number used to access the records associated with the entity. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

MATCHING_GIFT_COMPANY_NAME Organization name. VARCHAR2(255)

SPRIDEN

SPRIDEN_LAST_NAME

MATCHING_GIFT_COMPANY_UID Internal identification number for the matching gift company associated with the organization. The identification number may be the same identification number or the parent identification number. NUMBER

AOBORGN

AOBORGN_MG_PIDM

MATCHING_GIFT_IND Whether a related reference has a matching gift associated with it. VARCHAR2(1)

APREHIS

APREHIS_MG_IND

MONTHS_IN_POSITION Years and months the person was in the previous employment position. Calculated using the position start and end dates. NUMBER

CALCULATION

MONTHS_BETWEEN(NVL(APREHIS_TO_DATE,SYSDATE),APREHIS_FROM_DATE)

MONTHS_BETWEEN(PPREXPE_END_DATE, PPREXPE_START_DATE)

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. 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 employee. VARCHAR2(63)

PPREXPE

SPRADDR

PPREXPE_NATN_CODE

SPRADDR_NATN_CODE

NATION_DESC Nation/country description 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

PHONE_NUMBER_COMBINED Combination of the area code, phone number and extension of employee. VARCHAR2(63)

SPRADDR

SPRADDR_CARRIER_ROUTE

POSITION_TITLE Employee's job title. 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 Institution value of the process-oriented identifier for the record used to determine access authorization to this record. VARCHAR2(255)

NA

NA

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

PPREXPE

PPREXPE_REASON_LEFT

START_DATE Start date during which this experience was obtained. DATE

APREHIS

PPREXPE

APREHIS_FROM_DATE

PPREXPE_START_DATE

STATE_PROVINCE State/Province of employee. VARCHAR2(63)

PPREXPE

SPRADDR

PPREXPE_STAT_CODE

SPRADDR_STAT_CODE

STATE_PROVINCE_DESC Address state/province. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

STREET_LINE1 First line of employee address. VARCHAR2(63)

SPRADDR

SPRADDR_STREET_LINE1

STREET_LINE2 Second line of employee address. VARCHAR2(63)

SPRADDR

SPRADDR_STREET_LINE2

STREET_LINE3 Third line of employee address. VARCHAR2(63)

SPRADDR

SPRADDR_STREET_LINE3

STREET_LINE4 Fourth line of employee address. VARCHAR2(255)

NA

NA

WEEKLY_HOURS Hours per week for part-time employee used for matching gift qualification. NUMBER

APREHIS

APREHIS_WKLY_HOURS



Ver: 3.1