Ngp 25-10 National Guard Pamphlet 25-10

Personnel Information Systems

National Guard Bureau

Arlington, VA 22204

29 May 2016
UNCLASSIFIED

SUMMARY of CHANGE
NGP 25-10

Standard Installation/Division Personnel System Army National Guard (SIDPERS-ARNG) Data Element

Dictionary

29 May 2016
SIDPERS RELEASE 1.13.00:

**ECP 604: MGIB/GIMS load procedure created to automatically update SIDPERS with the latest MGIB/GIMS data provided by RCMS-iMARC/Guard Incentive Management System (GIMS)

ECP 605: Validate/Update Assignment Loss Reason codes to reflect accurate regulatory guidance, character of service and military personnel class

ECP 606: Current parameter screen does not close on submit, allowing the user to resubmit before the process has run to completion (it takes 60-seconds, but if a resubmit is done within this period of time then this resubmit will cause the 0440 to be overridden and this truncates the JUMPS table). A second submit results in the GPFD 0440 report not populating with data.

ECP 608: Perform Organizational Intact Unit Loss (OIUL) transaction for the unit and update Organizational Status code (OESTS) to value ‘M’ only when all Soldier records in the unit are validated and qualified to be mobilized

ECP 609: Perform OIUR (Organizational Intact Unit Return) transaction for the unit and allow user to select Soldiers records from the multi-record screen for the Release from Active Duty (RADT) transaction

ECP 610: The SIDPERS Headquarters Operational Level (SIHOL) database procedure will be modified to provide capability to recreate the previous year’s SIHOL’s history

ECP 611: The auto advancement report will be modified to use the date of Initial Active Duty for Training (IADT) in calculating Time in Service (TIS). Prior Service Gain (PSG) will insert a Soldiers record into the Non Prior Service Gain (NPSG) table if it does not already exist

ECP 613: Unit Manning Report (UMR) Rollup has several added user friendly functions that allows easier review and management of the UMR. This ECP will fix the excess code issue currently in the application

ECP 614: The Return to Inactive National Guard (RING) transaction screen will be modified to disable the list of value buttons for Soldiers of ranks E1-E4 if their RFP flag is equal to ‘Y’

ECP 616: Prevents incorrect BAQ-DEP-TYPE and Marital Status combinations

ECP 627: Updates the correct record into the Local Supplemental Database (LSDB) table for any Soldier with two or more records in the person table with the same SSN and different last names

ECP 628: PSG form module will be modified to make NCO Education field a required field and insert its value into the PERS_SVCMBR_EDUC_TBL

ECP 634: The applications DSCH and SEP transactions will be modified to auto populate to ‘W’ (not applicable) in the PERS_SVCMBR_LOSS table Character of Service when transactions are performed with an assignment loss reason of ‘GA’ (gained to the ARNG of another state or USAR unit)

ECP 636: Created script to increase description field size for the PERS_CRS_CODE_TBL and insert new Military Course Completion Records

ECP 643: Modified UMR report module select statements, procedures and layout to identify held information in a new table added called PERS_POSN_HELD_TYPE_CODE_TBL for the Soldier and display excess held section if the held position does not exist in the PERS_AUTH_STR_TBL

ECP 649: Created a script to increase the length of the description fields and update description for the records in the PERS_TPRC_CODE_TBL, PERS_TNGSTAT_CODE_TBL, and PERS_RECSTAT_CODE_TBL

ECP 651: Modified modules to display AREAX (Army Area and State or Country) value in the originator code field to update/review report sequence code and removed originator code update capability

ECP 652: Created Ranking waiver conditions database procedure to assign the appropriate occurrence order of precedence of waiver conditions for enlisted and officer/warrant officer in the PERS_SVCMBR_WVR_COND_TBL

ECP 687: Updated PERS_SVCMBR_EDUC_TBL to include current Intermediate Level Education (ILE) codes in PERS_CRS_CODE_TBL

** THIS INFORMATION WILL NOT BE AVAILABLE UNTIL TAPDB-G IS READY TO RECEIVE IT IN RELEASE 1.14.00

