CM_STNDTL_STATION_DTL
This is a station master table that stores station master details. It provides static reference data for linking stations, and related attributes in transaction processing.
Process: MAINTPLANNING · Component: BASCm · Table type: Master Table Category: Stores station master details to link operational transactions with accurate organizational and locational data.
This table is the canonical store for the Station entity.
Primary key
STNDTL_STATION_NO, STNDTL_CREATED_OUINSTANCE
Columns (28)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | STNDTL_CREATED_OUINSTANCE 🔑 | varchar | Organization Unit instance where the station record was created |
| 2 | STNDTL_STATION_NO 🔑 | varchar | Station number |
| 3 | STNDTL_STATION_DESC | varchar | Description of the station |
| 4 | STNDTL_STATION_DESC_UP | varchar | Station description in uppercase |
| 5 | STNDTL_STATION_STATUS | varchar | Status of the station |
| 6 | STNDTL_STATION_CODE_TYPE | varchar | Type of station code |
| 7 | STNDTL_STATION_TIMEZONE_NO | #N/A | Station time zone number |
| 8 | STNDTL_STATION_OUINSTANCE | varchar | Organization Unit instance associated with the station |
| 9 | STNDTL_IATA_STATION_REF | varchar | IATA (International Air Transport Association) station reference code |
| 10 | STNDTL_ICAO_STATION_REF | varchar | ICAO (International Civil Aviation Organization) station reference code |
| 11 | STNDTL_OTHERS_STATION_REF | varchar | Other station reference code |
| 12 | STNDTL_CITY | varchar | City where the station is located |
| 13 | STNDTL_CITY_UP | varchar | City name in uppercase |
| 14 | STNDTL_COUNTRY | varchar | Country where the station is located |
| 15 | STNDTL_COUNTRY_UP | varchar | Country name in uppercase |
| 16 | STNDTL_LONGEST_RUNWAY | varchar | Length of the longest runway at the station |
| 17 | STNDTL_RUNWAY_WIDTH | varchar | Width of the runway at the station |
| 18 | STNDTL_LATITUDE | varchar | Latitude coordinate of the station |
| 19 | STNDTL_LONGITUDE | varchar | Longitude coordinate of the station |
| 20 | STNDTL_OVERLOAD_CAPABILITY | #N/A | Overload capability of the station |
| 21 | STNDTL_TIMESTAMP | varchar | Timestamp of the station record |
| 22 | StnDtl_Region | varchar | Region associated with the station |
| 23 | STNDTL_CREATED_BY | datetime | User who created the station record |
| 24 | STNDTL_CREATED_DATE | varchar | Date when the station record was created |
| 25 | STNDTL_MODIFIED_BY | datetime | User who last modified the station record |
| 26 | STNDTL_MODIFIED_DATE | Char | Date when the station record was last modified |
| 27 | STNDTL_TAXREGION | Char | Tax region associated with the station |
| 28 | STNDTL_OFFLINEUSAGE | #N/A | Flag indicating if the station is available for offline usage |
Relationships (2)
- AMEPackage (FLOG_TLGMN_TECH_LOG_HDR) →
AT_STATION(this table is target)- Join:
FLOG_TLGMN_TECH_LOG_HDR.TLGMN_FROM_STATION = CM_STNDTL_STATION_DTL.STNDTL_STATION - AME Package executed at station
- Join:
STATION_HAS_TIMEZONE→ Timezone (CM_TZDTL_TIMEZONE_DTL)- Join:
CM_STNDTL_STATION_DTL.created_area_code = CM_TZDTL_TIMEZONE_DTL.created_area_code - Station has timezone
- Join:
Sample rows (from live DB)
STNDTL_CREATED_OUINSTANCE | STNDTL_STATION_NO | STNDTL_STATION_DESC | STNDTL_STATION_DESC_UP | STNDTL_STATION_STATUS | STNDTL_STATION_CODE_TYPE |
|---|---|---|---|---|---|
| 2.0 | 0000 | TRTR | TRTR | A | IA |
| 2.0 | 00000 | 101 | 101 | A | IA |
| 2.0 | 00000111222 | KOVI | KOVI | A | IA |
Showing 3 of 113 rows.