Personnel Data Warehouse

Snapshot Cycles Available as of November 13, 2009:

Note: All snapshots cycles are placed in the ALL table once the cycle is considered final.  The only table
which contains preliminary data is the CURRENT table (e.g., Per_Snap_Curr).

Cycle Comments
October 2009 (CURRENT) Campuses have converted a number of faculty appointment and/or distribution records to pay a portion of their general-funded salary from Contracts and Grants or Federal funds.  The portion of this salary which has been converted to C&G or Federal funds has a PPS DOS code of "FEP".  More information on how this data is reflected in CPS will be provided soon.

You can find information on how the standard salary reduction/furlough is reflected in CPS data here. 

See August comments about Leave usage and accrual (DOS code "LV") or visit this webpage:

 http://www.ucop.edu/irc/dd/cps/dw/LeaveHoursExamples.html
September 2009 (PRIOR) September 2009 was the first month of the Universitywide furlough program. 

As of the end of  September, employees covered by a collective bargaining had not had their salaries reduced.  About 42,000 employees systemwide have had their salaries reduced under this program so far..

You can find information on how the salary reduction is reflected in CPS data here. 

See August comments about Leave usage and accrual (DOS code "LV") or visit this webpage:

 http://www.ucop.edu/irc/dd/cps/dw/LeaveHoursExamples.html
August 2009 The July 2009 snapshot now includes Leave DOS codes (CPS DOS code "LV") in the distribution segment.  These records represent either leave hours (i.e., vacation, sick, comp time, etc.) accrued or leave hours taken.  They should NOT be included in most queries - only those for which you want to specifically exclude leave hours which have been paid or to specifically include them.

Distribution records with a CPS DOS code of "LV" and Payment Category Code of "L" represent leave hours taken.  These hours should be subtracted from total hours if the intent is to calculate total hours of effort. 

Records with a DOS code of "LV" and Payment Category of "A" represent corrections to hours accrued; they cannot be used to calculate the total hours of leave accrued.  They should not be added to or subtracted from total hours; they should simply be excluded from the calculation of total hours or FTE. 

Examples of LV distributions and defined fields which can be created in WebFocus to handle the LV records can be found here:

http://www.ucop.edu/irc/dd/cps/dw/LeaveHoursExamples.html

Because leave usage/accrual is frequently processed after the fact, the "LV" transactions will not usually arrive on the distribution file for the month in which they were taken.  You will need to check the PRIOR/ALL snapshot to get leave data for a given month.

Please note that San Diego does  not use this mechanism for calculating leave accrual and usage, so they have no distribution records with DOS code "LV" at this time. 

July 2009  The July 2009 snapshot now includes Leave DOS codes (CPS DOS code "LV") in the distribution segment.  These records represent either leave hours (i.e., vacation, sick, comp time, etc.) accrued or leave hours taken.  They should NOT be included in most queries - only those for which you want to specifically exclude leave hours or specifically include them.

Distribution records with a CPS DOS code of "LV" and Payment Category Code of "L" represent leave hours taken.  These hours should be subtracted from total hours if the intent is to calculate total hours of effort. 

Records with a DOS code of "LV" and Payment Category of "A" represent corrections to hours accrued; they cannot be used to calculate the total hours of leave accrued.  They should not be added to or subtracted from total hours; they should simply be excluded from the calculation of total hours or FTE.

Because leave usage/accrual is generally processed after the fact, the "LV" transactions will not usually arrive on the distribution file for the month in which they were taken.  You will need to check the PRIOR/ALL snapshot to get leave data for a given month.

Please note that San Diego does  not use this mechanism for calculating leave accrual and usage, so they have no distribution records with DOS code "LV" at this time. 

June 2009   The June 2009 snapshot now includes Leave DOS codes (CPS DOS code "LV") in the distribution segment.  These records represent either leave hours (i.e., vacation, sick, comp time, etc.) accrued or leave hours taken.  They should NOT be included in most queries - only those for which you want to specifically exclude leave hours or specifically include them.

Distribution records with a CPS DOS code of "LV" and Payment Category Code of "L" represent leave hours taken.  These hours should be subtracted from total hours if the intent is to calculate total hours of effort. 

Records with a DOS code of "LV" and Payment Category of "A" represent corrections to hours accrued; they cannot be used to calculate the total hours of leave accrued.  They should not be added to or subtracted from total hours; they should simply be excluded from the calculation of total hours or FTE.

