Hangar Work Order Reporting

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	Customer 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	Revision 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 flag	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	Manufacture Lot No.	No	No
WOCRD_CRNT_LOTNO	varchar(40)	NULL	System Generated 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 Measurement 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 - pBlank REST - Restoration REM - Replacement REP - Remove only ATT - Attachment only	No	No
wocrh_comp_condition	varchar(25)	NULL	Component Condition	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(Break 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	ModifiedDate	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	Attendance 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	Attendance 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	Usage 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 - ool	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	FacilityOu	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 will 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 Elapsed 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 Measurement	No	No
WRMRA_Hist_AdQty	numeric(28,8)	NULL	Additional Quantity	No	No
WRMRA_Hist_RvQty	numeric(28,8)	NULL	Revised 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	Reconcile Comments	No	No
worcon_reconcil_date	datetime	NULL	Reconcile 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 Maintenance Number	Yes	No
wrcom_num_type_no	varchar(5)	NULL	Number Type No	No	No
wrcom_com_status	varchar(5)	NULL	Certificate Of Maintenance 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 Maintenance 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 Reporting Flag	No	No
wropt_addln_cons_rep_flag	varchar(20)	NULL	Cons Reporting 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	Extra 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	Modified 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

Data Dictionary - Hangar Work Reporting