ECP 748: Removes functionality from SEP, DSCH and DECD transactions of updating MGIB/GIMS data stored in the PERS_SVCMBR_TNG_TBL and removal of the MGIB/GIMS transaction created by SEP, DSC, and DECD transactions for TAPDB-G that was implemented in ECP 604 Release 1.13.00

ARNG IMS SPR 105: Allows SIDPERS user granted SIDPERS_ROLE ability to run the RPAM, QA reports, 4100 Enlisted Promotion Worksheet

ECP 762: Fix to ECP 654 AGR EADT (SEP and DSCH) Incorporates an edit to alert the user to ensure if Soldier is on any type of AD by displaying a banner, prior to completing a loss transaction to close out an active duty period

ECP 777: Modified the MEDPROS procedure preventing the adding or removing of position number excess code of 999M based on the Medical Readiness Code of ‘B’ to a Soldiers record based on the ARNG G1’s intent to discontinue the use of 999M value. NGB approval will be needed to use this code

ECP 631: New Branch Codes will be added to Branch Table- per Department of Defense Manual (DODM) requirements

ECP 645: Personnel Religious Codes will be updated per TAPDB Edit Support System (TESS) Values – per DODM requirements

ECP 646: Personnel Race table will be updated- per DODM requirements.

ECP 648: A script to convert existing records with a Reserve Category (RESCAT) Code Value of ‘T’ will be removed and replaced with ‘S’ from the Personnel Reserve Category table – per DODM requirements

ECP 658: Personnel Country code table will be updated to reflect updated TESS values per DODM requirements

ECP 662: Personnel Security Code table will be updated to reflect current TESS values per DODM requirements

ECP 663: Personnel Security Investigation Required table will be updated to reflect current TESS values per DODM requirements

ECP 664: Personnel Security Investigation code table will be updated to reflect current TESS values per DODM requirements

ECP 667: Personnel Civilian Education level table will be updated to reflect current TESS values per DODM requirements

ECP 668: Personnel Course code table PERS_CRS_CODE_TBL will be updated to add ‘AJ’, ‘AA, and ‘D4’ codes to

Comply with DODM requirements

ECP 679: Personnel campaign ID code table will be updated with new values per DODM requirements

ECP 680: Does not allow a security clearance granted date when security clearance = N, P, or Y (ineligible for security clearance or does not have one)

ECP 681: Personnel statutory authority code table will be updated to include new TAPDB-G TESS values per DODM

Requirements
ECP 691: The code values in Suspension of Favorable Personnel Action (SFPA) table will be updated to match the current TESS tables per DODM requirements

ECP 714: Evaluation Report (EERF) screen will validate and not allow a date prior to 19400101(1January1940) to be entered for the date at the end of an evaluation period on the EERF form

ECP716: Checks the entered military education level enrolled and the completed education level against the Soldiers Military Personnel Class (MPC) and creates a validity check to prevent assignment of military education courses that do not pertain to the Soldiers MPC

ECP 718: Validation of Authorized Personnel Identity (API) code and gender when a clerk uses a Transfer within state (TRF) mnemonic the TRF allows the assignment of female Soldiers into closed Military Occupational Specialties (MOSs) or Male coded positions

ECP 720: Modify LOADAPFT procedure to insert new records into the personnel service member history table and to update existing records. On the APFT form validate APFT dates to require a six digit YYYYMM date format

ECP 732: Updated current organization code values will be displayed on the Non Prior Service Gain (NPSG), Prior Service Gain (PSG) Return from Inactive National Guard (RING) and Current Organization Identification (COCD) forms

ECP 737: If the date of expiration of retention beyond MRD and the retained beyond mandatory removal reason are being entered or they currently exist then the initial MRD and reason cannot be modified for officers who’s grade is LTC-O5 and below

ECP 755: Expands all personnel actions Mnemonics GUI to display 120 characters as opposed to only the first 40

ECP 786: Reenlistment (RENL) transactions fix - when doing a RENL on an SM transaction will not fall into a loop and hang up system

ECP 787: PMOS fix- when doing an ADMA transaction the PSG that is created displays the PMOS for Enlisted, Warrants and Officers when sent to TAPDB-G

Description of Data Elements ● 1-2

Table of Contents ● 1-3

