| Data Dictionary - Aircraft History | ||||||||
| Table Name Achist_AcPrm_FHFC_Val_Dtl | ||||||||
| Table Comment This stores the FH, FC value for the aircraft on a transaction date- Flight Category wise. | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| AcPrm_AcHist_OUInstance | numeric(10) | NOT NULL | Aircraft History OUInstance | Yes | No | |||
| AcPrm_Aircraft_OU | numeric(10) | NOT NULL | Aircraft OUInstance | Yes | No | |||
| AcPrm_Aircraft_Reg_No | varchar(30) | NOT NULL | Aircraft Registration Number | Yes | No | |||
| AcPrm_Flight_Category | varchar(25) | NOT NULL | Flight Category | Yes | No | |||
| AcPrm_Transaction_Date | datetime | NOT NULL | Transaction Date | Yes | No | |||
| AcPrm_FH_Value | numeric(28,8) | NULL | Flying Hours Value as on transaction date, flight category | No | No | |||
| AcPrm_FC_Value | numeric(28,8) | NULL | Flying Cycles Value as on transaction date, flight Category | No | No | |||
| AcPrm_Record_Created_Date | datetime | NULL | Record Created Date Time ie the Date and time when the record posted by the Flight Log Component to the Ac History Component | No | No | |||
| Table Name ACHIST_INCOCC_REPT_DTL | ||||||||
| Table Comment This table stores the occurrence report info for the aircraft on a Occ date - Occ Type wise. | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| INCOCC_OUINSTANCE | decimal(10) | NOT NULL | Occurrence Report OU Instance. | Yes | No | |||
| INCOCC_AIRCRAFT_REG_NO | varchar(30) | NOT NULL | Aircraft Registration Number | Yes | No | |||
| INCOCC_OCCREP_NO | varchar(40) | NOT NULL | Occurrence Report Number. | Yes | No | |||
| INCOCC_INC_OCC_INCIDENT | varchar(25) | NOT NULL | Occurrence Inscident Number. | Yes | No | |||
| INCOCC_INC_OCC_TYPE | varchar(25) | NOT NULL | Occurrence Type. | No | No | |||
| INCOCC_INC_OCC_DATE | datetime | NOT NULL | Occurrence Date. | No | No | |||
| Table Name Achist_Jad_JrnLg_Delay_dtl | ||||||||
| Table Comment This table stores the delay information of a Journey Log as reported by the AME after doing detailed delay analaysis of a confirmed journey log. Since Pilot entered delay information and AME entered delay information are always referred seperately and is maintained as two different records, different tables have been put for pilot reported delay and AME reported delay (i.e. same table is not used with a kind of AME_OR_PILOT_FLAG + AME_Delay_Remarks and Pilot_Delay_Remarks). Moreover, there is a possibility of changing the delay information reported by the pilot at delay category level than at the delay no level. Keeping the information seperately in two different tables will reduce the impact due to such possible changes. | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| Jad_AcHist_OUInstance | numeric(10) | NOT NULL | OUInstance of Aircraft History | Yes | Yes | |||
| Jad_JrnLog_OUInstance | numeric(10) | NOT NULL | OUInstance of Journey Log | Yes | Yes | |||
| Jad_JrnLog_No | varchar(40) | NOT NULL | Journey Log Number System generated unique number to identify a Flight Log for a journey. | Yes | Yes | |||
| Jad_Delay_OU | numeric(10) | NOT NULL | Delay Code OU | Yes | No | |||
| Jad_Delay_No | varchar(25) | NOT NULL | This delay no will be created under one of the following delay category in Common Master Following lists the Delay Categories and it’s values: AGA Airport and Government Authorities ARH Aircraft and Ramp Handling CM Cargo and Mail DAEF Damage to Aircraft & EDP/Automated  Equipment Failure FOC Flight Operation and Crewing MIS Miscellaneous PB Passenger and Baggage RCY Reactionary TAE Technical and Aircraft Equipment WEA Weather | Yes | No | |||
| JAD_JRNLOG_LEG_NO | decimal(10) | NULL | Leg No ie for each multiline there will be one leg | No | No | |||
| Jad_Aircraft_No | varchar(30) | NOT NULL | Aircraft Number | No | No | |||
| Jad_Delay_Category | varchar(25) | NULL | Delay Category | No | No | |||
| JAD_DELAY_ON | varchar(25) | NULL | Delay No defined in Common Masters. | No | No | |||
| JAD_TIMEUNIT | varchar(10) | NULL | UOM of Time | No | No | |||
| JAD_DURATION | varchar(10) | NULL | Delay Duration | No | No | |||
| JAD_DELAY_REASON | varchar(255) | NULL | Reason for delay defined in Common Masters. | No | No | |||
| Jad_Delay_Remarks | varchar(255) | NULL | Delay Remarks | No | No | |||
| Jad_Delay_Days | numeric(28,8) | NULL | Delay in Days | No | No | |||
| Jad_Delay_Hrs | numeric(28,8) | NULL | Delay in Hours | No | No | |||
| Jad_Delay_Minutes | numeric(28,8) | NULL | Delay in Minutes | No | No | |||
| Jad_Tot_Delay_InMin | numeric(28,8) | NULL | Total Delay (i.e. Days converted to minutes + Hours converted to minutes + minutes) in minutes | No | No | |||
| Jad_Utc_Dep_Datetime | datetime | NULL | Departure Datetime of the Journey Log in UTC Format | No | No | |||
| Jad_Created_By | varchar(30) | NULL | User who created the Journey Log Delay information | No | No | |||
| Jad_CreatedDate | datetime | NULL | Date at which the Journey Log Delay information are created | No | No | |||
| Jad_Record_Created_date | datetime | NULL | Record Created Date Time ie the Date and time when the record posted by the Flight Log Component to the Ac History Component | No | No | |||
| Table Name Achist_JIfSh_InFlt_ShDn_Dtl | ||||||||
| Table Comment This table is used to store the Inflight Shutdown details Due to an emergency like fire warning in the engine, the pilot may choose to shutdown the engine when the aircraft has already started its journey. Shutdowns may occur owing to reasons other than fire situations, like engine experiencing a negative oil pressure. Such an event is called In-flight shutdown and in such cases, the bleed and electrical loads of the shutdown engine are transferred to the APU. The in-flight shut down rate for the fleet is computed during reliability analysis. In-flight shut down is an incident and reflects on the quality of maintenance. The increase in rate indicates to the operator that his maintenance program needs to be looked into. Another reason why it needs to be recorded is to update the engine hours during the time it is shut down. | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| JIfSh_AcHist_OUInstance | numeric(10) | NOT NULL | OUInstance of Aircraft History | Yes | No | |||
| JIfSh_JrnLog_OUInstance | numeric(10) | NOT NULL | OUInstance of Journey Log | Yes | No | |||
| JIfSh_JrnLog_No | varchar(40) | NOT NULL | Journey Log Number System generated unique number to identify a Flight Log for a journey. | Yes | No | |||
| JIfSh_Cfg_OUInstance | numeric(10) | NOT NULL | OUInstance of Configuration | Yes | No | |||
| JIfSh_Pos_Code | varchar(25) | NOT NULL | Position code | Yes | No | |||
| JIfSh_Utc_Shutdown_Datetime | datetime | NOT NULL | Inflight Shutdown datetime in UTC format | Yes | No | |||
| JIfSh_Aircraft_Reg_No | varchar(30) | NULL | Aircraft Registration Number | No | No | |||
| JIfSh_Part_OUInstance | numeric(10) | NULL | OUInstance of Part Component | No | No | |||
| JIfSh_Part_No | varchar(40) | NULL | Part Number | No | No | |||
| JIfSh_Serial_No | varchar(40) | NULL | Serial Number | No | No | |||
| JIfSh_Component_ID | varchar(90) | NULL | Component ID | No | No | |||
| JIfSh_Shutdown_Type | varchar(25) | NULL | Inflight Shutdown type This will take one of the Quick Code values defined in ’Common Master’ Quick Codes under type ’Shutdown type’ | No | No | |||
| JIfSh_Shutdown_Datetime | datetime | NULL | Inflight Shutdown datetime | No | No | |||
| JIfSh_ShutDown_TimeZone | varchar(30) | NULL | Inflight Shutdown Time Zone | No | No | |||
| JIfSh_Restart_Datetime | datetime | NULL | Inflight Restart Datetime | No | No | |||
| JIfSh_Utc_Restart_Datetime | datetime | NULL | Restart Datetime in UTC format | No | No | |||
| JIfSh_Restart_TimeZone | varchar(30) | NULL | Inflight Restart Time Zone | No | No | |||
| JIfSh_ShutDown_Remarks | varchar(255) | NULL | Inflight Shutdown remarks | No | No | |||
| JIfSh_Created_By | varchar(30) | NULL | User who created the details | No | No | |||
| JIfSh_CreatedDate | datetime | NULL | Date at which the details are created | No | No | |||
| JIfSh_Record_Created_Date | datetime | NULL | Record Created Date Time ie the Date and time when the record posted by the Flight Log Component to the Ac History Component | No | No | |||
| Table Name ACHIST_JLGLEG_LEG_PARAM_DTL | ||||||||
| Table Comment This table stores the history of leg details info for the aircraft. | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| JLD_JRNLOG_NO | varchar(40) | NOT NULL | OU Instance | Yes | No | |||
| JLD_LEGNO | decimal(10) | NOT NULL | Leg No ie for each multiline there will be one leg | Yes | No | |||
| JLD_JRNLOG_OUINSTANCE | decimal(10) | NOT NULL | OU Instance | Yes | No | |||
| JLD_ACHIST_OUINSTANCE | numeric(28) | NOT NULL | OUInstance | Yes | No | |||
| JLD_FROM_STATION | varchar(40) | NULL | From Station for a particular Leg no | No | No | |||
| JLD_TO_STATION | varchar(40) | NULL | To Station for a particular Leg no | No | No | |||
| JLD_USER_FROM_TIME | varchar(8) | NULL | From Time for a particular Leg No | No | No | |||
| JLD_USER_TO_TIME | varchar(8) | NULL | To Time for a particular Leg No | No | No | |||
| JLD_FROM_DATE | datetime | NULL | From Date for a particular Leg No | No | No | |||
| JLD_FROM_TIME | datetime | NULL | From Time for a particular Leg No | No | No | |||
| JLD_TO_DATE | datetime | NULL | To Date for a particular Leg No | No | No | |||
| JLD_TO_TIME | datetime | NULL | To Time for a particular Leg No | No | No | |||
| JLD_FLIGHT_TIME | varchar(10) | NULL | Flight Duration of each and every leg No | No | No | |||
| JLD_FLIGHT_FOLL | varchar(10) | NULL | Flight Foll Count | No | No | |||
| JLD_PASSENGERS | decimal(10) | NULL | Number of Passengers for each and every leg No | No | No | |||
| JLD_TAKEOFFS | decimal(10) | NULL | Number of Take Offs for each and every leg No | No | No | |||
| JLD_FLIGHT_STATUS | varchar(30) | NULL | Flight Status - OS - OnSchedule De - Delayed. | No | No | |||
| JLD_PARAMETER1 | varchar(40) | NULL | Param Value for the Parameter Code 1 | No | No | |||
| JLD_PARAMETER2 | varchar(40) | NULL | Param Value for the Parameter Code 2 | No | No | |||
| JLD_PARAMETER3 | varchar(40) | NULL | Param Value for the Parameter Code 3 | No | No | |||
| JLD_PARAMETER4 | varchar(40) | NULL | Param Value for the Parameter Code 4 | No | No | |||
| JLD_PARAMETER5 | varchar(40) | NULL | Param Value for the Parameter Code 5 | No | No | |||
| JLD_PARAMETER6 | varchar(40) | NULL | Param Value for the Parameter Code 6 | No | No | |||
| JLD_PARAM_OUINSTANCE | decimal(10) | NULL | Param OU Instance | No | No | |||
| JLD_CREATED_BY | varchar(30) | NULL | Created By User | No | No | |||
| JLD_CREATEDDATE | datetime | NULL | Created Date of the Transaction | No | No | |||
| JLD_MODIFIED_BY | varchar(30) | NULL | (30) Modified by | No | No | |||
| JLD_MODIFIEDDATE | datetime | NULL | Modified Date of the Transaction | No | No | |||
| JLD_RECORD_CREATED_DATE | datetime | NULL | Created Date of the Transaction | No | No | |||
| Table Name Achist_Jlh_Journey_Log_Hdr | ||||||||
| Table Comment This table stores the Journey Log main info like AcRegNo, Journey Start Date, Arrival date time, departure date time, etc. | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| Jlh_AcHist_OUInstance | numeric(10) | NOT NULL | Aircraft History OUInstance | Yes | No | |||
| Jlh_JrnLog_OUInstance | numeric(10) | NOT NULL | OUInstance of Journey Log | Yes | No | |||
| Jlh_JrnLog_No | varchar(40) | NOT NULL | Journey Log Number System generated unique number to identify a Flight Log for a journey. | Yes | No | |||
| JLH_FLIGHT_DATE | datetime | NOT NULL | Date of Travelling | No | No | |||
| Jlh_Corr_Tech_Log_OU | numeric(10) | NULL | Corresponding Technical Log OU for the given journey log | No | No | |||
| JLH_STARTING_STATION | varchar(30) | NOT NULL | Starting station of the Flight | No | No | |||
| Jlh_Corr_Tech_Log_No | varchar(40) | NULL | Corresponding Technical Log No of the journey log | No | No | |||
| Jlh_Aircraft_OUInstance | numeric(10) | NOT NULL | OUInstance of the Aircraft | No | No | |||
| Jlh_Aircraft_Reg_No | varchar(30) | NOT NULL | Aircraft Registration Number | No | No | |||
| JLH_TCHLOG_NO | varchar(40) | NULL | Referred Technical Log Number. | No | No | |||
| Jlh_Aircraft_Model_No | varchar(18) | NULL | Aircraft Model Number | No | No | |||
| JLH_JRNLOG_CATEGORY | varchar(25) | NULL | This will be the quick codes that are defined under the Qc type ’Journey Log Category’ | No | No | |||
| Jlh_Flight_No | varchar(30) | NULL | Code to identify the flight number | No | No | |||
| Jlh_Leg_No | numeric(10) | NULL | Code to identify the leg of the flight | No | No | |||
| JLH_JRNLOG_STATUS | varchar(5) | NULL | Journey Log Status. Following are the list of codes and values: FR  Fresh  CN  Cancelled  CF  Confirmed | No | No | |||
| JLH_JRNLOG_AMENDMENT_NO | decimal(38) | NULL | Amendment No | No | No | |||
| Jlh_Flight_Type | varchar(5) | NULL | Following will be the values and codes for various Flight Types. ’On Schedule’ - OS ’Delayed’ - DE ’Cancelled’ - C ’Air Turned Back’ - ATB ’Ground Turned Back’ - GTB ’Diverted’ - DI | No | No | |||
| Jlh_Flight_Category | varchar(25) | NULL | This will have the ’Flight Category’ as defined in the ’Quick Code’ activity of the ’Common Master’ component. | No | No | |||
| JLH_REP_TIMEZONE | varchar(25) | NULL | Reporting TimeZone will always be null except in case when the Timeindicator setoptions is "User Defined" and the user has selected a Timezone , that timezone will be stored here. For the subsequent fetches if the Setoptions is set to "User defined" , then all date and time values are to be displayed in this TimeZone. | No | No | |||
| Jlh_Recording_Station | varchar(32) | NULL | Recording Station | No | No | |||
| JLH_AIRCRAFT_MODEL | varchar(30) | NULL | Model of the Aircraft Reg No | No | No | |||
| JLH_MFGSRLNO | varchar(40) | NULL | Maufacturing Serial No of the Aircraft Reg No | No | No | |||
| JLH_FROM_STATION_OU | numeric(10) | NULL | From Station OU | No | No | |||
| JLH_CONFIG_CLASS | varchar(40) | NULL | Configuration Class of the Aircraft Reg No | No | No | |||
| JLH_LAST_JLOG_DATE | datetime | NULL | Last JL’s Date. | No | No | |||
| Jlh_From_Station_Code | varchar(32) | NULL | Code that identifies From Station | No | No | |||
| JLH_LEG_PARAMETER1 | varchar(40) | NULL | Param Code 1 as fetched from the Journey Log Parameters | No | No | |||
| Jlh_Sch_Dep_Datetime | datetime | NULL | Scheduled Departure Datetime. This will be w.r.t From Station TimeZone if the option setting is ’Local’ otherwise it will be in the UTC std. | No | No | |||
| JLH_LEG_PARAM1_VAL | varchar(30) | NULL | Param Value for Parameter 1 as entered by the user | No | No | |||
| Jlh_Utc_Sch_Dep_Datetime | datetime | NULL | Scheduled Departure Datetime as per the UTC std | No | No | |||
| Jlh_Dep_Datetime | datetime | NULL | Departure Datetime as entered. This will be w.r.t From Station TimeZone if the option setting is ’Local’ otherwise it will be in the UTC std. | No | No | |||
| JLH_LEG_PARAM1_UOM | varchar(30) | NULL | Unit of Measurement for Parameter 1 as specified  from the Journey Log Parameters | No | No | |||
| Jlh_Utc_Dep_Datetime | datetime | NULL | Departure Datetime as per the UTC std | No | No | |||
| JLH_LEG_PARAMETER2 | varchar(40) | NULL | Param Code 2 as fetched from the Journey Log Parameters | No | No | |||
| JLH_TO_STATION_OU | numeric(10) | NULL | To Station OU | No | No | |||
| JLH_LEG_PARAM2_VAL | varchar(30) | NULL | Param Value for Parameter 2 as entered by the user | No | No | |||
| Jlh_To_Station_Code | varchar(32) | NULL | Code that identifies To station | No | No | |||
| JLH_LEG_PARAM2_UOM | varchar(30) | NULL | Unit of Measurement for Parameter 2 as specified  from the Journey Log Parameters | No | No | |||
| Jlh_Arrival_Datetime | datetime | NULL | Arrival Datetime as entered. This will be w.r.t To Station TimeZone if the option setting is ’Local’ otherwise it will be in the UTC std. | No | No | |||
| JLH_LEG_PARAMETER3 | varchar(40) | NULL | Param Code 3 as fetched from the Journey Log Parameters | No | No | |||
| JLH_LEG_PARAM3_VAL | varchar(30) | NULL | Param Value for Parameter 3 as entered by the user | No | No | |||
| Jlh_Utc_Arrival_Datetime | datetime | NULL | Arrival Datetime as per the UTC std | No | No | |||
| JLH_LEG_PARAM3_UOM | varchar(30) | NULL | Unit of Measurement for Parameter 3 as specified  from the Journey Log Parameters | No | No | |||
| Jlh_IncAcc_Type | varchar(25) | NULL | Incident or Accident Type [Quick Code defined in common master] | No | No | |||
| Jlh_Compliance_Date | datetime | NULL | Compliance Date - Reporting Date of Technical Log | No | No | |||
| JLH_LEG_PARAMETER4 | varchar(40) | NULL | Param Code 4 as fetched from the Journey Log Parameters | No | No | |||
| JLH_LEG_PARAM4_VAL | varchar(30) | NULL | Param Value for Parameter 4 as entered by the user | No | No | |||
| Jlh_Maint_Program_OU | numeric(10) | NULL | Maintenance Program OU - Captured as part of Technical Log | No | No | |||
| Jlh_Maint_Program_No | varchar(40) | NULL | Maintenance Program No - Captured as part of Technical Log | No | No | |||
| JLH_LEG_PARAM4_UOM | varchar(30) | NULL | Unit of Measurement for Parameter 4 as specified  from the Journey Log Parameters | No | No | |||
| Jlh_Work_Unit_OU | numeric(10) | NULL | Work Unit OU - Captured as part of Technical Log | No | No | |||
| JLH_LEG_PARAMETER5 | varchar(40) | NULL | Param Code 5 as fetched from the Journey Log Parameters | No | No | |||
| Jlh_Work_Unit_No | varchar(30) | NULL | Work Unit No - Captured as part of Technical Log | No | No | |||
| JLH_LEG_PARAM5_VAL | varchar(30) | NULL | Param Value for Parameter 5 as entered by the user | No | No | |||
| Jlh_Work_Unit_Type | varchar(5) | NULL | Work Unit Type - Captured as Part of Technical Log T - Task P - Standard Procedure W - Work Package | No | No | |||
| JLH_LEG_PARAM5_UOM | varchar(30) | NULL | Unit of Measurement for Parameter 5 as specified  from the Journey Log Parameters | No | No | |||
| JLH_LEG_PARAMETER6 | varchar(40) | NULL | Param Code 6 as fetched from the Journey Log Parameters | No | No | |||
| JLH_LEG_PARAM6_VAL | varchar(30) | NULL | Param Value for Parameter 6 as entered by the user | No | No | |||
| JLH_LEG_PARAM6_UOM | varchar(30) | NULL | Unit of Measurement for Parameter 6 as specified  from the Journey Log Parameters | No | No | |||
| JLH_PARAM_OUINSTANCE | decimal(10) | NULL | Param OU Instance | No | No | |||
| JLH_TOTAL_FLIGHT_HOURS | decimal(28,8) | NULL | Number of Take offs of the specified Aircraft Reg No. | No | No | |||
| JLH_TOTAL_TAKEOFFS | decimal(10) | NULL | No | No | ||||
| JLH_FLIGHT_HOURS | decimal(28,8) | NULL | Flight Duration of the specified Aircraft Reg No for a particular Journey Log No | No | No | |||
| JLH_TAKEOFFS | decimal(10) | NULL | Number of Take offs of the specified Aircraft Reg No for a particular Journey Log No | No | No | |||
| JLH_TAKEOFFS_UOM | varchar(30) | NULL | Unit of Measurement  for the Take Offs of the specified Aircraft Reg No for a particular Journey Log No | No | No | |||
| JLH_TOTTAKEOFFS_UOM | varchar(30) | NULL | Unit of Measurement  for the Total Take Offs of the specified Aircraft Reg No | No | No | |||
| JLH_FLIGHTHOURS_UOM | varchar(30) | NULL | Unit of Measurement  for the Flight Hours of the specified Aircraft Reg No for a journey log | No | No | |||
| JLH_TOTALFH_UOM | varchar(30) | NULL | Unit of Measurement  for the Total Flight Hours of the specified Aircraft Reg No | No | No | |||
| Jlh_Reporting_Datetime | datetime | NULL | Reporting Datetime | No | No | |||
| Jlh_Utc_Reporting_Datetime | datetime | NULL | Reporting Datetime in UTC format | No | No | |||
| Jlh_Created_By | varchar(30) | NULL | User who created the details | No | No | |||
| Jlh_CreatedDate | datetime | NULL | Date at which the user created the details | No | No | |||
| JLH_MODIFIED_BY | varchar(30) | NULL | User who modified the details | No | No | |||
| JLH_MODIFIEDDATE | datetime | NULL | Date at which the user modified the details | No | No | |||
| JLH_FILENAME | varchar(50) | NULL | File Name | No | No | |||
| JLH_REMARKS | varchar(255) | NULL | Remarks | No | No | |||
| Jlh_Record_Created_date | datetime | NULL | Record Created Date Time ie the Date and time when the record posted by the Flight Log Component to the Ac History Component | No | No | |||
| Table Name Achist_MRMn_Maint_Report_Hdr | ||||||||
| Table Comment This table contains Maintenance Report Details along with carry forward details. It also contains the DMR Parameters. | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| MRMn_AcHist_OUInstance | numeric(10) | NOT NULL | OUInstance of Aircraft History | Yes | No | |||
| MRMn_Maint_Report_OUInstance | numeric(10) | NOT NULL | Maintenance Report OUInstance | Yes | No | |||
| MRMn_Maint_Report_No | varchar(40) | NOT NULL | Maintenance Report Number is stored here. | Yes | No | |||
| MRMn_Maint_Report_Desc | varchar(150) | NULL | Maintenance Report Description | No | No | |||
| MRMn_Maint_Report_Status | varchar(15) | NULL | Maintenance Report Status FRSH - Fresh CNFIM - Confirmed CLS - Close CNCL - Cancel | No | No | |||
| MRMn_Fault_OUInstance | numeric(10) | NULL | OUInstance of Fault Code | No | No | |||
| MRMn_Fault_No | varchar(25) | NULL | This is the Fault Code associated with Maintenance Report. All Discrepancies associated with a MR can be assigned to a fault code. | No | No | |||
| MRMn_Ata_OU | numeric(10) | NULL | OUInstance of ATA | No | No | |||
| MRMn_Ata_No | varchar(16) | NULL | ATA Chapter Number. - This gets associated 1) when a fault is associated to MR, the corresponding ATA Chapter Number is copied automatically. 2) When EAN Number is associated to MR, the corresponding ATA Chapter number is copied automatically. 3) User can specify the ATA Number. | No | No | |||
| MRMn_Cause_Code | varchar(25) | NULL | This is Cause Code that will be assigned to the MR- fault code combination. | No | No | |||
| MRMN_STATION_OU | numeric(10) | NULL | Station OU | No | No | |||
| MRMn_Station_Code | varchar(32) | NULL | Station Code - Reporting Station of Technical Log (Execution Details - Tech. Log on which Maintenance Report is getting Closed) | No | No | |||
| MRMn_Work_Center_OU | numeric(10) | NULL | Work Center OU | No | No | |||
| MRMn_Work_Center_No | varchar(30) | NULL | Work Center Number | No | No | |||
| MRMn_Ref_Doc_OU | numeric(10) | NULL | OUInstance of Reference Document | No | No | |||
| MRMn_Ref_Doc_No | varchar(40) | NULL | Reference Document Number | No | No | |||
| MRMn_Ref_Doc_Type | varchar(25) | NULL | Reference Document Type -  Technical Log/ Line WorkOrder / Hangar Work Order | No | No | |||
| MRMn_Reported_Date | datetime | NULL | Reporting Date of Technical Log / Journey Log | No | No | |||
| MRMn_Rectified_Date | datetime | NULL | Reporting Date of Technical Log on which the Maintenance Report is getting closed | No | No | |||
| MRMn_Rectification_Comments | varchar(18) | NULL | Remarks of Maintenance Report | No | No | |||
| MRMn_Carry_Forward | varchar(5) | NULL | Carry Forward - Y/N | No | No | |||
| MRMn_Def_Item_Type | varchar(5) | NULL | Deferred Item Type | No | No | |||
| MRMn_Comments | varchar(255) | NULL | Maintenance Report Remarks | No | No | |||
| MRMn_Created_By | varchar(30) | NULL | User who created the Maintenance Report | No | No | |||
| MRMn_CreatedDate | datetime | NULL | This is the date on which MR got created | No | No | |||
| MRMn_Record_Created_date | datetime | NULL | Record Created Date Time ie the Date and time when the record posted by the Discrepancy Processing Component to the Ac History Component | No | No | |||
| Table Name Achist_MRWU_MR_WorkUnit_Dtl | ||||||||
| Table Comment This table contains the list of workunits that should be performed against the maintenance report. Workunit will be task/Non-routine Task/Standard procedure. | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| MRWU_AcHist_OUInstance | numeric(10) | NOT NULL | Aircraft History OUInstance | Yes | Yes | |||
| MRWU_Maint_Report_OUInstance | numeric(10) | NOT NULL | Maintenance Report OUInstance | Yes | Yes | |||
| MRWU_Maint_Report_No | varchar(40) | NOT NULL | Maintenance Report Number is stored here. | Yes | Yes | |||
| MRWU_Seq_No | numeric(10) | NOT NULL | Sequence Number for the workunit. Sequence number will form the order of execution. | Yes | No | |||
| MRWU_WorkUnit_OUInstance | numeric(10) | NULL | OUInstance of WorkUnit | No | No | |||
| MRWU_WorkUnit_No | varchar(30) | NULL | Work Unit Number which is getting associated with MR is stored here. | No | No | |||
| MRWU_WorkUnit_Type | varchar(5) | NULL | Work Unit Type - Task/ Standard Procedure/Non-Routine Task. | No | No | |||
| MRWU_Work_Unit_Desc | varchar(150) | NULL | Work Unit Description - This detail will be captured for non-routine task. i.e MRWU_New_Exist_Flag = ’N’ | No | No | |||
| MRWU_New_Exist_Flag | varchar(25) | NULL | New/Exist Flag - This flag maintains whether workunit is existing or new one. New is only applicable for Task. On confimation of MR, new Non- Routine Task will be generated. Existing will be applicable for Task/Standard Procedure. | No | No | |||
| MRWU_Task_Type | varchar(25) | NULL | This is one of the quick code type  from Maintenance task component. | No | No | |||
| MRWU_Performed_On | datetime | NULL | Performed On - Date | No | No | |||
| MRWU_Performed_At | varchar(25) | NULL | Performed At - Station Code | No | No | |||
| MRWU_Exec_Status | varchar(15) | NULL | Execution Status | No | No | |||
| MRWU_Inc_Flight_No | varchar(30) | NULL | Incoming Flight Number | No | No | |||
| MRWU_Inc_Leg_No | numeric(10) | NULL | Incoming Leg Number | No | No | |||
| MRWU_Arrival_DateTime | datetime | NULL | Arrival DateTime | No | No | |||
| MRWU_Out_Flight_No | varchar(30) | NULL | Outgoing Flight Number | No | No | |||
| MRWU_Out_Leg_No | numeric(10) | NULL | Outgoing Leg Number | No | No | |||
| MRWU_Sch_Dep_Datetime | datetime | NULL | Schedule Departure Datetime | No | No | |||
| MRWU_Created_By | varchar(30) | NULL | User who creates the data. | No | No | |||
| MRWU_CreatedDate | datetime | NULL | Date on which data got created. | No | No | |||
| MRWU_Record_Created_date | datetime | NULL | Record Created Date Time ie the Date and time when the record posted by the Discrepancy Processing  component to the Ac History Component | No | No | |||
| Table Name Achist_OilDtl_Tech_Oil_Dtl | ||||||||
| Table Comment This table is used to store the Tech Log fuel consumption details | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| OilDtl_AcHist_OUInstance | numeric(10) | NOT NULL | OUInstance of Aircraft History | Yes | No | |||
| OilDtl_TechLog_OUInstance | numeric(10) | NOT NULL | OUInstance of Technical Log | Yes | No | |||
| OilDtl_TechLog_No | varchar(40) | NOT NULL | Tech Log  number System generated unique number to identify a Technical Log for a journey. | Yes | No | |||
| OilDtl_Cfg_OUInstance | numeric(10) | NOT NULL | OUInstance of Configuration | Yes | No | |||
| OilDtl_Pos_Code | varchar(25) | NOT NULL | Position code | Yes | No | |||
| OilDtl_Part_OUInstance | numeric(10) | NOT NULL | OUInstance of Part Component | Yes | No | |||
| OilDtl_Part_No | varchar(40) | NOT NULL | Part Number | Yes | No | |||
| OilDtl_Serial_No | varchar(40) | NOT NULL | Serial Number | Yes | No | |||
| OilDtl_Component_Id | varchar(90) | NOT NULL | Component Id | Yes | No | |||
| OilDtl_Aircraft_Reg_No | varchar(30) | NOT NULL | Aircraft Registration Number | No | No | |||
| OilDtl_Pos_Type | varchar(25) | NOT NULL | Position Type | No | No | |||
| OilDtl_Uplifted_Oil_In_StkUom | numeric(28,8) | NULL | Uplifted Oil in Stock UOM | No | No | |||
| OilDtl_Reported_Date | datetime | NULL | Reported Date of Tech. Log | No | No | |||
| OilDtl_Created_By | varchar(30) | NULL | User who created the details | No | No | |||
| OilDtl_CreatedDate | datetime | NULL | Date at which the details are created by the user | No | No | |||
| OilDtl_Record_Created_Date | datetime | NULL | Record Created Date Time ie the Date and time when the record posted by the Flight Log Component to the Ac History Component | No | No | |||
| Table Name Achist_parameter_details | ||||||||
| Table Comment Stores Parameter detail information. | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| ComponentName | varchar(80) | NOT NULL | Component Name | Yes | No | |||
| ParamCategory | varchar(10) | NOT NULL | Parameter Category | Yes | No | |||
| ParamType | varchar(25) | NOT NULL | Parameter Type | Yes | No | |||
| ParamCode | varchar(5) | NOT NULL | Param Code | Yes | No | |||
| Langid | numeric(10) | NOT NULL | Language ID | Yes | No | |||
| ParamDesc | varchar(80) | NULL | Parameter Description | No | No | |||
| sortby | numeric(10) | NULL | Sorting will be done based on this field | No | No | |||
| CreationDate | datetime | NULL | Date on which it got created. | No | No | |||
| Table Name Achist_TJsd_TJLog_Snag_Dtl | ||||||||
| Table Comment This table stores the discrepancies details reported by the Pilot in the journey log. It also stores the discrepancy details  of the corresponding Technical Log. | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| TJsd_AcHist_OUInstance | numeric(10) | NOT NULL | Aircraft History OUInstance | Yes | No | |||
| TJsd_TJLog_OUInstance | numeric(10) | NOT NULL | Technical Log/Journey Log OUInstance | Yes | No | |||
| TJsd_TJLog_No | varchar(40) | NOT NULL | Technical/Journey Log Number | Yes | No | |||
| TJsd_TJLog_Type | varchar(25) | NOT NULL | Type - whether it is journey log/ Technical Log Values ’BASDP’ - Journey Log ’BASFLTLOG’ - Technical Log | Yes | No | |||
| TJsd_Discrepancy_No | varchar(40) | NOT NULL | Discrepancy Number | Yes | No | |||
| TJsd_Discrepancy_Desc | varchar(255) | NULL | Discrepancy Description | No | No | |||
| TJsd_Maint_Report_OU | numeric(10) | NULL | OUInstance Of Maintenance Report associated with discrepancy number | No | No | |||
| TJsd_Maint_Report_No | varchar(40) | NULL | Maintenance Report number associated with discrepancy number | No | No | |||
| TJsd_Ata_OUInstance | numeric(10) | NULL | OUInstance of ATA | No | No | |||
| TJsd_Ata_No | varchar(16) | NULL | ATA Chapter Number | No | No | |||
| TJsd_Fault_OUInstance | numeric(10) | NULL | OUInstance of Fault Code | No | No | |||
| TJsd_Fault_Code | varchar(25) | NULL | Code which identifies the faults | No | No | |||
| TJsd_Cause_Code | varchar(25) | NULL | Cause Code | No | No | |||
| TJsd_Reported_By | varchar(30) | NULL | This will be a valid EmpCode in Hrm Employee Component | No | No | |||
| TJsd_Delay_Flag | varchar(5) | NULL | Caused Delay Y or N | No | No | |||
| TJsd_ATA_Apportion_Value | numeric(28,8) | NULL | Calculation of ATA#  Apportion Value --------------------------------------------------------- For Corresponding Tech Log Look up for discrepancies (and the associated ATA#) where the work units are marked as Caused Delay = yes. If in one Tech Log there are say, 5 ATA#, then for that cancellation, the No. of Sch. Interruption for each ATA has to be apportioned equally as 1/5. | No | No | |||
| TJsd_Created_By | varchar(30) | NULL | User who creates this record | No | No | |||
| TJsd_CreatedDate | datetime | NULL | Date at which the user created the details | No | No | |||
| TJsd_Record_Created_date | datetime | NULL | Record Created Date Time ie the Date and time when the record posted by the Flight Log Component to the Ac History Component | No | No | |||
| Table Name AcHist_TLgMn_Tech_Log_Hdr | ||||||||
| Table Comment This table is used to store the Tech Log Main Details | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| TLgMn_AcHist_OUInstance | char(18) | NOT NULL | OU Instance | Yes | No | |||
| TLgMn_TechLog_OUInstance | numeric(10) | NOT NULL | Tech Log OUInstance | Yes | No | |||
| TLgMn_TechLog_No | varchar(40) | NOT NULL | Tech Log No | Yes | No | |||
| TLgMn_Aircraft_OUInstance | numeric(10) | NULL | Aircraft OUIstance | No | No | |||
| TLgMn_Aircraft_Reg_No | varchar(30) | NULL | Aircraft Registration Number | No | No | |||
| TLGMN_AIRCRAFT_MODEL_NO | varchar(18) | NULL | Model of the Aircraft Registration Number | No | No | |||
| TLgMn_Reporting_Station | varchar(32) | NULL | Code that identifies the Reporting Station | No | No | |||
| TLgMn_Reporting_Datetime | datetime | NULL | Reporting Datetime | No | No | |||
| TLgMn_Utc_Reporting_Datetime | datetime | NULL | Reporting Datetime in UTC format | No | No | |||
| TLgMn_Created_By | varchar(30) | NULL | User who created the details | No | No | |||
| TLgMn_CreatedDate | datetime | NULL | Date at which the details are created by the user | No | No | |||
| TLgMn_Record_Created_Date | char(18) | NULL | Record Created Date in the history | No | No | |||