Penn Computing

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

POSITION_COMPARISON_SUMMARY Table

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.

Primary Key Indexed Data Elements Related Tables
POSITION_COMPARISON_SUMMARY_PK
ACCOUNTING_PERIOD 
FISCAL_YEAR
JOB_DEPT_ORG
JOB_SCHOOL_CTR
PERSONNEL_CLASS
POSITION_STATUS
EMPLOYEE_GENERAL

ORG_CODES

POSITION_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_COMPARISON_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