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.
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
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.
Data | Format | Trailing delimiter |
Session Date | MM/DD/YY | None |
Session ID | 1 Character | Space |
City | Quoted String | Space |
State | Quoted String | Space |
Sponsor | Quoted String | Space |
VEC | Quoted String | Space |
Callarea | Quoted String | Space |
Liaison | Quoted String | Space |
Deleted Flag | Quoted String "Y" or "N" | Space |
Fee | $x.xx | Space |
Retained | $x.xx | Space |
Sequence Max | nnn | Space |
Code Slots | nn | Space |
CSCE VE #1 | 6 Characters | None |
CSCE VE #2 | 6 Characters | None |
CSCE VE #3 | 6 Characters | None |
FCC VE #1 | 6 Characters | None |
FCC VE #2 | 6 Characters | None |
FCC VE #3 | 6 Characters | Space |
VEC Receipt date | MM/DD/YY | None |
Data | Format | Trailing delimiter |
Time | HH:MM | Space |
Status | O, C or K | Space |
User WPM | nn | Space |
Current WPM | nn | Space |
Max Candidates | nn | None |
Data | Format | Trailing delimiter |
First Name | Quoted String | Space |
Middle Initial | Quoted String | Space |
Last Name | Quoted String | Space |
Suffix | Quoted String | Space |
Address | Quoted String | Space |
City | Quoted String | Space |
State | Quoted String | Space |
Zip Code | nnnnnnnnn | Space |
Night Phone | (nnn)nnn-nnnn | Space |
Day Phone | (nnn)nnn-nnnn | Space |
Callsign | Quoted String | Space |
Class | Quoted String | Space |
VE Expiration | MM/DD/YY | Space |
License Expiration | MM/DD/YY | Space |
New Callsign | 6 Characters | None |
Nickname | 8 Characters | None |
Display | Y or N | None |
Email Address | Up to 48 Characters | None |
Data | Format | Trailing delimiter |
Sequence Number | nnn | Space |
Registration # | nnn | Space |
First Name | Quoted String | Space |
Middle Initial | Quoted String | Space |
Last Name | Quoted String | Space |
Suffix | Quoted String | Space |
Address | Quoted String | Space |
City | Quoted String | Space |
State | Quoted String | Space |
Zip Code | nnnnnnnnn | Space |
Night Phone | (nnn)nnn-nnnn | Space |
Day Phone | (nnn)nnn-nnnn | Space |
Date of Birth | mm/dd/yy | Space |
Callsign | Quoted String | Space |
FCC Class | Quoted String | Space |
Effective Class | Quoted String | Space |
Earned Class | Quoted String | Space |
Data | Format | Trailing delimiter |
Spacer | 4 spaces | None |
CSCE Status | Y, N, or P | None |
ID Verified | Y, N, or * | None |
Complete | Y or N | None |
610 Status | Y, N or P | Space |
610 Item 4C | Y or N | None |
610 Item 4D | Y or N | None |
610 Item 4E | Y or N | None |
610 Item 4F | Y or N | None |
610 Env. Impact | Y or N | Space |
Cand Signed | Y or N | None |
VE #1 Signed | Y or N | None |
VE #2 Signed | Y or N | None |
VE #3 Signed | Y or N | None |
FCC Review | Y or N | None |
Keyer Initials | 3 Characters | Space |
610 Other App. Date | MM/DD/YY | Space |
Fee Paid | $x.xx | Space |
CSCE VE #1 | 6 Characters | None |
CSCE VE #2 | 6 Characters | None |
CSCE VE #3 | 6 Characters | None |
FCC VE #1 | 6 Characters | None |
FCC VE #2 | 6 Characters | None |
FCC VE #3 | 6 Characters | Space |
Element 1A | 8 Characters | None |
Element 1B | 8 Characters | None |
Element 1C | 8 Characters | None |
Element 2 | 8 Characters | None |
Element 3A | 8 Characters | None |
Element 3B | 8 Characters | None |
Element 4A | 8 Characters | None |
Element 4B | 8 Characters | None |
Email Address | Up to 48 Characters | None |
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
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.
Data | Format |
VEC Code and Region | XNN, e.g. D01 |
Test date | MM/DD/YYYY |
Test City | 10 characters, no abbreviations, e.g. "BRATTLEBOR" |
Test State | 2 characters. Use DX for foreign |
New license/upgrade count, minus holds. | nnn |
New license/upgrade count, including holds. | nnn |
No license or upgrade count | nnn |
Exam elements passed | nnn |
Exam elements failed | nnn |
Reserved field 1 | Must Be Blank |
Reserved field 2 | Must Be Blank |
Reserved field 3 | Must Be Blank |
Holds | Holds: 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.
Data | Format |
Reserved | N/A |
Callsign | 6 characters. All capitals |
Lastname Suffix, Firstname Middle initial | Space before suffix(if present). Space before Firstname. Space before Middle initial (if present). All capitals. |
Address | All 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. |
City | All capitals. Max 20 characters, no abbreviations, United States addresses only |
State | 2 characters. US States or AP for APO, FP for FPO. |
Zip Code | Five or nine digits. No dash |
Date of Birth | MM/DD/YYYY |
Purpose (Form 610 Item 4) | A through F. A must be by itself. Any other actions may appear together, no spaces. |
Old Lastname | All capitals. Max 10 characters. When purpose includes "C" |
Reserved | Must be blank |
License class before test session | Blank, N, T, P, G, A, or E. Where P is a Tech Plus. |
Environmental impact | Q, Y or N. All capitals. Should be N, otherwise attachments must be provided. |
Pending application | Q, Y or N. All capitals. Must be N to submit. |
Applicants signature present | Must be Y |
New License class earned | N, T, P, G, A, or E. Where P is a Tech Plus. |
VEC receipt date | MM/DD/YYYY |
VEC Code and Region | XNN, e.g. D01 |
Test date | MM/DD/YYYY |
Test City | 10 characters, no abbreviations, e.g. "BRATTLEBOR" |
Test State | 2 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 required | Should be N |
VEC key entry person initials | If VE team, then used "VET". All capitals. |
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:
Field Name | Type | Description |
DATE | Long | Date of exam session |
ID | String(1) | ID for multiple same day sessions |
LIAISON | String(6) | Callsign of Session liaison |
CITY | String(32) | Session Location City |
STATE | String(2) | Session Location State |
SPONSOR | String(32) | Sponsor of session |
VEC | String(32) | Volunteer Examiner Coordinator |
CALLAREA | String(2) | FCC US call district |
FEE | Real | Session Fee |
RETAINED | Real | Portion of fee retained |
SEQWRAP | Byte | Wrap limit on sequence numbers |
MERGE | Long | Session merged into global database files: 1 = Hasn't been; 0 = Has been; >0 = Has been, and has changed since |
DELETED | String(1) | Candidate data deleted from history flag |
VECRECEIPT | Long | Date of VEC Receipt |
VECNT | Short | Attending VE count |
VICNT | Short | Victim (candidate) Count |
VIC73 | Short | Victim (candidate) complete count |
NOVELONLY | Short | Count of candidates that have taken novice elements only |
CSCE2PRINT | Short | CSCE's to be printed |
FCC2PRINT | Short | Form 610's to print |
EARNED | Short(6) | Count of each license class earned (Novices,Technician, Technician Plus, General, Advanced, and Extra) |
MARKED | Long | Temp Marker field used by Alt-M |
CWSLOTS | Short | Number of CW test slots |
VECALL | String(6,50) | Callsign list of VE's at session |
VECLASS | String(1)(50) | Class (G, A, E)of VE's at time of session |
LASTVECSCE | String(6)(3) | Callsigns of last 3 VE's signing CSCE's |
LASTVEFCC | String(6)(3) | Callsigns of last 3 VE's signing FCC-610's |
TIME | Long(16) | Time of CW Slot |
SLOTCLOSED | String(1)(16) | Slot status (O, C, K) |
WPM | Short(16) | Current WPM/code slot |
USERWPM | Short(16) | User specified WPM/code slot (0 = assign speed when first slot is allocated) |
CWMAX | Short(16) | Maximum # of candidates in code slot |
CWVIC | Short(16) | Number of candidates in this CW slot |
ELEMCNT | Short(8) | Element taken counts |
ELEMPASS | Short(8) | Element passed counts |
ELEMFAIL | Short(8) | Element failed counts |
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:
Field Name | Type | Description |
LAST | String(20) | Last name |
FIRST | String(16) | First name |
MI | String(1) | Middle initial |
SUF | String(4) | Suffix. Jr., Sr., III, etc. |
ADR | String(32) | Address |
CITY | String(20) | City/Town |
STATE | String(2) | State |
ZIP | Long | Zip Code |
HPHONE | Decimal(10) | Home Phone number |
WPHONE | Decimal(10) | Work Phone Number |
CLASS | String(8) | Current License class |
CALL | String(6) | Callsign |
NEWCALL | String(6) | New Callsign. If non-blank indicates an old VE record. |
NICKNAME | String(8) | Casual name of VE. |
String(48) | Electronic mail address | |
VEEXPIRE | Long | VE accreditation expiration date |
LICEXPIRE | Long | License Expiration |
NOTIFY | String(1) | Notify VE about next session (Y or N) |
DISPLAY | String(1) | Flag (Y/N) on showing this record in VE list |
DATE | Long | Last Session Attended |
ID | String(1) | ID of Last session Attended |
SESSIONCNT | Short | Total Sessions Attended |
NOTES | String(32,8) | Miscellaneous text |
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:
CALL | String(6) | Callsign |
CLASS | String(8) | Class of VE at time of session |
DATE | Long | Date of Session |
ID | String(1) | Session ID |
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:
Field Name | Type | Description |
DATE | Long | Date of session |
ID | String(1) | Session ID |
SEQNO | Byte | Sequence number |
REQNO | Byte | Re-registration count |
LAST | String(20) | Last name |
FIRST | String(16) | First name |
MI | String(1) | Middle initial |
SUF | String(4) | Suffix. Sr., Jr., III, etc. |
ADR | String(32) | Address |
CITY | String(20) | City/Town |
STATE | String(2) | State |
ZIP | Long | Zip Code |
HPHONE | Decimal(10) | Night/Home Phone number |
WPHONE | Decimal(10) | Work/Day Phone number |
DOB | Long | Date of Birth |
CALL | String(6) | Callsign |
String(48) | Electronic mail address | |
CLASS | String(8) | Current License class |
VCLASS | String(8) | Effective operating class |
NEWCLASS | String(8) | New class earned |
CSCE | String(1) | CSCE Issued/Printed (N, Y, P) |
EYEDEED | String(1) | Credentials verified |
COMPLETE | String(1) | Testing completion status |
FCC610 | String(1) | 610 Needed/Printed (N, Y, P) |
FEE | Real | Session fee paid |
VECSCE | String(6,3) | VE's signing CSCE |
VEFCC | String(6,3) | VE's signing 610 |
ELEMENTS | String(8) | Element status |
FCC4C | String(1) | Form 610 Item 4C Status |
FCC4D | String(1) | Form 610 Item 4D Status |
FCC4E | String(1) | Form 610 Item 4E Status |
FCC4F | String(1) | Form 610 Item 4F Status |
FCCENV | String(1) | Old Form 610 Item 6 Environmental Impact Status |
FCCOAD | String(1) | Form 610 Item Other Application Date |
SIGNVICTIM | String(1) | Candidate signature status |
SIGNVE1 | String(1) | VE 1 Signature status |
SIGNVE2 | String(1) | VE 2 Signature status |
SIGNVE3 | String(1) | VE 3 Signature status |
FCCREVIEW | String(1) | Should FCC review application |
DATADWEEB | String(3) | Data entry person Initials |
NOTES | String(64,4) |
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:
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:
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:
CITY | String(20) | Town or City |
STATE | String(2) | State |
ZIP | Long | Zip Code |
Field Name | Type | Description |
NAME | String(32) | Configuration Name |
DEFAULT | Short | Record number of default configuration record |
LIAISON | String(6) | Default Team Leader Callsign |
SEQWRAP | Byte | Default wrap limit on sequence numbers |
LPT610 | String(12) | Printer type for 610's |
LPTCSCE | String(12) | Printer type for CSCE's |
LPTRPTS | String(12) | Printer type for reports |
DEVICE610 | String(12) | Print device for 610's |
DEVICECSCE | String(12) | Print device for CSCE's |
DEVICERPTS | String(12) | Print device for reports |
FILLINVE | String(1) | Fill in CSCE/610 Signatures |
LOOKUPVCALL | String(1) | Lookup Victim on Callsign |
LOOKUPFCC | String(10) | Lookup Victim in an FCC database collection |
LOOKUPVNAME | String(1) | Lookup victim on last name |
LOOKUPCITY | String(1) | Lookup city |
LOOKUPZIP | String(1) | Lookup Zip Code |
ADDNEWCITIES | String(1) | Add new cities to LOCATION database |
ADRATREG | String(1) | Require Address @ Registration |
AUTOPRINT | String(1) | Automatically print on candidate completion Enabled |
AUTOPRTCSCE | String(1) | Automatically print CSCE's on candidate completion |
AUTOPRT610 | String(1) | Automatically print 610's on candidate completion |
AUTOCLOSE | String(1) | Automatically close CW slots when past start time |
VEC | String(32) | Default Sponsoring VEC |
CALLAREA | String(2) | FCC call district |
CITY | String(32) | City of Session |
STATE | String(2) | State of Session |
SPONSOR | String(32) | Sponsor of session |
FEE | Real | Session Fee |
RETAINED | Real | Portion of fee retained |
CWMAX | Short | Max victims/CW slot |
CWINTERVAL | Long | Average time between CW slots |
BACKINT | Long | Backup interval |
BACKCMD | String(32) | What to execute on |
FCCDBPATH | String(64) | Path to FCC data (dependent on LOOKUPFCC choice) |
VECSCE | String(6,3) | VE's signing CSCE |
VEFCC | String(6,3) | VE's signing 610 |
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.
VEC | String(32) | A Valid VEC |
FCCID | String(1) | One character FCC assigned VEC ID |
Anchorage Amateur Radio Club | Milwaukee Radio Amateurs Club |
ARRL/VEC | MO-KAN VE Coordinator |
Central Alabama VEC | Mountain Amateur Radio Club |
Charlotte VEC | SandarcVEC |
Golden Empire ARS | Sunnyvale VEC Amateur Radio Club |
Greater Los Angeles ARG | W4VEC |
Jefferson Amateur Radio Club | W5YIVEC |
Koolau Amateur Radio Club | Western Carolina ARS VEC |
Laurel Amateur Radio Club |
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.
STATUS | String(8) | An element status |
Candidate has credit for this element. I.E. Grandfather credit for element 3B for Technicians licensed before 21 March 1987. | |
Candidate has an exemption for this element. I.E. Physician's certificate for the Morse code exemption. | |
Candidate has failed this element. | |
Candidate has taken this element, and it has not been graded yet. | |
Candidate has passed this element. | |
Candidate is currently taking this element. | |
Candidate wants to take this element. |