Penn Computing

University of Pennsylvania
Penn Computing << go backback
POSITION_SUMMARY Table - Data Element Index    Tables and Data Elements   Position Inventory Home   Data Warehouse Home

POSITION_SUMMARY Table

Note: This table is no longer updated, following the retirement of the mainframe Personnel/Payroll and Position Inventory systems and the implementation Workday@Penn in July 2019.

Explanation
Provides a snapshot of staff positions for a given accounting period, for accounting periods from JUL-97 to JUN-19. Contains records for staff positions only, and categorizes them by personnel class and position status.


Common Uses
Tracking staff position changes in employee incumbants, organizational affilitiation, job classification, or funding.

Primary Key Indexed Data Elements Related Tables
POSITION_SUMMARY_PK
ACCOUNTING_PERIOD 
APPT_BEGIN_DATE
APPT_END_DATE
EMPLOYMENT_STATUS
FISCAL_YEAR
FULL_PART_TIME
HOME_DEPT
HOME_DEPT_ORG
HOME_SCHOOL
HOME_SCHOOL_CTR
JOB_CLASS
JOB_DEPT
JOB_DEPT_ORG
JOB_SCHOOL
JOB_SCHOOL_CTR
PENN_ID
PERCENT_FULL_TIME
PERSONNEL_CLASS
POSITION_BEGIN_DATE
POSITION_END_DATE
POSITION_NUMBER
POSITION_STATUS
SSN
TENURE_STATUS
EMPLOYEE_GENERAL

ORG_CODES

POSITION_COMPARISON_SUMMARY

Cautions
  • Since the snapshots capture data at the end of each period, data changes are picked up as they occur. These changes are not applied to previous periods, to preserve the accuracy of the snapshot as a view of the data at a point in time. There may therefore be cases where data (such as a birthdate) appears incorrectly in an early period, and appears correctly in later snapshots after it was corrected in the source system.
POSITION_SUMMARY Table - Data Element Index    Tables and Data Elements   Position Inventory Home    Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania