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.

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

• 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