14. Database Definitions

In the tables describing databases field the Type column will contain one of the following:

In the case of strings, the length of the string is shown in parenthesis. For arrays of bytes, shorts, longs, and reals, the number of elements is shown in parenthesis. For string arrays, the length of each element followed by the number of elements, are shown in parenthesis and are separated by a comma. I.E. "String(6,50)" refers to a 50 element array of 6 character strings.

14.1 Export file format

This section describes the format of the ASCII text generated by the Export function. This is not a free format file. While there is some flexibility in placement of data, it is quite limited. The format described here reflects the version of VEWD at the time it was written and is subject to change without notice.

Each VED file contains seven (7) sections, some of which are may not be present. They are

  1. A header comment line
  2. Session definition line
  3. Optional code slot definition lines
  4. Attending VE Count
  5. Optional VE records (2 lines per record)
  6. Candidate count
  7. Optional candidate records (3 lines per record)

The VED file header is the first line in the file. The line generated by VEWD is of the form:

!! VEWD Version 2.2 ( 4/08/98) Exported session data file

The session definition line describes all the unique information required to re-create the session record except for the individual code slots. Table 14-1 describes the format of the session definition lines.

The code slot definition lines are only present if the number of code slots specified in the session definition line is non-zero. There is one code slot definition line per code slot. Table 14-2 describes the format of the code slot definition lines.

The Attending VE count is a single line containing the number of attending VE's. It may be zero. The VE lines are only present if the Attending VE count is non-zero. There are two VE lines per attending VE. slot. Table 14-3 describes the format of the first VE data line. The second VE data line is the 256 character notes field, without quotes.

The Candidate count is a single line containing the number of candidates. It may be zero. The candidate lines are only present if the Candidate count is non-zero. There are three candidate lines per candidate. Table 14-4 describes the format of the first candidate data line. Table 14-5 describes the format of the second candidate data line. The third candidate data line is the 256 character notes field, without quotes.

Table 14-1 VED Session definition line
DataFormat Trailing delimiter
Session DateMM/DD/YY None
Session ID1 Character Space
CityQuoted StringSpace
StateQuoted StringSpace
SponsorQuoted String Space
VECQuoted StringSpace
CallareaQuoted String Space
LiaisonQuoted String Space
Deleted FlagQuoted String "Y" or "N" Space
Fee$x.xxSpace
Retained$x.xxSpace
Sequence MaxnnnSpace
Code SlotsnnSpace
CSCE VE #16 Characters None
CSCE VE #26 Characters None
CSCE VE #36 Characters None
FCC VE #16 Characters None
FCC VE #26 Characters None
FCC VE #36 Characters Space
VEC Receipt dateMM/DD/YY None

Table 14-2 Code Slot definition line
DataFormatTrailing delimiter
TimeHH:MMSpace
StatusO, C or KSpace
User WPMnnSpace
Current WPMnnSpace
Max CandidatesnnNone

Table 14-3 VE definition line 1
DataFormatTrailing delimiter
First NameQuoted String Space
Middle InitialQuoted String Space
Last NameQuoted String Space
SuffixQuoted String Space
AddressQuoted String Space
CityQuoted StringSpace
StateQuoted StringSpace
Zip CodennnnnnnnnSpace
Night Phone(nnn)nnn-nnnn Space
Day Phone(nnn)nnn-nnnn Space
CallsignQuoted String Space
ClassQuoted StringSpace
VE ExpirationMM/DD/YY Space
License ExpirationMM/DD/YY Space
New Callsign6 Characters None
Nickname8 Characters None
DisplayY or NNone
Email AddressUp to 48 Characters None

Table 14-4 Candidate definition line 1
DataFormatTrailing delimiter
Sequence NumbernnnSpace
Registration #nnnSpace
First NameQuoted String Space
Middle InitialQuoted String Space
Last NameQuoted String Space
SuffixQuoted String Space
AddressQuoted String Space
CityQuoted StringSpace
StateQuoted StringSpace
Zip CodennnnnnnnnSpace
Night Phone(nnn)nnn-nnnn Space
Day Phone(nnn)nnn-nnnn Space
Date of Birthmm/dd/yy Space
CallsignQuoted String Space
FCC ClassQuoted String Space
Effective ClassQuoted String Space
Earned ClassQuoted String Space

