CPS Datawarehouse Table Descriptions

CPS Data Warehouse Table Descriptions:

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

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

Last Updated: September 4, 2001

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