| Data Dictionary-Maintenace Planning | |||||
| 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 | Maintenace 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 Forcast 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 Paramter 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 - USUAGE 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 Exe.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 GENEREATED | 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 tem coun | 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 untilization is defined | Yes | No |
| MFSFUT_PARAM_OU | numeric(10) | NULL | Parameter OU Code | No | No |
| mfsfut_comp_method | varchar(25) | NULL | Computaional 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 untilization 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 |