Because leave usage/accrual is generally processed after the fact, the "LV" transactions will not usually arrive on the distribution file for the month in which they were taken.  You will need to check the PRIOR/ALL snapshot to get leave data for a given month.

Please note that San Diego does  not use this mechanism for calculating leave accrual and usage, so they have no distribution records with DOS code "LV". 

Continuing Education of the Bar - each month, CEB employees are paid from UC Systemwide accounts .  The following month, adjustments are made to earnings from the previous month to credit the UCOP accounts and debit UCLA accounts.  Many CEB employees have Home Departments that are not University Extension or Continuing Education of the Bar.  The UCLA ORG_1 code is 48400 in CPS and 8400 in the Account Fund Profile; the UCOP ORG_1 code is 48300 (Provost & Exec VP-Academic Aff) in CPS and 8300 in the Account Fund Profile. 

If you use the CURRENT (Preliminary) snapshot, CEB employees will appear to have been paid by UCOP, since the adjustments have not occurred yet.  When using PRIOR/ALL Snapshot, or the FY table, you must sum the earnings, FTE, or hours and only include those which add up to a total greater than zero in order to display only the UCLA earnings.

May 2009   UC Berkeley implemented a new set of PSS and MSP title codes with Grade Type "CC" (Career Compass) and grades 15 through 30.  For employees who were slotted into the new titles, the former appointment was ended with an Appointment End Date of  04/30/09 and a new appointment was established with an Appointment Begin Date of 05/01/09 and an indefinite end date.
April 2009   Adjustments to distribution data to move Continuing Education of the Bar employees from UCOP to UCLA appear to be complete.  Many CEB employees have Home Departments that are not University Extension or Continuing Education of the Bar.  You can identify CEB employees by using the ORG_1 code; it is 48400 in CPS and 8400 in the Account Fund Profile. 
March 2009  Adjustments are being made to move Continuing Education of the Bar employees from UCOP to UCLA.  It appears that earnings from previous months are being transferred between UCOP and UCLA accounts, so you will find CEB employees with LOCNM_13 values of "UCOP" and gross earnings and FTE of 0.  Those same employees will have earnings where the LOCNM_13 value is "Los Angeles" and earnings and FTE are positive.  Be very careful when trying to track UCOP employees or CEB employees throughout time. 
February 2009  Official W2 data, as reported to the IRS for calendar year 2008, is available in the Taxable Gross Cal Prior and Total Gross Cal Ytd Prior fields.

The Highly Compensated flag is based on Calendar Year 2008 W2 total gross earnings of $105,000. 
January 2009  Medical, dental, vision, and legal premiums in the January 2009 tables are calendar year 2009 rates. 

The highly compensated flag is based on total earnings of  $105,000 or more on the W2 for the prior year.  The prior year W2 data for January is calculated from earnings reported to CPS as of December 31st.  Official  W2 data as reported to the IRS should be available for 2008 when we build the February 2009 snapshot.
December 2008  As is the case every December, some benefits coverage codes and plan codes do not match; some apply to December and some apply to January.  December is not a good month to report on benefits coverage.  The rates in the data warehouse for December 2008 are calendar year 2008 rates.
November 2008  The HCRA Indicator gets reset on December 1st each year if the employee has no HCRA deductions remaining for the current calendar year.  For this reason, the HCRA Indicator is not accurate in the November snapshot.  It is not advisable to use the November file to examine HCRA data. 
October 2008    
September 2008   
August 2008   
July 2008   
June 2008   
May 2008   
April 2008    
March 2008  Blank Sublocation codes have been converted to ** to allow a proper join to TCS tables for those title codes which have not been assigned a Sublocation.
February 2008   The medical, dental, and optical premiums  - UC-paid, employee-paid, and total - are the January 2008 rates.  The Benefits Eligibility Unit code is not taken into account in calculating the medical rates; these are the standard premiums based on the employee's medical contribution base, plan code, and coverage code.

Prior Year Taxable Gross and Prior Year Total Gross are now the 2007 calendar year grosses. 

We now have email addresses for many ASUCLA employees. 

Lawrence Livermore National Laboratory is no longer covered by UC benefits or the UC Retirement Plan (UCRP).  Starting with October 2007, the lab is not included in the Corporate Personnel System.
January 2008  The medical, dental, and optical premiums  - UC-paid, employee-paid, and total - are the January 2008 rates.  The Benefits Eligibility Unit code is not taken into account in calculating the medical rates; these are the standard premiums based on the employee's medical contribution base, plan code, and coverage code.