Table 14-5 Candidate definition line 2
DataFormatTrailing delimiter
Spacer4 spacesNone
CSCE StatusY, N, or P None
ID VerifiedY, N, or * None
CompleteY or NNone
610 StatusY, N or P Space
610 Item 4CY or NNone
610 Item 4DY or NNone
610 Item 4EY or NNone
610 Item 4FY or NNone
610 Env. ImpactY or N Space
Cand SignedY or NNone
VE #1 SignedY or NNone
VE #2 SignedY or NNone
VE #3 SignedY or NNone
FCC ReviewY or NNone
Keyer Initials3 Characters Space
610 Other App. DateMM/DD/YY Space
Fee Paid$x.xxSpace
CSCE VE #16 Characters None
CSCE VE #26 Characters None
CSCE VE #36 Characters None
FCC VE #16 Characters None
FCC VE #26 Characters None
FCC VE #36 Characters Space
Element 1A8 Characters None
Element 1B8 Characters None
Element 1C8 Characters None
Element 28 Characters None
Element 3A8 Characters None
Element 3B8 Characters None
Element 4A8 Characters None
Element 4B8 Characters None
Email AddressUp to 48 Characters None

14.2 FCC Filing Format

This section describes the format of the ASCII text created by the Generate FCC filing data function. This is not a free format file. The data must conform to the format required by the FCC. The format described here reflects the version of VEWD at the time it was written and is subject to change without notice. Each record, session or candidate, contains multiple fields, not all of which are present. Each field is terminated by a vertical bar character (|). Each record is terminated by a carriage return and a line feed.

Each FCC file contains four (4) sections, some of which are may be repeated. They are

  1. A VEWD header line
  2. One or more Session definition lines
  3. A VEWD session header line (1 per session)
  4. Zero or more Candidate definitions lines (1 per session)

The session header line and candidate record block alternate in the file. The session header provides a convenient delimiter for visual inspection. The VEWD header is the first line in the file. It can have any text. This line is not specified by FCC and should be removed before submittal. The line generated by VEWD is of the form:

!! VEWD Version 2.2 ( 4/08/98) Generated FCC Electronic filing format

The header line is followed by a blank line. The session definition lines contain the FCC required session data in the format required by the FCC. Table 14-6 describes the format of the session definition lines.

Table 14-6 FCC Session definition line format
DataFormat
VEC Code and RegionXNN, e.g. D01
Test dateMM/DD/YYYY
Test City10 characters, no abbreviations, e.g. "BRATTLEBOR"
Test State2 characters. Use DX for foreign
New license/upgrade count, minus holds. nnn
New license/upgrade count, including holds. nnn
No license or upgrade countnnn
Exam elements passednnn
Exam elements failednnn
Reserved field 1Must Be Blank
Reserved field 2Must Be Blank
Reserved field 3Must Be Blank
HoldsHolds: firstname lastname, firstname lastname, etc.

If none, leave blank

The VEWD session header (1 per session) precedes the upgrade and new license candidate data for that session. It is followed by a blank line and provides a convenient delimiter for visual inspection. This line is not specified by FCC and should be removed before submittal. The line generated by VEWD is of the form:

Candidate records (nn) follow

Zero or more Candidate definitions lines follow each VEWD session header. The number of candidate lines matches the count in parenthesis on the session header line. The candidate definition lines contain the FCC required candidate data in the format required by the FCC. Table 14-7 describes the format of the candidate definition lines. The reserved first field provides an initial vertical bar (|) at the start of each candidate record.

