| This tab, 1.Cover Letter, describes the information in the other tabs of this document. |
|
|
|
| Tab |
|
Description |
| 2.DMDC_Pers_Master_TXN-USAPHC Atr |
Report on the attributes available for selection. Explaination of the report column heads appears below, titled Column Definitions. |
|
|
|
|
Column Definitions |
|
|
|
| Column |
Name |
Description |
| A |
Source |
Name of Data Source |
| B |
SourceTabOrd |
Ordinal Position of Table in Data Dictionary received from Source System-used internally |
| C |
SourceTable |
Name of the Table from which the data element is extracted from Source System |
| D |
SourceFieldOrd |
Ordinal Position of the data element in a Table in the Source System Data Dictionary-used internally |
| E |
FieldName |
Name of the data element (please use the literal format as in the column) |
| F |
PII/HIPAA Sensitive |
Please note YES, NO or DI (De-Identification)for the element PII or HIPAA sensitivity. If the element is PII or HIPAA sensitive and it will be de-identified, enter DI. A blank enter will be considered the same as a NO. |
| G |
Army STARRS (or USAPHC(Prov)) Approval |
User has accepted this as a valid element for their use-drop down list-Yes or No |
| H |
Army STARRS (or USAPHC(Prov)) SP2Delta |
Date the data element requested in Spiral-2. This will help in revising your existing extract routines |
| I |
FieldType |
This is the data type. |
| J |
Nullability |
This is the Nullability condition |
| K |
Primary Key |
Indicator if data element is a primary key (PK) or foreign key (FK) in this table |
| L |
Title |
Data Element Name |
| M |
Desc |
Dictionary meaning of the data element and enumerated values if applicable |
| N |
Values |
Information on values the element may have |
| O |
Notes |
Notes concerning the element |
| P |
FDM Comments |
Please add any comments that will help us understand the output extract. |
| Q |
ADS Comment |
Please add any comments on authoritativeness |
| R |
Code Table Reference |
Reference to code table. |
| S |
STARRS Category |
Army STARRS justification of how data element plays a critical role in anticipated future research. This will appear in the Special Project Attachment (SPA) to the Memoradium of Understanding (MOU) between the Defense Manpower Data Center (DMDC) and USAPHC(Prov). |
| Source |
SourceTabOrd |
SourceTable |
SourceFieldOrd |
FieldName |
PII/HIPAA Sensitive |
USAPHC Approval |
USAPHC SP2Delta |
FieldType |
Nullability |
Primary Key |
Title |
Desc |
Values |
Notes |
FDM Comments |
ADS Comment |
Code Table Reference |
STARRS Category |
| DMDC/Pers_Master_TXN |
1 |
DMDC/Pers_Master_TXN |
4 |
EDIT_DSRC_TYP_CD |
|
Yes |
|
Char(1) |
|
|
Data Source Type Code |
The code that indicates whether a record is a master or transaction. |
M = Master
T= Transaction |
|
|
|
|
|
| DMDC/Pers_Master_TXN |
1 |
DMDC/Pers_Master_TXN |
3 |
ISVC_SEP_CD |
|
Yes |
|
Number(4) |
|
|
Interservice Separation Code |
The code which represents a classification of the domain values for Separation Program Designator (SPD) Code and the obsolete Separation Program Number (SPN) Code. |
List of Values Located in Appendix I |
Applicable only to Transaction Files. |
|
Taken from the 2000-2004 version. |
|
|
| DMDC/Pers_Master_TXN |
1 |
DMDC/Pers_Master_TXN |
1 |
EDIT_MSVC_CHAR_CD |
|
Yes |
|
Char(1) |
|
|
Military Service Characterization Code |
The code that represents the evaluation of a member's conduct and performance during a period of military service. Recode of CSVC2 for <2004. |
See picklist |
Applicable only to personnel status change loss and immediate reenlistment transaction records. If not applicable or unknown, report Z. Suppress in analytical datasets. IS LABEL CORRECT ABOUT FORMAT? CSVC IS READ IN FROM 2007 DATA - NOT CSVC2. |
|
|
|
|
| DMDC/Pers_Master_TXN |
1 |
DMDC/Pers_Master_TXN |
2 |
MSVC_CHAR_CD |
|
Yes |
|
Char(1) |
|
|
Military Service Characterization Code |
The code that represents the evaluation of a member's conduct and performance during a period of military service. |
A = Honorable, B = General-Under honorable conditions, D = Bad Conduct, E = Under other than honorable conditions, F = Dishonorable-Dismissal, Y = Uncharacterized, Z = Unknown or Not Applicable |
Applicable only to Transaction Files. Characterization of Service. |
|
Taken from the 2000-2004 version. |
|
|
| DMDC/Pers_Master_TXN |
1 |
DMDC/Pers_Master_TXN |
5 |
EDIT_PNL_TXN_TYP_CD |
|
Yes |
|
Number(3) |
|
|
Personnel Transaction Type Code |
The code that represents a type of personnel transaction. |
see pckTransType |
|
|
|
|
|
| DMDC/Pers_Master_TXN |
1 |
DMDC/Pers_Master_TXN |
6 |
PNL_TXN_TYP_CD |
|
Yes |
|
Char(1) |
|
|
Personnel Transaction Type Code |
The code that represents the specific kind of batch transaction that last updated the personnel record. |
G = Gain, L = Loss, N = Not Gain/Not Loss (Change) |
|
|
Taken from the 2000-2004 version. |
|
|
| DMDC/Pers_Master_TXN |
1 |
DMDC/Pers_Master_TXN |
7 |
EDIT_REENL_ELIG_CD |
|
Yes |
|
Char(2) |
|
|
Reenlistment Eligibility Code |
The Service-specific code which represents the eligibility of the member to reenlist for an additional period of active or reserve service. |
List of Values Located in Appendix Q: Reenlistment Eligibility Code DS A Vrsn 1 |
Applicable only to enlisted personnel status change loss and immediate reenlistment transaction records. If not applicable or unknown, report ZZ. |
|
|
|
|
| DMDC/Pers_Master_TXN |
1 |
DMDC/Pers_Master_TXN |
8 |
REENL_ELIG_CD |
|
Yes |
|
Char(2) |
|
|
Reenlistment Eligibility Code |
The Service-specific code which represents the eligibility of the member to reenlist for an additional period of active or reserve service. |
List of Values Located in Appendix J |
Applicable only to Transaction Files. |
|
Taken from the 2000-2004 version. |
|
|
| DMDC/Pers_Master_TXN |
1 |
DMDC/Pers_Master_TXN |
9 |
EDIT_SPD_CD |
|
Yes |
|
Char(3) |
|
|
Separation Program Designator Code |
The code that defines the circumstances under which a member ended a period of active or reserve service. |
No Values Associated With This Item |
Applicable only to personnel status change loss and immediate reenlistment transaction records. If not applicable or unknown, report ZZZ. These codes are for Official Use Only. Please see the current file manager for documentation on all current service-specific domain values. |
|
|
|
|
| DMDC/Pers_Master_TXN |
1 |
DMDC/Pers_Master_TXN |
10 |
SPD_CD |
|
Yes |
|
Char(4) |
|
|
Separation Program Designator Code/Accession Designator Code |
The code which defines the circumstances under which a member ended a period of active service or the Service-specific code that represents the means by which a member began a period of active service. |
No Values Associated With This Item |
Applicable only to Transaction Files. These codes are for Official Use Only. Please see the current file manager for the codes. |
|
Taken from the 2000-2004 version. |
|
|
| DMDC/Pers_Master_TXN |
1 |
DMDC/Pers_Master_TXN |
11 |
EDIT_TXN_EFF_DT |
|
Yes |
|
Number(8) |
|
|
Transaction Effective Calendar Date |
The date the transaction came into effect. |
No Values Associated With This Item |
For personnel status change gain records reports the date of enlistment, transfer, or return to military control. For personnel status change loss records report the date of release, separation, transfer, retirement, death, or loss from military control. For personnel status change extension and immediate reenlistment records and personnel data change records report the date the change came into effect. Applicable only to transaction records. If not applicable, report all zeros. Format: YYYYMMDD |
|
|
|
|
| DMDC/Pers_Master_TXN |
1 |
DMDC/Pers_Master_TXN |
12 |
TXN_EFF_CDT |
|
Yes |
|
Date(8) |
|
|
Transaction Effective Calendar Date |
The date the transaction came into effect. |
No Values Associated With This Item |
AKA Loss Date/Accession Date. If date is not applicable, unknown, invalid, or year is unknown or invalid, date equals all zeros. If month is unknown or invalid, month and day equal all zeros. If day is unknown or invalid, day equals all zeros. Applicable only to Transaction Files. |
|
Taken from the 2000-2004 version. |
|
|