New fields have been added for the Armed Forces Service Medal (Employee table) and the Derived Percent (Distribution table). The Derived Percent should only be used for Effort Reporting/NIH Salary Cap purposes; Time_Distribution is the field which should be used for Actual FTE.

Prior Year Taxable Gross and Prior Year Total Gross are still the 2006 calendar year grosses.  W2 data for 2007 arrives soon and will be represented in the February snapshot database.

Lawrence Livermore National Laboratory is no longer covered by UC benefits or the UC Retirement Plan (UCRP).  Starting with October 2007, the lab is not included in the Corporate Personnel System.
December 2007 Lawrence Livermore National Laboratory is no longer covered by UC benefits or the UC Retirement Plan (UCRP).  Starting with October 2007, the lab is not included in the Corporate Personnel System.

As is the case every December, some benefits coverage codes and plan codes do not match; some apply to December and some apply to January.  December is not a good month to report on benefits coverage.  The rates in the data warehouse are calendar year 2007 rates.
November 2007 Lawrence Livermore National Laboratory is no longer covered by UC benefits or the UC Retirement Plan (UCRP).  Starting with October 2007, the lab is not included in the Corporate Personnel System.

The HCRA Indicator gets reset on December 1st each year if the employee has no HCRA deductions remaining for the current calendar year.  For this reason, the HCRA Indicator is not accurate in the November snapshot.  It is not advisable to use the November file to examine HCRA data. 

October 2007  Lawrence Livermore National Laboratory is no longer covered by UC benefits or the UC Retirement Plan (UCRP).  Starting with October 2007, the lab is not included in the Corporate Personnel System.
September 2007  
August 2007  
July 2007  
June 2007   
May 2007  
April 2007 Merced seems to have gotten all of their titles into TCS, so the appointment data for Merced is much improved.
March 2007  Merced still has a few PSS title codes missing from TCS.  For employees in those titles, the appointment data which is obtained from TCS is missing.  This includes such fields as personnel program, Class Title Outline, Federal Occupational Subcategory Code, FLSA status, etc., as well as the min, mid, and max salaries for the range.  This data will be updated in CPS as it is updated in TCS. 
February 2007  Prior Year total and taxable gross fields now contain 2006 earnings from the W2.

Merced still has a few PSS title codes missing from TCS.  For employees in those titles, the appointment data which is obtained from TCS is missing.  This includes such fields as personnel program, Class Title Outline, Federal Occupational Subcategory Code, FLSA status, etc., as well as the min, mid, and max salaries for the range.  This data will be updated in CPS as it is updated in TCS. 

January 2007  Medical, dental, and optical employee-paid and UC-paid premiums are calculated using the 2007 rates and the new Medical Contribution Base (MCB) tier structure.

Merced still has a few PSS title codes missing from TCS.  For employees in those titles, the appointment data which is obtained from TCS is missing.  This includes such fields as personnel program, Class Title Outline, Federal Occupational Subcategory Code, FLSA status, etc., as well as the min, mid, and max salaries for the range.  This data will be updated in CPS as it is updated in TCS. 
December 2006  Three new fields have been added to the Employee segment: Ben_Unit_Code, Ben_Rep_Code, and Ben_Unit_Der.  These codes are all related to the bargaining unit which is to be considered the predominant unit for benefit purposes, such as for health insurance plan selection or employee-paid premiums.  

Merced still has a few PSS title codes missing from TCS.  For employees in those titles, the appointment data which is obtained from TCS is missing.  This includes such fields as personnel program, Class Title Outline, Federal Occupational Subcategory Code, FLSA status, etc., as well as the min, mid, and max salaries for the range.  This data will be updated in CPS as it is updated in TCS. 

November 2006 A number of new fields have been added to the Distribution segment, all related to the Description of Service code from PPS.  The CPS DOS description and PPS DOS description have both been added to the October snapshot.  This should make analysis of DOS code mapping easier.  We intend to load these same fields into previous months' snapshot tables from fiscal year 2006-07, as time permits.

