CPS Datawarehouse Table Descriptions-Lab/Campus Domain

CPS Data Warehouse Table Descriptions: Lab/Campus Domain

Table Name When to 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_FY_Curr_CmpLab
Use this when you need campus, UCOP, DANR, DOE lab, Hastings, and ASUCLA 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 the location's monthly files. The Employee and Appointment data is the most recent data for each employee.

Note: the labs, Hastings, and ASUCLA do not include valid account and fund numbers in their earnings records. They also do not use the same title codes, personnel programs, CTO codes, etc. as the campuses, so their appointment level data is fairly limited in its usefulness.

Per_FY_Curr_CmpLab Summary
Use this when you need earnings summarized for the most current fiscal year. It is most useful when the fiscal year has ended, since many transfers are performed during the last month or two of the fiscal year. This table is the one to use if you want fundsource data for all locations in one report.

This table is intended mainly for the purpose of adding up earnings, FTE, and retirement covered compensation for the fiscal year. For the labs, the only fund source is "DOE-Lab Funds", and for Hastings and ASUCLA, the fund source is "Other".

This is a summarized version of the FY table - it does not include data at the account, fund, and subacct level (which are not valid for labs, Hastings, and ASUCLA anyway), and it only includes the most basic data elements to be used for summarizing.

Note: the first year for which the summary FY table is available is fiscal year 2002-2003.

Per_FY_All_CmpLab
Use this when you need campus, UCOP, DANR, DOE lab, Hastings, and ASUCLA data from a previous 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 the location's monthly files. The Employee and Appointment data is the most recent data for each employee.

Note: the labs, Hastings, and ASUCLA do not include valid account and fund numbers in their earnings records. They also do not use the same title codes, personnel programs, CTO codes, etc. as the campuses, so their appointment level data is fairly limited in its usefulness.

Per_FY_All_CmpLab Summary
Use this when you need earnings summarized for a previous fiscal year. It is most useful when the fiscal year has ended, since many transfers are performed during the last month or two of the fiscal year. This table is the one to use if you want fundsource data for all locations in one report.

This table is intended mainly for the purpose of adding up earnings, FTE, and retirement covered compensation for the fiscal year. For the labs, the only fund source is "DOE-Lab Funds", and for Hastings and ASUCLA, the fund source is "Other".

This is a summarized version of the FY table - it does not include data at the account, fund, and subacct level (which are not valid for labs, Hastings, and ASUCLA anyway), and it only includes the most basic data elements to be used for summarizing.

Note: the first year for which the summary FY table is available is fiscal year 2002-2003.

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.

Note: The labs, Hastings, and ASUCLA do not use the same title codes, personnel programs, CTO's, or other appointment-related data elements as the campuses, so this table is of limited usefulness.

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_FY_Curr_Lab
Use this when you need DOE lab, Hastings, or ASUCLA 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 the location's monthly files. The Employee and Appointment data is the most recent data for each employee.

Note: the labs, Hastings, and ASUCLA do not include valid account and fund numbers in their earnings records. They also do not use the same title codes, personnel programs, CTO codes, etc. as the campuses, so the appointment level data is fairly limited in its usefulness.

Per_FY_Curr Lab Emp
Use this when you need DOE lab, Hastings, or ASUCLA 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_Lab_Curr_Summary
Use this when you need earnings summarized for the most current fiscal year. It is most useful when the fiscal year has ended, since many transfers are performed during the last month or two of the fiscal year.

This table is intended mainly for the purpose of adding up earnings, FTE, and retirement covered compensation for the fiscal year. For the labs, the only fund source is "DOE-Lab Funds", and for Hastings and ASUCLA, the fund source is "Other".

This is a summarized version of the FY table - it does not include data at the account, fund, and subacct level (which are not valid for labs, Hastings, and ASUCLA anyway), and it only includes the most basic data elements to be used for summarizing.

Note: the first year for which the summary FY table is available is fiscal year 2002-2003.

Per_FY_All_Lab
Use this when you need DOE lab, Hastings, or ASUCLA 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 the location's monthly files. The Employee and Appointment data is the most recent data for each employee.

Note: the labs, Hastings, and ASUCLA do not include valid account and fund numbers in their earnings records. They also do not use the same title codes, personnel programs, CTO codes, etc. as the campuses, so the appointment level data is fairly limited in its usefulness.

Per_FY_All Lab Emp
Use this when you need DOE lab, Hastings, or ASUCLA 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_Lab_All Summary
Use this when you need earnings summarized for a previous fiscal year. It is most useful when the fiscal year has ended, since many transfers are performed during the last month or two of the fiscal year.

This table is intended mainly for the purpose of adding up earnings, FTE, and retirement covered compensation for the fiscal year. For the labs, the only fund source is "DOE-Lab Funds", and for Hastings and ASUCLA, the fund source is "Other".

This is a summarized version of the FY table - it does not include data at the account, fund, and subacct level (which are not valid for labs, Hastings, and ASUCLA anyway), and it only includes the most basic data elements to be used for summarizing.

