USAFA Class of 1965
https://usafa-1965.org
Database Fields
===============
# Note text starting with '#' is a comment
# primary data
# ------------
sqdn # CS assignment(s) during USAFA as a '65 member
preferred_sqdn # preferred CS for data keeping and primary association
last # last name
first - first name
middle - middle name
suff - Jr., I, II, etc.
nickname - preferred name for friends
index - unique index number assigned by DBA
# contact data
# ------------
email - preferred e-mail address
cert_email - for DBA use only!! this address is keyed to the cert
email2 - secondary
email3 - tertiary
home_phone - with country code if not US
cell_phone - with country code if not US
work_phone - with country code if not US
fax_phone - with country code if not US
address1 - first address line
address2 - as needed
address3 - as needed
city
state
zip
country
foreign_zip
# spouse data (if classmate is deceased, classmate contact data fields
# are assumed to be that of family POC (widow or child)
# -----------
spouse_first
spouse_last - if different from classmate
spouse_email - if different from classmate
spouse_cell - if different from classmate
family_poc - empty (no interest) or 'widow', 'daughter', etc.
poc_title - Mr., Ms., etc.
poc_first - POC first name (if POC not 'widow')
poc_last - POC last name (if POC not 'widow')
# reunion plans
# -------------
reunion50 # code for plans for attending the 50th class reunion:
# 0: unknown
# 1-6: definite with number attending
# 7: plan YES with guests
# 8: plan YES alone
# 9: plan NOT to attend
#
# Examples:
# 3 - classmate definitely plans to attend with 2 guests (total of 3)
# 7 - classmate plans to go with unknown number of guests
# 9 - classmate plans NOT to attend
# 8 - classmate plans to attend alone
# data privacy (normally zero if no concern or restriction)
# ------------
# note the next three fields have a different meaning for zero values:
# this field is ONLY for the data on the maps
show_on_map # codes for showing precise location and name on maps:
# 0: do NOT show
# 1: do show location and name
# this field is ONLY for the data on the maps (and only for widows)
show_on_map_spouse # codes for showing precise location and name on maps:
# 0: do NOT show
# 1: do show location and name
# this field lists any restrictions on display of data on the web site
# (spreadsheets, etc.)
hide_data # codes for restricting data shown on the web site:
# 0: (default) show data to all classmates on the "Classmates
# Only" page (secure access required via a valid
# TLS certificate)
# 1: show data to REPs and DBA only (not currently implemented,
# treated same as a code '2' below for now)
# 2: do NOT show or use any data; data are not currently
# shown on any web-accessible page or spreadsheet, entries
# are marked "Data restricted" or "(Classmate wants to hide
# data)"
buzz_off # >0: never bother me again!
# admin data
# ----------
# two updated fields: one for CS Rep and one for DBA use
dba_updated # use ISO date format YYYY-MM-DD, e.g., 3 Apr 2013: 2013-04-03
csrep_updated # use ISO date format YYYY-MM-DD, e.g., 3 Apr 2013: 2013-04-03
file
# two comment fields: one for CS Rep and one for DBA use
dba_comments # for database administrator and assistants
csrep_comments # CS rep comments
memory_file
deceased
burial_site
polaris62orig
polaris62corrected
seqnum
page
pagepart
picsource
nobct1961 # 0 - default, 1 - did NOT start with the class in BCT
left_usafa
graduated
commissioned
aog_id
aog_status
aog_addressee
highest_rank # 1Lt, Maj, LtCol, Col, BrigGen
service # USAF, USMC, etc.
cert_installed # 'yyyy-mm-dd'
operating_system # 'Mac OS X', etcx
# data for deceased members
# (widows, children, burial site, etc.)',
# (to be added as needed)