Appendix B to Part 114 - Transaction and Editing Procedures For Submission Tapes  


Latest version.
  • A. Transaction Concept

    1. All transactions flowing into the RCCPDS from the Reserve components apply to gains and losses (including transfers, reenlistments and extensions). Report the appropriate Reserve Component Category Designator (RCCD) and Reserve Component Training-Retirement Category Designator (RCTRCD) for all transactions, as follows:

    a. For accessions, use codes for gaining categories listed in record field 92.a.

    b. For transfers, use codes for categories to which transferred listed in record field 92.d.

    c. For losses, use codes for categories from which loss occurred listed in record field 92.b.

    2. The following conditions show examples of acceptable transaction practices:

    a. When a Service member is transferred from the IRR to the Standby Reserve, submit a transfer transaction i.e. TN.

    b. If a Service member transfers from one State to another, and continues as a Selected Reservist of the same Reserve component, submit no transaction.

    c. If a Service member is transferred from the IRR and/or ING (or Standby and/or Retired) to the Selected Reserve, submit a transfer transaction. Do not submit a corresponding loss transaction for the decrease in IRR strength.

    d. A loss to the Reserve component shall only be reported if a change from Reserve component appropriations to Active component appropriations occurs. That does not apply to Reserve component members performing duty for 180 days, or less, in support of an Active component mission that is being funded through Active component appropriations. Reserve component members shall be reported in RCCPDS in their current Reserve Component Category while performing that duty.

    3. The occurrence of multiple transactions during a single reporting period is unusual. However, those must be reported against the same record in the same update cycle. The following conditions shall apply:

    a. Include only valid gains, losses, transfers, reenlistments, and extensions.

    b. Do not report record corrections resulting from erroneous gains, losses, reenlistments, or extensions. For example, if an erroneous “loss” is processed and then a corresponding “gain” is initiated during the same reporting cycle, do not report those transactions.

    c. Ensure that the transaction effective dates of the various transactions are different.

    B. Edit Concept

    All data submitted to the RCCPDS must be edited by the Reserve components for validity, reliability, and consistency before submission to ensure that the Reserve component strengths match the official strengths produced from the RCCPDS. At the Department of Defense, all master files and transaction inputs are edited before file update to ensure the accuracy of files and resulting reports. Use the following edit procedures to screen all input:

    1. Master Files

    a. Duplicate SSN in a Reserve Component's Submission. When a duplicate SSN is found, accept the first occurrence and reject subsequent occurrences.

    b. Duplicate SSNs Between Reserve Component Files. That procedure checks for duplication among Reserve components. It is applied after files are updated and does not result in rejects. As agreed to by the Reserve components, the DMDC shall provide each Reserve component periodic output from the RCCPDS to assist in reconciling errors. That maximally reduces the incidence of duplication, and encourages cooperation among the Reserve components.

    2. Transactions

    a. Gains and Transfers. Check all gain and transfer transactions for Service member's status on last month's master file (previous month's submission).

    (1) A gain from outside the Reserve component is valid only if the Service member's record did not exist on the Reserve component's last month's master file. If the Service member's record already exists on last month's master file, the transaction shall reject and not be counted.

    (2) A transfer from inside the Reserve component (i.e. from IRR to Selected Reserve) is valid if the Service member's record existed on the Reserve component's last month's master file. If that condition is not satisfied, the transaction shall reject and not be counted.

    b. Losses. All current loss transactions are also reviewed with respect to a Service member's status on last month's master file. A loss to the Reserve component is valid, only if the Service member's record previously existed. If not, the loss transaction shall reject and not be counted.

    c. Gain and/or Loss. Where simultaneous gain and loss, and reenlistment and/or extension, transactions occur against the same record (SSN) during one reporting period, count each transaction.

    d. Reenlistment and/or Extension. A reenlistment and/or extension transaction is acceptable to the RCCPDS if the record identifies the Service member as a Reservist and that record is in the Reserve component's master file of the previous month. When those conditions cannot be validated, the transaction shall reject and not be counted.

    3. Master File and/or Transactions. Standard validity checks are made on all master file and transaction inputs to ensure that they conform to the code structure in Section 3 of this Instruction. For example, if a “GA” transaction were submitted, it would reject because its second character is “ALPHA” and the procedure requires a “NUMERIC” second character. Validity errors in a record shall cause rejection of the entire record, only under the following circumstances:

    a. When the Reserve component code equals “9”.

    b. When the SSN does not fit within the numeric boundaries established by the Social Security Administration.

    4. Master File and/or Transaction File Relationship

    a. During the month's reporting cycle, each gain, loss, reenlistment, extension, or transfer transaction shall have a corresponding impact on the master file for the same period. The following relationships exist:

    (1) When a gain transaction is submitted, report a master file record on that Service member during the same cycle.

    (2) When a loss transaction is reported, eliminate the master file record showing the Service member as a Reservist.

    (3) When a reenlistment and/or extension transaction is submitted, the corresponding master file for the same period must reflect the individual as being in a Reserve component.

    (4) When a transfer transaction occurs, the corresponding master file for the same period must reflect the individual as being in the new Reserve component category.

    b. All transactions that cannot satisfy the above relationship to the current master file shall reject and will not be counted.

    Pt. 114, App. C Appendix C to Part 114—Coding Instructions—Transaction File DD-RA (M) 1148Record field and data itemCoding and remarksRecord positionLength classDOD Std. data elem.Applicable toSel ResIrr/IngStnby ResRet ResThe transaction file is identified by the RCS DD-RA(M)1148. That RCS shall be used to report gains, transfers, losses, and reenlistments and/or extensions for members of the Reserve.1-102. Transaction FileIn addition to a master record, a transaction record shall include items: transaction codes and the transaction effective date1-450450 ANXXX1-91. Master RecordThe first 398 positions of data for the transaction record will be identical to the Master Record (see enclosure 2)1-398398 ANXXX92. Transaction CodesFor gains to the Reserve components (for both officers and enlisted)399-4002 ANNon-Standard.XXXa. Gains G1=NPS: an individual from civilian status who has never served previously in an Active or Reserve component, and has not received credit toward fulfillment of his or her Military Service Obligation (MSO).
  • G3=From civil Life (prior service).
  • G4=Direct from active duty (AD) to the Reserve components.
  • G5=Gain from another Reserve component (i.e.) the USNR to the USAFR, the USAR, to the ARNG, etc.).
  • G7=Other gain.
  • G8=From enlisted to officer status or vice versa (shall appear as a gain in the officer file and a loss in the enlisted file, or vice versa).
  • G0=Reenlistment gain: Individuals with a break in Service of more than 24 hours, but less than 91 days, who have reenlisted. That transaction assumes the individual was a previous loss to strength.
  • b. LossesFor losses from the Reserve components (for both officers and enlisted)399-4002 ANNon-Standard.XXXL1=Discharged to civil life (a final or complete discharge, which severs all contractual service or statutory obligations).
  • L2=To extended active duty (EAD) any Service only if change from Reserve appropriations to Active component appropriations.
  • L3=Loss to another Reserve component (i.e.) the USNR to the USMCR, the ANG, to the USCGR, etc.).
  • L7=Death (See record field 102 on master and transaction file for additional coding instructions.)
  • L8=From enlisted to officer status, or vice versa (shall appear as a “loss” in the enlisted file and a “gain” in the officer file or vice versa).
  • L0=Other losses which cannot be classified into the above codes.
  • c. Reenlistments and/or ExtensionsFor immediate (in 24 hours) reenlistment and/or extensions in the Reserve components399-4002 ANNon-Standard.XXXDefinition—A reenlistment occurs when an individual immediately reenlists (in 24 hours) on expiration of his or her Service contract, or agreement, or reenlists before the expiration of his or her Service contract, or agreement, in the same Reserve component. An extension occurs when an individual voluntarily extends his or her service contract, or agreement in writing beyond its normal expiration date. A break in Service of over 24 hours but less than 91 days, is to be counted as a PS gain (reenlistment) and should be reported with a gain code of “GO.”
  • M1=Immediate reenlistment.
  • M2=Extension of current enlistment contract or agreement.
  • d. TransfersFor intracomponent transfers between Reserve categories399-4002 ANNon-Standard.XXXTA=Selected Reserve (other than AGR) to AGRTB=Selected Reserve (other than AGR) to IRRTC=Selected Reserve (other than AGR) to INGTD=Selected Reserve (other than AGR) to StandbyTE=Selected Reserve (other than AGR) to Retired (V2)TF=AGR to Selected (other than AGR)TG=AGR to IRRTH=AGR to INGTJ=AGR to StandbyTK=AGR to Retired (V2)TL=IRR to AGRTM=IRR to Selected (other than AGR)TN=IRR to StandbyTP=IRR to Retired (V2)TQ=ING to AGRTR=ING to Selected (other than AGR)TU=Standby to AGRTV=Standby to Selected (other than AGR)TW=Standby to IRRTY=Standby to Retired (V2)TZ=Retired to AGRT1=Retired to Selected (other than AGR)T2=Retired to IRRT3=Retired to StandbyP0=Retired transferred to retired status other than V2P1=Selected Reserve transferred to retired status other than V2P2=AGR transferred to retired status other than V2P3=IRR transferred to retired status other than V2P4=Standby transferred to retired status other than V2For intercomponent transfer within the same ServiceN1=Guard Selected to Selected Reserve in same serviceN2=Guard Selected to Reserve IRRN3=Guard Selected to Reserve-Standby for reason other than retirementN4=Guard Selected to Reserve-Standby for purpose of retirementN5=Guard AGR to Reserve IRRN6=Guard AGR to Reserve-Standby for reason other than retirementN7=Guard AGR to Reserve-Standby for the purpose of retiremente. Changes to Social Security Number or NameChanges to an individual's SSN, or name, shall be submitted in an abbreviated record format consisting of:399-4002 ANNon-Standard.XXXReserve component 1-2Old SSN 3-11Old name 12-38New name 39-65New SSN 66-74Filler 75-398Transaction Codes 399-400S1—change to Service member's SSNS2—change to Service member's nameFiller 401-405Transaction effective date 406-411Filler 412-42593. Separation CodesFor use in describing losses from the Reserve component (for both officers and enlisted). Applicable to loss codes “L1” only, for all other transaction codes use filler, set I=99999 401-405(1) Separation Program Designator (SPD) code401-4033 ANSE-KY-AAXXXX(2) Character of Service4041 ACH-DB-AAXXXX(3) Filler. Reserved for future use.4051 A Report as “not applicable,” set I=W94. Transaction Effective DateThe effective date of a gain, loss, reenlistment, extension or transfer in the Reserve components. That date supports the transaction code defined in record field 92 and would be submitted along with it. ENTER: YYMMDD406-4116NXXXX95. Reeenlisted Eligibility CodeReport the reenlistment eligibility code. If not applicable, set I=WW412-4132 ANService StandardXXXX96. Five-Year Defense Plan Program (FYDP) Structure Program Element Code (SPEC)Leave blank for Transaction File414-421 8 AN97. Service Occupation Code (Secondary)Enter up to eight most significant characters indicating the secondary military skill held by the individual. Include a prefix or suffix, only if space permits. Report Army enlisted MOS and ASI, Army warrant officer MOS and ASI, Army commissioned officer SSI and ASI, Navy enlisted rating and secondary NEC, Navy officer secondary subspecialty, Marine Corps MOS, Air Force AFSC, Coast Guard officer experience indicator, and Coast Guard enlisted rating and qualification code. (Left justify). If not applicable, set I=WWWWWWWW. If unknown, set I=ZZZZZZZZ. (Not required for PJ and PK.)422-4298 NService SpecificXXXX98. Career Management Field (CMF), EnlistedReport for ARNG. If not applicable, set I=66. If unknown, set I=99430-4312 NStandard PendingXXXX99. Date of Expiration of Selected Reserve CommitmentReport the end of an individuals Selected Reserve commitment. Enter YYMMDD. If unknown set I=99432-4376 NStandard PendingXXXX100. Reason for Loss/Transfer from Selected ReserveReporting requirements apply to all members of the Selected Reserve who transfer from the Selected Reserve to another RCC in either the same Reserve component, other Reserve or Active compoennt or who are discharged. For Service members assigned a SPD reporting must be consistent with data reported in record field 92b of the Transaction File Coding Instruction. If other, set I=XX. If unknown, set I=ZZ. For individuals with unsatisfactory performance/participation report the following:
  • UP=Unsatisfactory participation as defined in DOD Directive 1215.13 (reference (r))
  • US=Misconduct (to include misconduct for purely military offenses)
  • 438-4392 AStandard PendingXXXX
    101. Military Unit Designator (UIC)Enter “UIC” of Reserve unit where Service member is actually performing duty (can be different from “Unit member is assigned to”—see record field 46). IMAs shall carry the UIC of the unit they augment on mobilization. (Marine Corps to submit Reporting Unit Code (RUC) and Monitored Command Code (MCC)), Air Force to submit PAS code, Army Reserve to submit 6-position UIC and MUSARC code.) If not applicable, set I=WWWWWWWWW. If unknown, set I=ZZZZZZZZ440-4478 ANService SpecificXXXX102. Circumstance of DeathWhen Loss code L7 is reported, additional information below is required:448-4492 AStandard PendingXXXXDD=Death as a proximate result of participating on active or reserve inactive dutyDC=Death not as a proximate result of participating on active or reserve inactive dutyDA=Death under adjudicationIf not applicable, set I=WW103. FillerReserved for future use. Report as “not applicable,” set I=W4501 A General Note for Personnel Processing this Report: Data elements and coding must be as indicated in Sections two and four above. In cases where specific coding instructions are not provided, refer to DoD 5000.12-M (reference (i)). Non-compliance with either the coding instructions herein or those approved standards published in reference (i) shall make the organization that fails to comply responsible for required concessions in data base communication. Cost of data conversions shall be borne by the organization whose category of data element lacks precedence.