Skip to content

CPS Data Warehouse Table Descriptions:

Campus Domain Table Name Use
Per_Snap_Curr

Use this when you need campus, UCOP, or DANR data from the most current monthly cycle. This table includes data from the Employee, Appointment, and Distribution levels.

Earnings data is preliminary in the current cycle.

Per_Snap_Curr Empl

Use this when you need campus, UCOP, or DANR data from the most current monthly cycle. This table only includes data from the Employee level.

Earnings data is preliminary in the current cycle.

Per_Snap_Curr Appt

Use this when you need campus, UCOP, or DANR data from the most current monthly cycle. This table only includes data from the Appointment level.

Earnings data is preliminary in the current cycle.

Per_Snap_Curr Dist

Use this when you need campus, UCOP, or DANR data from the most current monthly cycle. This table only includes data from the Distribution level.

Earnings data is preliminary in the current cycle.

Per_Snap_Prior

Use this when you need campus, UCOP, or DANR data from the prior monthly cycle. This table includes data from the Employee, Appointment, and Distribution levels.

Earnings data is final in the prior cycle.

Per_Snap_Prior Empl

Use this when you need campus, UCOP, or DANR data from the prior monthly cycle. This table only includes data from the Employee level.

Earnings data is final in the prior cycle.

Per_Snap_Prior Appt

Use this when you need campus, UCOP, or DANR data from the prior monthly cycle. This table only includes data from the Appointment level.

Earnings data is final in the prior cycle.

Per_Snap_Prior Dist

Use this when you need campus, UCOP, or DANR data from the prior monthly cycle. This table only includes data from the Distribution level.

Earnings data is final in the prior cycle.

Per_Snap_All

Use this when you need campus, UCOP, or DANR data from previous cycles. This table includes data from the Employee, Appointment, and Distribution levels.

The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., OCT2000).

Per_Snap_All Empl

Use this when you need campus, UCOP, or DANR data from previous cycles. This table only includes data from the Employee level.

The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., OCT2000).

Per_Snap_All Appt

Use this when you need campus, UCOP, or DANR data from previous cycles. This table only includes data from the Appointment level.

The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., OCT2000).

Per_Snap_All Dist

Use this when you need campus, UCOP, or DANR data from previous monthly cycles. This table only includes data from the Distribution level.

The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., OCT2000).

Per_FY_Curr

Use this when you need campus, UCOP, or DANR data from the current fiscal year file. This table includes data from the Employee, Appointment, and Distribution levels.

Previous months' earnings are updated throughout the fiscal year when new earnings records are submitted on campus files. The Employee and Appointment data is the most recent data for each employee.

Per_FY_Curr Emp

Use this when you need campus, UCOP, or DANR data from the current fiscal year file. This table includes data from the Employee level. This is the most recent data for each employee.

Per_FY_Curr Appt

Use this when you need campus, UCOP, or DANR data from the current fiscal year file. This table includes data from the Appointment level. This is the most recent data for each employee.

Per_FY_Curr Dist

Use this when you need campus, UCOP, or DANR data from the current fiscal year file. This table includes data from the Distribution level.

Previous months' earnings are updated throughout the fiscal year when new earnings records come in on campus files.

Per_FY_All

Use this when you need campus, UCOP, or DANR data from a previous fiscal year file. This table includes data from the Employee, Appointment, and Distribution levels.

Earnings for previous fiscal years include only those earnings which were submitted on campus files by July cycle of the selected fiscal year. The Employee and Appointment data is the most recent data submitted during the fiscal year for each employee.

The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., JUN2000). Previous fiscal years will always have an Effective Date of JUNyyyy.

Per_FY_All Emp

Use this when you need campus, UCOP, or DANR data from a previous fiscal year file. This table includes data from the Employee level. The Employee is the most recent data for each employee for the selected fiscal year.

The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., JUN2000). Previous fiscal years will always have an Effective Date of JUNyyyy.

Per_FY_All Appt

Use this when you need campus, UCOP, or DANR data from a previous fiscal year file. This table includes data from the Appointment level. The Appointment data is the most recent data for each employee for the selected fiscal year.

The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., JUN2000). Previous fiscal years will always have an Effective Date of JUNyyyy.

Per_FY_All Dist

Use this when you need campus, UCOP, or DANR data from a previous fiscal year file. This table includes data from the Distribution level.

Earnings for previous fiscal years include only those earnings which were submitted on campus files by July cycle of the selected fiscal year.

The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., JUN2000). Previous fiscal years will always have an Effective Date of JUNyyyy.

Lab/Campus Domain Table Name Use
Per_Cmp_Lab_Snap_Curr

Use this when you need to combine data from the campuses, UCOP, and DANR with that of the DOE labs, Hastings, and ASUCLA. Fields which are not applicable to the labs will be blank, or zero if numeric.

