| Data Dictionary - Hangar Work Reporting | |||||
| Table Name Cmn_hwor_Task_Roster_dtls | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| hwor_ouinstance | udd_ouinstname | NOT NULL | Ouinstance | Yes | No |
| hwor_Wo_no | udd_DocumentNo | NOT NULL | Work order no | Yes | No |
| hwor_Task_Seqno | udd_taskseqno | NOT NULL | Task Sequence No | Yes | No |
| hwor_Task_Serialno | udd_taskseqno | NOT NULL | Task Serial no | Yes | No |
| hwor_ActualCls_Date | Datetime | NULL | Actual Close date | No | No |
| hwor_Task_code | udd_taskcode | NULL | Task Code | No | No |
| hwor_Customer_order_no | udd_DocumentNo | NULL | Curomer Order No | No | No |
| hwor_Amend_no | udd_revisionno | NULL | Amend No | No | No |
| hwor_Service_price_list | udd_flag | NULL | Service Price list | No | No |
| hwor_Revision_no | udd_revisionno | NULL | Revison No | No | No |
| hwor_Element | udd_flag | NULL | Element | No | No |
| hwor_Employecode | udd_empcode | NULL | Employee code | No | No |
| hwor_ResourceType | udd_flag | NULL | Resource type | No | No |
| hwor_ResourceCode | udd_flag | NULL | Resource code | No | No |
| hwor_Rostercode | udd_flag | NULL | Roster code | No | No |
| hwor_Fromtime | DATETIME | NULL | From Time | No | No |
| hwor_Totime | DATETIME | NULL | To Time | No | No |
| hwor_SPL_Factor | udd_amount | NULL | Spl Factor | No | No |
| hwor_Day | udd_flag | NULL | Day | No | No |
| hwor_DayType | udd_flag | NULL | Day type | No | No |
| hwor_Worked_hrs | Udd_Duration | NULL | Worked hours | No | No |
| hwor_Factor_per_hr | Udd_amount | NULL | Factor Per hour | No | No |
| hwor_normal_rate_per_hr | Udd_Duration | NULL | Normal rate per hour | No | No |
| hwor_Resource_Price | Udd_amount | NULL | Resource price | No | No |
| hwor_Apportion_flag | udd_flag | NULL | apportion flag | No | No |
| hwor_EXCHANGE_RATE | Udd_amount | NULL | Exchange Rate | No | No |
| hwor_rcd_factor | Udd_amount | NULL | rcd factor | No | No |
| hwor_NonBillable_flag | udd_flag | NULL | Non Billable flag | No | No |
| hwor_Prarent_wu_no | UDD_WORKUNITCODE | NULL | Parent work unit no | No | No |
| hwor_PARENT_WU_TYPE | UDD_DESIGNPARAMCODE | NULL | Parent work unit Type | No | No |
| hwor_SellRate | Udd_amount | NULL | Sell rate | No | No |
| hwor_Tmsht_Billable_flag | udd_designparamcode | NULL | Tmsht Billable falg | No | No |
| Table Name hwr_hwocrd_com_replace_det | |||||
| Table Comment Component Replacement Detail | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| wocrd_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | Yes |
| wocrd_visit_pkg_no | varchar(40) | NOT NULL | Visit Package No | Yes | Yes |
| wocrd_wo_no | varchar(40) | NOT NULL | Work Order No | Yes | Yes |
| WOCRD_SEQ_NO | numeric(10) | NOT NULL | Sequence Number | Yes | No |
| wocrd_part_no | varchar(40) | NOT NULL | Part No | No | No |
| wocrd_current_Serial | varchar(40) | NOT NULL | Current Serial | No | No |
| wocrd_object_type | varchar(5) | NULL | Object Type C- Component O- Others | No | No |
| wocrd_position_code | varchar(25) | NULL | Position Code | No | No |
| wocrd_other_obj_detail | varchar(90) | NULL | Other Object Detail | No | No |
| wocrd_action | varchar(5) | NULL | Action | No | No |
| wocrd_reason_code | varchar(20) | NULL | Reason code | No | No |
| wocrd_tag_no | varchar(40) | NULL | Tag No | No | No |
| wocrd_incoming_object | varchar(5) | NULL | Incoming Object | No | No |
| wocrd_incoming_Serial | varchar(40) | NULL | Incoming Serial | No | No |
| wocrd_component_id | varchar(90) | NULL | Component ID | No | No |
| wocrd_remarks | varchar(255) | NULL | Remarks | No | No |
| wocrd_removal_date | datetime | NULL | Removal Date | No | No |
| wocrd_removed_by | varchar(30) | NULL | Removed By | No | No |
| wocrd_attached_date | datetime | NULL | Attached Date | No | No |
| wocrd_attached_by | varchar(30) | NULL | Attached by | No | No |
| WOCRD_ROTABLEREPLCMTNO | varchar(40) | NULL | Rotable Replacement No | No | No |
| wocrd_repl_type | varchar(25) | NULL | Replacement Type B - Blank REST - Restoration REM - Replacement REP - Remove only ATT- Attachment only | No | No |
| wocrd_comp_condition | varchar(25) | NULL | Component Condition | No | No |
| WOCRD_PART_SERIAL | varchar(40) | NULL | Part Serial | No | No |
| WOCRD_INCOMING_PART | varchar(40) | NULL | Incoming Part | No | No |
| WOCRD_MANF_SERIAL | varchar(40) | NULL | Manufacturing Serial | No | No |
| WOCRD_ATTACH_TIME | datetime | NULL | Attach time | No | No |
| WOCRD_REMOVE_TIME | datetime | NULL | Remove Time | No | No |
| WOCRD_SERIAL_TYPE | varchar(25) | NULL | Serial Type NEW - New EXT - Existing | No | No |
| wocrd_partreturn_flag | varchar(5) | NULL | Part Return Flag Initially it will be NULL When the Part is Removed, it will be N When the removed part is returned it will be Y | No | No |
| wocrd_stockstatus | varchar(40) | NULL | The Return Stock Status of the Removed Part, which is to be returned | No | No |
| wocrd_timestamp | numeric(10) | NULL | Time Stamp | No | No |
| wocrd_issuedocno | varchar(40) | NULL | Issue # of the Part/Serial which is Attached. | No | No |
| wocrd_levelcode | varchar(150) | NULL | Level code on which CR happens | No | No |
| wocrd_workcenter | varchar(30) | NULL | Work Center | No | No |
| WOCRD_MANF_LOTNO | varchar(40) | NULL | Manufature Lot No. | No | No |
| WOCRD_CRNT_LOTNO | varchar(40) | NULL | System Genrated Lot No. | No | No |
| WOCRD_PROCESSFLAG | varchar(25) | NULL | Process Flag | No | No |
| WOCRD_BASREM_REASON | UDD_TXT5 | NULL | Basic Removal for reason # | No | No |
| WOCRD_REMTYPE_REASON | UDD_TXT5 | NULL | Removal Type for reason # | No | No |
| Table Name hwr_hwrdel_work_delay_codes | |||||
| Table Comment Work related Delay codes are 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 |
| hwrdel_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| hwrdel_delay_code | varchar(25) | NOT NULL | Delay Code | Yes | No |
| hwrdel_delay_desc | varchar(80) | NULL | Delay Description | No | No |
| hwrdel_delay_category | varchar(25) | NULL | Delay Category | No | No |
| hwrdel_status | varchar(5) | NULL | Status A -  Active I -  Inactive | No | No |
| hwrdel_createdby | varchar(30) | NULL | Created By | No | No |
| hwrdel_createddate | datetime | NULL | Created Date | No | No |
| hwrdel_modifiedby | varchar(30) | NULL | Modified By | No | No |
| hwrdel_modifieddate | datetime | NULL | Modified Date | No | No |
| hwrdel_timestamp | numeric(10) | NULL | Time Stamp | No | No |
| Table Name hwr_pabfadl_dtl | |||||
| Table Comment Back Flushable Parts | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| PABFADL_OUINSTANCE | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| PABFADL_VISIT_PKG_NO | varchar(40) | NOT NULL | Visit Package No | Yes | No |
| PABFADL_WORKORDERNO | varchar(40) | NOT NULL | work Order No | Yes | No |
| PABFADL_TASKSEQNO | numeric(10) | NOT NULL | Task Sequence No | Yes | No |
| PABFADL_LINENO | numeric(10) | NOT NULL | Line No | Yes | No |
| PABFADL_REQD_PARTNO | varchar(40) | NULL | Required Part No | No | No |
| PABFADL_UOM | varchar(10) | NULL | Unit Of Measurment H - Hours M - Minutes D - Days | No | No |
| PABFADL_REQD_QTY | numeric(28,8) | NULL | Required Quantity | No | No |
| PABFADL_PART_TYPE | varchar(5) | NULL | Part Type OTHS - Others ALL - All | No | No |
| PABFADL_CONS_PARTNO | varchar(40) | NULL | Consumed Part No | No | No |
| PABFADL_CONS_QTY | numeric(28,8) | NULL | Consumed Quantity | No | No |
| PABFADL_RPTD_QTY | numeric(28,8) | NULL | Reported Quantity | No | No |
| PABFADL_RETD_QTY | numeric(28,8) | NULL | returned Quantity | No | No |
| PABFADL_PEND_RETD_QTY | numeric(28,8) | NULL | Pending Returned Quantity | No | No |
| PABFADL_PART_CNTRL_TYPE | varchar(25) | NULL | Part Central Type | No | No |
| PABFADL_WH_CODE | varchar(10) | NULL | Ware House Code | No | No |
| PABFADL_WAREHOUSE_OU | numeric(10) | NULL | Warehouse Ou | No | No |
| PABFADL_STOCK_STATUS | varchar(40) | NULL | Stock Status | No | No |
| PABFADL_REMARKS | varchar(255) | NULL | Remarks | No | No |
| PABFADL_MR_GEN | varchar(40) | NULL | MR Gen | No | No |
| PABFADL_MR_QTY | numeric(28,8) | NULL | MR Quantity | No | No |
| PABFADL_PART_OU | numeric(10) | NULL | Part Ou | No | No |
| PABFADL_REQD_QTY_INSTKUOM | numeric(28,8) | NULL | Required Quantity In Stck  Unit Of Measurement | No | No |
| PABFADL_RECD_STATUS | varchar(5) | NULL | Received Status | No | No |
| Table Name hwr_pabfsladl_dtl | |||||
| Table Comment Back Flushable Serial and Lot Part Detail | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| PABFSLADL_OUINSTANCE | numeric(10) | NOT NULL | Ouinstance | No | No |
| PABFSLADL_VISIT_PKG_NO | varchar(40) | NOT NULL | Visit Package Number | No | No |
| PABFSLADL_WORKORDERNO | varchar(40) | NOT NULL | Work Order No | No | No |
| PABFSLADL_LINENO | numeric(10) | NOT NULL | Line No | No | No |
| PABFSLADL_CONS_PARTNO | varchar(40) | NOT NULL | Consumed Part No | No | No |
| PABFSLADL_SERIAL_NO | varchar(40) | NULL | Serial No | No | No |
| PABFSLADL_LOT_NO | varchar(18) | NULL | Lot No | No | No |
| PABFSLADL_QTY | numeric(28,8) | NULL | Quantity | No | No |
| PABFSLADL_ZONE | varchar(10) | NULL | Zone | No | No |
| PABFSLADL_BIN | varchar(10) | NULL | Bin | No | No |
| PABFSLADL_PART_TYPE | varchar(5) | NULL | Part Type OTHS - Others ALL - All | No | No |
| PABFSLADL_EXPIRY_DATE | datetime | NULL | Expiry Date | No | No |
| PABFSLADL_CONFIRM_FLAG | varchar(5) | NULL | Confirm Flag | No | No |
| PABFSLADL_TIMESTAMP | numeric(10) | NULL | time Stamp | No | No |
| PABFSLADL_LOTSER_LINENO | NULL | LotSer Line No | No | No | |
| Table Name hwr_woaddt_addln_task_list | |||||
| Table Comment Additional Task execution details | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| woaddt_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| woaddt_visit_pkg_no | varchar(40) | NOT NULL | Visit Package No | Yes | No |
| woaddt_wo_no | varchar(40) | NOT NULL | Work Order No | Yes | No |
| woaddt_seq_no | numeric(10) | NOT NULL | Sequence No | Yes | No |
| woaddt_task_no | varchar(30) | NULL | Task No | No | No |
| woaddt_est_man_hrs | numeric(28,8) | NULL | Man Hours | No | No |
| woaddt_start_datetime | datetime | NULL | Start Date Time | No | No |
| woaddt_end_datetime | datetime | NULL | End date time | No | No |
| woaddt_exec_comments | varchar(255) | NULL | Exec Comments | No | No |
| woaddt_reported_by | varchar(30) | NULL | Reported by | No | No |
| woaddt_reported_date | datetime | NULL | Reported Date | No | No |
| woaddt_time_uom | varchar(10) | NULL | Time Uom H - Hours M - Minutes D - Days | No | No |
| woaddt_act_duration | numeric(28,8) | NULL | Act duration | No | No |
| woaddt_createddate | datetime | NULL | Created date | No | No |
| woaddt_created_by | varchar(30) | NULL | Created by | No | No |
| woaddt_modifieddate | datetime | NULL | Modified Date | No | No |
| woaddt_modified_by | varchar(30) | NULL | Modified By | No | No |
| woaddt_timestamp | numeric(10) | NULL | Time Stamp | No | No |
| WOADDT_BASE_MODEL_NO | varchar(20) | NOT NULL | Base Model No | No | No |
| Table Name hwr_wocrh_com_replace_hdr | |||||
| Table Comment Component Replacement Header | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| wocrh_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| wocrh_visit_pkg_no | varchar(40) | NOT NULL | Visit Package No | Yes | No |
| wocrh_wo_no | varchar(40) | NOT NULL | Work Order No | Yes | No |
| wocrh_tag_no | varchar(40) | NULL | Tag No | No | No |
| wocrh_reason_code | varchar(20) | NULL | Reason Code | No | No |
| wocrh_removal_date | datetime | NULL | Removal Date | No | No |
| wocrh_removed_by | varchar(30) | NULL | Removed by | No | No |
| wocrh_component_id | varchar(90) | NULL | Component id | No | No |
| wocrh_part_no | varchar(40) | NULL | Pat no | No | No |
| WOCRH_PART_OU | numeric(10) | NULL | Part Ou | No | No |
| wocrh_serial_no | varchar(40) | NULL | Serial No | No | No |
| wocrh_issue_no | varchar(40) | NULL | Issue No | No | No |
| wocrh_attached_date | datetime | NULL | Attached Date | No | No |
| wocrh_attached_by | varchar(30) | NULL | Attached By | No | No |
| wocrh_createddate | datetime | NULL | Created Date | No | No |
| wocrh_created_by | varchar(30) | NULL | created by | No | No |
| wocrh_modifieddate | datetime | NULL | Modified Date | No | No |
| wocrh_modified_by | varchar(30) | NULL | Modified By | No | No |
| wocrh_timestamp | numeric(10) | NULL | Time stamp | No | No |
| WOCRH_ROTABLEREPLCMTNO | varchar(40) | NULL | Rotable Replacement No | No | No |
| wocrh_repl_type | varchar(25) | NULL | Replacement Type B -  Blank REST - Restoration REM - Replacement REP - Remove only ATT - Attachment only | No | No |
| wocrh_comp_condition | varchar(25) | NULL | Component Condidtion | No | No |
| wocrh_partreturn_flag | varchar(5) | NULL | Part Return Flag Initially it will be NULL When the Part is Removed, it will be N When the removed part is returned it will be Y | No | No |
| wocrh_stockstatus | varchar(40) | NULL | This the Return Stock status of the Part which is removed. | No | No |
| wocrh_rem_componentid | varchar(90) | NULL | Removed Component # | No | No |
| wocrh_rem_partno | varchar(40) | NULL | Removed Part # | No | No |
| wocrh_rem_serialno | varchar(40) | NULL | Removed Serial # | No | No |
| wocrh_levelcode | varchar(150) | NULL | Level Code on which CR happens | No | No |
| wocrh_positioncode | varchar(25) | NULL | Position Code on which CR happens | No | No |
| WOCRH_PROCESSFLAG | varchar(25) | NULL | Process Flag | No | No |
| wocrh_remtype_reason | udd_DesignParamCode | NULL | Removal Type for Reason # | No | No |
| wocrh_basrem_reason | udd_DesignParamCode | NULL | Basic Removal for Reason # | No | No |
| Table Name hwr_wodel_wo_task_delay | |||||
| Table Comment Work Order Delay details | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| wodel_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| wodel_wo_no | varchar(40) | NOT NULL | Work Order Number | Yes | No |
| wodel_keyseq_no | numeric(10) | NOT NULL | Key sequence No | Yes | No |
| wodel_seq_no | numeric(10) | NOT NULL | Sequence No | Yes | No |
| wodel_delay_code | varchar(25) | NULL | Delay Code | No | No |
| wodel_from_datetime | datetime | NULL | From date time | No | No |
| wodel_to_datetime | datetime | NULL | To Date time | No | No |
| wodel_time_unit | varchar(5) | NULL | Time Unit | No | No |
| wodel_delay_duration | numeric(28,8) | NULL | Delay duration | No | No |
| wodel_delay_comments | varchar(255) | NULL | Delay Comments | No | No |
| wodel_timestamp | numeric(10) | NOT NULL | Time Stamp | No | No |
| Table Name hwr_wodplt_descrepancy_list | |||||
| Table Comment Descrepancy details | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| wodplt_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| WODPLT_DISCREPANCY_NO | varchar(40) | NOT NULL | Discrepancy No | Yes | No |
| wodplt_visit_pkg_no | varchar(40) | NULL | Visit Package No | No | No |
| wodplt_vp_wo_flag | varchar(5) | NULL | Work Order Flag V - Visit  Package W - Work Order | No | No |
| wodplt_wo_no | varchar(40) | NULL | Work Order No | No | No |
| wodplt_seq_no | numeric(10) | NULL | Sequence No | No | No |
| wodplt_fault_code | varchar(20) | NULL | Fault Code | No | No |
| wodplt_task_code | varchar(40) | NULL | Task Code | No | No |
| WODPLT_TASK_OU | numeric(10) | NULL | Task Ou | No | No |
| WODPLT_REVISION_NO | varchar(40) | NULL | Revision Number | No | No |
| WODPLT_MODEL_NO | varchar(20) | NULL | Model No | No | No |
| WODPLT_MODEL_OU | numeric(10) | NULL | Model Ou | No | No |
| WODPLT_ACTION_FLAG | varchar(5) | NULL | Action Flag T - Task PEND - To Process CNCL - Cancel NFF- No Fault Found CLSD - Close TRNS - Transfer B - Blank | No | No |
| Table Name hwr_woemt_emp_time_sheet | |||||
| Table Comment Employee Time sheet detail | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| woemt_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| woemt_emp_code | varchar(20) | NOT NULL | Emp Code | Yes | No |
| woemt_keyseq_no | numeric(10) | NOT NULL | Key Sequence No | Yes | No |
| woemt_wo_no | varchar(40) | NOT NULL | work order no | Yes | No |
| woemt_seq_no | numeric(10) | NOT NULL | Sequence No | Yes | No |
| woemt_empcode_ou | numeric(10) | NULL | Empcode Ou | No | No |
| woemt_start_datetime | datetime | NOT NULL | Start date time | No | No |
| woemt_end_datetime | datetime | NULL | End datetime | No | No |
| WOEMT_TOTAL_HRS | numeric(28,8) | NULL | Total Hours(This is the difference between the From/To Date Time. This includes the Indirect/Break Hours) | No | No |
| woemt_act_duration | numeric(28,8) | NULL | actual duration(this is the value in the Actual Duration Hours column converted to the UOM reported, which is stored in the ActualDurationUOM column) | No | No |
| woemt_act_duration_uom | varchar(5) | NULL | actual duration Uom | No | No |
| woemt_act_duration_hrs | numeric(28,8) | NULL | actual duration in hours(This is the worked Hours excluding Break/Indirect Hours) | No | No |
| woemt_indir_wrk_hrs | numeric(28,8) | NULL | Indirect work hours | No | No |
| woemt_break_hrs | numeric(28,8) | NULL | Break hours(Breaked hours defined in the Work center component) | No | No |
| woemt_employee_comments | varchar(2000) | NULL | Employee Comments | No | No |
| woemt_modifiedby | varchar(30) | NULL | Modified By | No | No |
| woemt_modifieddate | datetime | NULL | Modified  Date | No | No |
| WOEMT_TIMESTAMP | numeric(10) | NULL | Time Stamp | No | No |
| woemt_upd_mode | varchar(5) | NULL | Updation Mode CLK - Clock MAN - Manual | No | No |
| WOEMT_TILL_DATETIME | datetime | NULL | Till  Date Time | No | No |
| WOEMT_CLOCK_FLAG | varchar(5) | NULL | Clock Flag | No | No |
| woemt_exec_comments | varchar(2000) | NULL | To store the execution comments provided during each time sheet reporting by the employee for the Work Order/Task | No | No |
| woemt_work_skill_cost | numeric(28,8) | NULL | The Cost for the Actual Worked Hours(calculated using the Job rate for the Employee) | No | No |
| WOEMT_TIMESHTSTATUS | varchar(5) | NULL | The status of the timesheet Fresh, Confirmed, Authorized, Not Required | No | No |
| WOEMT_ATTENDTYPE | varchar(25) | NULL | Attenance type Normal Over time | No | No |
| EMPTMP_BILLABLE | varchar(5) | NULL | Billable Yes No | No | No |
| Table Name hwr_woenh_emp_non_work_hrs | |||||
| Table Comment Employee non working hours details | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| woenh_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| woenh_emp_code | varchar(20) | NOT NULL | Emp Code | Yes | No |
| woenh_seq_no | numeric(10) | NOT NULL | Sequence No | Yes | No |
| woenh_from_datetime | datetime | NULL | From date time | No | No |
| woenh_to_datetime | datetime | NULL | To date time | No | No |
| woenh_break_duration | numeric(28,8) | NULL | Break Duration | No | No |
| woenh_emp_comments | varchar(2000) | NULL | Employee Comments | No | No |
| woenh_upd_mode | varchar(5) | NULL | Updation Mode CLK - Clock MAN - Manual | No | No |
| woenh_category | varchar(25) | NULL | Category | No | No |
| woenh_modified_by | varchar(30) | NULL | Modified By | No | No |
| woenh_modified_date | datetime | NULL | Modified  Date | No | No |
| woenh_timestamp | numeric(10) | NULL | Time Stamp | No | No |
| woenh_created_by | varchar(30) | NULL | Created By | No | No |
| woenh_created_date | datetime | NULL | Created Date | No | No |
| WOENH_TIMESHTSTATUS | varchar(5) | NULL | Time sheet Status Fresh, Confirmed, Authorized, Not Required | No | No |
| WOENH_ATTENDTYPE | varchar(25) | NULL | Attendence Type, Normal, Overtime | No | No |
| Table Name hwr_wofit_part_fitment_det | |||||
| Table Comment Fitment details of the part | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| wofit_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| wofit_visit_pkg_no | varchar(40) | NOT NULL | Visit Package No | Yes | No |
| wofit_wo_no | varchar(40) | NOT NULL | Work Order No | Yes | No |
| wofit_seq_no | numeric(10) | NOT NULL | Seq No | Yes | No |
| wofit_position_no | varchar(25) | NOT NULL | Position No | Yes | No |
| wofit_component_id | varchar(90) | NULL | Component Id | No | No |
| wofit_task_no | varchar(30) | NULL | Task No | No | No |
| wofit_part_no | varchar(40) | NULL | Part No | No | No |
| WOFIT_LOT_NO | varchar(18) | NULL | Lot  No | No | No |
| wofit_serial_no | varchar(40) | NULL | Serial No | No | No |
| wofit_date_of_attachment | datetime | NULL | Date Of Attachment | No | No |
| wofit_fitment_comments | varchar(255) | NULL | Fitment Comments | No | No |
| wofit_createddate | datetime | NULL | Created Date | No | No |
| WOFIT_CREATED_BY | varchar(30) | NULL | Created By | No | No |
| WOFIT_MODIFIEDDATE | datetime | NULL | Modified Date | No | No |
| WOFIT_MODIFIED_BY | varchar(30) | NULL | Modified By | No | No |
| WOFIT_TIMESTAMP | numeric(10) | NULL | Time Stamp | No | No |
| WOFIT_SPRT_UPD_FLAG | varchar(25) | NULL | Updation Flag Y -  Yes N -  No | No | No |
| Table Name hwr_wofusg_facility_usage | |||||
| Table Comment Facility Usuage Details of Work Order | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| wofusg_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| wofusg_visit_pkg_no | varchar(40) | NOT NULL | Visit Package No | Yes | No |
| wofusg_wo_no | varchar(40) | NOT NULL | Work Order No | Yes | No |
| wofusg_seq_no | numeric(10) | NOT NULL | Sequence No | Yes | No |
| wofusg_keyseqno | numeric(10) | NOT NULL | Key Sequence No | Yes | No |
| wofusg_facility_obj_code | varchar(40) | NULL | Object Code | No | No |
| wofusg_time_uom | varchar(5) | NULL | Time Unit Of Measurement H - Hours M - Minutes D - Days | No | No |
| wofusg_used_duration | numeric(28,8) | NULL | Used Duration | No | No |
| wofusg_from_datetime | datetime | NULL | From datetime | No | No |
| wofusg_to_datetime | datetime | NULL | To datetime | No | No |
| wofusg_usage_comments | varchar(255) | NULL | Usuage Comments | No | No |
| wofusg_timestamp | numeric(10) | NULL | Time Stamp | No | No |
| wofusg_fac_code | varchar(40) | NOT NULL | Facility  code | No | No |
| wofusg_fac_type | varchar(5) | NULL | Facility  Type E - Equipment O - Others T -  Tool | No | No |
| wofusg_modifieddate | datetime | NULL | Modified Date | No | No |
| wofusg_from_datetime_gmt | datetime | NULL | from datetime Gmt | No | No |
| wofusg_to_datetime_gmt | datetime | NULL | To datetime Gmt | No | No |
| wofusg_used_duration_hrs | numeric(28,8) | NULL | Used duration hours | No | No |
| wofusg_fac_ou | numeric(10) | NULL | Facility  Ou | No | No |
| WOFUSG_ADDLN_FLAG | varchar(25) | NULL | Additional flag Y - Yes N - No | No | No |
| Table Name hwr_woissld_wo_iss_sl_det | |||||
| Table Comment Table to store the Issue Serial/Lot Details for the Visit Package/Work Order/Task. | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| woissld_ouinstance | numeric(10) | NOT NULL | OU Instance | Yes | No |
| woissld_visit_pkg_no | varchar(40) | NOT NULL | Visit package # for which this Part/Serial /Lot is issued. | Yes | No |
| woissld_wo_no | varchar(40) | NOT NULL | Visit package # for which this Part/Serial /Lot is issued.(If Issued at VP level then this will be ##) | Yes | No |
| woissld_seq_no | numeric(10) | NOT NULL | Visit package # for which this Part/Serial /Lot is issued..(If Issued at VP level or Work Order Level then this will be 0) | Yes | No |
| woissld_mr_no | varchar(40) | NOT NULL | Material Request # against which this Part/Serial /Lot is issued. | Yes | No |
| woissld_issuedoc_no | varchar(40) | NOT NULL | Issue # for which this Part/serial/lot is issued. | Yes | No |
| woissld_seqno | numeric(10) | NOT NULL | Line # for the Parts Issued. | Yes | No |
| woissld_part_no | varchar(40) | NOT NULL | Part # which is Issued | Yes | No |
| woissld_part_serialno | varchar(40) | NOT NULL | Serial # which is issued. (For None / Lot controlled this wil be ## | No | No |
| woissld_lot_no | varchar(25) | NULL | Lot # which is issued. For None/Serial Controlled this will be ## | No | No |
| woissld_return_partno | varchar(40) | NULL | Return part # | No | No |
| woissld_quantity | numeric(28,8) | NULL | Quantity Issued | No | No |
| Table Name hwr_wojcom_job_completion | |||||
| Table Comment Job Completion Details | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| wojcom_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| wojcom_visit_pkg_no | varchar(40) | NOT NULL | Visit Package No | Yes | No |
| wojcom_wo_no | varchar(40) | NOT NULL | Work Order No | Yes | No |
| wojcom_seq_no | numeric(10) | NOT NULL | Sequence No | Yes | No |
| wojcom_per_completed | NULL | Percent Completed | No | No | |
| wojcom_job_status | varchar(5) | NULL | Job Status | No | No |
| wojcom_start_datetime | datetime | NULL | Start_datetime | No | No |
| wojcom_end_datetime | datetime | NULL | End_datetime | No | No |
| wojcom_actual_elasped_time | numeric(28,8) | NULL | Actual Elapsed Time | No | No |
| wojcom_elasped_time_uom | varchar(5) | NULL | Actual Elasped time | No | No |
| wojcom_execution_comments | varchar(255) | NULL | Execution Comments | No | No |
| wojcom_entereddate | datetime | NULL | Entered Date | No | No |
| wojcom_entered_by | varchar(30) | NULL | Entered By | No | No |
| wojcom_act_man_hrs | numeric(28,8) | NULL | Actual Man Hours | No | No |
| Table Name hwr_womra_req_alloc_hist | |||||
| Table Comment Allocation History | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| WRMRA_Hist_OUInstance | numeric(10) | NULL | Ouinstance | No | No |
| WRMRA_Hist_DocTyp | varchar(25) | NULL | Document Type | No | No |
| WRMRA_Hist_DocNo | varchar(40) | NULL | Document No | No | No |
| WRMRA_Hist_TaskNo | varchar(40) | NULL | Task No | No | No |
| WRMRA_Hist_UOM | varchar(10) | NULL | Unit Of Mesurement | No | No |
| WRMRA_Hist_AdQty | numeric(28,8) | NULL | Additional Qunatity | No | No |
| WRMRA_Hist_RvQty | numeric(28,8) | NULL | Revisied Quantity | No | No |
| WRMRA_Hist_User | varchar(40) | NULL | User | No | No |
| WRMRA_Hist_Date | datetime | NULL | Date | No | No |
| Table Name hwr_wonstdp_nonstd_part_con | |||||
| Table Comment Non Standard Part Consumption | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| wonstdp_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| wonstdp_visit_pkg_no | varchar(40) | NOT NULL | Visit Package No | Yes | No |
| wonstdp_wo_no | varchar(40) | NOT NULL | Work Order No | Yes | No |
| wonstdp_non_std_part | varchar(40) | NOT NULL | Non Standard Part | Yes | No |
| wonstdp_part_desc | varchar(150) | NULL | Part Description | No | No |
| wonstdp_part_type | varchar(5) | NULL | Part Type OTHS - Others ALL - All | No | No |
| wonstdp_uom | varchar(10) | NULL | Unit of Measurement H - Hours M - Minutes D - Days | No | No |
| wonstdp_issue_qty | numeric(28,8) | NULL | Issue Quantity | No | No |
| wonstdp_cost | numeric(28,8) | NULL | Cost | No | No |
| wonstdp_comments | varchar(255) | NULL | Comments | No | No |
| wonstdp_ref_doc_no | varchar(40) | NULL | Reference Doc No | No | No |
| wonstdp_createddate | datetime | NULL | Created Date | No | No |
| wonstdp_created_by | varchar(30) | NULL | Created by | No | No |
| wonstdp_modifieddate | datetime | NULL | Modified Date | No | No |
| wonstdp_modified_by | varchar(30) | NULL | Modified By | No | No |
| wonstdp_timestamp | numeric(10) | NULL | Time Stamp | No | No |
| WONSTDP_STOCK_STATUS | varchar(40) | NULL | Stock Status | No | No |
| Table Name hwr_wopcon_part_consumption | |||||
| Table Comment Part consumption details | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| wopcon_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| wopcon_visit_pkg_no | varchar(40) | NOT NULL | Visit Package No | Yes | No |
| wopcon_wo_no | varchar(40) | NOT NULL | Work Order No | Yes | No |
| wopcon_seq_no | numeric(10) | NOT NULL | Sequence No | Yes | No |
| wopcon_issue_part_no | varchar(40) | NOT NULL | Part No | Yes | No |
| wopcon_issued_wh_code | varchar(10) | NOT NULL | Issued WareHouse Code | Yes | No |
| wopcon_issue_stock_status | varchar(40) | NOT NULL | Stock Status | Yes | No |
| wopcon_line_no | numeric(10) | NULL | Line No | No | No |
| wopcon_issued_qty | numeric(28,8) | NULL | Issued Quantity | No | No |
| wopcon_used_qty | numeric(28,8) | NULL | Used Quantity | No | No |
| wopcon_used_qty_in_stock_uom | numeric(28,8) | NULL | Quantity in Stock | No | No |
| wopcon_pending_return_qty | numeric(28,8) | NULL | Return Quantity | No | No |
| wopcon_returned_qty | numeric(28,8) | NULL | Returned Quantity | No | No |
| wopcon_timestamp | numeric(10) | NULL | Time Stamp | No | No |
| wopcon_addln_flag | varchar(25) | NULL | Additional flag Y -  YES N -  NO | No | No |
| wopcon_uom | varchar(5) | NULL | Unit of Measurement H - Hours M - Minutes D - Days | No | No |
| wopcon_comments | varchar(255) | NULL | Comments | No | No |
| wopcon_ref_doc_no | varchar(40) | NULL | Reference Doc No | No | No |
| wopcon_cost | numeric(28,8) | NULL | Cost | No | No |
| WOPCON_QTY_IN_ISSUE_UOM | numeric(28,8) | NULL | Qty in issue uom | No | No |
| wopcon_createddate | datetime | NULL | created date | No | No |
| wopcon_created_by | varchar(30) | NULL | created by | No | No |
| wopcon_modifieddate | datetime | NULL | modified date | No | No |
| wopcon_modified_by | varchar(30) | NULL | modified by | No | No |
| wopcon_returned_qty_core | numeric(28,8) | NULL | Returned Quantity Core | No | No |
| wopcon_issue_part_Ou | numeric(10) | NULL | Issue Part Ou | No | No |
| wopcon_returned_qty_excess | numeric(28,8) | NULL | Returned Quantity Excess | No | No |
| wopcon_pend_ret_qty_core | numeric(28,8) | NULL | Returned quantity Core | No | No |
| wopcon_pend_ret_qty_excess | numeric(28,8) | NULL | Returned Quantity Excess | No | No |
| wopcon_Issue_basis | varchar(5) | NULL | Issue Basis | No | No |
| WOPCON_RECON_QTY_CORE | numeric(28,8) | NULL | recon Quantity Core | No | No |
| WOPCON_RECON_QTY_EXCESS | numeric(28,8) | NULL | Recon quantity Excess | No | No |
| Table Name hwr_worcon_ret_part_reconcl | |||||
| Table Comment Reconciliation details | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| worcon_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| worcon_visit_pkg_no | varchar(40) | NOT NULL | Visit Package No | Yes | No |
| worcon_wo_no | varchar(40) | NOT NULL | Work Order No | Yes | No |
| worcon_seq_no | numeric(10) | NOT NULL | Sequence No | Yes | No |
| worcon_issued_part_no | varchar(40) | NOT NULL | Issued Part No | Yes | No |
| WORCON_ISSUE_STOCK_STATUS | varchar(40) | NOT NULL | Issue Stock Status | Yes | No |
| worcon_issued_qty | numeric(28,8) | NOT NULL | Issued Quantity | No | No |
| worcon_issue_wh_code | varchar(10) | NOT NULL | Issue Ware House Code | No | No |
| worcon_used_qty | numeric(28,8) | NULL | Used Quantity | No | No |
| worcon_core_pending_ret_qty | numeric(28,8) | NULL | Core Pending Ret Quantity | No | No |
| worcon_excess_pending_ret_qty | numeric(28,8) | NULL | Excess Pending Ret Quantity | No | No |
| worcon_reconcil_comments | varchar(255) | NULL | Reconcil Comments | No | No |
| worcon_reconcil_date | datetime | NULL | Reconcil Date | No | No |
| WORCON_LINE_NO | numeric(10) | NULL | Line No | No | No |
| Table Name hwr_worusg_resource_usage | |||||
| Table Comment Resource usage details | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| worusg_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| worusg_visit_pkg_no | varchar(40) | NOT NULL | Visit Package No | Yes | No |
| worusg_wo_no | varchar(40) | NOT NULL | Work Order No | Yes | No |
| worusg_seq_no | numeric(10) | NOT NULL | Sequence No | Yes | No |
| WORUSG_KEYSEQNO | numeric(10) | NOT NULL | Key Sequence No | Yes | No |
| worusg_resource_no | varchar(40) | NOT NULL | Resource No | Yes | No |
| worusg_resource_type | varchar(5) | NOT NULL | Resource Type | No | No |
| worusg_resource_hrs | numeric(28,8) | NULL | Resource Hours | No | No |
| worusg_uom | varchar(5) | NULL | Unit Of Measurement | No | No |
| worusg_from_datetime | datetime | NULL | From dateTime | No | No |
| worusg_from_datetime_gmt | datetime | NULL | From datetime Gmt | No | No |
| worusg_to_datetime | datetime | NULL | To datetime | No | No |
| worusg_to_datetime_gmt | datetime | NULL | to datetime gmt | No | No |
| worusg_usage_comments | varchar(255) | NULL | usuage comments | No | No |
| worusg_timestamp | numeric(10) | NULL | Time Stamp | No | No |
| worusg_modifieddate | datetime | NULL | Modified date | No | No |
| worusg_res_object_code | varchar(40) | NULL | Object Code | No | No |
| worusg_resource_ou | numeric(10) | NULL | Resource Ou | No | No |
| worusg_addln_flag | varchar(5) | NULL | Additonal  Flag | No | No |
| worusg_resource_duration | numeric(28,8) | NULL | Resource Duration | No | No |
| Table Name hwr_wostgn_subtask_sign_off | |||||
| Table Comment Task Sign Off details are 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 |
| wostgn_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| wostgn_visit_pkg_no | varchar(40) | NOT NULL | Visit Package No | Yes | No |
| wostgn_wo_no | varchar(40) | NOT NULL | Work Order No | Yes | No |
| wostgn_seq_no | numeric(10) | NOT NULL | Sequence No | Yes | No |
| wostgn_skill_code | varchar(40) | NOT NULL | Skill Code | Yes | No |
| wostgn_resource_group | varchar(25) | NOT NULL | Resource Group | Yes | No |
| wostgn_subtask_seq_no | numeric(10) | NOT NULL | SubTsk Seq No | Yes | No |
| wostgn_subtask_no | varchar(2000) | NULL | Subtask No | No | No |
| wostgn_task_no | varchar(30) | NULL | Task No | No | No |
| wostgn_sign_off_date | datetime | NULL | Sign Off Date | No | No |
| wostgn_sign_off_comments | varchar(255) | NULL | Sign Off Comments | No | No |
| wostgn_document_no | varchar(40) | NULL | Document No | No | No |
| wostgn_sign_off_flag | varchar(5) | NULL | Sign Off Flag Y - YES N -  NO NR - Not Required V - Void | No | No |
| wostgn_emp_code | varchar(20) | NULL | Emp Code | No | No |
| Table Name hwr_wotsgn_task_sign_off | |||||
| Table Comment Task Sign Off details are maintained here | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| wotsgn_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| wotsgn_visit_pkg_no | varchar(40) | NOT NULL | Visit Package No | Yes | No |
| wotsgn_wo_no | varchar(40) | NOT NULL | Work Order No | Yes | No |
| wotsgn_seq_no | numeric(10) | NOT NULL | Sequence No | Yes | No |
| wotsgn_sign_off_date | datetime | NULL | Sign Off Date | No | No |
| wotsgn_sign_off_comments | varchar(2000) | NULL | Sign Off Comments | No | No |
| wotsgn_document_no | varchar(40) | NULL | Document No | No | No |
| wotsgn_sign_off_flag | varchar(5) | NULL | Sign Off Flag Y  YES N  NO | No | No |
| WOTSGN_TIMESTAMP | numeric(10) | NULL | Time Stamp | No | No |
| Table Name hwr_wratpm_att_tech_param_det | |||||
| Table Comment Attribute and Technical parameter updates | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| wratpm_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| wratpm_visit_pkg_no | varchar(40) | NOT NULL | Visit Package Number | Yes | No |
| wratpm_wo_no | varchar(40) | NOT NULL | Work Order No | Yes | No |
| wratpm_seq_no | numeric(10) | NOT NULL | Sequence No | Yes | No |
| wratpm_param_code | varchar(40) | NOT NULL | Param Code | Yes | No |
| wratpm_component_id | varchar(90) | NOT NULL | Component Id | Yes | No |
| wratpm_ac_reg_no | varchar(30) | NOT NULL | ac Registration No | Yes | No |
| wratpm_param_type | varchar(5) | NOT NULL | Param Type | No | No |
| wratpm_param_value | varchar(32) | NULL | Param Value | No | No |
| wratpm_upd_datetime | datetime | NULL | Updated Datetime | No | No |
| wratpm_modifieddate | datetime | NULL | Modified date | No | No |
| wratpm_modified_by | varchar(30) | NULL | Modified By | No | No |
| wratpm_upd_datetime_gmt | datetime | NULL | Updated Datetime gmt | No | No |
| Table Name hwr_wrcom_certificate_maint | |||||
| Table Comment Certificate of Maintenance - For aircraft and its components | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| wrcom_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| wrcom_com_no | varchar(40) | NOT NULL | Certificate of Maintainence Number | Yes | No |
| wrcom_num_type_no | varchar(5) | NULL | Number Type No | No | No |
| wrcom_com_status | varchar(5) | NULL | Certificate Of Maintainence Status F - Fresh N - Not Issued B - Blank C - Confirmed CA - Cancelled | No | No |
| wrcom_visit_pkg_no | varchar(40) | NULL | Visit Package No | No | No |
| wrcom_aircraft_reg_no | varchar(30) | NULL | Aircraft Registration No | No | No |
| wrcom_emp_code | varchar(20) | NULL | Employee Code | No | No |
| wrcom_remarks | varchar(255) | NULL | Remarks | No | No |
| WRCOM_COM_ISSUE_DATETIME | datetime | NULL | Com Issue date and time | No | No |
| wrcom_document_name | varchar(150) | NULL | Document Name | No | No |
| wrcom_createdby | varchar(30) | NULL | Created By | No | No |
| wrcom_createddate | datetime | NULL | Created Date | No | No |
| wrcom_modifiedby | varchar(30) | NULL | Modified by | No | No |
| wrcom_modifieddate | datetime | NULL | Modified Date | No | No |
| WRCOM_CONFIRMEDBY | varchar(30) | NULL | Confirmed By | No | No |
| WRCOM_CONFIRMEDDATE | datetime | NULL | Confirmed Date | No | No |
| wrcom_comments | varchar(255) | NULL | Comments | No | No |
| wrcom_timestamp | numeric(10) | NULL | Timestamp | No | No |
| WRCOM_CERTTYPE | varchar(25) | NULL | active certificate types defined for the part | No | No |
| WRCOM_CERTAGENT | varchar(25) | NULL | Active Regulatory authority  codes | No | No |
| WRCOM_CERTREFNO | varchar(25) | NULL | The certificate reference document number. | No | No |
| WRCOM_CERTREMARKS | varchar(2000) | NULL | Any remarks pertaining to the issue of certificate of maintenance | No | No |
| Table Name hwr_wrcome_com_employee | |||||
| Table Comment Certificate of Maintenance - Inspector details | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| wrcome_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | Yes |
| wrcome_com_no | varchar(40) | NOT NULL | Certificate of Mainatainence Number | Yes | Yes |
| wrcome_emp_code | varchar(20) | NOT NULL | Employee Code | Yes | No |
| wrcome_skill_code | varchar(40) | NOT NULL | Skill code | Yes | No |
| wrcome_license_no | varchar(15) | NULL | License Number | No | No |
| wrcome_remarks | varchar(255) | NULL | Remarks | No | No |
| Table Name hwr_wropt_wor_option_setting | |||||
| Table Comment Various options set for the Work Order reporting component will be 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 |
| wropt_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| wropt_dp_num_type_no | varchar(20) | NULL | Numbering type for Dp | No | No |
| wropt_cr_num_type_no | varchar(20) | NULL | Numbering Type for Cr | No | No |
| wropt_crsame_gen_flag | varchar(20) | NULL | flag for Cr R - Required NR - Not Required | No | No |
| wropt_task_reporting_flag | varchar(20) | NULL | Task Reporting Flag AL - All Employees AS - Assigned Employees | No | No |
| wropt_auto_dp_close_flag | varchar(20) | NULL | Dp Close Flag A - Allowed NA - Not Allowed | No | No |
| wropt_backdated_rep_time_limit | numeric(10) | NULL | Back Dated Report Time Limit | No | No |
| wropt_parent_wo_closure | varchar(20) | NULL | Work Order Closure | No | No |
| wropt_rep_nstd_addln_parts | varchar(20) | NULL | Non standard Additional Parts | No | No |
| wropt_addln_comp_rep_flag | varchar(20) | NULL | Component Reporting Flag | No | No |
| wropt_addln_raw_rep_flag | varchar(20) | NULL | Raw  Reporting flag | No | No |
| wropt_addln_spare_rep_flag | varchar(20) | NULL | Spare Reporting Flag | No | No |
| wropt_addln_kits_rep_flag | varchar(20) | NULL | Kits Reporting Flag | No | No |
| wropt_addln_tools_rep_flag | varchar(20) | NULL | Tools Reporing Flag | No | No |
| wropt_addln_cons_rep_flag | varchar(20) | NULL | Cons Reporing Flag | No | No |
| wropt_createdby | varchar(30) | NULL | Created by | No | No |
| wropt_createddate | datetime | NULL | Created Date | No | No |
| wropt_modifiedby | varchar(30) | NULL | Modified By | No | No |
| wropt_modifieddate | datetime | NULL | Modified Date | No | No |
| wropt_timestamp | numeric(10) | NULL | Time  Stamp | No | No |
| wropt_ac_panel_close_flag | varchar(20) | NULL | Panel Close Flag R - Required NR - Not Required | No | No |
| wropt_emp_attendence_flag | varchar(20) | NULL | Attendance Flag R - Required NR - Not Required | No | No |
| wropt_extra_hrs_rep_flag | varchar(20) | NULL | Hours Reporting Flag R - Required NR - Not Required | No | No |
| wropt_compute_xtra_hrs_flag | varchar(20) | NULL | Exta Hours Flag A - Allowed NA - Not Allowed | No | No |
| wropt_addln_qty_back_flush | varchar(20) | NULL | quantity back Flush A - Allowed NA - Not Allowed | No | No |
| wropt_addln_prt_back_flush | varchar(20) | NULL | Part Back Flush A - Allowed NA - Not Allowed | No | No |
| wropt_corrtn_bfl_reg_flag | varchar(20) | NULL | Registration Flag Y - YES N - NO | No | No |
| wropt_wh_mod_back_flush | varchar(20) | NULL | Back Flush | No | No |
| wropt_mr_num_type_no | varchar(25) | NULL | Mr Number Type No | No | No |
| wropt_issue_num_type_no | varchar(25) | NULL | Issue Number Type no | No | No |
| wropt_dp_trn_num_type_no | varchar(25) | NULL | Transaction Number Type No | No | No |
| wropt_emp_ts_mode | varchar(25) | NULL | Employee Ts Mode | No | No |
| WROPT_AUTHTIMESHT_FLAG | varchar(5) | NULL | Authorization required , Not required | No | No |
| WROPT_CNFRMTIMESHT_FLAG | varchar(5) | NULL | Confirmation required not required | No | No |
| Table Name hwr_wroptpr_part_recon_opt | |||||
| Table Comment Option Setting for Multiline | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| wroptpr_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| wroptpr_part_type | varchar(25) | NOT NULL | Part Type OTHS - Others ALL - All | Yes | No |
| wroptpr_excess_returnable_flag | varchar(20) | NULL | Excess Returnable Flag | No | No |
| wroptpr_core_returnable_flag | varchar(20) | NULL | Core Returnable Flag | No | No |
| wroptpr_modifieddate | datetime | NULL | Modidfied Date | No | No |
| wroptpr_modified_by | varchar(30) | NULL | Modified By | No | No |
| wroptpr_timestamp | numeric(10) | NULL | Time stamp | No | No |
| Table Name hwr_wrpins_preliminary_insp | |||||
| Table Comment Preliminary Inspection Details are 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 |
| wrpins_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| wrpins_visit_pkg_no | varchar(40) | NOT NULL | Visit Package No | Yes | No |
| WRPINS_VISIT_PKG_OU | numeric(10) | NULL | Visit Package Ou | No | No |
| wrpins_aircraft_reg_no | varchar(30) | NULL | Aircraft Registration No | No | No |
| wrpins_gate_in_date | datetime | NULL | Gate in date | No | No |
| wrpins_gate_in_time | varchar(11) | NULL | Gate in Time | No | No |
| wrpins_hanger_in_date | datetime | NULL | Hanger In Date | No | No |
| wrpins_hanger_in_time | varchar(11) | NULL | Hanger In Time | No | No |
| wrpins_towing_hours | numeric(28,8) | NULL | Towing Hours | No | No |
| wrpins_reported_by | varchar(30) | NULL | Reported By | No | No |
| wrpins_reported_date | datetime | NULL | Reported Date | No | No |
| wrpins_att_doc_name | varchar(150) | NULL | Attached Document Name | No | No |
| wrpins_other_observations | varchar(255) | NULL | Other Observations | No | No |
| wrpins_createdby | varchar(30) | NULL | Created By | No | No |
| wrpins_createddate | datetime | NULL | Created Date | No | No |
| wrpins_modifiedby | varchar(30) | NULL | Modified By | No | No |
| wrpins_modifieddate | datetime | NULL | Modified Date | No | No |
| wrpins_timestamp | numeric(10) | NULL | Time stamp | No | No |
| Table Name hwr_wrqc_quick_code | |||||
| Table Comment User defined Quick codes are 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 |
| wrqc_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| wrqc_quick_code | varchar(25) | NOT NULL | Quick Code | Yes | No |
| wrqc_type | varchar(25) | NULL | Type | No | No |
| wrqc_desc | varchar(150) | NULL | Description | No | No |
| wrqc_status | varchar(5) | NULL | Status | No | No |
| wrqc_createddate | datetime | NULL | Created Date | No | No |
| wrqc_created_by | varchar(30) | NULL | Created By | No | No |
| wrqc_modifieddate | datetime | NULL | Modified Date | No | No |
| wrqc_modified_by | varchar(30) | NULL | Modified By | No | No |
| wrqc_timestamp | numeric(10) | NULL | Time Stamp | No | No |
| Table Name hwr_wrrcpm_rc_param_upd_det | |||||
| Table Comment Range & Consumption Parameter Update Details | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| wrrcpm_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| wrrcpm_visit_pkg_no | varchar(40) | NOT NULL | Visit Package No | Yes | No |
| wrrcpm_wo_no | varchar(40) | NOT NULL | Work Order No | Yes | No |
| wrrcpm_seq_no | numeric(10) | NOT NULL | Sequence No | Yes | No |
| wrrcpm_param_code | varchar(40) | NOT NULL | Param Code | Yes | No |
| wrrcpm_component_id | varchar(90) | NOT NULL | Component Id | Yes | No |
| wrrcpm_ac_reg_no | varchar(30) | NOT NULL | Aircraft Registration No | Yes | No |
| wrrcpm_param_type | varchar(5) | NULL | Param Type A - Attribute B - Blank C - Consumption R - Range T - Technical | No | No |
| wrrcpm_param_value | numeric(28) | NULL | Param Value | No | No |
| wrrcpm_mode_flag | varchar(5) | NULL | Mode Flag N - New D - Delta | No | No |
| wrrcpm_upd_datetime | datetime | NULL | Updated  DateTime | No | No |
| wrrcpm_modifieddate | datetime | NULL | Modified Date | No | No |
| wrrcpm_modified_by | varchar(30) | NULL | Modified By | No | No |
| wrrcpm_upd_datetime_gmt | datetime | NULL | Updated datetime gmt | No | No |