Docstoc

Officer Bonus

Document Sample
Officer Bonus Powered By Docstoc
					                         Personnel Database Deficiencies Document

The Personnel Universes, Personnel Monthly and Personnel Annual, have some known
deficiencies, which are described below. NCCA will update this list as necessary.


Deficiencies

Duplicate Records

       In the five monthly master files used to process non-cost data in both VAMOSC
       Personnel Universes, duplicate records for the same person for the same month were
       processed so that only one record per month was retained. If an individual showed up
       in both an officer and an enlisted file for the same month, it was assumed that the
       officer file would have the valid entry for that month. There were no duplicates found
       within each data file. On average, less than 0.25 percent duplicate records were found
       among the Navy enlisted data sources. There were less than 0.08 percent duplicate
       records found between the combined Navy enlisted data file and the Marine Master
       File.

       There were duplicate records found both within and between the four monthly DMDC
       pay files (Active Duty Officer, Active Duty Enlisted, Reserve Officer, and Reserve
       Enlisted). This duplicate percentage again was extremely low, approximately 2
       percent.

      During processing of the pay files, duplicate pay records are summed so that no actual
      reported costs are dropped, and non-cost elements were chosen based on business rules
      similar to those of the master personnel file business rules.


Matching Records

      To process both Personnel Universes, the monthly records from the four DMDC pay
      files and the master personnel files were matched; only data for those individuals who
      had records in both files were processed. The chart below shows the total monthly
      DMDC record counts, both matching to master personnel files and non-matching.

                                          Count of                       Count of
                          Count of        DMDC           Count of        DMDC Non-
                          DMDC            Matching       DMDC Non-       Matching
             DMDC         Matching        Master File    Matching        Master File
      FY     Count        Master File     (%)            Master File     (%)
      FY02   8,595,792        8,366,875         97.34%         234,240           2.73%
      FY03   8,715,097        8,481,691         97.32%         233,406           2.68%
      FY04   8,656,129        8,376,328         96.77%         279,801           3.23%
      FY05   8,370,591        8,154,281         97.42%         216,310           2.58%
      FY06   8,193,790        7,970,000         97.27%         223,790           2.73%
      FY07   7,994,705        7,761,856         97.09%         232,847           2.91%



31 January 2008                                                                      Page 1 of 3
                        Personnel Database Deficiencies Document


Enlisted vs. Officer Designation and Pay Grade indication

       In FY02, for Navy personnel, the master personnel files are used to determine the
       military member’s status (officer or enlisted). In cases where the respective master
       file does not contain this indicator, the pay files are used to determine the enlisted or
       officer status. Marine Corps personnel status was determined using the pay file from
       DMDC because the member’s status was unavailable from the master file. Also, Pay
       Grade, Special Pay Designator, Current Pay Status, and Geographic Location Code
       are determined from the pay records since not all of the master files contain this
       information. These file characteristics cause a very small number of personnel to
       apparently be in the wrong folders. As an example, an individual is found in the
       Enlisted Master File (EMF), so he is categorized as Enlisted. If, however, his
       corresponding DMDC pay file indicates his paygrade to be O-1, this record will
       appear in the Navy Enlisted folder with a paygrade O-1.

       Beginning in FY03, all of the personnel master files contained an officer or enlisted
       status indicator so it was not necessary to use DMDC data to make this distinction.
       Pay Grade, Special Pay Designator, Current Pay Status, and Geographic Location
       Code are still determined from the pay records since not all of the master files contain
       this information.


Officer Bonus Data

      In FY02, two officer bonus elements (1.3.1.4 Nuclear Career Accession Bonus and
      1.3.1.7 Nuclear Qualified Officer Continuation Pay) were removed from the FY02
      databases. These elements, provided by DMDC and derived from DFAS data, were
      found to be invalid. Five other officer bonuses were validated and verified in time for
      the September 2003 quarterly database update. Detailed descriptions of the processing
      used during this validation can be found with each of the Personnel User Manuals
      under each specific officer bonus.

      In FY03, six officer bonus elements (1.3.1.1 Aviation Career Incentive Pay, 1.3.1.2
      Aviation Officer Continuation Pay, 1.3.1.3 Incentive Special Pay, 1.3.1.4 Nuclear
      Career Accession Bonus, 1.3.1.6 Nuclear Officer Accession Bonus, and 1.3.1.7
      Nuclear Qualified Officer Continuation Bonus) were removed. The data provider
      (DMDC) determined that these elements are invalid. At the time of the release,
      VAMOSC was unable validate these elements against a secondary source.

      In FY04-FY07, all seven officer bonus elements have been withheld pending further
      validation.




31 January 2008                                                                         Page 2 of 3
                      Personnel Database Deficiencies Document


Enlisted Bonus Data

      In FY02-FY07, both enlisted bonus elements (1.3.2.1 Enlistment Bonus and 1.3.2.2
      Selective Reenlistment Bonus) have been withheld from the databases. These
      elements, provided by DMDC and derived from DFAS data, were found to be invalid.
      At the time of release of the universe there was no secondary source to provide the
      data.


FSA (Family Separation Allowance)

      The data provider determined that FSA costs were invalid for FY03. VAMOSC
      removed the cost data associated with Element 1.2.5.4 and replaced the values with
      null value until correct FY03 data can be obtained.


Marine Foreign Language Pay

      Beginning June 2006, the data provider, DMDC, is unable to provide Foreign
      Language Pay for all Marines. DMDC expects to resolve the error by FY09. Until
      then, dollars reported after June 2006 for Marine Officer & Enlisted Foreign Language
      Proficiency Pay I are deficient by about 90% - 95% or reported as $0 (FY07).




31 January 2008                                                                    Page 3 of 3