Merced still has a few PSS title codes missing from TCS.  For employees in those titles, the appointment data which is obtained from TCS is missing.  This includes such fields as personnel program, Class Title Outline, Federal Occupational Subcategory Code, FLSA status, etc., as well as the min, mid, and max salaries for the range.  This data will be updated in CPS as it is updated in TCS.
October 2006  A number of new fields have been added to the Distribution segment, all related to the Description of Service code from PPS.  The CPS DOS description and PPS DOS description have both been added to the October snapshot.  This should make analysis of DOS code mapping easier.  We intend to load these same fields into previous months' snapshot tables from fiscal year 2006-07, as time permits.

The new fields SLCG Grade and SLCG Grade Effective Date have been added to the Employee table.  All of the campuses have assigned SLCG grades to some of their employees.

Santa Barbara, UCLA and Irvine have started adding Special_Training_Codes for  some of their employees.  The other campuses have not yet populated the field.  This field is used to select employees who are required to take Sexual Harassment Training but cannot be identified using the standard selection criteria for that training.

Merced still has a few PSS title codes missing from TCS.  For employees in those titles, the appointment data which is obtained from TCS is missing.  This includes such fields as personnel program, Class Title Outline, Federal Occupational Subcategory Code, FLSA status, etc., as well as the min, mid, and max salaries for the range.  This data will be updated in CPS as it is updated in TCS.
September 2006  The new fields SLCG Grade and SLCG Grade Effective Date have been added to the Employee table.  Five of the campuses have assigned SLCG grades to some of their employees.

UCLA and Irvine have started adding Special_Training_Codes for  some of their employees.  The other campuses have not yet populated the field.  This field is used to select employees who are required to take Sexual Harassment Training but cannot be identified using the standard selection criteria for that training.

Merced still has a few PSS title codes missing from TCS.  For employees in those titles, the appointment data which is obtained from TCS is missing.  This includes such fields as personnel program, Class Title Outline, Federal Occupational Subcategory Code, FLSA status, etc., as well as the min, mid, and max salaries for the range.  This data will be updated in CPS as it is updated in TCS.
August 2006  Los Alamos (LANL) is no longer covered by UC retirement and benefits programs effective June 2006, so the lab snapshot and FY files for July 2006 contain no LANL (campus 23) employees). 

Special_Training_Code has not yet been populated by any of the campuses.  This field will be used to select employees who are required to take Sexual Harassment Training but cannot be identified using the standard selection criteria for that training.

Merced still has a few PSS title codes missing from TCS.  For employees in those titles, the appointment data which is obtained from TCS is missing.  This includes such fields as personnel program, Class Title Outline, Federal Occupational Subcategory Code, FLSA status, etc., as well as the min, mid, and max salaries for the range.  This data will be updated in CPS as it is updated in TCS.
July 2006  Los Alamos (LANL) is no longer covered by UC retirement and benefits programs effective June 2006, so the lab snapshot and FY files for July 2006 contain no LANL (campus 23) employees). 

Special_Training_Code has not yet been populated by any of the campuses.  This field will be used to select employees who are required to take Sexual Harassment Training but cannot be identified using the standard selection criteria for that training.

Merced still has a few PSS title codes missing from TCS.  For employees in those titles, the appointment data which is obtained from TCS is missing.  This includes such fields as personnel program, Class Title Outline, Federal Occupational Subcategory Code, FLSA status, etc., as well as the min, mid, and max salaries for the range.  This data will be updated in CPS as it is updated in TCS.
June 2006  Los Alamos (LANL) is no longer covered by UC retirement and benefits programs effective June 2006, so the lab snapshot for June 2006 contains no LANL (campus 23) employees). 

Special_Training_Code has not yet been populated by any of the campuses.  This field will be used to select employees who are required to take Sexual Harassment Training but cannot be identified using the standard selection criteria for that training.

Merced still has a few PSS title codes missing from TCS.  For employees in those titles, the appointment data which is obtained from TCS is missing.  This includes such fields as personnel program, Class Title Outline, Federal Occupational Subcategory Code, FLSA status, etc., as well as the min, mid, and max salaries for the range.  This data will be updated in CPS as it is updated in TCS.
May 2006 A new field called Special_Training_Code has been added but is not yet populated from the Payroll System.  This field will be used to select employees who are required to take Sexual Harassment Training but cannot be identified using the standard selection criteria for that training.