Chapter 2

Personnel/Authorization Related Data Elements and Codes
Active Status Program ● 2-1

Additional Military Occupational Specialty Designator – Enlisted ● 2-2

Additional Military Occupational Specialty Designator – Warrant Officer ● 2-3

Additional Skill Identifier – Additional Military Occupational Specialty Designator – Enlisted ● 2-4

Additional Skill Identifier – Additional Military Occupational Specialty Designator – Warrant Officer ● 2-5

Additional Skill Identifier – Additional Specialty Skill Identifier ● 2-6

Additional Skill Identifier – Primary Military Occupational Specialty Designator – Enlisted ● 2-7

Additional Skill Identifier – Primary Military Occupational Specialty Designator – Warrant Officer ● 2-8

Additional Skill Identifier – Primary Specialty Skill Identifier ● 2-9

Additional Skill Identifier – Secondary Military Occupational Specialty Designator - Enlisted ● 2-10

Additional Skill Identifier – Secondary Specialty Skill Identifier ● 2-11

Additional Specialty Skill Identifier ● 2-12

Additional Withholding Tax ● 2-13

Address City ● 2-14

Address Mailing – Individual ● 2-15

Address Mailing – Individual Foreign ● 2-16

Appointment Waiver Conditions ● 2-17

Armed Forces Qualification Test Percentile Score ● 2-18

Armed Forces Qualification Test Score Groups ● 2-19

Army College Fund Montgomery G.I. Bill Increase of Basic Benefit – Active Duty ● 2-20

Army Physical Fitness Test Results ● 2-21

Army Physical Fitness Test Score ● 2-22

Assignment/Loss Reason ● 2-23

Attached Payroll Number ● 2-24

Attachment Code ● 2-25

Aviation Service Entry Date ● 2-26

Basic Allowance for Quarters Dependent Type ● 2-27

Basic Allowance for Quarters DOB Primary Dependent ● 2-28

Basic Allowance for Quarters Effective Date ● 2-29

Basic Allowance for Quarters Status ● 2-30

Basic Branch ● 2-31

Benefit Status Waiver Code ● 2-32

Branch School Completed ● 2-33

Branch School Enrolled ● 2-34

Break in Military Status ● 2-35

Campaign Identification Code ● 2-36

Character of Separation ● 2-37

Citizenship Status, United States, Origin ● 2-38

Civilian Education Level ● 2-39

Civilian Employer ● 2-40

Civilian Grade ● 2-41

Civilian Occupation ● 2-42

Command Status ● 2-43

Commissioned/Warrant Officer Service Date ● 2-44

Country of Residence, Current ● 2-45

Highest Military College Education/Course Level Enrolled ● 2-46

Cumulative Months of Extension ● 2-47

Cumulative Retirement Points ● 2-48

Current Aeronautical Rating ● 2-49

Current Incentive/Termination Status ● 2-50

Current Organization Identification ● 2-51

Current Procurement ● 2-52

Current Unit Processing Code ● 2-53

Date Declare Montgomery G.I. Bill Enrollment – Active Duty ● 2-54

Date Incentive Pay Indicator Number One ● 2-55

Date Incentive Pau Indicator Number Two ● 2-56

Date of Assignment/Loss Reason ● 2-57

Date of Birth ● 2-58

Date of Current Incentive/Termination Status ● 2-59

Date of Current Procurement ● 2-60

Date of Current Service Agreement ● 2-61

Date of End of Duty for Defense Enrollment Eligibility Reporting System Eligibility ● 2-62

Date of End of Evaluation Period ● 2-63

Date of Enlistment/Reenlistment Bonus – Reserve ● 2-64

Date of Execution of a Six-Year Service Obligation ● 2-65

Date of Initial Entry into a Reserve Component ● 2-66

Date of Initial Procurement ● 2-67

Date of Mandatory Removal ● 2-68

Date of Original Entry on IADT ● 2-69

Date of Previous Record Status ● 2-70

Date of Projected Promotion Eligibility ● 2-71

Date of Promotion Consideration ● 2-72

Date of Qualitative/Selective Retention Identifier ● 2-73

Date of Rank-Reserve ● 2-74