Data from the Employee, Appointment, and Distribution tables is included in this view.

Earnings data is preliminary in the current cycle.

Per_Cmp_Lab_Snap_Prior

Use this when you need to combine data from the campuses, UCOP, and DANR with that of the DOE labs, Hastings, and ASUCLA. Fields which are not applicable to the labs will be blank, or zero if numeric.

Data from the Employee, Appointment, and Distribution tables is included in this view.

Earnings data is final in the prior cycle. Data from the prior cycle is also included in the Per_Cmp_Lab_Snap_All table.

Per_Cmp_Lab_Snap_All

Use this when you need to combine data from the campuses, UCOP, and DANR with that of the DOE labs, Hastings, and ASUCLA. Fields which are not applicable to the labs will be blank, or zero if numeric.

Data from the Employee, Appointment, and Distribution tables is included in this view.

Data from the prior cycle is included in this table; data from the current cycle is not included since it is not final.

The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., OCT2000).

Per_Lab_Curr

Use this when you need DOE lab, Hastings, or ASUCLA data from the most current monthly cycle. This table includes data from the Employee, Appointment, and Distribution levels.

Earnings data is preliminary in the current cycle.

Per_Lab_Curr Empl

Use this when you need DOE lab, Hastings, or ASUCLA data from the most current monthly cycle. This table only includes data from the Employee level.

Per_Lab_Curr Appt

Use this when you need DOE lab, Hastings, or ASUCLA data from the most current monthly cycle. This table only includes data from the Appointment level.

Per_Lab_Curr Dist

Use this when you need DOE lab, Hastings, or ASUCLA data from the most current monthly cycle. This table only includes data from the Distribution level.

Earnings data is preliminary in the current cycle.

Per_Lab_Prior

Use this when you need DOE lab, Hastings, or ASUCLA data from the prior monthly cycle. This table includes data from the Employee, Appointment, and Distribution levels.

Earnings data is final in the prior cycle.

Per_Lab_Prior Empl

Use this when you need DOE lab, Hastings, or ASUCLA data from the prior monthly cycle. This table only includes data from the Employee level.

Per_Lab_Prior Appt

Use this when you need DOE lab, Hastings, or ASUCLA data from the prior monthly cycle. This table only includes data from the Appointment level.

Per_Lab_Prior Dist

Use this when you need DOE lab, Hastings, or ASUCLA data from the prior monthly cycle. This table only includes data from the Distribution level.

Earnings data is final in the prior cycle.

Per_Lab_All

Use this when you need DOE lab, Hastings, or ASUCLA data from previous cycles. This table includes data from the Employee, Appointment, and Distribution levels.

The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., OCT2000).

Per_Lab_All Empl

Use this when you need DOE lab, Hastings, or ASUCLA data from previous cycles. This table only includes data from the Employee level.

The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., OCT2000).

Per_Lab_All Appt

Use this when you need DOE lab, Hastings, or ASUCLA data from previous cycles. This table only includes data from the Appointment level.

The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., OCT2000).

Per_Lab_All Dist

Use this when you need DOE lab, Hastings, or ASUCLA data from previous cycles. This table only includes data from the Distribution level.

The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., OCT2000).

Address Domain Table Name Use
Per_Addr

Use this when you only need address data. This table only includes the home and work address, employee name, employee number, campus, and social security number.

Address data will be the most recent address available. Previous cycles of address data are not maintained.

Per_Snap_All Addr

Use this when you need to combine address data with campus, UCOP, or DANR data for any cycle.

The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., OCT2000).

Address data will be the most recent address available. Previous cycles of address data are not maintained.

Per_Snap_All Empl Addr

Use this when you need to combine address data with employee data ONLY from any cycle for campuses, UCOP, or DANR data.

The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., OCT2000).

Address data will be the most recent address available. Previous cycles of address data are not maintained.

Per_Snap_Curr Addr

Use this when you need to combine address data with campus, UCOP, or DANR data for the most current cycle.

Per_Snap_Curr Empl Addr

Use this when you need to combine address data with employee data from the most current cycle for campuses, UCOP, or DANR data.

Per_Snap_Prior Addr

Use this when you need to combine address data with campus, UCOP, or DANR data for the PRIOR cycle.

Address data will be the most recent address available. Previous cycles of address data are not maintained.

Per_Snap_Prior Empl Addr

Use this when you need to combine address data with employee data from the PRIOR cycle for campuses, UCOP, or DANR data.

Address data will be the most recent address available. Previous cycles of address data are not maintained.

Per_CmpLab Dep_All Addr

Use this when you need to combine address data with campus, UCOP, DANR, lab, Hastings, and ASUCLA employee and Dep data, for any cycle. This table does not include earnings or appointment data.

