CPS Data Warehouse Table Descriptions:

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.

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.

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.

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.

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.

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.

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.

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.

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).

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).

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).

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).

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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).

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.

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.

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.

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.

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.

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.

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.

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).

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).

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).

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).

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.

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.

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.

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

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

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.

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.

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).

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).

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).

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).

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.

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.

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.

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.

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).

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.

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.

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).

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).

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.

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.

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.