Data Dictionary- Aircraft Maintenance Forecast

 

Table Name MF_FSL_FORECAST_SCHEDULER_LOG

 

 
Table Comment Shows details of the scheduler

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK
FSL_OUINSTANCE decimal(10) NULL Ouinstance No No
FSL_SUBFLEET_NO varchar(20) NULL Subfleet_no No No
FSL_FORECAST_NO varchar(40) NULL Maintenance Forecast No. No No
FSL_START_DATE datetime NULL Automatic Re-Forecast_MF Start Date No No
FSL_END_DATE   NULL Automatic Re-Forecast_MF End Date No No
FSL_USER_NAME varchar(30) NULL User name No No
FSL_FLAG varchar(25) NULL Re Forecast Flag No No
FSL_LINE_NO numeric(28) NULL Log line no No No
FSL_REMARKS varchar(100) NULL Remarks if any No No

 
Table Name mf_mffcpv_forecast_param_val

 

 
Table Comment It will have workunitwise parameter values.

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK
mffcpv_ouinstance numeric(10) NOT NULL OUInstance Yes No
mffcpv_forecast_no varchar(40) NOT NULL Forecast # Yes No
mffcpv_ac_reg_no varchar(30) NOT NULL Aircraft Registration Code Yes No
mffcpv_seq_no numeric(10) NOT NULL Sequence Number Yes No
MFFCPV_WU_LINENO numeric(10) NOT NULL Line Number Yes No
mffcpv_param_code varchar(40) NOT NULL Parameter code. Yes No
mffcpv_maint_program_no varchar(30) NOT NULL Maintenance Program # Yes No
mffcpv_mp_rev_no varchar(40) NOT NULL Maintenance Program Revision # Yes No
MFFCPV_PARAM_OU numeric(10) NULL Parameter OU Code No No
mffcpv_sch_val numeric(28,8) NULL Schedule Value No No
mffcpv_alert_val numeric(28,8) NULL Alert Value No No
mffcpv_earliest_sch_val numeric(28,8) NULL Earliest Schedule Value No No
mffcpv_latest_sch_val numeric(28,8) NULL Latest Schedule Value No No
MFFCPV_TRIGG_PARAM_YN varchar(5) NULL Trigger Parameter Y/N No No

 
Table Name mf_mffcuv_forecast_util_val

 

 
Table Comment Forecast level utilization Value.

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK
mffcuv_ouinstance numeric(10) NOT NULL OUInstance Yes No
mffcuv_forecast_no varchar(40) NOT NULL Forecast # Yes No
mffcuv_sub_fleet_No varchar(20) NOT NULL Sub Fleet Code Yes No
mffcuv_param_code varchar(40) NOT NULL Parameter Code Yes No
mffcuv_session_no numeric(10) NOT NULL Session Number Yes No
MFFCUV_SESSION_DESC varchar(20) NULL Session Description No No
mffcuv_month_from numeric(10) NULL Starting From Month No No
mffcuv_month_to numeric(10) NULL Till Month No No
mffcuv_util_value numeric(28) NULL Utilization Value No No
MFFCUV_UTIL_REF numeric(28) NULL Utilization Reference No No

 
Table Name mf_mffdtl_forecast_det

 

 
Table Comment Aircraft wise Workunit Details for the Forecast is maintained in this table

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK
mffdtl_ouinstance numeric(10) NOT NULL Ouinstance Yes Yes
mffdtl_forecast_no varchar(40) NOT NULL Forecast Number Yes Yes
mffdtl_ac_reg_no varchar(30) NOT NULL Aircraft Registration Number Yes No
mffdtl_sch_no numeric(10) NOT NULL Schedule Number Yes No
mffdtl_seq_no numeric(10) NOT NULL Sequence Number Yes No
mffdtl_work_unit varchar(30) NOT NULL Work Unit Yes No
mffdtl_work_unit_type varchar(5) NOT NULL Work Unit Type - Can be T- Task P - Standard Procedure Aw - Aircraft Work Package Yes No
mffdtl_sch_date datetime NOT NULL Schedule Date Yes No
mffdtl_maint_program_no varchar(30) NOT NULL Maintenance Program # Yes No
mffdtl_mp_rev_no varchar(40) NOT NULL Maintenance Program Revision # Yes No
mffdtl_aircraft_ou numeric(10) NOT NULL Aircraft OU Code No No
mffdtl_wuline_no   NOT NULL Work Unit Line # No No
MFFDTL_REPEAT_LINENO   NULL Repeat Line Number No No
mffdtl_cycle_no varchar(6) NULL PM Cycle Number No No
mffdtl_work_unit_ou numeric(10) NULL Work Unit OU Code No No
mffdtl_assign_flag varchar(5) NULL Indicates if the Work Unit has been already considered for Visit Package or not. The flags are Y - YES N- NO No No
mffdtl_wu_rev_no varchar(40) NULL Work Unit Revision # No No
mffdtl_alert_date datetime NULL Alert Date No No
mffdtl_mp_ou numeric(10) NOT NULL Maintenance Program OU Code No No
mffdtl_earliest_sch_date datetime NULL Earliest Schedule Date No No
mffdtl_lates_sch_date   NULL Latest Schedule Date No No
mffdtl_arising_flag varchar(25) NULL Arising Flag No No
mffdtl_next_sch_FH numeric(28) NULL Next Scheduled Value (FH) No No
mffdtl_next_sch_FC   NULL Next Scheduled Value (FC) No No
mffdtl_wu_date_usg_flag varchar(5) NULL work unit flag can be stored as DT,USG for date based and usage based schedules DBS - DATE BASED SCHEDULE USG - USAGE BASED SCHEDULE No No
mffdtl_wu_maint_type   NULL Work Unit Maintenance Type No No
mffdtl_work_center varchar(30) NULL Work Center Code No No
mffdtl_work_center_ou numeric(10) NULL Work Center OU Code No No
Mffdtl_reforecast_impact varchar(150) NULL Reforecast Impact No No
mffdtl_level_code   NULL Level Code No No
mffdtl_position_code varchar(25) NULL Position Code No No
MFFDTL_PART_NO varchar(40) NULL Part Code No No
mffdtl_job_type varchar(25) NULL Job Type AC - AIRCRAFT ON- ONWING No No
MFFDTL_EXPENSE_TYPE varchar(5) NULL Expense Type No No
MFFDTL_VP_OU numeric(10) NULL Visit Package Created OU No No
MFFDTL_VP_NO varchar(40) NULL Visit Package # No No
MFFDTL_VP_REV_NO   NULL Visit Package Revision # No No
MFFDTL_EXEC_TYPE varchar(5) NULL Execution Type MA Major MI Minor B blank No No
MFFDTL_PRIMARY_MODEL varchar(20) NULL Primary Aircraft Model No No
MFFDTL_EO_NO char(18) NULL Eo no No No
MFFDTL_EO_TYPE char(18) NULL EO Doc type No No
MFFDTL_MPD_GROUP char(18) NULL Mpd group No No
MFFDTL_PROGITEM_TYPE char(18) NULL Program item type No No
MFFDTL_EO_REVNO char(18) NULL EO revision No No
MFFDTL_INTERVAL_FH char(18) NULL Interval FH No No
MFFDTL_CUSTOMER char(18) NULL Customer No No
MFFDTL_DEF_EXEPRI char(18) NULL Default Execution Priority  No No
MFFDTL_INIRES_BY char(18) NULL Initiate Reset by No No
MFFDTL_INTERVAL_FC char(18) NULL Interval FC No No
MFFDTL_Parent_item char(18) NULL Parent Task No No
MFFDTL_root_task char(18) NULL Root Task No No

 
Table Name mf_mffhdr_forecast_hdr

 

 
Table Comment Forecast Header

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK
mffhdr_ouinstance numeric(10) NOT NULL Ouinstance Yes No
mffhdr_forecast_no varchar(40) NOT NULL Forecast Number Yes No
mffhdr_user_status varchar(25) NULL User Status. It can be REGENERATED GENERATED No No
mffhdr_num_type_no varchar(5) NULL Numbering Type Number No No
mffhdr_status   NULL Status of Forecast F Fresh R Released CA Cancelled C Closed No No
mffhdr_sub_fleet_no varchar(20) NULL Sub Fleet Number No No
mffhdr_created_by varchar(30) NULL Created By No No
mffhdr_createddate datetime NULL Created Date No No
mffhdr_modified_by varchar(30) NULL Last Modified by No No
mffhdr_modifieddate datetime NULL Last Modified Date No No
mffhdr_timestamp numeric(10) NULL Timestamp No No
mffhdr_start_date datetime NULL Forecast Start Date No No
mffhdr_end_date   NULL Forecast End Date No No
mffhdr_refrcst_count numeric(10) NULL Reforecast Count No No
mffhdr_UF_FH_Sub_Fleet numeric(28) NULL Utilization Factor(FH) Subfleet No No
mffhdr_UF_FC_Sub_Fleet   NULL Utilization Factor(FC) Subfleet No No
mffhdr_released_by varchar(30) NULL Forecast Released By No No
mffhdr_releaseddate datetime NULL Forecast Date of release No No

 

 

 
Table Name mf_mfopt_option_settings

 

 

 

 

 
Table Comment Maintenance forecast Option settings

 
Table Column Name Table Column Datatype NULL Table Column Comment Table Column Is PK Table Column Is FK
mfopt_ouinstance numeric(10) NULL OU Instance Yes No
mfopt_comp_forecast_gen varchar(25) NULL Component Forecast Generation Option No No
mfopt_notypeno varchar(5) NULL Forecast Numbering Type No No
mfopt_comp_pln_security varchar(25) NULL Component Plan Security No No
mfopt_vp_autogen varchar(25) NULL Visit Package Automatic Generation No No
mfopt_vp_cmp_onJob varchar(25) NULL Component Maintenance Plan On wing Job No No
mfopt_unforecast_sch varchar(25) NULL Un Forecast Schedule No No
MFOPT_WUSTATUS_CHECK varchar(25) NULL Maintenance Forecast - Work Unit Status Check No No
mfopt_modifiedby varchar(30) NULL Option Setting Modified By No No
mfopt_modifieddate datetime NULL Option Setting Modified Date No No
mfopt_timestamp numeric(10) NULL Time Stamp No No
mfopt_createddate datetime NULL Option Settings Created Date No No
mfopt_createby varchar(30) NULL Option Settings Created By No No
mfopt_shtterm_Forecast udd_count null short term count No No
Table Name mf_mfrflg_reforecast_log

 

 

 

 

 
Table Comment To Store the log details on Reforecasting

 
Table Column Name Table Column Datatype NULL Table Column Comment Table Column Is PK Table Column Is FK
mfrflg_ouinstance numeric(10) NULL OU Instance No No
mfrflg_forecast_no varchar(40) NULL Forecast Number No No
mfrflg_forecast_count numeric(10) NULL Forecast Count No No
MFRFLG_LINE_NO numeric(10) NULL Forecast Line Number No No
MFRFLG_WUSEQ_NO numeric(10) NULL Work Unit Sequence Number No No
mfrflg_sch_no numeric(10) NULL Schedule Number No No
mfrflg_work_unit varchar(30) NULL Work Unit Code No No
MFRFLG_REPEAT_LINENO numeric(10) NULL Repeat Line Number No No
mfrflg_reforecast_impact varchar(150) NULL Reforecast Impact No No
mfrflg_cycle_no varchar(6) NULL Cycle Number No No
mfrflg_wu_type varchar(5) NULL Work Unit Type No No
mfrflg_assignment_flag   NULL Assignment Flag Y- YES N- NO No No
mfrflg_sch_date datetime NULL Scheduled Date No No
MFRFLG_VP_NO varchar(40) NULL Visit Package Number No No
MFRFLG_VP_OU numeric(10) NULL Visit Package Created OU Code No No
MFRFLG_VP_REV_NO varchar(40) NULL Visit Package Revision Number No No

 
Table Name mf_mfsac_subfleet_aircraft

 

 
Table Comment Aircraft associated to a Sub Fleet

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK
mfsac_ouinstance numeric(10) NOT NULL Ouinstance Yes Yes
mfsac_sub_fleet_no varchar(20) NOT NULL Sub fleet Number Yes Yes
mfsac_ac_reg_no varchar(30) NOT NULL Aircraft registration number Yes No
mfsac_reference_flag varchar(25) NULL Reference flag. Should the aircraft be considered for utilization purposes Y - YES N- NO No No
mfsac_ac_ou numeric(10) NULL Aircraft Created OU Code No No

 
Table Name mf_mfsflh_sub_fleet_hdr

 

 
Table Comment Subfleet Header Details

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK
mfsflh_ouinstance numeric(10) NOT NULL Ouinstance Yes No
mfsflh_sub_fleet_no varchar(20) NOT NULL Sub fleet Number Yes No
mfsflh_sub_fleet_desc varchar(255) NULL Sub Fleet Description No No
MFSFLH_SUB_FLEET_DESC_UP   NULL Sub Fleet Description (in Upper case) No No
mfsflh_start_date datetime NULL Start Date From which the Sub Fleet is active No No
mfsflh_std_horizon_days numeric(10) NULL Standard Horizon in Days No No
mfsflh_max_act_forecast   NULL Maximum Number of active forecasts for the sub fleet No No
mfsflh_utlit_profile varchar(5) NULL Sub Fleet Utilization Profile No No
mfsflh_num_type   NULL Numbering Type No No
mfsflh_status   NULL Status of the sub fleet A Active I Inactive No No
mfsflh_created_by varchar(30) NULL Created By No No
mfsflh_createddate datetime NULL Created Date No No
mfsflh_modified_by varchar(30) NULL Last Modified By No No
mfsflh_modifieddate datetime NULL Last Modified Date No No
mfsflh_timestamp numeric(10) NULL Timestamp No No
mfsflh_forecast_flag varchar(5) NULL Forecast Flag Y- YES N- NO No No

 
Table Name mf_mfsfpl_subfleet_planners

 

 
Table Comment Planners for the Sub Fleet

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK
mfsfpl_ouinstance numeric(10) NOT NULL Ouinstance Yes Yes
mfsfpl_sub_fleet_no varchar(20) NOT NULL Sub fleet Number Yes Yes
mfsfpl_planner varchar(30) NOT NULL Planner Yes No

 
Table Name mf_mfsfut_subfleet_util_hdr

 

 
Table Comment Utilization Details for the Parameter

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK
mfsfut_ouinstance numeric(10) NOT NULL Ouinstance Yes Yes
mfsfut_sub_fleet_no varchar(20) NOT NULL Sub fleet Number Yes Yes
mfsfut_param_code varchar(40) NOT NULL Parameter Code for which utilization is defined Yes No
MFSFUT_PARAM_OU numeric(10) NULL Parameter OU Code No No
mfsfut_comp_method varchar(25) NULL Computational method No No
mfsfut_moving_avg_count numeric(10) NULL Moving average count No No
mfsfut_ref_from_year   NULL Reference From Year No No
mfsfut_ref_to_year   NULL Reference From Year No No
mfsfut_util_ref varchar(5) NULL Utilization reference No No
mfsfut_remarks varchar(255) NULL Remarks No No

 
Table Name mf_mfsfuv_subfleet_util_val

 

 
Table Comment Seasonal Utilization details

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK
mfsfuv_ouinstance numeric(10) NOT NULL Ouinstance Yes Yes
mfsfuv_sub_fleet_no varchar(20) NOT NULL Sub fleet Number Yes Yes
mfsfuv_param_code varchar(40) NOT NULL Parameter Code for which utilization is defined Yes Yes
mfsfuv_session_no numeric(10) NOT NULL Session Number - System generated number Yes No
mfsfuv_month_from varchar(20) NULL Month From No No
mfsfuv_month_to varchar(20) NULL Month To No No
mfsfuv_session_desc varchar(20) NULL Session Description No No
mfsfuv_util_value varchar(20) NULL Utilization Value No No
mfsfuv_UF_computed varchar(20) NULL Utilization factor computed No No

 
Table Name mf_mfsfwt_subfleet_weigtage

 

 
Table Comment Weightage Details

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK
mfsfwt_ouinstance numeric(10) NOT NULL Ouinstance Yes Yes
mfsfwt_sub_fleet_no varchar(20) NOT NULL Sub fleet Number Yes Yes
mfsfwt_year_no numeric(10) NOT NULL Year Number Yes No
mfsfwt_weightage numeric(28,8) NULL Weightage to be given for the year No No

 
Table Name mf_quick_code

 

 
Table Comment User Defined Quick Codes

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK
mf_ouinstance numeric(10) NOT NULL OUinstance Yes No
mf_quick_code varchar(25) NOT NULL User Defined Quick Code Yes No
mf_type varchar(25) NOT NULL Quick Code Type. Yes No
mf_description varchar(80) NULL Quick Code description No No
MF_DESCRIPTION_UP varchar(80) NULL Forecast Description ( in Upper case) No No
mf_status varchar(15) NULL Status of the quick code. Can be A Active I Inactive No No
mf_created_by varchar(30) NULL Created by No No
mf_modified_by varchar(30) NULL Last Modified By No No
mf_creationdate datetime NULL Creation Date No No
mf_modifieddate datetime NULL Last Modified date No No
mf_timestamp numeric(10) NULL Timestamp No No