Fix to Import Pay Tables after 1/1/2010
Utility 50 to Recalculate Pay Table Codes
Utility 51 to Reprocess CB/CF Comp Time Codes
The following files are useful to registered users only.
PAY_1008.EXE - (1075 KB) contains the files PAY_1008.DBF, PAY_1008.CDX and PAY_1008.FPT. These files contain pay tables published through 31 May 2010.
To use these rates in Budget Builder:
1. Download then double click PAY_1008.EXE to extract the three files.
2. Put these three files in your Budget Builder directory
3. In Budget Builder click Pay Rates Menu (or Pay Rates Files) and choose Open Files Dialog
4. Select PAY_1008.DBF as the active pay rates file. PAY_1008 will show on the CivPers screen.
Note - If you extract files in PAY_1008.EXE directly to your Budget Builder directory steps 1 and 2 will be done at the same time.
BENE_10.EXE - (154 KB) contains the files BENE_10.DBF and BENE_10.CDX with benefit rates updated for 2010.
To use these rates in Budget Builder:
1. Download then double click BENE_10.EXE to extract the two files.
2. Put these two files in your Budget Builder directory
3. In Budget Builder click Benefits Rates Menu (or Benefit Rates Files) and choose Open Files Dialog
4. Select BENE_10.DBF as the active benefit rate file. BENE_10 will show on the main screen.
Note - If you extract files in BENE_10.EXE directly to your Budget Builder directory steps 1 and 2 will be done at the same time.
Important:
This fix is ONLY for BBCiv version 9 and BB2000 version 4.
If you do not import payrolls you do not need this fix.
BBCiv version 10 are being handled by email since some versions do not require a fix.
BBCiv version 8 and BB2000 version 3 (8 years old) are not updated.
We sincerely regret the inconvenience this error has caused Budget Builder users.
Background: Budget Builder requires a fix to import payroll files with pay period ending dates in 2010 and after. In other words payroll files for pay period ending 1/2/2010 cannot be imported without this fix.
Action:
1 - Determine which version of Budget Builder you are running. This fix is only for BBCiv version 9 and BB2000 version 4.
2 - Download this file: BBIMPORT.APP (151KB)
3 - Place BBIMPORT.APP in your Budget Builder directory when Budget
Builder is not running. It will replace a file by the same name.
Background: Employees between steps converted into the National Security Personnel System (NSPS) pay system get a salary increase based on what was earned towards their next within grade increase. For example an employee who has served 25% of the time between step 5 and 6 gets an increase of 25% of the step increase amount between step 5 and 6. This is sometimes called the NSPS step increase buy in amount.
Purpose: Provide a utility to calculate the NSPS step increase buy in cost and NSPS starting salary by employee.
Required: Budget Builder for Civilian Personnel Version 8.0 (or later) or Budget Builder 2000 Version 3 is required to run this utility.
Description: This utility uses the active personnel file. This should be an imported DCPDS_02 file without additional or manual entries. Running the utility does not change the personnel file in any way. The Buy In utility has options. When calculating the days between step increases either paid days or calendar days may be used. Locality pay may be included or excluded. The buy in date may be changed.
Results are displayed in the file BUYIN.TXT. It has two sections. The first section displays buy in and starting salary calculations. The total buy in cost is at the end of the first section. The second section lists employees not calculated in the first section. If the last WGI date is missing for an employee, calculations are skipped and the employee is listed in the second section. Employees at max step or step 00 are also listed in the second section. Column calculation formulas are shown for general schedule calculations. Wage grade calculations are slightly different in columns 8 and 13.
If BUYIN.TXT is pasted into Excel, use Text to Columns on the Excel Data menu to move data into separate worksheet columns.
Action: To use this utility download BBU12.FXP (9 KB) and place it in your Budget Builder directory when Budget Builder is not running. Then launch Budget Builder and click Utilities on the main screen.
Background: In July 2005 locality pay area codes in DCPDS_02 personnel files changed from numeric codes to character codes which Budget Builder does not recognize. Budget Builder therefore assigns RUS as the pay table code which is incorrect in many cases.
Description: This utility assigns the correct pay table codes in the active Personnel file using either the new or old OPM locality pay area codes. Locality pay area codes affect locality pay tables. IT, special rate, and wage grade tables are not affected. No harm is done if this utility is run on a personnel file that already has correct pay table codes.
Action: The utility needs to be run on DCPDS_02 personnel files imported after July 2005 to assign correct pay table codes.
To use this utility download BBU50.FXP (8 KB) and place it in your Budget Builder directory when Budget Builder is not running. Then launch Budget Builder and click Utilities on the main screen.
Background: In FY 2005 DCPS added these new type hour codes:
CB - Travel Compensatory Time Earned
CF - Travel Compensatory Time Taken
At present during payroll import Budget Builder does not apply special processing to these codes.
Description:
This utility reprocesses CB and CF records in the active payroll file as follows:
(1) Deletes CB records
(2) Records CF hours as FTE hours and
(3) Corrects the EOR to 11BB in Army files
Reprocessing these codes in this manner allows balancing with official accounting reports.
Action: This utility is to be run on payroll files containing CB or CF records. No harm is done if this utility is run on a payroll file more than once or run on a payroll file without CB and CF records.
To use this utility download BBU51.FXP (3 KB) and place it in your Budget Builder directory when Budget Builder is not running. Then launch Budget Builder and click Utilities on the main screen.
DCPDS_02.xls- (File Format Jun 15 2001) (25 KB) This Excel worksheet specifies the Defense Civilian Personnel Data System file format and data elements to be used by personnel offices using the MODERN DCPDS system to transfer personnel data to Budget Builder users.