Note: the first year for which the summary FY table is available is fiscal year 2002-2003.

Last Updated:August 31, 2004

Return to Personnel Data Warehouse Home Page

Table Name	When to 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_FY_Curr_CmpLab	Use this when you need campus, UCOP, DANR, DOE lab, Hastings, and ASUCLA 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 the location's monthly files. The Employee and Appointment data is the most recent data for each employee. Note: the labs, Hastings, and ASUCLA do not include valid account and fund numbers in their earnings records. They also do not use the same title codes, personnel programs, CTO codes, etc. as the campuses, so their appointment level data is fairly limited in its usefulness.
Per_FY_Curr_CmpLab Summary	Use this when you need earnings summarized for the most current fiscal year. It is most useful when the fiscal year has ended, since many transfers are performed during the last month or two of the fiscal year. This table is the one to use if you want fundsource data for all locations in one report. This table is intended mainly for the purpose of adding up earnings, FTE, and retirement covered compensation for the fiscal year. For the labs, the only fund source is "DOE-Lab Funds", and for Hastings and ASUCLA, the fund source is "Other". This is a summarized version of the FY table - it does not include data at the account, fund, and subacct level (which are not valid for labs, Hastings, and ASUCLA anyway), and it only includes the most basic data elements to be used for summarizing. Note: the first year for which the summary FY table is available is fiscal year 2002-2003.
Per_FY_All_CmpLab	Use this when you need campus, UCOP, DANR, DOE lab, Hastings, and ASUCLA data from a previous 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 the location's monthly files. The Employee and Appointment data is the most recent data for each employee. Note: the labs, Hastings, and ASUCLA do not include valid account and fund numbers in their earnings records. They also do not use the same title codes, personnel programs, CTO codes, etc. as the campuses, so their appointment level data is fairly limited in its usefulness.
Per_FY_All_CmpLab Summary	Use this when you need earnings summarized for a previous fiscal year. It is most useful when the fiscal year has ended, since many transfers are performed during the last month or two of the fiscal year. This table is the one to use if you want fundsource data for all locations in one report. This table is intended mainly for the purpose of adding up earnings, FTE, and retirement covered compensation for the fiscal year. For the labs, the only fund source is "DOE-Lab Funds", and for Hastings and ASUCLA, the fund source is "Other". This is a summarized version of the FY table - it does not include data at the account, fund, and subacct level (which are not valid for labs, Hastings, and ASUCLA anyway), and it only includes the most basic data elements to be used for summarizing. Note: the first year for which the summary FY table is available is fiscal year 2002-2003.
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. Note: The labs, Hastings, and ASUCLA do not use the same title codes, personnel programs, CTO's, or other appointment-related data elements as the campuses, so this table is of limited usefulness.
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_FY_Curr_Lab	Use this when you need DOE lab, Hastings, or ASUCLA 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 the location's monthly files. The Employee and Appointment data is the most recent data for each employee. Note: the labs, Hastings, and ASUCLA do not include valid account and fund numbers in their earnings records. They also do not use the same title codes, personnel programs, CTO codes, etc. as the campuses, so the appointment level data is fairly limited in its usefulness.
Per_FY_Curr Lab Emp	Use this when you need DOE lab, Hastings, or ASUCLA 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_Lab_Curr_Summary	Use this when you need earnings summarized for the most current fiscal year. It is most useful when the fiscal year has ended, since many transfers are performed during the last month or two of the fiscal year. This table is intended mainly for the purpose of adding up earnings, FTE, and retirement covered compensation for the fiscal year. For the labs, the only fund source is "DOE-Lab Funds", and for Hastings and ASUCLA, the fund source is "Other". This is a summarized version of the FY table - it does not include data at the account, fund, and subacct level (which are not valid for labs, Hastings, and ASUCLA anyway), and it only includes the most basic data elements to be used for summarizing. Note: the first year for which the summary FY table is available is fiscal year 2002-2003.
Per_FY_All_Lab	Use this when you need DOE lab, Hastings, or ASUCLA 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 the location's monthly files. The Employee and Appointment data is the most recent data for each employee. Note: the labs, Hastings, and ASUCLA do not include valid account and fund numbers in their earnings records. They also do not use the same title codes, personnel programs, CTO codes, etc. as the campuses, so the appointment level data is fairly limited in its usefulness.
Per_FY_All Lab Emp	Use this when you need DOE lab, Hastings, or ASUCLA 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_Lab_All Summary	Use this when you need earnings summarized for a previous fiscal year. It is most useful when the fiscal year has ended, since many transfers are performed during the last month or two of the fiscal year. This table is intended mainly for the purpose of adding up earnings, FTE, and retirement covered compensation for the fiscal year. For the labs, the only fund source is "DOE-Lab Funds", and for Hastings and ASUCLA, the fund source is "Other". This is a summarized version of the FY table - it does not include data at the account, fund, and subacct level (which are not valid for labs, Hastings, and ASUCLA anyway), and it only includes the most basic data elements to be used for summarizing. Note: the first year for which the summary FY table is available is fiscal year 2002-2003.