The following table lists the fields that can be imported into the TAP Fixed Facility database using the Facility Exchange Format (FXF).
The FXF file can be
A dBase (.DBF) file using the "Field Name" column values in the table as the field names in the DBF file
An Excel spreadsheet that contains the "Field Name" column values as the first row in each column of the spreadsheet
A comma-delimited ASCII file containing the "Field Name" column values, separated by commas, as the first line in the file
| Field Name | Field Header | Data Type | FoxPro Data Type | Total Field Width | Field Decimal Places |
Comments |
|---|---|---|---|---|---|---|
| FAC_DESC | DESCRIPTION | STRING | C | 40 | 0 |
Text description |
| FAC_LAT | Latitude | DOUBLE | F | 14 | 9 |
Facility (tower) latitude (+ for North, - for South) |
| FAC_LON | Longitude | DOUBLE | F | 14 | 9 |
Facility (tower) longitude (+ for East, - for West) |
| FAC_DATUM | Datum | STRING | C | 13 | 0 |
Facility coordinate datum NAD 27 or NAD 83 |
| FAC_ELV | Site Elevation | DOUBLE | F | 10 | 4 |
Site elevation AMSL |
| FAC_ELVUN | Elevation Units | STRING | C | 2 | 0 |
Units for site elevation m for meters or ft for feet |
| FAC_ELMODE | ELV MODE | STRING | C | 4 | 0 |
Source of Facility Site Elevation: SPEC or CALC |
| TX_A1ERP | TX Ant1 ERP | DOUBLE | F | 10 | 4 |
TX Effective Radiated Power |
| TX_A1ERPUN | TX Ant1 ERP UN | STRING | C | 3 | 0 |
Units for TX ERP W for Watts kW for kiloWatts mW for milliWatts dBm dBW dBk |
| TX_ERPMODE | TX ERP MODE | STRING | C | 4 | 0 |
Source of TX ERP value: SPEC if the ERP is specified directly (such as manual entry or imported) CALC if the ERP is calculated from the database TPO + Gains - Losses |
| TX_FREQMHZ | TX FREQ | DOUBLE | F | 11 | 5 |
TX frequency in MHz |
| TX_DIVFMHZ | TX DIV FREQ | DOUBLE | F | 10 | 4 |
TX diversity frequency in MHz |
| TX_A1AGL | TX Ant1 AGL | DOUBLE | F | 10 | 4 |
TX antenna height for center of radiation |
| TX_A1AGLUN | TX Ant1 AGL UN | STRING | C | 2 | 0 |
Units for antenna height for TX |
| TX_A1ELMOD | AGL or MSL? | STRING | C | 3 | 0 |
TX antenna height reference: AGL or MSL |
| TX_TPO | TX TPO | DOUBLE | F | 10 | 4 |
Transmitter power output |
| TX_TPOUN | TX TPO UNITS | STRING | C | 3 | 0 |
TPO units W for Watts kW for kiloWatts mW for milliWatts dBm dBW dBk |
| TX_L1FNM | TX L1 FNM | STRING | C | 8 | 0 |
File name for TAP line library containing TX line #1 (8.3 format file name, name only without ".DBF" extent) |
| TX_L1TID | TX Line1Type ID | STRING | C | 10 | 0 |
ID for TAP line library record for TX line #1 |
| TX_L1TYP | TX Line1TYPE | STRING | C | 75 | 0 |
Description from TAP line library record for TX line #1 |
| TX_L1LEN | TX Line1 LEN | DOUBLE | F | 10 | 4 |
Length of TX line #1 |
| TX_L1LENUN | TX Line1 LEN UN | STRING | C | 2 | 0 |
Units of length of TX line #1 |
| TX_L1LOS | TX Line 1 Loss | DOUBLE | F | 10 | 4 |
dB loss of TX line #1 |
| TX_L2FNM | TX L2 FNM | STRING | C | 8 | 0 |
File name for TAP line library containing TX line #2 (8.3 format file name, name only without ".DBF" extent) |
| TX_L2TID | TX Line2Type ID | STRING | C | 10 | 0 |
ID for TAP line library record for TX line #2 |
| TX_L2TYP | TX Line2TYPE | STRING | C | 75 | 0 |
Description from TAP line library record for TX line #2 |
| TX_L2LEN | TX Line2 LEN | DOUBLE | F | 10 | 4 |
Length of TX line #2 |
| TX_L2LENUN | TX Line2 LEN UN | STRING | C | 2 | 0 |
Units of length of TX line #2 |
| TX_L2LOS | TX Line2 Loss | DOUBLE | F | 10 | 4 |
dB loss of TX line #2 |
| TX_CRLOS | TX Circ Loss | DOUBLE | F | 10 | 4 |
dB loss for TX circulator |
| TX_CNLOS | TX Conn Loss | DOUBLE | F | 10 | 4 |
dB loss for TX connectors |
| TX_JPLOS | TX Jumper Loss | DOUBLE | F | 10 | 4 |
dB loss for TX jumpers |
| TX_CBLOS | TX Comb Loss | DOUBLE | F | 10 | 4 |
dB loss for TX combiner |
| TX_M1TYP | TX Misc1TYPE | STRING | C | 50 | 0 |
Description of misc TX loss #1 |
| TX_M1LOS | TX Misc 1 Loss | DOUBLE | F | 10 | 4 |
dB loss for misc TX loss #1 |
| TX_M2TYP | TX Misc2 Type | STRING | C | 50 | 0 |
Description of misc TX loss #2 |
| TX_M2LOS | TX Misc 2 Loss | DOUBLE | F | 10 | 4 |
dB loss for misc TX loss #2 |
| TX_A1FNM | TX A1 FNM | STRING | C | 8 | 0 |
File name for TAP antenna library containing TX antenna (8.3 format file name, name only without ".DBF" extent) |
| TX_A1TID | TX Ant1Type ID | STRING | C | 10 | 0 |
ID for TAP antenna library record for TX |
| TX_A1TYP | TX Ant1Type | STRING | C | 50 | 0 |
Description from TAP antenna library record for TX |
| TX_A1PWR | TX Ant1 PWR | DOUBLE | F | 10 | 4 |
Input power for TX antenna |
| TX_A1PWRUN | TX Ant1 PWR UN | STRING | C | 3 | 0 |
Units for input power for TX antenna |
| TX_A1GAIN | TX Ant1 GAIN | DOUBLE | F | 10 | 4 |
Gain for TX antenna |
| TX_A1GNUN | TX Ant1 Gain UN | STRING | C | 5 | 0 |
Gain for TX antenna dBd, dBi, or REL for relative (multiplier) |
| TX_A1ORIEN | TX Ant1 ORIENT | DOUBLE | F | 7 | 2 |
Orientation of TX antenna relative to manufacturer's pattern in TAP antenna library |
| TX_A1POL | TX A1 POL | STRING | C | 5 | 0 |
TX antenna polarization |
| TX_A1INVRT | TX A1 INVRT | INTEGER | N | 2 | 0 |
TX antenna pattern inverted? -1 for True 0 for False |
| TX_A1ETILT | TX Ant1ElecTILT | DOUBLE | F | 7 | 2 |
TX antenna electrical beam tilt (degrees) - for down, + for up |
| TX_A1MTILT | TX Ant MechTILT | DOUBLE | F | 7 | 2 |
TX antenna mechanical beam tilt (degrees) - for down, + for up
|
| TX_A1MDIR | TX Ant1Mech DIR | DOUBLE | F | 7 | 2 |
Azimuth (from True North) of TX antenna mechanical beam tilt |
| TX_A1RDTYP | TX Ant1 RadType | STRING | C | 50 | 0 |
Description of TX radome |
| TX_A1RDLOS | TX Radome Loss | DOUBLE | F | 10 | 4 |
db loss of TX radome |
| RX_A1AGL | RX Ant1 AGL | DOUBLE | F | 10 | 4 |
RX Primary Antenna height for center of radiation |
| RX_A1AGLUN | RX Ant1 AGL UN | STRING | C | 2 | 0 |
Units for antenna height for RX Primary Antenna |
| RX_A1ELMOD | AGL or MSL? | STRING | C | 3 | 0 |
RX primary antenna height reference: AGL or MSL |
| RX_FREQMHZ | RX FREQUENCY | DOUBLE | F | 11 | 5 |
RX Frequency in MHz |
| RX_IMPED | RX IMPEDANCE | DOUBLE | F | 10 | 4 |
RX impedance (Ohms) |
| RX_SENS | RX SENSITIVITY | DOUBLE | F | 10 | 4 |
RX input sensitivity |
| RX_SENSUN | RX SENS UNITS | STRING | C | 8 | 0 |
RX input sensitivity units uV dBuV dBm dBW |
| RX_A1FLD | RX Ant1 Req FLD | DOUBLE | F | 15 | 10 |
Required field for antenna on primary RX |
| RX_A1FLDUN | RX_A1FLDUN | STRING | C | 8 | 0 |
Field Units for primary RX antenna: dBu uV/m W/m2 |
| RX_FLDMODE | RX_FLDMODE | STRING | C | 4 | 0 |
Source of RX required field value: SPEC if the Required Field is specified directly (such as manual entry or imported) CALC if the Required Field is calculated from the database RX sensitivity + Gains - Losses |
| RX_DFM | RX DFM | DOUBLE | F | 10 | 4 |
Digital Microwave Dispersive fade margin for RX (dB) |
| RX_AIFM | RX AIFM | DOUBLE | F | 10 | 4 |
Digital Microwave Adjacent Channel fade margin for RX (dB) |
| RX_EIFM | RX EIFM | DOUBLE | F | 10 | 4 |
Digital Microwave External Interference Fade Margin for RX (dB) |
| RX_EIFM_TI | RX EIFM – T/I | DOUBLE | F | 10 | 4 |
Digital Microwave RX threshold to interference ratio (dB) |
| RX_EIFM_CI | RX EIFM – C/I | DOUBLE | F | 10 | 4 |
Digital Microwave RX carrier to interference ratio (dB) |
| RX_A1FNM | RX A1 FNM | STRING | C | 8 | 0 |
File name for TAP antenna library containing RX Primary antenna (8.3 format file name, name only without ".DBF" extent) |
| RX_A1TID | RX Ant1 Type ID | STRING | C | 10 | 0 |
ID for TAP antenna library record for RX Primary Antenna |
| RX_A1TYP | RX Ant1 TYPE | STRING | C | 50 | 0 |
Description from TAP antenna library record for RX Primary Antenna |
| RX_A1GAIN | RX Ant1 GAIN | DOUBLE | F | 10 | 4 |
Gain for RX Primary Antenna |
| RX_A1GNUN | RX Ant1 Gain UN | STRING | C | 5 | 0 |
Gain for RX Primary Antenna dBd, dBi, or REL for relative (multiplier) |
| RX_A1ORIEN | RX Ant1 ORIENT | DOUBLE | F | 7 | 2 |
Orientation of primary RX antenna relative to manufacturer's pattern in TAP antenna library |
| RX_A1ETILT | RX Ant1ElecTILT | DOUBLE | F | 7 | 2 |
Primary RX antenna electrical beam tilt (degrees) - for down, + for up |
| RX_A1MTILT | RX Ant1MechTILT | DOUBLE | F | 7 | 2 |
Primary RX antenna mechanical beam tilt (degrees) - for down, + for up
|
| RX_A1MDIR | RX Ant1Mech DIR | DOUBLE | F | 7 | 2 |
Azimuth (from True North) of Primary RX antenna mechanical beam tilt |
| RX_A1RDTYP | RX Ant1 RADTYPE | STRING | C | 50 | 0 |
Description of Primary RX radome |
| RX_A1RDLOS | RX1 Radome Loss | DOUBLE | F | 10 | 4 |
db loss of Primary RX radome |
| RX_A1L1FNM | RX A1 L1 FNM | STRING | C | 8 | 0 |
File name for TAP line library containing Line 1 for RX Primary antenna (8.3 format file name, name only without ".DBF" extent) |
| RX_A1L1TID | RX Ant1Line1TID | STRING | C | 10 | 0 |
ID for TAP line library record for RX Primary antenna line #1 |
| RX_A1L1TYP | RX Ant1Line1TYP | STRING | C | 75 | 0 |
Description from TAP line library record for RX Primary antenna line #1 |
| RX_A1L1LEN | RX Ant1Line1LEN | DOUBLE | F | 10 | 4 |
Length of RX Primary antenna line #1 |
| RX_A1L1LUN | RX Ant1Line1LUN | STRING | C | 2 | 0 |
Units of length of RX Primary antenna line #1 |
| RX_A1L1LOS | RX Line 1 Loss | DOUBLE | F | 10 | 4 |
dB loss of RX Primary antenna line #1 |
| RX_A1L2FNM | RX A1 L2 FNM | STRING | C | 8 | 0 |
File name for TAP line library containing Line 2 for RX Primary antenna (8.3 format file name, name only without ".DBF" extent) |
| RX_A1L2TID | RX Ant1Line2TID | STRING | C | 10 | 0 |
ID for TAP line library record for RX Primary antenna line #2 |
| RX_A1L2TYP | RX Ant1Line2TYP | STRING | C | 75 | 0 |
Description from TAP line library record for RX Primary antenna line #2 |
| RX_A1L2LEN | RX Ant1Line2LEN | DOUBLE | F | 10 | 4 |
Length of RX Primary antenna line #2 |
| RX_A1L2LUN | RX Ant1Line2LUN | STRING | C | 2 | 0 |
Units of length of RX Primary antenna line #2 |
| RX_A1L2LOS | RX Line 2 Loss | DOUBLE | F | 10 | 4 |
dB loss of RX Primary antenna line #2 |
| RX_A1CRLOS | RX Ant1 Circ Ls | DOUBLE | F | 10 | 4 |
dB loss of RX Primary antenna circulator |
| RX_A1CNLOS | RX Ant1 Conn Ls | DOUBLE | F | 10 | 4 |
dB loss of RX Primary antenna connectors |
| RX_A1JPLOS | RX Ant1 Jump Ls | DOUBLE | F | 10 | 4 |
dB loss of RX Primary antenna jumpers |
| RX_A1SPLOS | RX Ant1 Splt Ls | DOUBLE | F | 10 | 4 |
dB loss of RX Primary antenna splitter |
| RX_A1M1TYP | RX Ant1Misc1TYP | STRING | C | 50 | 0 |
RX Primary antenna miscellaneous loss #1 description |
| RX_A1M1LOS | RX Ant1Misc1 Ls | DOUBLE | F | 10 | 4 |
dB loss for RX Primary antenna miscellaneous loss #1 |
| RX_A1M2TYP | RX Ant1Misc2TYP | STRING | C | 50 | 0 |
RX Primary antenna miscellaneous loss #2 description |
| RX_A1M2LOS | RX Ant1Misc2 Ls | DOUBLE | F | 10 | 4 |
dB loss for RX Primary antenna miscellaneous loss #2 |
| RX_A1POL | RX A1 POL | STRING | C | 5 | 0 |
RX Primary antenna polarization |
| RX_A1INVRT | RX A1 INVRT | INTEGER | N | 2 | 0 |
RX Primary antenna pattern inverted? -1 for True 0 for False |
| RX_A2AGL | RX Ant2 AGL | DOUBLE | F | 10 | 4 |
RX Space Diversity antenna height for center of radiation |
| RX_A2AGLUN | RX Ant2 AGL UN | STRING | C | 2 | 0 |
Units for antenna height for RX Space Diversity antenna |
| RX_A2ELMOD | AGL or MSL? | STRING | C | 3 | 0 |
RX Space Diversity antenna height reference: AGL or MSL |
| RX_A2FNM | RX A2 FNM | STRING | C | 8 | 0 |
File name for TAP antenna library containing RX Space Diversity antenna (8.3 format file name, name only without ".DBF" extent) |
| RX_A2TID | RX Ant2 Type ID | STRING | C | 10 | 0 |
ID for TAP antenna library record for RX Space Diversity antenna |
| RX_A2TYP | RX Ant2 TYPE | STRING | C | 50 | 0 |
Description from TAP antenna library record for RX Space Diversity antenna |
| RX_A2GAIN | RX Ant2 GAIN | DOUBLE | F | 10 | 4 |
Gain for RX Space Diversity antenna |
| RX_A2GNUN | RX Ant2 Gain UN | STRING | C | 5 | 0 |
Gain for RX Space Diversity antenna dBd, dBi, or REL for relative (multiplier) |
| RX_A2FLD | RX Ant2 Req FLD | DOUBLE | F | 15 | 10 |
Required field for antenna on RX Space Diversity antenna in dBuV/m (dBu) |
| RX_A2ORIEN | RX Ant2 ORIENT | DOUBLE | F | 7 | 2 | Orientation of RX Space Diversity antenna relative to manufacturer's pattern in TAP antenna library |
| RX_A2ETILT | RX Ant2ElecTILT | DOUBLE | F | 7 | 2 |
Space Diversity RX antenna electrical beam tilt (degrees) - for down, + for up |
| RX_A2MTILT | RX Ant2MechTILT | DOUBLE | F | 7 | 2 |
Space Diversity RX antenna mechanical beam tilt (degrees) - for down, + for up |
| RX_A2MDIR | RX Ant2Mech DIR | DOUBLE | F | 7 | 2 |
Azimuth (from True North) of Space Diversity RX antenna mechanical beam tilt |
| RX_A2RDLOS | RX Ant2 Rad Ls | DOUBLE | F | 10 | 4 |
db loss of Space Diversity RX radome |
| RX_A2RDTYP | RX Ant2 RAD TYP | STRING | C | 50 | 0 |
Description of Space Diversity RX radome |
| RX_A2L1FNM | RX A2 L1 FNM | STRING | C | 8 | 0 |
File name for TAP line library containing Line 1 for RX Space Diversity antenna (8.3 format file name, name only without ".DBF" extent) |
| RX_A2L1TID | RX Ant2Line1TID | STRING | C | 10 | 0 |
ID for TAP line library record for Space Diversity RX antenna line #1 |
| RX_A2L1TYP | RX Ant2Line1TYP | STRING | C | 75 | 0 |
Description from TAP line library record for Space Diversity RX antenna line #1 |
| RX_A2L1LEN | RX Ant2Line1LEN | DOUBLE | F | 10 | 4 |
Length of Space Diversity RX antenna line #1 |
| RX_A2L1LUN | RX Ant2Line1LUN | STRING | C | 2 | 0 |
Units of length of Space Diversity RX antenna line #1 |
| RX_A2L1LOS | RX Ant2Line1 L | DOUBLE | F | 10 | 4 |
dB loss of Space Diversity RX antenna line #1 |
| RX_A2L2FNM | RX A2 L2 FNM | STRING | C | 8 | 0 |
File name for TAP line library containing Line 2 for RX Space Diversity antenna (8.3 format file name, name only without ".DBF" extent) |
| RX_A2L2TID | RX Ant2Line2TID | STRING | C | 10 | 0 |
ID for TAP line library record for Space Diversity RX antenna line #2 |
| RX_A2L2TYP | RX Ant2Line2TYP | STRING | C | 75 | 0 |
Description from TAP line library record for Space Diversity RX antenna line #2 |
| RX_A2L2LEN | RX Ant2Line2LEN | DOUBLE | F | 10 | 4 |
Length of Space Diversity RX antenna line #2 |
| RX_A2L2LUN | RX Ant2Line2LUN | STRING | C | 2 | 0 |
Units of length of Space Diversity RX antenna line #2 |
| RX_A2L2LOS | RX Ant2Line2 Ls | DOUBLE | F | 10 | 4 |
dB loss of Space Diversity RX antenna line #2 |
| RX_A2CRLOS | RX Ant2 Circ L | DOUBLE | F | 10 | 4 |
dB loss of Space Diversity RX antenna circulator |
| RX_A2CNLOS | RX Ant2 Conn Ls | DOUBLE | F | 10 | 4 |
dB loss of Space Diversity RX antenna connectors |
| RX_A2JPLOS | RX Ant2 Jump Ls | DOUBLE | F | 10 | 4 |
dB loss of Space Diversity RX antenna jumpers |
| RX_A2SPLOS | RX Ant2Splt Ls | DOUBLE | F | 10 | 4 |
dB loss of Space Diversity RX antenna splitter |
| RX_A2M1TYP | RX Ant2Misc1TYP | STRING | C | 50 | 0 |
Space Diversity RX antenna miscellaneous loss #1 description |
| RX_A2M1LOS | RX Ant2Misc1 Ls | DOUBLE | F | 10 | 4 |
dB loss for Space Diversity RX antenna miscellaneous loss #1 |
| RX_A2M2TYP | RX Ant2Misc2TYP | STRING | C | 50 | 0 |
Space Diversity RX antenna miscellaneous loss #2 description |
| RX_A2M2LOS | RX Ant2Misc2 Ls | DOUBLE | F | 10 | 4 |
dB loss for Space Diversity RX antenna miscellaneous loss #2 |
| RX_1L1RGAN | RX Preamp 1 Gn | DOUBLE | F | 10 | 4 |
RX Primary Antenna Preamp #1 gain (dB) |
| RX_1L2RGAN | RX Preamp 2 Gn | DOUBLE | F | 10 | 4 |
RX Primary Antenna Preamp #2 gain (dB) |
| RX_2L1RGAN | RX Preamp 2 Gn | DOUBLE | F | 10 | 4 |
RX Space Diversity Antenna Preamp #1 gain (dB) |
| RX_2L2RGAN | RX2 Preamp 2 Gn | DOUBLE | F | 10 | 4 |
RX Space Diversity Antenna Preamp #2 gain (dB) |
| RX_A2POL | RX A2 POL | STRING | C | 5 | 0 |
RX Space Diversity antenna polarization |
| RX_A2INVRT | RX A2 INVRT | INTEGER | N | 2 | 0 |
RX Space Diversity antenna pattern inverted? -1 for True 0 for False |
|
|