Merced still has a few PSS title codes missing from TCS.  For employees in those titles, the appointment data which is obtained from TCS is missing.  This includes such fields as personnel program, Class Title Outline, Federal Occupational Subcategory Code, FLSA status, etc., as well as the min, mid, and max salaries for the range.  This data will be updated in CPS as it is updated in TCS.
April 2006 (PRIOR) Merced still has a few PSS title codes missing from TCS.  For employees in those titles, the appointment data which is obtained from TCS is missing.  This includes such fields as personnel program, Class Title Outline, Federal Occupational Subcategory Code, FLSA status, etc., as well as the min, mid, and max salaries for the range.  This data will be updated in CPS as it is updated in TCS.
March 2006 Merced has many fewer PSS title codes missing from TCS than in previous months - there currently are fewer than 50 Merced employees with title codes that are not in TCS.  For those employees, the appointment data which is obtained from TCS is missing.  This includes such fields as personnel program, Class Title Outline, Federal Occupational Subcategory Code, FLSA status, etc., as well as the min, mid, and max salaries for the range.  This data will be updated in CPS as it is updated in TCS.
February 2006  The field Gradetype has been added to the appointment segment.  This field indicates which set of grades is applicable to the title code in question.

A new location field, Locnm_Comp has been added at the Distribution level, at the request of the HR Compensation unit.  This field includes the School of Medicine as part of  the Medical Center at UC Davis and UCLA.

A new field called Postdoc has been added at the Employee level so that postdoctoral scholars may be easily identified.

A new field called WOS_Emp has been added to the Employee segment to identify employees who have a Without Salary indicator in the payroll system. 

Budg_fund has been added to the snapshot table.  Previously it was stored only in the fiscal year table.  This field indicates whether the fund is identified in the Corporate Account Fund Profile (CAFP) as  a budgeted fund. 

Merced has many fewer PSS title codes missing from TCS than in previous months - there currently are fewer than 50 Merced employees with title codes that are not in TCS.  For those employees, the appointment data which is obtained from TCS is missing.  This includes such fields as personnel program, Class Title Outline, Federal Occupational Subcategory Code, FLSA status, etc., as well as the min, mid, and max salaries for the range.  This data will be updated in CPS as it is updated in TCS.
January 2006  The medical, dental, and vision premiums now reflect 2006 rates. 

2005 taxable and total gross earnings are reflected in the Total_Gross_Cal_YTD_Prior and Taxable_Gross_Cal_Prior fields in the January snapshot.

The Highly_Comp_Flag is now set to "Y" for employees whose total gross earnings for 2005 were greater than $95,000.

Merced still has many PSS title codes missing from TCS, so the appointment data which is obtained from TCS is missing for those titles in CPS.  This includes such fields as personnel program, Class Title Outline, Federal Occupational Subcategory Code, FLSA status, etc., as well as the min, mid, and max salaries for the range.  This data will be updated in CPS as it is updated in TCS.
December 2005  As is the case every December, some benefits coverage codes and plan codes do not match; some apply to December and some apply to January.  December is not a good month to report on benefits coverage.

Merced still has many PSS title codes missing from TCS, so the appointment data which is obtained from TCS is missing for those titles in CPS.  This includes such fields as personnel program, Class Title Outline, Federal Occupational Subcategory Code, FLSA status, etc., as well as the min, mid, and max salaries for the range.  This data will be updated in CPS as it is updated in TCS.
November 2005 Merced still has many PSS title codes missing from TCS, so the appointment data which is obtained from TCS is missing for those titles in CPS.  This includes such fields as personnel program, Class Title Outline, Federal Occupational Subcategory Code, FLSA status, etc., as well as the min, mid, and max salaries for the range.  This data will be updated in CPS as it is updated in TCS.
October 2005 (PRIOR) Fundsource now classifies fundgroups beginning with '4081' or '4082' as "Other Funds" instead of "Contracts and Grants."  Per George Ohye in Financial Management, these are private gifts and should not be considered contracts and grants.

Data is no longer being loaded into the Executive Severance fields.  The severance data will remain in tables for previous cycles, but should not be relied upon for accuracy.

Postdoctoral Fellows (title code 3253) and "Postdoc- Paid Directs" (title code 3254) are included even if they do not have an assigned or derived BELI of "P" and have no appointment or distribution information.  SF has its own benefits plans for these postdocs so they do not assign them a BELI of "P".  They can be selected by selecting Title_Code_Primary_Appt equals '3253' or '3254'.
September 2005   
August 2005  
July 2005  The snapshot now includes Merced as a separate location, location 1 = 10.

The Title Name Pri Appt is now available in the employee segment.