Date of Record Status ● 2-75

Date of Security Clearance ● 2-76

Date of Start of Duty for Defense Enrollment Eligibility Reporting System Eligibility ● 2-77

Date of Survivor Benefit Plan Election Status ● 2-78

Date of Training Status ● 2-79

Date Start Montgomery G.I. Bill Eligibility – Reserve Component ● 2-80

Date Terminated Montgomery G.I. Bill Eligibility – Reserve Component ● 2-81

Days Waived ● 2-82

Dependents, Number of ● 2-83

Designated Control Code ● 2-84

Detail Branch ● 2-85

Duty Language Identity ● 2-86

Duty Military Occupational Specialty Designator - Enlisted ● 2-87

Duty Military Occupational Specialty Designator – Warrant Officer ● 2-88

Duty Position ● 2-89

Duty Position – Commissioned Officer ● 2-90

Duty Position - Enlisted ● 2-91

Duty Position – Warrant Officer ● 2-92

Duty Position Qualification ● 2-93

Duty Specialty Secondary ● 2-94

Duty Specialty Skill Identifier ● 2-95

Effective Date of Attachment ● 2-96

Effective Date of Grade ● 2-97

Enlistment Option Period ● 2-98

Enlistment Waiver Condition ● 2-99

Enlistment/Reenlistment Bonus – Reserve Entitlement ● 2-100

Enlistment/Reenlistment Bonus – Reserve Entitlement Authorization ● 2-101

Enlistment/Reenlistment Bonus Reserve – Military Occupational Specialty – Enlisted ● 2-102

Ethnic Group ● 2-103

Executive Order Number ● 2-104

Expiration Date Inactive National Guard ● 2-105

Expiration Date of Attachment ● 2-106

Expiration Ready Reserve Obligation Date ● 2-107

Obligation Date ● 2-108

Expiration Term of Service Date ● 2-109

Eyes/Vision Capacity Indicator ● 2-110

Federal Recognition Identification ● 2-111

First Duty – Additional Skill Identifier – Commissioned Officer ● 2-112

First Duty – Additional Skill Identifier – Enlisted ● 2-113

First Duty – Additional Skill Identifier – Warrant Officer ● 2-114

First Language Identity ● 2-115

Grade Abbreviation and Code ● 2-116

Grade Change Waiver ● 2-117

Grade How Acquired Code ● 2-118

Hearing Capacity Indicator ● 2-119

Height Individual ● 2-120

Highest Military College Education/Course Completed ● 2-121

Incentive Pay Indicator Number One ● 2-122

Incentive Pay Indicator Number Two ● 2-123

Initial Procurement ● 2-124

Local Data-Personnel ● 2-125

Lower Extremities Capacity Indicator ● 2-126

Mail APO/FPO Identification ● 2-127

Major Subject of College Education ● 2-128

Mandatory Promotion Identification ● 2-129

Mandatory Removal Reason ● 2-130

Marital Status ● 2-131

Military Personnel Class ● 2-132

Montgomery G.I. Bill Benefit Recoupment Status – Reserve Component ● 2-133

Montgomery G.I. Bill Eligibility Status – Active Duty ● 2-134

Montgomery G.I. Bill Eligibility Status – Reserve Component ● 2-135

Montgomery G.I. Bill Kicker Eligibility Date – Reserve Component ● 2-136

Montgomery G.I. Bill Kicker Incentive Basis Code ● 2-137

Montgomery G.I. Bill Kicker Incentive Eligibility Status Code ● 2-138

Montgomery G.I. Bill Kicker Incentive Eligibility Status Effective Date ● 2-139

Montgomery G.I. Bill Kicker Incentive Obligation Service Begin Date ● 2-140

Montgomery G.I. Bill Kicker Incentive Rate Code ● 2-141

Montgomery G.I. Bill Supplemental Allowance – Active Duty ● 2-142

Months of Current Extension ● 2-143

Months of Obligated Service Remaining ● 2-144

Name, Individual ● 2-145

NCO Education ● 2-146

NCO Education Enrolled ● 2-147

Number of Enlistment/Reenlistment Bonus Payments ● 2-148

Number of Exemption ● 2-149

