| This tab, 1.Cover Letter, descripes the information in tab 2. |
|
|
|
| Tab |
|
Description |
| 2. PDCAPS-USAPHC(Prov) 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 |
NIMH (or USAPHC(Prov)) Approval |
User has accepted this as a valid element for their use-drop down list-Yes or No |
| H |
NIMH (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. |
|
| Note: Please see the xlsx file titled "PDCAPS_LookupTable-20091221" for detailed information on PDCAPS code tables |
| Source |
Source Tab Ord |
SourceTable |
Source Field Ord |
FieldName |
PII/HIPAA Sensitive |
USAPHC (Prov) Approval |
USAPHC (Prov) SP2Delta |
FieldType |
Nullability |
Primary Key |
Remarks |
Desc |
Values |
Notes |
FDM Comments |
ADS Comment |
Code Table Reference |
| PDCAPS |
1 |
PDA_MAIN |
1 |
ssn |
DI |
Yes |
|
C(20) |
|
|
|
ssn + date received xxx-xx-xxxx_yy.dd.mm Note: This was one of the first bandaids to PDCAPS to allow for multiple iterations of a record. That is why the date field was added to the ssn field. |
|
|
|
|
|
| PDCAPS |
1 |
PDA_MAIN |
4 |
last_name |
Yes |
Yes |
|
C(15) |
|
|
|
Last name from personnel record (LES) |
|
|
|
|
|
| PDCAPS |
1 |
PDA_MAIN |
5 |
first_name |
Yes |
Yes |
|
C(12) |
|
|
|
First name from personnel record (LES) |
|
|
|
|
|
| PDCAPS |
1 |
PDA_MAIN |
6 |
middle_i |
Yes |
Yes |
|
C(1) |
|
|
|
Middle initial from personnel record (LES) |
|
|
|
|
|
| PDCAPS |
1 |
PDA_MAIN |
14 |
component |
|
Yes |
|
C(3) |
|
|
|
see pda_comp.dbf |
|
|
|
|
|
| PDCAPS |
1 |
PDA_MAIN |
15 |
case_type |
|
Yes |
|
C(1) |
|
|
USACHPPM-KLCOX:
Okay, but a & b still of interest. ABCMR=Army Board for Correction of Military Records
not case c |
A=new case, B=TDRL re-evaluation C=ABCMR |
|
|
|
|
|
| PDCAPS |
1 |
PDA_MAIN |
18 |
birth_d |
|
Yes |
|
D |
|
|
|
Birthdate yy.mm.dd |
|
|
|
|
|
| PDCAPS |
1 |
PDA_MAIN |
31 |
medboard_d |
|
Yes |
|
D |
|
|
|
date of medical board (DA Form 3947) |
|
|
|
|
|
| PDCAPS |
1 |
PDA_MAIN |
36 |
mtf_code |
|
Yes |
|
C(4) |
|
|
|
pda_mtf.dbf |
|
ENABLE->MTF_CODE, TDRLMAIN->HOSP |
|
|
|
| PDCAPS |
1 |
PDA_MAIN |
42 |
result_d |
|
Yes |
|
D |
|
|
|
final result date |
|
CASELOAD->REFRAD |
|
|
|
| PDCAPS |
1 |
PDA_MAIN |
43 |
final_rslt |
|
Yes |
|
C(1) |
|
|
USACHPPM-KLCOX:
Noted. There are different outcomes available for final_rslt. Keep for now so we can compare with dispositn and come to understand how these fiields differ.
not disposition of board. |
final result of case (pda_rslt.dbf) |
|
CASELOAD->DISPOSITN (unless COAD, transferred to the Retired Reserve) |
|
|
|
| PDCAPS |
1 |
PDA-MAIN-DBF |
44 |
rsvd |
|
Yes |
|
C(20) |
|
|
|
special interest code field (PDA_VSRD.dbf table) |
|
|
|
|
|
| PDCAPS |
2 |
PDA_TRAN |
1 |
ssn |
DI |
Yes |
|
C(20) |
|
|
|
sets relation to pda_main->ssn |
|
|
|
|
|
| PDCAPS |
3 |
PDA_VSRD |
1 |
ssn |
DI |
Yes |
|
C(20) |
|
|
|
sets relation to pda_main->ssn |
|
|
|
|
|
| PDCAPS |
3 |
PDA_VSRD |
3 |
dispositn |
|
Yes |
|
C(2) |
|
|
|
the disposition of the board |
|
|
|
|
|
| PDCAPS |
3 |
PDA_VSRD |
5 |
percentage |
|
Yes |
|
C(3) |
|
|
|
percentage of disability |
|
|
|
|
|
| PDCAPS |
3 |
PDA_VSRD |
8 |
election |
|
Yes |
|
C(2) |
|
|
|
C=concurred, D=disagreed, R=rebuttel, X= failed to elect |
|
|
|
|
|
| PDCAPS |
3 |
PDA_VSRD |
9 |
combat |
|
Yes |
|
L(1) |
|
|
|
10A on DA Form 199 (armed conflict or instrumentality of war) |
|
|
|
|
|
|
|
|
|
combatzone |
|
|
|
|
|
|
|
|
|
|
|
|
|
| PDCAPS |
3 |
PDA_VSRD |
10 |
on_duty |
|
Yes |
|
L(1) |
|
|
|
10B on DA Form 199, on duty 24 Sep 1975 |
|
|
|
|
|
| PDCAPS |
3 |
PDA_VSRD |
11 |
combat_rel |
|
Yes |
|
L(1) |
|
|
|
10C on DA Form 199 combat related (26 U.S.C. 104) |
|
|
|
|
|
| PDCAPS |
3 |
PDA_VSRD |
12 |
vasrd_1 |
|
Yes |
|
C(4) |
|
|
|
|
|
|
|
|
|
| PDCAPS |
3 |
PDA_VSRD |
13 |
analog_1 |
|
Yes |
|
C(4) |
|
|
|
VASRD or Analogous code, every disability description has a string vasrd_1+analog_1, percent_1 (exceptions) |
|
|
|
|
|
| PDCAPS |
3 |
PDA_VSRD |
14 |
percent_1 |
|
Yes |
|
C(3) |
|
|
|
percentage rating of vasrd_1 and analog_1 |
|
|
|
|
|
| PDCAPS |
3 |
PDA_VSRD |
15 |
vasrd_2 |
|
Yes |
|
C(4) |
|
|
|
|
|
|
|
|
|
| PDCAPS |
3 |
PDA_VSRD |
16 |
analog_2 |
|
Yes |
|
C(4) |
|
|
|
|
|
|
|
|
|
| PDCAPS |
3 |
PDA_VSRD |
17 |
percent_2 |
|
Yes |
|
C(3) |
|
|
|
|
|
|
|
|
|
| PDCAPS |
3 |
PDA_VSRD |
18 |
vasrd_3 |
|
Yes |
|
C(4) |
|
|
|
|
|
|
|
|
|
| PDCAPS |
3 |
PDA_VSRD |
19 |
analog_3 |
|
Yes |
|
C(4) |
|
|
|
|
|
|
|
|
|
| PDCAPS |
3 |
PDA_VSRD |
20 |
percent_3 |
|
Yes |
|
C(4) |
|
|
|
|
|
|
|
|
|
| PDCAPS |
3 |
PDA_VSRD |
21 |
vasrd_4 |
|
Yes |
|
C(3) |
|
|
|
|
|
|
|
|
|
| PDCAPS |
3 |
PDA_VSRD |
22 |
analog_4 |
|
Yes |
|
C(4) |
|
|
|
|
|
|
|
|
|
| PDCAPS |
3 |
PDA_VSRD |
23 |
percent_4 |
|
Yes |
|
C(4) |
|
|
|
|
|
|
|
|
|
| PDCAPS |
4 |
PDA_ADMN |
1 |
ssn |
DI |
Yes |
|
C(20) |
|
|
|
pda_main->ssn |
|
|
|
|
|
| PDCAPS |
4 |
PDA_ADMN |
8 |
termvaiv_d |
|
Yes |
|
D |
|
|
|
date case terminated or formal board waived |
|
|
|
|
|