Table 14-7 FCC Candidate definition line format
DataFormat
ReservedN/A
Callsign6 characters. All capitals
Lastname Suffix, Firstname Middle initial Space before suffix(if present). Space before Firstname. Space before Middle initial (if present). All capitals.
AddressAll capitals. No punctuation. No PO boxes. Apartment or room number (number only)at end of address (e.g. "6 BIRCH DRIVE 5" for apartment 5. If address is PO Box, this field is blank.
Post Office Box.Number only. If PO Box, the address is blank.
CityAll capitals. Max 20 characters, no abbreviations, United States addresses only
State2 characters. US States or AP for APO, FP for FPO.
Zip CodeFive or nine digits. No dash
Date of BirthMM/DD/YYYY
Purpose (Form 610 Item 4)A through F. A must be by itself. Any other actions may appear together, no spaces.
Old LastnameAll capitals. Max 10 characters. When purpose includes "C"
ReservedMust be blank
License class before test sessionBlank, N, T, P, G, A, or E. Where P is a Tech Plus.
Environmental impactQ, Y or N. All capitals. Should be N, otherwise attachments must be provided.
Pending applicationQ, Y or N. All capitals. Must be N to submit.
Applicants signature presentMust be Y
New License class earnedN, T, P, G, A, or E. Where P is a Tech Plus.
VEC receipt dateMM/DD/YYYY
VEC Code and RegionXNN, e.g. D01
Test dateMM/DD/YYYY
Test City10 characters, no abbreviations, e.g. "BRATTLEBOR"
Test State2 characters. Use DX for foreign
VE signatures present (VE1, VE2, VE3)Must be "YYY".
Physician's Certification address, signature, and Patient's Release Signature Should be "NNN", unless a certification is present. Then, must be "YYY".
Additional review requiredShould be N
VEC key entry person initialsIf VE team, then used "VET". All capitals.

14.3 The SESSION Database

The SESSION database contains a list of all the exam sessions conducted. There is one record per exam session. Table 14-8 describes the fields in the session database. There is one key file:

Table 14-8 SESSION Database Fields
Field NameType Description
DATELongDate of exam session
IDString(1)ID for multiple same day sessions
LIAISONString(6)Callsign of Session liaison
CITYString(32)Session Location City
STATEString(2)Session Location State
SPONSORString(32)Sponsor of session
VECString(32)Volunteer Examiner Coordinator
CALLAREAString(2)FCC US call district
FEERealSession Fee
RETAINEDRealPortion of fee retained
SEQWRAPByteWrap limit on sequence numbers
MERGELongSession merged into global database files:
­1 = Hasn't been;
0 = Has been;
>0 = Has been, and has changed since
DELETEDString(1)Candidate data deleted from history flag
VECRECEIPTLongDate of VEC Receipt
VECNTShortAttending VE count
VICNTShortVictim (candidate) Count
VIC73ShortVictim (candidate) complete count
NOVELONLYShortCount of candidates that have taken novice elements only
CSCE2PRINTShortCSCE's to be printed
FCC2PRINTShortForm 610's to print
EARNEDShort(6)Count of each license class earned (Novices,Technician, Technician Plus, General, Advanced, and Extra)
MARKEDLongTemp Marker field used by Alt-M
CWSLOTSShortNumber of CW test slots
VECALLString(6,50)Callsign list of VE's at session
VECLASSString(1)(50)Class (G, A, E)of VE's at time of session
LASTVECSCEString(6)(3)Callsigns of last 3 VE's signing CSCE's
LASTVEFCCString(6)(3)Callsigns of last 3 VE's signing FCC-610's
TIMELong(16)Time of CW Slot
SLOTCLOSEDString(1)(16)Slot status (O, C, K)
WPMShort(16)Current WPM/code slot
USERWPMShort(16)User specified WPM/code slot (0 = assign speed when first slot is allocated)
CWMAXShort(16)Maximum # of candidates in code slot
CWVICShort(16)Number of candidates in this CW slot
ELEMCNTShort(8)Element taken counts
ELEMPASSShort(8)Element passed counts
ELEMFAILShort(8)Element failed counts

14.4 The VEINFO Database

The VEINFO database contains the personal data for Volunteer Examiners. There is one record per VE. Table 14-9 describes the fields in the VEINFO database. There are two key files:

Table 14-9 VEINFO Database Fields
Field NameType Description
LASTString(20)Last name
FIRSTString(16)First name
MIString(1)Middle initial
SUFString(4)Suffix. Jr., Sr., III, etc.
ADRString(32)Address
CITYString(20)City/Town
STATEString(2)State
ZIPLongZip Code
HPHONEDecimal(10)Home Phone number
WPHONEDecimal(10)Work Phone Number
CLASSString(8)Current License class
CALLString(6)Callsign
NEWCALLString(6)New Callsign. If non-blank indicates an old VE record.
NICKNAMEString(8)Casual name of VE.
EMAILString(48)Electronic mail address
VEEXPIRELongVE accreditation expiration date
LICEXPIRELongLicense Expiration
NOTIFYString(1)Notify VE about next session (Y or N)
DISPLAYString(1)Flag (Y/N) on showing this record in VE list
DATELongLast Session Attended
IDString(1)ID of Last session Attended
SESSIONCNTShortTotal Sessions Attended
NOTESString(32,8)Miscellaneous text

14.5 The ATTVE Database

The ATTVE database contains a list of all the VE's in the current exam session. There is one record per VE. Table 14-10 describes the fields in the ATTVE database. There are two key files:

Table 14-10 ATTVE Database Fields
Field Name
Type
Description
CALLString(6)Callsign
CLASSString(8)Class of VE at time of session
DATELongDate of Session
IDString(1)Session ID

14.6 The VICTIMS Database

The VICTIMS database contains a list of all the candidates in the current exam session. There is one record per candidate. A re-registration of a candidate counts as an additional candidate and results in another record. Table 14-11 describes the fields in the VICTIMS database. There are three key files:

Table 14-11 VICTIMS/VICTIMG Database Fields
Field NameType Description
DATELongDate of session
IDString(1)Session ID
SEQNOByteSequence number
REQNOByteRe-registration count
LASTString(20)Last name
FIRSTString(16)First name
MIString(1)Middle initial
SUFString(4)Suffix. Sr., Jr., III, etc.
ADRString(32)Address
CITYString(20)City/Town
STATEString(2)State
ZIPLongZip Code
HPHONEDecimal(10)Night/Home Phone number
WPHONEDecimal(10)Work/Day Phone number
DOBLongDate of Birth
CALLString(6)Callsign
EMAILString(48)Electronic mail address
CLASSString(8)Current License class
VCLASSString(8)Effective operating class
NEWCLASSString(8)New class earned
CSCEString(1)CSCE Issued/Printed (N, Y, P)
EYEDEEDString(1)Credentials verified
COMPLETEString(1)Testing completion status
FCC610String(1)610 Needed/Printed (N, Y, P)
FEERealSession fee paid
VECSCEString(6,3)VE's signing CSCE
VEFCCString(6,3)VE's signing 610
ELEMENTSString(8)Element status
FCC4CString(1)Form 610 Item 4C Status
FCC4DString(1)Form 610 Item 4D Status
FCC4EString(1)Form 610 Item 4E Status
FCC4FString(1)Form 610 Item 4F Status
FCCENVString(1)Old Form 610 Item 6 Environmental Impact Status
FCCOADString(1)Form 610 Item Other Application Date
SIGNVICTIMString(1) Candidate signature status
SIGNVE1String(1)VE 1 Signature status
SIGNVE2String(1)VE 2 Signature status
SIGNVE3String(1)VE 3 Signature status
FCCREVIEWString(1)Should FCC review application
DATADWEEBString(3)Data entry person Initials
NOTESString(64,4)

14.7 The VICTIMG Database

The VICTIMG database contains a list of all the candidates in every examination session. It is the sum of the VICTIMS database for each session that has been conducted. Table 14-11 describes the fields in the ATTVE database. There are three key files:

14.8 The LOCATION Database

The LOCATION database contains a list of City, State, and Zip Code triples. It is used to speed data entry by allowing manual and automatic lookups of one or two of the fields based on the value of the other field(s). Table 14-12 describes the fields in the LOCATION database. There are two key files:

14.9 The DEFAULTS Database

The DEFAULTS database contains the defaults for the VE team. There is a minimum of one record in this database. Table 14-13 describes the fields in the DEFAULTS database. There is one key file:

Table 14-12 LOCATION Database Fields
Field Name
Type
Description
CITYString(20)Town or City
STATEString(2)State
ZIPLongZip Code

Table 14-13 DEFAULTS Database Fields
Field NameTypeDescription
NAMEString(32)Configuration Name
DEFAULTShortRecord number of default configuration record
LIAISONString(6)Default Team Leader Callsign
SEQWRAPByteDefault wrap limit on sequence numbers
LPT610String(12)Printer type for 610's
LPTCSCEString(12)Printer type for CSCE's
LPTRPTSString(12)Printer type for reports
DEVICE610String(12) Print device for 610's
DEVICECSCEString(12) Print device for CSCE's
DEVICERPTSString(12) Print device for reports
FILLINVEString(1)Fill in CSCE/610 Signatures
LOOKUPVCALLString(1) Lookup Victim on Callsign
LOOKUPFCCString(10) Lookup Victim in an FCC database collection
LOOKUPVNAMEString(1) Lookup victim on last name
LOOKUPCITYString(1) Lookup city
LOOKUPZIPString(1)Lookup Zip Code
ADDNEWCITIESString(1) Add new cities to LOCATION database
ADRATREGString(1)Require Address @ Registration
AUTOPRINTString(1)Automatically print on candidate completion Enabled
AUTOPRTCSCEString(1) Automatically print CSCE's on candidate completion
AUTOPRT610String(1) Automatically print 610's on candidate completion
AUTOCLOSEString(1)Automatically close CW slots when past start time
VECString(32)Default Sponsoring VEC
CALLAREAString(2)FCC call district
CITYString(32)City of Session
STATEString(2)State of Session
SPONSORString(32)Sponsor of session
FEERealSession Fee
RETAINEDRealPortion of fee retained
CWMAXShortMax victims/CW slot
CWINTERVALLongAverage time between CW slots
BACKINTLongBackup interval
BACKCMDString(32)What to execute on
FCCDBPATHString(64) Path to FCC data (dependent on LOOKUPFCC choice)
VECSCEString(6,3)VE's signing CSCE
VEFCCString(6,3)VE's signing 610

14.10 The VECLIST Database

The VECLIST database contains a list of all the Volunteer Examiner Coordinator's (VEC's) currently in existence. There is one record per VEC. Table 14-14 describes the fields in the VECLIST database. There is one key file, the VEC field. This is a fixed database, and cannot be changed by the user. Its only purpose is the scrolling list that pops up on the Define Session form, when an incorrect VEC is entered, and to store the FCC assigned VEC identification letter. The VEC's currently in the VECLIST database are shown in Table 14-15.