Address data will be the most recent address available. Previous cycles of address data are not maintained.

The DOE labs do not provide work address information, so those fields are blank for the three labs.

The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., OCT2000).

Per_CmpLab Dep_Curr Addr

Use this when you need to combine address data with campus, UCOP, DANR, lab, Hastings, and ASUCLA employee and Dep data, for the most current cycle. This table does not include earnings or appointment data.

Address data will be the most recent address available. Previous cycles of address data are not maintained.

The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., OCT2000).

Per_Lab_All Addr

Use this when you need DOE lab, Hastings, or ASUCLA data combined with address data, from any cycle. This table includes data from the Employee, Appointment, and Distribution levels.

Address data will be the most recent address available. Previous cycles of address data are not maintained.

The DOE labs do not provide work address information, so those fields are blank for the three labs.

The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., OCT2000).

Per_Lab_All Empl Addr

Use this when you need DOE lab, Hastings, or ASUCLA data combined with address data, from any cycle. This table only includes data from the Employee level..

Address data will be the most recent address available. Previous cycles of address data are not maintained.

The DOE labs do not provide work address information, so those fields are blank for the three labs.

The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., OCT2000).

Per_Lab_Curr Addr

Use this when you need DOE lab, Hastings, or ASUCLA data, combined with address data, from the most recent cycle. This table includes data from the Employee, Appointment, and Distribution levels.

The DOE labs do not provide work address information, so those fields are blank for the three labs.

Per_Lab_Curr Empl Addr

Use this when you need DOE lab, Hastings, or ASUCLA data, combined with address data, from the most recent cycle. This table only includes data from the Employee level.

The DOE labs do not provide work address information, so those fields are blank for the three labs.

Per_Lab_Prior Addr

Use this when you need DOE lab, Hastings, or ASUCLA data, combined with address data, from the PRIOR cycle. This table includes data from the Employee, Appointment, and Distribution levels.

Address data will be the most recent address available. Previous cycles of address data are not maintained.

The DOE labs do not provide work address information, so those fields are blank for the three labs.

Per_Lab_Prior Empl Addr

Use this when you need DOE lab, Hastings, or ASUCLA data, combined with address data, from the PRIOR cycle. This table only includes data from the Employee level.

Address data will be the most recent address available. Previous cycles of address data are not maintained.

Per_CmpLab Snap_All Addr

Use this when you need to combine address data with campus, UCOP, DANR, lab, Hastings, and ASUCLA data. This table includes data from the Employee, Appointment, and Distribution levels.

Address data will be the most recent address available. Previous cycles of address data are not maintained.

The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., OCT2000).

Per_CmpLab Snap Curr Addr

Use this when you need to combine address data with campus, UCOP, DANR, lab, Hastings, and ASUCLA employee and Dep data, for the most current cycle. This table includes data from the Employee, Appointment, and Distribution levels.

Address data will be the most recent address available. Previous cycles of address data are not maintained.

The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., OCT2000).

The DOE labs do not provide work address information, so those fields are blank for the three labs.

Per_CmpLab Snap Prior Addr

Use this when you need to combine address data with campus, UCOP, DANR, lab, Hastings, and ASUCLA employee and Dep data, for the PRIOR cycle. This table includes data from the Employee, Appointment, and Distribution levels.

Address data will be the most recent address available. Previous cycles of address data are not maintained.

The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., OCT2000).

The DOE labs do not provide work address information, so those fields are blank for the three labs.

Dep/Campus/Lab Domain Table Name Use
Per_Snap_Curr_Dependent Use this when you need dependent data from the most current monthly cycle. This table includes some employee data, so you may be able to use this without joining to the Per Snap Curr Empl table.
Per_Snap All_Dependent

Use this when you need dependent data from previous cycles. This table includes some employee data, so you may be able to use this without joining to the Per Snap Curr Empl table.

The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., OCT2000).

Per_CmpLab_Dep_Curr Use this when you need dependent data from the most current monthly cycle, and the Dependent tables above do not have enough Employee level data to meet your needs.
Per_CmpLab_Dep_All

Use this when you need dependent data from previous cycles, and the Dependent tables above do not have enough Employee level data to meet your needs.

The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., OCT2000).

Academic Domain Table Name Use
Per_Academic_Curr

Use this when you need data from the academic file for the most recent academic year.

This table only includes those data elements which are received on the academic file submitted by the campuses.

Per_Academic All

Use this when you need data from the academic file from previous academic years. The earliest academic file available is Final 2001.

This table only includes those data elements which are received on the academic file submitted by the campuses.

Title Code Domain Table Name Use
Ttl Title Rates

Use this when you need title code data and do not need employee data, or when you need specific rate information which is not available in the CPS Appointment table.