Merced title code attribute data which is obtained from the Title Code System is blank for many title codes.  It will be populated as Merced provides TCS data to UCOP.
June 2005   
May 2005   
April 2005  
March 2005 The snapshot now includes premium data for  medical, dental, and optical insurance.
February 2005  The taxable and total gross earnings reported on the 2004 W2 have been updated.
January 2005  Non-employee postdocs are now included in the snapshot whether or not they have payroll earnings during the month.  They can be identified by title code 3253 and 3254, by assigned or derived BELI of "P", or by medical plan codes "P1" and "P2".  Postdocs in title code 3252 are considered employees and are eligible for employee benefit plans.

Riverside HCRA and Depcare data was not submitted this month.
December 2004 ) There is a mixture of coverage codes and plan codes; some represent the employee's coverage effective January 1, 2005, and some represent the employee's December coverage. December is not a good month to report on benefits data due to this inconsistency.
November 2004   
October 2004   
September 2004

 
August 2004   
June 2004

A number of new defined and actual fields have been added to the data warehouse. See http://www.ucop.edu/irc/dd/cps/ChangesJune2004.html for more information.
May 2004  
April 2004

SF is now submitting data in the Salary Step field for both academic and staff employees. Use the Salary Step field, when appropriate, for all campuses.
March 2004

SF is now submitting data in the Salary Step field for both academic and staff employees. Use the Salary Step field, when appropriate, for all campuses.

The total and taxable gross earnings fields for the prior year have been updated and reflect calendar year 2003 earnings.
February 2004

SF is now submitting data in the Salary Step field for both academic and staff employees. Use the Salary Step field, when appropriate, for all campuses.

LANL submitted some records with obsolete medical plan codes for February 2004. Please do not use the February snapshot to report on medical plans for the DOE labs. January 2004 and March 2004 snapshots both report the correct medical plan codes.
January 2004

Several campuses are reporting a few employees with Recently Separated Veterans Dates. However, in most cases, the field is not used as expected - the veteran separation dates are not within one year of the employee's hire date. It is possible that campuses might be using this field for some employees who are in the reserves and recently completed active military service as a reserve.
December 2003

There is a mixture of coverage codes and plan codes; some represent the employee's coverage effective January 1, 2004, and some represent the employee's December coverage. December is not a good month to report on benefits data due to this inconsistency.

SF continues to submit no data in the Salary Step field. Use Salary Grade for SF employees.

Several campuses are reporting a few employees with Recently Separated Veterans Dates. However, in most cases, the field is not used correctly - the veteran separation dates are not within one year of the employee's hire date.
November 2003

SF continues to submit no data in the Salary Step field. Use Salary Grade for SF employees.

Several campuses are reporting a few employees with Recently Separated Veterans Dates. However, in most cases, the field is not used correctly - the veteran separation dates are not within one year of the employee's hire date.
October 2003

SF continues to submit no data in the Salary Step field. Use Salary Grade for SF employees.

Several campuses are reporting a few employees with Recently Separated Veterans Dates. However, in most cases, the field is not used correctly - the veteran separation dates are not within one year of the employee's hire date.

Depcare Annual Amount and Depcare Termination Date have been added to the Snapshot and FY tables.

Home zip code has been added to the Employee tables (and Emp,Apt, Dst views). If the only address field you need is the home zip code, you can use these tables rather than a view which includes the Address table.
September 2003

SF continues to submit no data in the Salary Step field. Use Salary Grade for SF employees.

Several campuses are reporting a few employees with Recently Separated Veterans Dates. However, in most cases, the field is not used correctly - the veteran separation dates are not within one year of the employee's hire date.

SMG severance pay exception indicator and SMG override contribution rate fields are now in the Snapshot and FY tables.

August 2003

SF continues to submit no data in the Salary Step field. Use Salary Grade for SF employees.

Several campuses are reporting a few employees with Recently Separated Veterans Dates. However, in most cases, the field is not used correctly - the veteran separation dates are not within one year of the employee's hire date.

SMG severance pay exception indicator and SMG override contribution rate fields are now in the Snapshot and FY tables.

July 2003

SF continues to submit no data in the Salary Step field. Use Salary Grade for SF employees.

Several campuses are reporting a few employees with Recently Separated Veterans Dates. However, in most cases, the field is not used correctly - the veteran separation dates are not within one year of the employee's hire date.
June 2003

START data is now available.

SF continues to submit no data in the Salary Step field. Use Salary Grade for SF employees.

