| Component History | ||||||
| Table Name chist_com_cirt_of_maint_dtl | ||||||
| Table Comment Cirtificate of Maintenance (COM) Details | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| com_ouinstance | decimal(38) | NOT NULL | CWO OU Instance | Yes | No | |
| com_CompWorkOrder | varchar(40) | NOT NULL | Comp Work Order | Yes | No | |
| com_ComNo | varchar(40) | NOT NULL | Cirtificate of Maintenance | Yes | No | |
| com_partno | varchar(40) | NULL | Partno of the CWo Stored here for Last COM details fetch | No | No | |
| com_serialno | varchar(40) | NULL | CWO Part Serial No Stored here for Last COM details fetch | No | No | |
| com_AuthEmpName | varchar(60) | NULL | Authorized Employee Name | No | No | |
| com_AuthLicenseNo | varchar(25) | NULL | Authorized Licenence No | No | No | |
| com_AuthApprovalno | varchar(25) | NULL | Authorized Approval No | No | No | |
| com_CertificationDetails | varchar(5) | NULL | Indicates that the Employee is Internal or outsider | No | No | |
| com_status | varchar(5) | NULL | COM Status F- Fresh A- Authorized C - Cancel | No | No | |
| com_Authremarks | varchar(255) | NULL | Authorization Remarks | No | No | |
| com_AuthSkillCode | varchar(25) | NULL | Authorization Employee Skill Code | No | No | |
| com_AuthEmpCode | varchar(15) | NULL | Authorization Employee Code | No | No | |
| com_AuthorizedBy | varchar(60) | NULL | Authorization Employee Code - Login user Name | No | No | |
| com_AuthDateTime | datetime | NULL | Authorization Date Time | No | No | |
| com_NewlyOverhauled | varchar(25) | NULL | Flag Indicating the NewlyOverhauled | No | No | |
| com_ReturnToService | varchar(25) | NULL | Flag Indicating the Return to Service | No | No | |
| com_CreatedBy | varchar(30) | NULL | Record Created By User Login name | No | No | |
| com_CreatedDate | datetime | NULL | Record Creation Date | No | No | |
| com_ModifiedBy | varchar(30) | NULL | Last Modified By | No | No | |
| com_ModificationDate | datetime | NULL | Last Modification Date | No | No | |
| com_timestamp | decimal(38) | NULL | Timestamp | No | No | |
| Table Name CHIST_CRA_COMP_REPL_AUD | ||||||
| Table Comment Audit table for history values of Component Removal Details. | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| CRA_AIRCRAFTCODE | varchar(30) | NOT NULL | Aircraft Reg Number. | Yes | No | |
| CRA_REMOVEDCOMPONENTID | varchar(90) | NOT NULL | Removed Component Id. | Yes | No | |
| CRA_PART_NO | varchar(40) | NOT NULL | Removal Part Number. | Yes | No | |
| CRA_SERIAL_NO | varchar(40) | NOT NULL | Removal Serial Number. | Yes | No | |
| CRA_ATA | varchar(16) | NOT NULL | ATA Number. | Yes | No | |
| CRA_OUINSTANCE | decimal(38) | NOT NULL | OUInstance. | Yes | No | |
| CRA_LAST_RECORD_MOD_DATE | datetime | NULL | Last Modified Date. | No | No | |
| CRA_CREATE_DATE | datetime | NULL | Created Date. | No | No | |
| Table Name Chist_cra_comp_repl_aud | ||||||
| Table Comment Audit Table for Chist_crd_comp_repl_dtl . This table would have an entry for any past dated record modification , which has already been processed by the Reliability Setup. | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| cra_ouinstance | numeric | NOT NULL | OU instance | Yes | No | |
| cra_aircraftcode | varchar(30) | NOT NULL | aircraft registration number | Yes | No | |
| cra_removedcomponentid | varchar(90) | NOT NULL | removed component id | Yes | No | |
| cra_part_no | varchar(40) | NOT NULL | part number | Yes | No | |
| cra_serial_no | varchar(40) | NOT NULL | Serial number of the part | Yes | No | |
| cra_ata | varchar(16) | NOT NULL | ATA number | Yes | No | |
| cra_last_record_mod_date | datetime | NULL | The Transactioin Date time | No | No | |
| cra_create_date | datetime | NULL | Record Created Date Time | No | No | |
| Table Name chist_cra_cwo_res_actuals | ||||||
| Table Comment CWO Resouce Actuals | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| cra_ouinstance | decimal(38) | NOT NULL | CWO OU Instance | Yes | Yes | |
| cra_compworkorder | varchar(40) | NOT NULL | CWO Work Order | Yes | Yes | |
| cra_ResCode | varchar(40) | NOT NULL | Resource Code | Yes | No | |
| cra_taskserialno | numeric(10) | NOT NULL | Unique task no - System Generated | Yes | Yes | |
| cra_TransId | varchar(40) | NOT NULL | Unique Transaction Id - GUID | Yes | No | |
| cra_Restype | varchar(25) | NOT NULL | Resource Type | Yes | No | |
| cra_Comments | varchar(255) | NULL | Comments | No | No | |
| cra_CWOActDuration | decimal(28,8) | NULL | Resource Actual Usage Duration in min | No | No | |
| CRA_FROMDATETIME | datetime | NULL | date and time from when the resource started working on the task | No | No | |
| cra_DisplayActDurationHrs | decimal(28,8) | NULL | Display Duration | No | No | |
| cra_ToDateTime | datetime | NULL | date and time till when the resource worked on the task | No | No | |
| cra_Attendancetype | varchar(25) | NULL | Attendance type | No | No | |
| cra_createdDate | datetime | NULL | Reported Date | No | No | |
| CRA_CREATEDBY | varchar(30) | NULL | login user reporting the atuals | No | No | |
| Table Name Chist_crd_comp_repl_dtl | ||||||
| Table Comment Component Replacement Transaction Details The data Gets Populated by the CR Confirmation Process and Report Inspection Findings Process. | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| crd_ouinstance | numeric | NOT NULL | OU instance | Yes | No | |
| Crd_cr_ouinstance | numeric | NOT NULL | Comp Replacement OU Instance | Yes | No | |
| Crd_RotableReplcmtNo | varchar(30) | NOT NULL | Component Replacement No | Yes | No | |
| Crd_TranType | varchar(20) | NOT NULL | Transaction Type RM - Removal Transaction R - Reversal Transaction | Yes | No | |
| crd_AircraftCode | varchar(30) | NULL | Aircraft Reg no | No | No | |
| crd_RemovedComponentID | varchar(90) | NULL | Removed Component Id | No | No | |
| Crd_Part_no | varchar(40) | NULL | Part No associated with the Component at the time of Removal | No | No | |
| Crd_Serial_no | varchar(40) | NULL | Serial No associated with the Component at the time of Removal | No | No | |
| Crd_Ata | varchar(16) | NULL | ATA No associated with the Component at the time of Removal | No | No | |
| crd_RemovalDate | datetime | NULL | Totable Removal Date | No | No | |
| crd_RemovalTime | datetime | NULL | Rotable Removal Time | No | No | |
| crd_RemType | varchar(25) | NULL | Rotable Removal Type | No | No | |
| crd_BasRemoval | varchar(25) | NULL | Bas Removal Category | No | No | |
| crd_confirmed_failure | varchar(25) | NULL | Indicates whether this removal is a confirmed Failure. The flag gets updated by the Report Inspection Findings | No | No | |
| crd_status | varchar(15) | NULL | Component Replacement Status Fresh, Confirm Removal, Confirm Replacement, Cancel | No | No | |
| crd_created_by | varchar(30) | NULL | record creating user | No | No | |
| crd_created_date | datetime | NULL | record created date | No | No | |
| Table Name CHIST_CRD_COMP_REPL_DTL | ||||||
| Table Comment this table will have history values of Component Removal Details. | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| CRD_ROTABLEREPLCMTNO | varchar(40) | NOT NULL | Replacement Number | Yes | No | |
| CRD_OUINSTANCE | decimal(38) | NOT NULL | Replacement OUInstance. | Yes | No | |
| CRD_CR_OUINSTANCE | decimal(38) | NOT NULL | CR Ouinstance | Yes | No | |
| CRD_TRANTYPE | varchar(20) | NULL | Trannsaction type of the Component Replacement. | No | No | |
| CRD_AIRCRAFTCODE | varchar(30) | NULL | Aircraft Registration Number. | No | No | |
| CRD_REMOVEDCOMPONENTID | varchar(90) | NULL | Removed Component Id. | No | No | |
| CRD_PART_NO | varchar(40) | NULL | Removed Part Number. | No | No | |
| CRD_SERIAL_NO | varchar(40) | NULL | Removed Serial Number. | No | No | |
| CRD_ATA | varchar(16) | NULL | ATA Number. | No | No | |
| CRD_REMOVALDATE | datetime | NULL | Removal Date. | No | No | |
| CRD_REMOVALTIME | datetime | NULL | Removal Time. | No | No | |
| CRD_REMTYPE | varchar(25) | NULL | Removal Type. | No | No | |
| CRD_BASREMOVAL | varchar(25) | NULL | Basic removal (Yes/No) | No | No | |
| CRD_CONFIRMED_FAILURE | varchar(25) | NULL | Confirmed Failure Flag. | No | No | |
| CRD_STATUS | varchar(15) | NULL | Status of the Replacement. | No | No | |
| CRD_CREATED_BY | varchar(30) | NULL | User who creates the Replacement. | No | No | |
| CRD_CREATED_DATE | datetime | NULL | Replacement Created  Date. | No | No | |
| Table Name chist_cwh_comp_wo_hdr | ||||||
| Table Comment CWO Header history Details | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| cwh_ouinstance | decimal(38) | NOT NULL | CWO OU Instance | Yes | No | |
| cwh_CompWorkorder | varchar(40) | NOT NULL | Comp Work Order | Yes | No | |
| cwh_ComponentID | varchar(90) | NULL | CWO Component ID | No | No | |
| cwh_CompOUInst | decimal(38) | NULL | Comp Ou Instance | No | No | |
| cwh_EnggOrgunit | decimal(38) | NULL | EO OU | No | No | |
| cwh_partno | varchar(40) | NULL | Component Part No | No | No | |
| cwh_partserialno | varchar(40) | NULL | Comp Part Serial No | No | No | |
| cwh_warranty | varchar(25) | NULL | Component Warranty | No | No | |
| cwh_sourcedoctype | varchar(25) | NULL | Source Document Type | No | No | |
| cwh_SourceDocumentNo | varchar(40) | NULL | Source Document No | No | No | |
| cwh_Rotablereplcmtno | varchar(40) | NULL | Component replacement No | No | No | |
| cwh_cwodesc | varchar(150) | NULL | workorder description | No | No | |
| cwh_CWOtype | varchar(25) | NULL | work order type overhaul - OVH repair - REP inspection - INS others - OTH | No | No | |
| cwh_CWOUDStatus | NULL | CWO user Status | No | No | ||
| cwh_CWOPriorityno | numeric(10) | NULL | CWO Priority No | No | No | |
| cwh_CWOcategory | varchar(25) | NULL | CWO Category | No | No | |
| cwh_parentcwo | varchar(40) | NULL | CWO Parent WO NO | No | No | |
| cwh_precedencecwo | varchar(40) | NULL | CWO Precendence WO No | No | No | |
| cwh_PrimaryWCCode | varchar(30) | NULL | Primary Work Center Code | No | No | |
| cwh_WCOUInstance | decimal(38) | NULL | Work Center OU Instance | No | No | |
| cwh_cwostdate | datetime | NULL | CWO Start Date | No | No | |
| cwh_DisplayTimeuom | varchar(5) | NULL | Display Time UOM H - hours D - days M - minutes | No | No | |
| cwh_CWOEnddate | datetime | NULL | CWO End Time | No | No | |
| cwh_DisplayEst_Elap_Time | numeric(28,8) | NULL | Estimated Elapsed Time in Display Unit | No | No | |
| cwh_EstElapsedTime | numeric(28,8) | NULL | CWO Elapsed Time | No | No | |
| cwh_status | varchar(5) | NULL | CWO Status completed - C cancelled - CA closed - CL fresh - F inprogress - I preclosed - PC scheduled - S | No | No | |
| cwh_MaxUniqueTaskNo | numeric(10) | NULL | CWO Max Task Serial No | No | No | |
| cwh_ReschCount | numeric(10) | NULL | Resheduled Count | No | No | |
| cwh_EstManHrs | numeric(28,8) | NULL | Estimated Man Hrs | No | No | |
| cwh_ResCost | numeric(28,8) | NULL | Total resource cost | No | No | |
| cwh_MiscCost | numeric(28,8) | NULL | Miscellaneous Cost | No | No | |
| cwh_MatCost | numeric(28,8) | NULL | Total Material cost | No | No | |
| cwh_currency | varchar(20) | NULL | CWO Currency | No | No | |
| cwh_CoMReqd | varchar(5) | NULL | Sign off Required Yes/No Checked - Yes, UnChecked - No | No | No | |
| cwh_Childcount | numeric(10) | NULL | Sub work Orders Count | No | No | |
| cwh_SchFlag | varchar(25) | NULL | Schedule Flag yes - Y no - N | No | No | |
| cwh_InspFindings | varchar(25) | NULL | Inspected Findings Flag | No | No | |
| cwh_ESReqNo | varchar(40) | NULL | ES Reqest No | No | No | |
| cwh_AOGFlag | varchar(25) | NULL | AOG Flag yes - Y no - N | No | No | |
| cwh_COMStaus | varchar(15) | NULL | COM Status Indicating the COM has been issued or not based on the cwh_ComRequired flag. Ths should be read in relation to the COMRequired flag. Default Value - N Y -  COM Issued N - COM Not Issued | No | No | |
| cwh_Remarks | varchar(255) | NULL | Authorization Remarks | No | No | |
| CWH_AUTHORIZEDBY | varchar(30) | NULL | User authorizing the work order | No | No | |
| cwh_AuthDate | datetime | NULL | Authorization Date | No | No | |
| CWH_CREATEDBY | varchar(30) | NULL | doc creating user | No | No | |
| cwh_created_date | datetime | NULL | Created Date | No | No | |
| cwh_modified_date | datetime | NULL | modified Date | No | No | |
| CWH_MODIFIED_BY | varchar(30) | NULL | doc modified user | No | No | |
| cwh_ActualStartDate | datetime | NULL | actual start date | No | No | |
| cwh_ActualEndDate | datetime | NULL | actual end date | No | No | |
| cwh_ActualDuration | numeric(28,8) | NULL | actual duration hours | No | No | |
| cwh_TotalNoOfSubCwos | decimal(38) | NULL | Total no of sub work orders | No | No | |
| cwh_TotalSubCWoCost | numeric(28,8) | NULL | total cost of sub work order | No | No | |
| Table Name chist_cws_comp_wo_sch_dtl | ||||||
| Table Comment CWO Schedule Details History. This Entity maintains the Scheduling details of the WO and Task. The Last Resch Count Rev Start/End  Date and Time Represent the Planned Start /End  and Times of the CWo /Task | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| cws_ReschCount | numeric(10) | NOT NULL | Reschedule Count for this CWO/ task | Yes | No | |
| cws_ouinstance | decimal(38) | NOT NULL | CWO OU Instance | Yes | Yes | |
| cws_compworkorder | varchar(40) | NOT NULL | CWO Work Order | Yes | Yes | |
| cws_taskserialno | numeric(10) | NOT NULL | Unique task no - System Generated | Yes | Yes | |
| cws_ReschType | varchar(25) | NULL | Reschedule Type W - Work Order Level T - Task Level | No | No | |
| cws_status | varchar(5) | NULL | CWO/Task Status at the time of Reschedule | No | No | |
| cws_plstdate | datetime | NULL | Planned Start Date | No | No | |
| cws_plenddate | datetime | NULL | Planned End Date | No | No | |
| cws_RevStdate | datetime | NULL | Rev Wo Start Date | No | No | |
| cws_RevEndDate | datetime | NULL | Rev End Date | No | No | |
| cws_scheduledBy | varchar(30) | NULL | The Rescheduling done by - Login User | No | No | |
| cws_scheduleRemarks | varchar(255) | NULL | Schedule Renmarks | No | No | |
| cws_created_date | datetime | NULL | Rescedule Transaction Date | No | No | |
| Table Name chist_cwt_comp_wo_task_dtl | ||||||
| Table Comment CWO Planned Task Details | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| cwt_ouinstance | decimal(38) | NOT NULL | CWO OU Instance | Yes | Yes | |
| cwt_CompWorkorder | varchar(40) | NOT NULL | CWO Work Order | Yes | Yes | |
| cwt_TaskSerialNo | numeric(6) | NOT NULL | Unique task no - System Generated | Yes | No | |
| cwt_seqno | numeric(6) | NULL | Sequence No | No | No | |
| cwt_Taskcode | varchar(40) | NULL | Task Code | No | No | |
| cwt_RevisionNo | varchar(40) | NULL | Task Revision No | No | No | |
| cwt_WCCode | varchar(40) | NULL | Work Center | No | No | |
| cwt_DisplayTimeUom | varchar(5) | NULL | Display time Uom H - hours D - days M - minutes | No | No | |
| cwt_EstElapsedTime | numeric(28,8) | NULL | Estimated Elapsed Time | No | No | |
| Cwt_Displayest_Elap_Time | numeric(28,8) | NULL | Display Duration | No | No | |
| cwt_EstManHrs | numeric(28,8) | NULL | Estimated Man Hrs | No | No | |
| cwt_CWOPlStartDate | datetime | NULL | Planned Start Date | No | No | |
| cwt_CWOPlEndDate | datetime | NULL | Planned End Date | No | No | |
| cwt_status | varchar(5) | NULL | CWO Task Status | No | No | |
| cwt_ref_workunit | varchar(40) | NULL | Reference Work Unit No Task, Sp or WP | No | No | |
| cwt_created_date | datetime | NULL | Created Date | No | No | |
| cwt_created_by | varchar(30) | NULL | Record Created User Name | No | No | |
| cwt_TaskDescription | varchar(150) | NULL | Task description | No | No | |
| cwt_ActualStartDate | datetime | NULL | task actual start date | No | No | |
| cwt_ActualEndDate | datetime | NULL | task actual end date | No | No | |
| cwt_ActDurUom | varchar(5) | NULL | Unit of measurement for actual duration | No | No | |
| cwt_ActualDuration | numeric(28,8) | NULL | actual duration | No | No | |
| cwt_MatCost | numeric(28,8) | NULL | Material cost | No | No | |
| cwt_ResCost | numeric(28,8) | NULL | Resource cost | No | No | |
| cwt_MiscCost | numeric(28,8) | NULL | Miscellaneous cost | No | No | |
| Table Name Chist_Eoc_Engine_OiL_Consum | ||||||
| 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 | |
| eoc_techlog_ouinstance | numeric | NOT NULL | Tech log OU instance | Yes | No | |
| eoc_ouinstance | numeric | NOT NULL | Ou instance | Yes | No | |
| eoc_TechLog_No | varchar(18) | NOT NULL | Tech Log Number System generated unique number to identify a Technical Log for a journey. | Yes | No | |
| eoc_Pos_Code | varchar(25) | NOT NULL | Position code | Yes | No | |
| eoc_Component_Id | varchar(90) | NOT NULL | Component Id | Yes | No | |
| eoc_aircraft_no | varchar(30) | NOT NULL | aircraft registration number | Yes | No | |
| eoc_cfg_ouinstance | numeric | NULL | Configuration OU instance | No | No | |
| eoc_part_ouinstance | numeric | NULL | part OU instance | No | No | |
| eoc_Part_No | varchar(40) | NULL | Part Number | No | No | |
| eoc_Serial_No | varchar(40) | NULL | Serial Number of the part | No | No | |
| eoc_Pos_Type | varchar(25) | NULL | Position Type | No | No | |
| eoc_Fuel_On_Arr | numeric(28,8) | NULL | Fuel On arrival | No | No | |
| eoc_Fuel_On_Arr_In_StkUom | numeric(28,8) | NULL | Fuel On arrival in stock UOM | No | No | |
| eoc_Uplifted_Oil | numeric(28,8) | NULL | Uplifted Oil | No | No | |
| eoc_Uplifted_Oil_In_StkUom | numeric(28,8) | NULL | Uplifted Oil in Stock UOM | No | No | |
| eoc_reported_date_time | datetime | NULL | reported date and time | No | No | |
| eoc_Created_By | varchar(30) | NULL | User who created the details | No | No | |
| eoc_CreatedDate | datetime | NULL | Date at which the details are created by the user | No | No | |
| eoc_Modified_By | varchar(30) | NULL | User who modified the details | No | No | |
| eoc_Modified_Date | datetime | NULL | Date at which the details are modified by the user | No | No | |
| eoc_utc_report_date | datetime | NULL | Date at which the details are modified by the user | No | No | |
| Table Name CHIST_EOC_ENGINE_OIL_CONSUM | ||||||
| Table Comment This table will have history information of Fuel and Oil Consumption. | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| EOC_TECHLOG_NO | varchar(40) | NOT NULL | Technical Log Number. | Yes | No | |
| EOC_POS_CODE | varchar(25) | NOT NULL | Position Code of the Component Id. | Yes | No | |
| EOC_COMPONENT_ID | varchar(90) | NOT NULL | Component Id. | Yes | No | |
| EOC_OUINSTANCE | decimal(38) | NOT NULL | OUInstance. | Yes | No | |
| EOC_TECHLOG_OUINSTANCE | decimal(38) | NOT NULL | Technical Log OUInstance. | Yes | No | |
| EOC_CFG_OUINSTANCE | decimal(38) | NULL | Configuration OUInstance. | No | No | |
| EOC_PART_OUINSTANCE | decimal(38) | NULL | Part OUInstance. | No | No | |
| EOC_PART_NO | varchar(40) | NULL | Part Number. | No | No | |
| EOC_SERIAL_NO | varchar(40) | NULL | Serial Number. | No | No | |
| EOC_POS_TYPE | varchar(25) | NULL | Postion Type of the Position Code. | No | No | |
| EOC_FUEL_ON_ARR | decimal(28,8) | NULL | Fuel reading on Arrival. | No | No | |
| EOC_FUEL_ON_ARR_IN_STKUOM | decimal(28,8) | NULL | Fuel reading on Arrival in Stock UOM. | No | No | |
| EOC_UPLIFTED_OIL | decimal(28,8) | NULL | Uplifted Oil Level. | No | No | |
| EOC_UPLIFTED_OIL_IN_STKUOM | decimal(28,8) | NULL | Uplifted Oil Level in Stock UOM. | No | No | |
| EOC_UTC_REPORT_DATE | datetime | NULL | UTC Reported Date. | No | No | |
| EOC_REPORTED_DATE_TIME | datetime | NULL | Repored Date and time. | No | No | |
| EOC_AIRCRAFT_NO | varchar(30) | NULL | Aircrtafe Reg Number. | No | No | |
| EOC_CREATED_BY | varchar(30) | NULL | Recored Created User. | No | No | |
| EOC_CREATEDDATE | datetime | NULL | Recored Created Date. | No | No | |
| EOC_MODIFIED_BY | varchar(30) | NULL | Recored Modified User. | No | No | |
| EOC_MODIFIED_DATE | datetime | NULL | Recored Modified Date. | No | No | |
| Table Name chist_erd_est_res_dtl | ||||||
| Table Comment CWO Estimated Resource Details | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| erd_ouinstance | decimal(38) | NOT NULL | OU Instance | Yes | Yes | |
| erd_compworkorder | varchar(40) | NOT NULL | work order code | Yes | Yes | |
| erd_TaskSerialNo | numeric(10) | NOT NULL | Unique task no - System Generated | Yes | Yes | |
| erd_ResourceCode | varchar(40) | NOT NULL | Resource Code | Yes | No | |
| erd_Resourcetype | varchar(25) | NOT NULL | Resource Type S- Skill E- Equipment O- Others T-Tool | Yes | No | |
| erd_DispTimeUom | varchar(5) | NULL | Display Time UOM H- hours D- days M-minutes | No | No | |
| erd_DispReqDur | numeric(28,8) | NULL | Display Required Duration in the Display Time UOM | No | No | |
| erd_ReqdDuration | numeric(28,8) | NULL | Required Duration In MIn | No | No | |
| erd_QtyReq | numeric(28,8) | NULL | Qty Required | No | No | |
| erd_SignOff | varchar(25) | NULL | Sign off Required yes -Y no -N | No | No | |
| erd_rescost | numeric(28,8) | NULL | Resource Cost | No | No | |
| erd_created_date | datetime | NULL | Record Created Date | No | No | |
| erd_created_by | varchar(30) | NULL | Record Created By | No | No | |
| erd_modified_date | datetime | NULL | Last Modification Date | No | No | |
| erd_modified_by | varchar(30) | NULL | Last Modified User Name | No | No | |
| erd_timestamp | numeric | NULL | Timestamp | No | No | |
| Table Name chist_eta_emp_timesheet_act | ||||||
| Table Comment CWO Employee Assignment Details | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| eta_ouinstance | decimal(38) | NOT NULL | OU Instance | Yes | No | |
| eta_CompWorkOrder | varchar(40) | NOT NULL | CWO | Yes | No | |
| ETA_EMPCODE | varchar(20) | NOT NULL | employee code | Yes | No | |
| eta_TransId | varchar(40) | NOT NULL | Time Sheet Entry Serial No for the given OU, CWO No, Task Serial No, Employee Code Use GUID | Yes | No | |
| eta_TaskSerialNo | numeric(4) | NOT NULL | Unique task no - System Generated | Yes | No | |
| eta_FromDate | datetime | NULL | Timesheet actulas From Date | No | No | |
| eta_ToDate | datetime | NULL | timesheet Actuals To Date | No | No | |
| eta_created_date | datetime | NULL | Created Date | No | No | |
| eta_created_by | varchar(30) | NULL | Created By - Log in USer name | No | No | |
| eta_modified_date | datetime | NULL | LastModified Date | No | No | |
| eta_modified_by | varchar(30) | NULL | Last Modified By | No | No | |
| eta_timestamp | decimal(38) | NULL | Timestamp | No | No | |
| Table Name chist_etd_emp_timesheet_dtl | ||||||
| Table Comment CWO Employee Timesheet Details | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| etd_ouinstance | decimal(38) | NOT NULL | OU Instance | Yes | Yes | |
| etd_CompWorkOrder | varchar(40) | NOT NULL | Comp Work Order | Yes | Yes | |
| etd_empcode | varchar(20) | NOT NULL | employee code | Yes | Yes | |
| etd_TransId | varchar(40) | NOT NULL | Time Sheet Serail No | Yes | Yes | |
| etd_TaskSerialNo | numeric(10) | NOT NULL | Unique task no - System Generated | Yes | Yes | |
| etd_TimesheetDate | datetime | NOT NULL | Time Sheet Date | Yes | No | |
| etd_DisplayTimeUom | varchar(5) | NULL | Display Time Uom | No | No | |
| etd_Fromtime | varchar(10) | NULL | From Time - Time Stored in hh:mm format | No | No | |
| etd_totime | varchar(10) | NULL | To Time - Time Stored in hh:mm format | No | No | |
| etd_timeperday | numeric(28,8) | NULL | Time Per Day - Stored in Min. During display it should be converted to unit of Display | No | No | |
| etd_DisplayTimeperday | numeric(28,8) | NULL | Display Duration | No | No | |
| etd_empCost | numeric(28,8) | NULL | Cost incurred on the employee | No | No | |
| etd_Attendancetype | varchar(25) | NULL | Attendance Type | No | No | |
| etd_Emptaskstatus | varchar(25) | NULL | Task Status at the time of Reporting this Transaction | No | No | |
| etd_comments | varchar(2000) | NULL | Comments | No | No | |
| ETD_EMPNORMALCOST | decimal(28,8) | NULL | Employee Normal Cost. | No | No | |
| ETD_EMPOTCOST | decimal(28,8) | NULL | Employee Over Time Cost. | No | No | |
| ETD_OT_HRS | decimal(28,8) | NULL | Employee Over Time Hours. | No | No | |
| Table Name Chist_JLgSng_JrnLg_Snag_Dtl | ||||||
| Table Comment This table stores the discrepancies details reported by the Pilot in the journey log | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| JLGSNG_JRNLOG_OUINSTANCE | numeric | NOT NULL | journey log OU instance | Yes | No | |
| JLgSng_JrnLog_No | varchar(18) | NOT NULL | Journey Log Number System generated unique number to identify a Flight Log for a journey. | Yes | No | |
| JLgSng_Discrepancy_No | varchar(18) | NOT NULL | Discrepancy Number | Yes | No | |
| JlgSng_Flight_no | varchar(30) | NULL | Flight No | No | No | |
| JlgSng_Leg_no | numeric | NULL | Leg No | No | No | |
| JLgSng_Aircraft_Reg_No | varchar(30) | NULL | Aircraft Reg No | No | No | |
| JLgSng_Discrepancy_Status | varchar(5) | NULL | At the time of create, Status will be ’FR’ [Fresh], At the time of cancelling the Jlog, status will be Cn [Cancel] At the time of confirming the Jlog, status will be Cf [Confirm] At the time of closing the workorder which get raised from DP with a MR reference, this status will be updated as ’CL’ [’Closed’ ] | No | No | |
| JLgSng_Discrepancy_Desc | varchar(255) | NULL | Discrepancy Description | No | No | |
| JLGSNG_ATA_OUINSTANCE | numeric | NULL | ATA OU instance | No | No | |
| JLgSng_Ata_No | varchar(16) | NULL | ATA Chapter Number | No | No | |
| JlgSng_sch_dep_date | datetime | NULL | Scheduled Departure Date in UTC | No | No | |
| JlgSng_Reported_dateTime | datetime | NULL | Snag Reported Date Time in UTC | No | No | |
| JLGSNG_FAULT_OUINSTANCE | numeric | NULL | Fault OU instance | No | No | |
| JLgSng_Fault_Code | varchar(25) | NULL | Code which identifies the faults | No | No | |
| JLgSng_Reported_By | varchar(15) | NULL | This will be a valid EmpCode in Hrm Employee Component | No | No | |
| JLgSng_Created_By | varchar(30) | NULL | User who created the details | No | No | |
| JLgSng_CreatedDate | datetime | NULL | Data at which the user created the details | No | No | |
| JLgSng_Modified_By | varchar(30) | NULL | User who modified the details | No | No | |
| JLgSng_ModifiedDate | datetime | NULL | Data at which the user modified the details | No | No | |
| Table Name CHIST_JLGSNG_JRNLG_SNAG_DTL | ||||||
| Table Comment This table stores the history information of Journey Log Discrepency details. | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| JLGSNG_JRNLOG_NO | varchar(40) | NOT NULL | Journey Log Number System generated unique number to identify a Flight Log for a journey. | Yes | No | |
| JLGSNG_DISCREPANCY_NO | varchar(40) | NOT NULL | Discrepancy Number | Yes | No | |
| JLGSNG_JRNLOG_OUINSTANCE | decimal(38) | NOT NULL | journey log OU instance | Yes | No | |
| JLGSNG_DISCREPANCY_STATUS | varchar(5) | NULL | At the time of create, Status will be ’FR’ [Fresh], At the time of cancelling the Jlog, status will be Cn [Cancel] At the time of confirming the Jlog, status will be Cf [Confirm] At the time of closing the workorder which get raised from DP with a MR reference, this status will be updated as ’CL’ [’Closed’ ] | No | No | |
| JLGSNG_FLIGHT_NO | varchar(30) | NULL | Flight No | No | No | |
| JLGSNG_LEG_NO | decimal(38) | NULL | Leg No | No | No | |
| JLGSNG_DISCREPANCY_DESC | varchar(255) | NULL | Discrepancy Description | No | No | |
| JLGSNG_ATA_OUINSTANCE | decimal(38) | NULL | ATA OU instance | No | No | |
| JLGSNG_AIRCRAFT_REG_NO | varchar(30) | NULL | Aircraft Reg No | No | No | |
| JLGSNG_ATA_NO | varchar(16) | NULL | ATA Chapter Number | No | No | |
| JLGSNG_FAULT_OUINSTANCE | decimal(38) | NULL | Fault OU instance | No | No | |
| JLGSNG_FAULT_CODE | varchar(25) | NULL | Code which identifies the faults | No | No | |
| JLGSNG_REPORTED_BY | varchar(15) | NULL | This will be a valid EmpCode in Hrm Employee Component | No | No | |
| JLGSNG_CREATED_BY | varchar(30) | NULL | User who created the details | No | No | |
| JLGSNG_SCH_DEP_DATE | datetime | NULL | Scheduled Departure Date. | No | No | |
| JLGSNG_CREATEDDATE | datetime | NULL | Data at which the user created the details | No | No | |
| JLGSNG_REPORTED_DATETIME | datetime | NULL | Reported Date and Time. | No | No | |
| JLGSNG_MODIFIED_BY | varchar(30) | NULL | User who modified the details | No | No | |
| JLGSNG_MODIFIEDDATE | datetime | NULL | Data at which the user modified the details | No | No | |
| Table Name chist_npc_nonstd_part_act | ||||||
| Table Comment Consumables and Non Standard Part consumpation actual details of CWO | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| npc_ouinstance | decimal(38) | NOT NULL | CWO OU Instance | Yes | Yes | |
| npc_CompWorkorder | varchar(40) | NOT NULL | CWO Work Order | Yes | Yes | |
| npc_TaskSerialNo | numeric(10) | NOT NULL | Unique task no - System Generated | Yes | Yes | |
| npc_transid | varchar(40) | NOT NULL | Transaction id | Yes | No | |
| npc_partnomlt | varchar(40) | NULL | part number | No | No | |
| npc_PartDescMlt | varchar(150) | NULL | part description | No | No | |
| npc_UOMMlt | varchar(10) | NULL | unit of measurement | No | No | |
| npc_qtyused | decimal(28,8) | NULL | used quantity of parts | No | No | |
| npc_MatCost | numeric(28,8) | NULL | material cost | No | No | |
| npc_Warehouse | varchar(10) | NULL | warehouse code | No | No | |
| npc_PartType | varchar(25) | NULL | part type standard -  S Non standard - N | No | No | |
| npc_createdDate | datetime | NULL | record creation date | No | No | |
| npc_createdBy | varchar(30) | NULL | created by | No | No | |
| Table Name chist_pcd_Parts_Cons_dtl | ||||||
| Table Comment Component Work Order Part Consumption Details | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| pcd_PartNoMlt | varchar(40) | NOT NULL | Part No | Yes | No | |
| pcd_Warehousemlt | varchar(10) | NOT NULL | Warehouse Number | Yes | No | |
| pcd_ouinstance | decimal(38) | NOT NULL | CWO OU Instance | Yes | Yes | |
| pcd_CompWorkorder | varchar(40) | NOT NULL | CWO Work Order | Yes | Yes | |
| pcd_TaskSerialNo | numeric(10) | NOT NULL | Unique task no - System Generated | Yes | Yes | |
| pcd_partDesc | varchar(150) | NULL | Part description | No | No | |
| pcd_UOMMlt | varchar(10) | NULL | Part Consumption Qty UOM | No | No | |
| pcd_ReqQty | numeric(28,8) | NULL | required quantity | No | No | |
| pcd_QtyUsed | numeric(28,8) | NULL | Consumption Qty | No | No | |
| pcd_QtyIssued | numeric(28,8) | NULL | Issued Quantity | No | No | |
| pcd_QtyReturned | numeric(28,8) | NULL | Returned quantity | No | No | |
| pcd_createdDate | datetime | NULL | Transaction Date | No | No | |
| pcd_createdBy | varchar(30) | NULL | Login User Id | No | No | |
| Table Name chist_rad_res_assign_dtl | ||||||
| Table Comment CWO Resource Assignment Details. Currently only one Schedule would be there for a resource in a task. | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| rad_ouinstance | decimal(38) | NOT NULL | CWO OU Instance | Yes | Yes | |
| rad_compworkorder | varchar(40) | NOT NULL | CWO Work Order | Yes | Yes | |
| rad_taskserialno | numeric(10) | NOT NULL | Unique task no - System Generated | Yes | Yes | |
| RAD_RESOURCECODE | varchar(40) | NOT NULL | resource code | Yes | No | |
| RAD_RESOURCETYPE | varchar(5) | NOT NULL | resource type Equipment - E Skill -S Others - O Tool - T | Yes | No | |
| rad_ResourceSeqNo | numeric(10) | NOT NULL | Resocue Schedule No - Runing serail no of the Resource Schedule details for a given resource and resource type. The ResSchno does not indicate the sequence of the time horizon. | Yes | No | |
| rad_Fromdate | datetime | NULL | From Date -  date from which assignment of employee starts | No | No | |
| rad_Todate | datetime | NULL | To Date - date on which assignment of employee ends | No | No | |
| rad_DisplayTimeUOM | varchar(5) | NULL | Display Time UOM H - hours D - days M- minutes | No | No | |
| rad_displaytimeperday | numeric(28,8) | NULL | Display Duration as shown on the screen | No | No | |
| rad_timeperday | numeric(28,8) | NULL | Time Per Day - Duration Stored in Min | No | No | |
| rad_created_date | datetime | NULL | Record Created Date | No | No | |
| rad_created_by | varchar(30) | NULL | Record Created By | No | No | |
| rad_modified_date | datetime | NULL | Last Modified Date | No | No | |
| rad_modified_by | varchar(30) | NULL | Last Modified By | No | No | |
| rad_timestamp | numeric | NULL | Timestamp | No | No | |
| Table Name chist_sod_sign_off_dtl | ||||||
| Table Comment Task Sign off details | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| sod_ouinstance | decimal(38) | NOT NULL | OU Instance | Yes | No | |
| sod_CompWorkOrder | varchar(40) | NOT NULL | Component Work Order No | Yes | No | |
| sod_TaskSerialNo | numeric(10) | NOT NULL | Unique task no - System Generated | Yes | No | |
| sod_SkillCode | varchar(40) | NOT NULL | Employee Skill Code | Yes | No | |
| sod_EmpCode | varchar(40) | NULL | Employee Code | No | No | |
| sod_SignoffDate | datetime | NULL | Sign Off Date | No | No | |
| sod_Comments | varchar(255) | NULL | Sign off Comments | No | No | |
| sod_SignFlag | varchar(5) | NULL | Sign Flag Indicating that the CWo,Task, skill code  has been signed or not Y - Signed N- Not Signed | No | No | |
| sod_CreatedDate | datetime | NULL | Record Creation Date | No | No | |
| sod_CreatedBy | varchar(30) | NULL | Record Created by User Login name | No | No | |
| sod_modifiedDate | datetime | NULL | Last Modification Date | No | No | |
| sod_modifiedby | varchar(30) | NULL | Last Modified By | No | No | |
| sod_timestamp | decimal(38) | NULL | Timestamp | No | No | |