Running the UW Frozen Snapshot of Employee Data View in EPM


This view is designed to facilitate trend analyses. It gives a fixed (frozen) snapshot of a time period (October or March) used frequently as a date of record for analyses. This data view is designed to have the same individuals as those included on the InfoAccess October and March Payroll analytical views, but also includes individuals not paid in October (or March) who have active jobs, such as $0 appointments or individuals on leave.

Process Considerations:

Example:   Records in OCTJOB showing a faculty member with more than one faculty relationship department and a faculty member with two faculty relationship departments and two faculty tenure home departments.
An individual with more than one job during the month will have a record for each job held.  This includes jobs held simultaneously and jobs held sequentially.   If a person transfers to a new job during the month and the new job has a different UW_JOB_START_DATE, both the job transferred from and the job transferred to will be included.  Any job that is active for at least one day in the month is included.  Canceled jobs that start and end on the same date are excluded from the view.
If rate, FTE, title, pay basis, or other attributes of a particular job are changed during the month, the attributes with the latest effective date during the month are reported.

Example:  Records from ALLJOB showing a promotion with jobcode change and rate change during March
Records for same individual contained in MARJOB:
Same individual in MARJOB

Sample analyses addressed with this view:


HR and Institutional Research staff.  This view is useful to anyone who needs a frozen snapshot of employee data and is particularly valuable for analyses over time. 

Example Types of Data Included:
Example uses of view:

Additional Resources

Related Links:

Get Help

  • Click HERE to contact UW Shared Services or HERE for the Office of Technology Services (OTS) Helpdesk if you have any issues with these instructions.
To the top