POSITION_COMPARISON_SUMMARY Table - Data Element Index    Tables and Data Elements   Position Inventory Home   Data Warehouse Home

POSITION_COMPARISON_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 position funding comparisons by job organization and position status for a given period to the previous period, last period of the previous fiscal year and same period in the previous year. Positions are totalled by accounting_period / job_dept_org / personnel_class / position_status.

Common Uses
Tracking changes in staff position funding by job organization and position status.

POSITION_COMPARISON_SUMMARY_PK

ACCOUNTING_PERIOD 
FISCAL_YEAR 
JOB_DEPT_ORG 
JOB_SCHOOL_CTR 
PERSONNEL_CLASS 
POSITION_STATUS 

EMPLOYEE_GENERAL

ORG_CODES

POSITION_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_COMPARISON_SUMMARY Table - Data Element Index    Tables and Data Elements   Position Inventory Home    Data Warehouse Home