Skip to content

Personnel Data Warehouse

Data Models

Personnel Table Descriptions

Per_FY_All View Campus Domain
Per_Snap_All View Labs/Campus Domain
Dep/Campus/Lab Domain
Address tables (Campus and Lab )
Academic Domain
Title Code Domain



Links:


CPS Data Dictionary (Excel)
Biweekly Pay Period Pro-Ration Process in CPS
New Fields Added to CPS during UCPath Integration Project
Notable Changes in CPS due to UCPath
Vacation Leave Earnings in UCPath
Vacation Leave Earnings in PPS
CPS Welcome Page
WebFocus Tips
Sample WebFocus Focexecs Using Personnel Data
Go to the WebFocus Managed Reporting Environment
Corporate Data Warehouse Help`

Data Available in the Personnel Data Warehouse:

  • Snapshot:
    • Monthly cycles from July 2000 through the most current complete month
    • October final cycles from October 1989 through the most recent final October cycle (excluding  October 1991 and 1995)
      Note: All snapshots cycles are placed in the ALL table once the cycle is considered final.  The only table which contains preliminary data is the CURRENT table (e.g, Per_Snap_Curr).
  • Fiscal Year:
    • Complete Fiscal year cycles from final June 1998 through the most recent final fiscal year
    • Current FY table contains data from the most recent complete month.
      Note: Previous fiscal year cycles are placed in the ALL table once the cycle is considered final. Current FY data is available in the Per_FY_Current table and is updated monthly.
  • Dependent Data:
    • Monthly cycles from July 2000 through the most current complete month

Note: All Dependent cycles are placed in the ALL table once the cycle is final.  The only table which contains preliminary data is the CURRENT table (e.g, Per_Snap_Curr_Dependent)

  • Title Code/Rates Data:
    • Staff Title Codes only


Note: Title code data is updated each month, or more frequently upon request of the HR&B Compensation unit.  We do not store title code data for each month in separate tables or cycles.  Rates are effective as of the date of the extract from TCS, unless otherwise noted. 

Appointment data in the Snapshot and Fiscal Year tables is matched to TCS each month when the database is built, so it reflects the Title Code attributes (such as CTO, Salary Range Maximum, Title Unit code TCS, etc.) that were in effect at the time.  

Note: Address data is updated each month with the most recent address data we have received for employees whose records are included in the current fiscal year file. We do not store address data for each month in separate tables. There are views which combine address data with snapshot data from various months; the address data is the most current that we have for each employee, regardless of which cycle of snapshot data is used.