Masters Map
The master data layer is the stable reference plane — stations, customers, work centres, facilities, task definitions, MEL rules. Transactional work (tech logs, discrepancies, shop WOs) references these masters constantly, so understanding the master graph is the foundation of understanding any transaction.
Fleet masters
Aircraft — AC_ACI_AIRCRAFT_INFO
The aircraft roster. One row per airframe. 1,025 aircraft across 125 models. Key column: ACI_AIRCRAFT_REG_NO.
AircraftPart — AC_ACPRT_AIRCRAFT_PART_INFO
Parts master with effectivity for specific aircraft models/serials. 183K rows — every part that's approved to fit onto at least one aircraft in the fleet.
ComponentID — AC_CMPID_COMPONENT_ID_INFO
Serialised component identities. 1.08M rows — this is the largest master table. Each row is a unique physical component (by serial), tracking its installation/removal/repair history across its life.
Task and work-definition masters
TaskMaster — BAS_TSK_TSK_TASK_MASTER
The catalogue of defined maintenance tasks. 712K rows. Each row is a reusable task definition — "Replace nose landing gear assembly", "Check hydraulic fluid levels", etc. Referenced by:
- bas_tsk_tskd_task_details — step-by-step detail lines
- bas_tsk_tskp_spare_part — parts specified by the task
- bas_tsk_tskme_mdl_effect — which aircraft models the task applies to
- BAS_TSK_TSKWZ_TSK_WRK_AREA — which work area performs it
- bas_tsk_trso_res_signoff — required sign-off resources
ModelEffectivity — bas_tsk_tskme_mdl_effect
The routing between a task and an aircraft model. Determines which tasks appear in AME planning for a given airframe.
Organisational masters
Station — CM_STNDTL_STATION_DTL
Airport stations where maintenance is performed. 113 rows. Used in AMEPackage as TLGMN_FROM_STATION.
Workcenter — BAS_WCLOG_WC_LOGICAL_WC_DTL
Logical work centres (e.g., "Avionics Shop", "Engine Test Cell"). 1,352 rows. Referenced as WC_CODE across transaction tables. Related:
- BAS_WC_FAC_FACILITY — 46K rows of physical facilities housed within work centres
- BAS_WC_WCOUDT_OU_LEV_WCDET — OU-level work centre detail
- BAS_WC_WCUSR_WC_USER_MAP — 1.46M rows of user-to-work-centre mapping (who can work where)
- BAS_WC_WCWHM_WH_MAP — warehouse mapping for each work centre
- BAS_WC_WCCERA_WC_CERT_APPL — work-centre certification applicability
Customer — Cu_CMH_Cust_Master_Hdr
Customer master. 684 rows. Referenced by swoh_cust_no on shop WOs (for third-party MROs) and TLGMN_CUST_NO on tech logs.
Facility — BAS_WC_FAC_FACILITY
Physical facilities (hangars, test benches, tools, calibration labs). 46,388 rows.
MEL / configuration masters
MELCategory — CFG_CFGMELC_MEL_CATEGORY
MEL category definitions (A/B/C/D) with their deferral rules. 19 rows.
MELConfig — CFG_CFGMEL_MDL_CONFIG_MEL
MEL items mapped to specific aircraft model configurations. 148 rows.
Reference / lookup masters
Priority — BAS_CM_PRI_PRIORITY_NUMBER
Priority classification codes (AOG, urgent, routine, etc.). 18 rows.
RemovalReason — CM_RMVRSN_REMOVAL_REASONS
Why a component was pulled. 18 codes. See Component Removal Reasons.
CM_TZDTL_TIMEZONE_DTL · CM_TZDLS_DAYLIGHTSAVING_DTL
Timezone reference data for multi-region operations.
DP_CFWDDTL_MEL_PART_CF_DTL
MEL part carry-forward detail (empty in this data drop, but the schema is there).
BAS_CM_DOC_CLASSI_ATT_DET
Document classification attributes — used when attaching documents to maintenance records.
PRT_PRCRL_CENTRALREFLIST_INFO
Central reference list — 570K rows of part/item references used across the ERP. Often the back-stop when a specific part master doesn't exist.
SA_WRHSE_MSTR
Warehouse master — 1,384 rows.
wc_wccap_capacity
Work-centre capacity definitions.
How masters link into transactions
Every transaction carries one or more master foreign keys:
FLOG_TLGMN_TECH_LOG_HDR
.TLGMN_AIRCRAFT_REG_NO ──▶ AC_ACI_AIRCRAFT_INFO.ACI_AIRCRAFT_REG_NO (Aircraft)
.TLGMN_FROM_STATION ──▶ CM_STNDTL_STATION_DTL.STNDTL_STATION (Station)
.TLGMN_CUST_NO ──▶ Cu_CMH_Cust_Master_Hdr.CMH_Cust_No (Customer)
swo_swoh_shop_wo_hdr
.swoh_partno ──▶ AC_ACPRT_AIRCRAFT_PART_INFO.ACPRT_PART_NO
.swoh_rem_aircraft_reg_no ──▶ AC_ACI_AIRCRAFT_INFO.ACI_AIRCRAFT_REG_NO
.swoh_primary_wc_code ──▶ BAS_WCLOG_WC_LOGICAL_WC_DTL.WCLOG_WC_CODE
.swoh_cust_no ──▶ Cu_CMH_Cust_Master_Hdr.CMH_Cust_No
DP_DISCP_DISCREPANCY_DTL
.DISCP_AIRCRAFT_NO ──▶ AC_ACI_AIRCRAFT_INFO.ACI_AIRCRAFT_REG_NO
.DISCP_COMPONENT_ID ──▶ AC_CMPID_COMPONENT_ID_INFO.CMPID_COMPONENT_ID