# CifpTerminalWaypoint

Terminal area waypoints (named fixes) associated with specific airports or terminal regions, used in instrument flight procedures

**Source:** CIFP table `CIFP_TERMINAL_WAYPOINT` · version `239462ba9c35` · effective 2026-04-16

> ARINC 424 Section Code PC. Terminal waypoints are distinct from enroute waypoints in that they are defined within the context of a specific airport or terminal area. Latitude/longitude are encoded as concatenated strings (e.g., N52155864 = N 52° 15' 58.64").

## Example query

```graphql
# Introspect the CifpTerminalWaypoint type in GraphiQL at https://api.nav.sortie.co/graphql
# Example shape (pair with a compatible root query field):
{
  # ...rootQuery... {
    recordType
    customerAreaCode
    sectionCode
    regionCode
  # }
}
```

Run at https://api.nav.sortie.co/graphql (GraphiQL available in-browser).

## Fields

| Field | Type | Description | Units | Enum |
|---|---|---|---|---|
| `recordType` | `CifpApproachRecordType` | Indicates whether the record is a standard record or a tailored record |  | `S`=Standard record; `T`=Tailored record |
| `customerAreaCode` | `CustomerAreaCode` | Geographic area code identifying the region of the world where the terminal waypoint is located |  | `CAN`=Canada; `LAM`=Latin America and Mexico; `PAC`=Pacific; `SPA`=South Pacific Area; `USA`=United States |
| `sectionCode` | `CifpTerminalWaypointSectionCode` | ARINC 424 section and subsection code identifying the record type; PC indicates terminal (airport) waypoints |  | `PC`=Terminal Waypoint |
| `regionCode` | `String` | ICAO airport identifier (4-character) of the terminal area or airport with which this waypoint is associated |  |  |
| `icaoCode` | `CifpApproachIcaoCode` | ICAO region code identifying the geographic/political region for the associated airport or terminal area |  | `K1`, `K2`, `K3`, … (19 values) |
| `waypointIdentifier` | `String` | Five-character alphanumeric identifier for the terminal waypoint (named fix) |  |  |
| `icaoCode2` | `CifpTerminalWaypointIcaoCode2` | Secondary ICAO region code, typically corresponding to the waypoint's own geographic region; may differ from ICAO_CODE when waypoints span region boundaries |  | `CY`, `K`, `K1`, … (18 values) |
| `continuationRecordNo` | `ContinuationRecordNo` | Continuation record number; 0 indicates the primary record, values 1 and above indicate continuation records with additional data for the same waypoint |  | `0`=Primary record; `1`=First continuation record; `2`=Second continuation record |
| `waypointType` | `CifpTerminalWaypointWaypointType` | ARINC 424 coded type classification of the terminal waypoint indicating its role or definition method |  | `A`=Airport as waypoint; `C`=Combined named intersection and RNAV waypoint; `I`=Unnamed, charted intersection; `R`=Named intersection defined by radials; `W`=RNAV waypoint (unnamed or uncharted) |
| `waypointUsage` | `String` | Coded field indicating the procedure types in which the waypoint is used (e.g., high altitude, low altitude, terminal); null if not restricted to a specific usage |  |  |
| `waypointLatitude` | `String` | Geographic latitude of the waypoint encoded as a string in the format H DDMMSSss where H is hemisphere (N/S), DD is degrees, MM is minutes, SS is seconds, ss is hundredths of seconds | degrees, minutes, seconds (encoded string) |  |
| `waypointLongitude` | `String` | Geographic longitude of the waypoint encoded as a string in the format H DDDMMSSss where H is hemisphere (E/W), DDD is degrees, MM is minutes, SS is seconds, ss is hundredths of seconds | degrees, minutes, seconds (encoded string) |  |
| `dynamicMagVariation` | `String` | Dynamic magnetic variation at the waypoint location, encoded as a direction letter (E/W) followed by a four-digit value in tenths of degrees (e.g., E0044 = 4.4 degrees East) | degrees (tenths), East or West |  |
| `datumCode` | `DatumCode` | Geodetic datum code indicating the horizontal reference datum used for the waypoint coordinates |  | `NAR`=North American Datum (NAD83/WGS84 compatible); `WGE`=World Geodetic System 1984 (WGS-84) |
| `nameFormatIndicator` | `String` | Indicates the format or type of the waypoint name/description field; null when not specified |  |  |
| `waypointNameDesc` | `String` | Full name or description of the waypoint; typically matches or expands upon the waypoint identifier |  |  |
| `fileRecordNo` | `String` | Sequential file record number assigned to this record within the ARINC 424 data file, used for internal referencing and ordering |  |  |
| `cycleDate` | `String` | AIRAC cycle date indicating when this record was last created or revised, formatted as YYNN where YY is the two-digit year and NN is the AIRAC cycle number within that year (e.g., 2504 = year 2025, cycle 4) |  |  |

## Enum values

### `icaoCode` (`CifpApproachIcaoCode`)

| Code | Description |
|---|---|
| `K1` | Contiguous United States (Eastern) |
| `K2` | Contiguous United States (Central) |
| `K3` | Contiguous United States (Western) |
| `K4` | Contiguous United States (Southern) |
| `K5` | Contiguous United States (Additional) |
| `K6` | Contiguous United States (Additional) |
| `K7` | Contiguous United States (Additional) |
| `NS` | Unspecified Pacific/North Pacific area |
| `PA` | Alaska |
| `PF` | Pacific - unspecified subregion |
| `PG` | Guam and Mariana Islands |
| `PH` | Hawaii |
| `PK` | Marshall Islands |
| `PM` | Midway Island |
| `PO` | Pacific - unspecified subregion |
| `PP` | Pacific - unspecified subregion |
| `PT` | Pacific - unspecified subregion |
| `TI` | United States Virgin Islands |
| `TJ` | Puerto Rico |

### `icaoCode2` (`CifpTerminalWaypointIcaoCode2`)

| Code | Description |
|---|---|
| `CY` | Canada |
| `K` | United States (generic) |
| `K1` | Contiguous United States (Eastern) |
| `K2` | Contiguous United States (Central) |
| `K3` | Contiguous United States (Western) |
| `K4` | Contiguous United States (Southern) |
| `K5` | Contiguous United States (Additional) |
| `K6` | Contiguous United States (Additional) |
| `K7` | Contiguous United States (Additional) |
| `MM` | Mexico |
| `MY` | Bahamas |
| `NZ` | New Zealand |
| `P` | Pacific (generic) |
| `PA` | Alaska |
| `PG` | Guam and Mariana Islands |
| `PH` | Hawaii |
| `TI` | United States Virgin Islands |
| `TJ` | Puerto Rico |

## Column provenance

Every field maps 1:1 to a column in the `CIFP_TERMINAL_WAYPOINT` table of `nasr.db`. Original FAA column names:

| GraphQL field | SQLite column |
|---|---|
| `recordType` | `RECORD_TYPE` |
| `customerAreaCode` | `CUSTOMER_AREA_CODE` |
| `sectionCode` | `SECTION_CODE` |
| `regionCode` | `REGION_CODE` |
| `icaoCode` | `ICAO_CODE` |
| `waypointIdentifier` | `WAYPOINT_IDENTIFIER` |
| `icaoCode2` | `ICAO_CODE_2` |
| `continuationRecordNo` | `CONTINUATION_RECORD_NO` |
| `waypointType` | `WAYPOINT_TYPE` |
| `waypointUsage` | `WAYPOINT_USAGE` |
| `waypointLatitude` | `WAYPOINT_LATITUDE` |
| `waypointLongitude` | `WAYPOINT_LONGITUDE` |
| `dynamicMagVariation` | `DYNAMIC_MAG_VARIATION` |
| `datumCode` | `DATUM_CODE` |
| `nameFormatIndicator` | `NAME_FORMAT_INDICATOR` |
| `waypointNameDesc` | `WAYPOINT_NAME_DESC` |
| `fileRecordNo` | `FILE_RECORD_NO` |
| `cycleDate` | `CYCLE_DATE` |