Table 14-14 VECLIST Database Fields
Field Name
Type
Description
VECString(32)A Valid VEC
FCCIDString(1)One character FCC assigned VEC ID

Table 14-15 Current VEC's
Anchorage Amateur Radio ClubMilwaukee Radio Amateurs Club
ARRL/VECMO-KAN VE Coordinator
Central Alabama VECMountain Amateur Radio Club
Charlotte VECSandarc­VEC
Golden Empire ARSSunnyvale VEC Amateur Radio Club
Greater Los Angeles ARGW4VEC
Jefferson Amateur Radio ClubW5YI­VEC
Koolau Amateur Radio ClubWestern Carolina ARS VEC
Laurel Amateur Radio Club

14.11 The ELEMSTAT Database

The ELEMSTAT database contains a list of all the valid choices for element status, excluded CSCE dates. Table 14-16 describes the fields in the ELEMSTAT database. There is one key file, the status field. This is a fixed database, and cannot be changed by the user. Its only purpose is the scrolling list that pops up on form containing element status when an incorrect value is entered. The values in the ELEMSTAT database are shown in Table 14-17.

Table 14-16 ELEMSTAT Database Fields
Field Name
Type
Description
STATUSString(8)An element status

Table 14-17 ELEMSTAT Values
  • Credit
  • Candidate has credit for this element. I.E. Grandfather credit for element 3B for Technicians licensed before 21 March 1987.
  • Exempt
  • Candidate has an exemption for this element. I.E. Physician's certificate for the Morse code exemption.
  • Fail
  • Candidate has failed this element.
  • Grading
  • Candidate has taken this element, and it has not been graded yet.
  • Pass
  • Candidate has passed this element.
  • Taking
  • Candidate is currently taking this element.
  • Wants
  • Candidate wants to take this element.



    Last Modified: 01 January 1998
    Jim Heedles: heedles@ww1y.mv.com