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)