USARSUPTHAI Association Directory.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Select the DirectoryTab to see the data.
2
Data Date15-Jul-2017This is the currency date of the data in the spreadsheet.
3
Please advise the Administrator if your data is in error.
4
5
Spec Proc AdminTo Update information, send email to Barry_P_Meyer@hotmail.com
6
Preferred, but not required: Send copy of Data Sheet as attachment
7
8
TABSTab Definition for this Workbook
9
KeyThe Sheet describing the Directory
10
DirectoryThe Curren Direcory of the Association
11
Unit TypeValue of the Unit Type within the Directory (Other "Types" may be requested for specific units
12
Data SheetThe Data Sheetis provided as a convenience and can be copy/pasted into email.
13
14
The Data Sheetis provided as a convenience and can be copy/pasted into email.
15
16
The data is from USARSUPTHAI Web Sites and Groups
17
1. USARSUPTHAI Association Members
18
2. USARSUPTHAI Site Members
19
3. 519th Site Members
20
4. USARSUPTHAI Facebook Group Membership
21
5. Yahoo USARSUPTHAI Group Members
22
6. Jack's Corner (Former USARSUPTHAI Membership Organization)
23
7. Continuous collection from USARSUPTHAI Site Member, Yahoo Group, and Facebook Group.
24
25
Due to multiple extractions, the color coding may not be exact, but can be extrapolated
26
Highlighted Records
Highlighted records indicate there may be an issue with the extracted data.
27
Highlighted records indicate the individual may be a member of Facebook due to similarity or partial names.
28
Highlighted records indicate a Facebook Member, but not onUSARSUPTHAI Association List
29
If Yahoo is highlighted, then then email sent to the member bounces.
30
Highlighted Record added from 2004 Association Records
31
Deceased Members
Information is Displayed as Red
32
33
Field NamesField Usage
34
Mult
Blank if only one record for an individual. Incremented as A, B, C, etc. if there are multiple assignments.
35
Yahoo
Value of "Yahoo" indicates the individual is a member of the Yahoo Group (See highlight exception above)
36
FBValue of "FB" indicates the individual is a member of the Facebook Group
37
U SM
Value of "U" indicates the individual is a USARSUPTHAI Association Site Member: Selecting the "U" will link to the record.
38
519 SM
Value of "519" indicates the individual is a 519th Trans Association Site Member: Selecting the "519" will link to the record.
39
RelationshipIf a Relative of a USARSUPTHAI Veteran is a member, this is the relationship
40
Rel NameIf a Relative of a USARSUPTHAI Veteran is a member, this is the relative's name.
41
LastIndividual's last name
42
FirstIndividual's first name, possibly initials or middle name, and Jr or Sr if provided
43
FamiliarIdividual's first name or nickname: if provided
44
UnitsUnit of assignment or attachment.
45
TypeType of Unit (See Unit Type Tab for Definitions)
46
BaseThe base provided for the assignment
47
LocationThe location of the base
48
Additional Information
Various additional information. Examples are rank, staff position, or other information provided
49
Dates
The dates or years of an assignment. Some individuals with multiple assignments have broken out dates.
50
HomeThe last known location of the individual
51
StateThe State or Country of the last known location
52
BornDate of individual's birth: Generally only known for deceased individuals.
53
DiedDate of indivual's death.
54
BuriedLocation of burial site for deceased individual
55
EAssignments preceding 1960, designated by "x"
56
60An "x" indicates the individual was in this assignment for at least a portion of the year. Use as Filter.
57
61
58
62
59
63
60
64
61
65
62
66
63
67
64
68
65
69
66
70
67
71
68
72
69
73
70
74
71
75
72
76
73
99Assignments beyond 1976, designated by "x"
74
TOTThe total number of years within assignments. This also serves as a check digit for the spreadsheet.
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Key
Directory
Unit Type
Data Sheet