Number of Exemption of Enlistment ● 2-150

Number of Months of Active Federal Service ● 2-151

Organization Identification ● 2-152

Pay Entry Basic Date ● 2-153

Pay Grade ● 2-154

Physical Capacity Indicator ● 2-155

Physical Category ● 2-156

Physical Profile Serial ● 2-157

Position Number Excess Individual ● 2-158

Previous Army Physical Fitness Test Results ● 2-159

Previous Army Physical Fitness Test Score ● 2-160

Previous Date of Birth ● 2-161

Previous Military Personnel Class ● 2-162

Previous Organization Identification ● 2-163

Previous Record Status ● 2-164

Previous Site Identification ● 2-165

Previous Social Security Number ● 2-166

Previous Unit Processing Code ● 2-167

Primary Military Occupational Specialty Designator – Enlisted ● 2-168

Primary Military Occupational Specialty Designator – Enlisted – Basis for Acquiring ● 2-169

Primary Military Occupational Specialty Designator – Warrant Officer ● 2-170

Primary Specialty Skill Identifier ● 2-171

Privacy Act Disputed Record ● 2-172

Procurement Program ● 2-173

Professional Military Education ● 2-174

Proficiency Pay Date ● 2-175

Proficiency Pay Status ● 2-176

Promotion Consideration Code ● 2-177

Psychiatric Capacity Indicator ● 2-178

Qualitative/Selective Retention Identifier ● 2-179

Race/Population Group ● 2-180

Reason for Ineligibility for Army Physical Fitness Testing ● 2-181

Record Precedence ● 2-182

Record Status ● 2-183

Religious Denomination ● 2-184

Reserve Category ● 2-185

Reserve Officers Training Corps Armed Forces ● 2-186

Reserve Officers Training Corps – Years Completed ● 2-187

Retention Waiver ● 2-188

Retirement Year Ending Date ● 2-189

Second Duty Additional Skill Identifier – Commissioned Officer ● 2-190

Second Duty Additional Skill Identifier – Enlisted ● 2-191

Second Duty Additional Skill Identifier – Warrant Officer ● 2-192

Secondary Specialty Skill Identifier ● 2-193

Secondary Military Occupational Specialty Designator – Enlisted ● 2-194

Security Clearance ● 2-195

Security Investigation Status ● 2-196

Separation Program Designator ● 2-197

Service Component ● 2-198

Servicemen’s Group Life Insurance Election ● 2-199

Sex ● 2-200

Social Security Number, Service Member ● 2-201

Source of Commission/Warrant ● 2-202

Source of Original Enlistment/Induction ● 2-203

Special Pay ● 2-204

Special Qualification Identifier – Enlisted ● 2-205

Special Qualification Identifier – Warrant ● 2-206

Specialty – Commissioned Officer ● 2-207

State Tax Code ● 2-208

States of the United States ● 2-209

Statutory Authority ● 2-210

Street Address ● 2-211

Survivor Benefit Plan Election Coverage ● 2-212

Survivor Benefit Plan Election Status ● 2-213

Survivor Benefit Plan Option ● 2-214

Technician/Selective Service Code ● 2-215

Term of Enlistment – Reserve ● 2-216

Total Federal Officer Service Date ● 2-217

Total Years Satisfactory Federal Service for Retirement ● 2-218

Training/Pay/Retired Category ● 2-219

Training Status ● 2-220

Transaction Code ● 2-221

Twenty-Year Certificate Status ● 2-222

Type Address ● 2-223

Type Attachment ● 2-224

Type Reserve Officers Training Corps Program ● 2-225

Uniformed Thrift Savings Plan Basic Pay Contribution ● 2-226

Uniformed Thrift Savings Plan Bonus – Pay Contribution ● 2-227

Uniformed Thrift Savings Plan Effective Date ● 2-228

Uniformed Thrift Savings Plan Incentive Pay Contribution ● 2-229

Uniformed Thrift Savings Plan Participation Status Code ● 2-230

Uniformed Thrift Savings Plan Special Pay Contribution ● 2-231

Uniformed Thrift Savings Plan Status Reason Code ● 2-232

Unite Processing Code ● 2-233