LA has reported four employees with Recently Separated Veterans Dates (Sep_Vet_Date).

SD and DV are reporting a few employees with Recently Separated Veterans Dates. However, neither campus is using the field correctly - the dates are not within one year of the employee's hire date.
May 2003

SF continues to submit no data in the Salary Step field. Use Salary Grade for SF employees.

LA has reported one employee with Recently Separated Veterans Date (Sep_Vet_Date).

SD is reporting a few employees with Recently Separated Veterans Dates. However, they are not using the field correctly - the dates are not within one year of the employee's hire date.
April 2003

SF continues to submit no data in the Salary Step field. Use Salary Grade for SF employees.

SD has started reporting a few employees with Recently Separated Veterans Dates (Sep_Vet_Date). However, they are not using the field correctly - the dates are not within one year of the employee's hire date.
March 2003 SF continues to submit no data in the Salary Step field. Use Salary Grade for SF employees.
February 2003 

This cycle contains the Prior Year Taxable and Total Gross for the calendar year 2002.

SF continues to submit no data in the Salary Step field. Use Salary Grade for SF employees.
January 2003 

This cycle contains the new coverage codes, medical plan codes, medical contribution salary base for current and next year, and HCRA data for 2003.

SF continues to submit no data in the Salary Step field. Use Salary Grade for SF employees.
December 2002 

This cycle contains some mismatched data from campuses and labs; some submitted 2003 coverage codes with the 2002 medical plan codes; LANL has a lot of missing data, including DEPCARE. Campuses generally have a DEPCARE YTD amount that reflects payments for 2003 (since payment is taken from December paycheck), while the labs usually have YTD amounts for 2002.

SF continues to submit no data in the Salary Step field. Use Salary Grade for SF employees.
November 2002 SF continues to submit no data in the Salary Step field. Use Salary Grade for SF employees.
October 2002 All campuses other than SF submitted Salary Step data in the Salary Step field this cycle. Use Salary Grade for SF employees.
September 2002 There were still some campuses submitting Salary Step data in the Salary Grade field this cycle.
August 2002  
July 2002 
Some campuses started submitting Salary Step in the Salary Step field this cycle. Others still submitted salary step in the Salary Grade field, as in the past. Both fields must be checked to retrieve salary step.
June 2002   
May 2002   
April 2002   
March 2002

 
February 2002 

 
January 2002   
December 2001 

 

November 2001  
October 2001  
September 2001 Appointment data may be missing for some employees/titles for this cycle.
August 2001

Appointment data may be missing for some employees/titles for this cycle.
July 2001

Appointment data may be missing for some employees/titles for this cycle.
June 2001  
May 2001

Santa Barbara Employee numbers were changed for this cycle.
April 2001 Riverside Employee numbers were changed for this cycle.
March 2001  
February 2001  
January 2001  
December 2000  
November 2000 Davis Employee numbers changed this cycle.
October 2000 Employee numbers for Davis, Riverside, and Santa Barbara have all been converted to the new Employee numbers in the October 2000 cycle in order to match later cycles.
September 2000 In Per_Snap_All tables - UCLA submitted incorrect Location 2 codes for UCOP employees this cycle. UCOP employees have a Location 2 code of "1" for this cycle only.
August 2000

 
July 2000 UCOP Employees changed from Berkeley payroll to UCLA; UCOP Employee numbers changed this cycle.
October 1999 While UCOP Employees changed from Berkeley payroll to UCLA in July 2000; UCOP Employee numbers were changed for the October 1999 cycle in order to allow us to produce reports which followed UCOP employees from one October to the next.
October 1998  
October 1997  
October 1996  
October 1994 The UC personnel programs changed in 1995.  Before 1995, the personnel programs were A for Academic (still used), E for Executive, M for MAP, P for A&PS, and S for Staff.

The Account Fund Profile (AFP) was changed in 1995; Snapshot cycles before 1995 do not have the Org 2  field, ACCTGROUP, or FUNDGROUP.  The length of the ORG1  and ORG3 codes was shorter before 1995.
October 1993 The UC personnel programs changed in 1995.  Before 1995, the personnel programs were A for Academic (still used), E for Executive, M for MAP, P for A&PS, and S for Staff.

The Account Fund Profile (AFP) was changed in 1995; Snapshot cycles before 1995 do not have the Org 2  field, ACCTGROUP, or FUNDGROUP.  The length of the ORG1  and ORG3 codes was shorter before 1995.