User Contributed (Unofficial) Forms
Data File Format
Field Name Data Type Field Length Notes
Certificate Number String 7 X123456
Last NameString25
First NameString15(update 04 Feb)
Rank CodeString3(see rank.html)
GradeString2S/P/AP/JN/N/FC
District NumberInteger2(see sqd.html)
Squadron CodeInteger4(see sqd.html)
Membership TypeString2(see member.html)
Membership StatusInteger2(see member.html)
SexString1M/F
Address 1String30
Address 2String30
CityString30
StateString2
Zip CodeString501234 (see notes)
Zip plus 4String40987 (see notes)
Membership DateInteger6MMDDYY
Birth DateInteger6MMDDYY
Senior YearInteger4CCYY
Life YearInteger4CCYY
Home PhoneString10AAAEEENNNN
Work PhoneString10AAAEEENNNN
Work ExtensionString5
Work Phone OKString1Y/N
Fax PhoneString10AAAEEENNNN
Email AddressString40
Active CertificateString7X123456
Boat TypeString30P/S
Boat NameString30
Home PortString30
Previous DistrictInteger2(see sqd.html)
Previous SquadronInteger4(see sqd.html)
Original DistrictInteger2(see sqd.html)
Original SquadronInteger4(see sqd.html)
Total Years MemberInteger2
Total Merit MarksInteger2
Spouse NameString30
Spouse CertificateString7X123456
Spouse SexString1M/F
Squadron RankString3(see rank.html)
Squadron Field 1String30
Squadron Field 2String30
SInteger6CCYYMM
PInteger6CCYYMM
APInteger6CCYYMM
JNInteger6CCYYMM
NInteger6CCYYMM
EMInteger6CCYYMM
IQInteger6CCYYMM
MEInteger6CCYYMM
SAInteger6CCYYMM
WXInteger6CCYYMM
ITInteger6CCYYMM
IAInteger6CCYYMM
OTInteger6CCYYMM
CPInteger6CCYYMM
Last BDU ChangeInteger8CCYYMMDD
Last HQ ChangeInteger8CCYYMMDD

Notes:
  1. All fields are separated by a comma (,).
  2. String values are always enclosed in double-quotes (").
  3. Field length given is maximum characters allowed for the field.
  4. Unknown, empty, or otherwise invalid strings may be the empty string, all spaces, or zero-filled.
  5. Integer values might contain leading zeros, particularly when used to represent dates.
  6. Unknown, empty, or otherwise invalid integers are represented by 0.
  7. Zip codes will require leading zeros to correctly format 5-digit and zip-plus-4 codes.
  8. Zip-plus-4 notation using a plus-4 of all zeros (-0000) is not valid - use the 5-digit instead.
Privacy | Trademarks | Disclaimer | Contact | ©2006 United States Power Squadrons