Unite Processing Code of Attachment ● 2-234

Upper Extremities Capacity Indicator ● 2-235

Weight, Individual ● 2-236

Year-Month Army Physical Fitness Test Administered ● 2-237

Year-Month Previous Army Physical Fitness Test Administered ● 2-238

Year and Month of Last Physical Examination ● 2-239

Years of Commissioned Service ● 2-240

Zip Code ● 2-241
Chapter 3

Authorization/Organizational Data Elements and Codes
Active/Reserve/Mobilization Document Indicator ● 3-1

Additional Skill Identifier ● 3-2

Address Mailing - Unit ● 3-3

Army Area and State or Country ● 3-4

Authorized Branch ● 3-5

Authorization Document Position Title ● 3-6

Authorized Enlisted Pay Grade Range ● 3-7

Authorized Line Designator ● 3-8

Authorized Paragraph Designator ● 3-9

Authorized Personnel Identity ● 3-10

Authorized Strength ● 3-11

Change Year - Month ● 3-12

Descriptive Designator ● 3-13

Designated Control Specialty ● 3-14

Document Number ● 3-15

Effective Date of Implementation ● 3-16

Effective Date of OESTS ● 3-17

Enlisted Authorized Strength ● 3-18

Enlisted Structured Strength ● 3-19

Grade ● 3-20

Position Held Type ● 3-21

Implementation Year - Month ● 3-21

Local Data ● 3-22

Officer Authorized Strength ● 3-23

Officer Structured Strength ● 3-24

Organization Status Code ● 3-25

Paragraph Title ● 3-26

Parent Organization Designator ● 3-27

Payroll Number ● 3-28

Personnel Occupational Specialty Code ● 3-29

Position Status ● 3-30

Program Element Code ● 3-31

Record Type ● 3-32

Report Sequence Code ● 3-33

Required Strength ● 3-34

Rescission Year-Month ● 3-35

Security Clearance Required ● 3-36

Service Designator ● 3-37

Special Qualification Identifiers Validate Field ● 3-38

State Code ● 3-39

Status Code ● 3-40

Transaction Document Number ● 3-41

Troop Program Sequence Number ● 3-42

Type of Record ● 3-43

Unit Identification Code ● 3-44

Unit Name ● 3-45

Unit Processing Code ● 3-46

Warrant Officer Authorized Strength ● 3-47

Warrant Officer Structured Strength ● 3-48

Zip Code ● 3-49

Batch Number ● 4-2

Beginning Control Number ● 4-3

Control Data – Organizational Transactions ● 4-4

Control Data – Personnel Transactions ● 4-5

Control Number ● 4-6

Current Date ● 4-7

Date of Last Type Transaction ● 4-8

Date of Transaction Processing ● 4-9

Effective Date ● 4-10

Ending Control Number ● 4-11

Extension Processing Identity ● 4-12

Gain Processing Identity ● 4-13

Inactive National Guard Processing Identity ● 4-14

Initial Active Duty Training Processing Identity ● 4-15

Last Type Transaction ● 4-16

Loss Processing Identity ● 4-17

Originator Agency ● 4-18

Originator Code ● 4-19

Product Control Number ● 4-20

Promotion Processing Identity ● 4-21

Record Condition Code ● 4-22

Reenlistment Processing Identity ● 4-23

Report Name ● 4-24

Skill Type ● 4-25

Subsystem Indicator ● 4-26

Transaction Document Number ● 4-27

Transaction Mnemonic ● 4-28

Transaction Name, Last ● 4-29

Transaction Social Security Number ● 4-30

Transaction Unit Processing Code ● 4-31

Waiver Occurrences ● 4-32

1. 
   Assignment/Loss Reason
   
2. 
   Civilian Occupation
   
3. 
   Country of Residence, Current
   
4. 
   First Language Identity
   
5. 
   Major Subject of College Education
   
6. 
   Religious Denomination
   
7. 
   PULHES
   
8. 
   Previous Site Identification Codes
   
9. 
   Local Supplemental Database
   
10. 
    Federal Awards and Decorations
    
11. 
    State Awards and Decorations
    
12. 
    Index
    

This page intentionally left blank