| WorkOrder | ||||||||
| Table Name hwo_hwomrd_wo_mat_req_det | ||||||||
| Table Comment This entity contains the Part list for the MR document. | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| hwomrd_ouinstance | float | NOT NULL | MR OUInstance ID | Yes | Yes | |||
| hwomrd_mr_no | varchar(18) | NOT NULL | Material Request Document No | Yes | Yes | |||
| hwomrd_line_no | float | NOT NULL | Line Number | Yes | No | |||
| hwomrd_part_ou | float | NULL | Requested Part Created OUInstance | No | No | |||
| hwomrd_part_no | varchar(40) | NULL | Requested Part No | No | No | |||
| hwomrd_req_qty | float | NULL | Requested Part Qty in requested Uom | No | No | |||
| hwomrd_uom | varchar(10) | NULL | Requested Uom | No | No | |||
| hwomrd_qty_in_stkuom | varchar(10) | NULL | Requested Part Qty in Stock Uom | No | No | |||
| hwomrd_substitute_part_ou | float | NULL | Alternate Part Created OUInstance | No | No | |||
| hwomrd_substitute_part_no | varchar(40) | NULL | Alternate Part No | No | No | |||
| hwomrd_part_status | varchar(40) | NULL | Part/Stock Status | No | No | |||
| hwomrd_condition | varchar(5) | NULL | Preferred Condition as requested by the user department | No | No | |||
| hwomrd_exp_return_date | datetime | NULL | Expected Return Date | No | No | |||
| hwomrd_remarks | varchar(255) | NULL | Remarks (if any) | No | No | |||
| hwomrd_created_by | varchar(30) | NULL | created by | No | No | |||
| hwomrd_createddate | datetime | NULL | created date | No | No | |||
| hwomrd_modified_by | varchar(30) | NULL | last modified by | No | No | |||
| hwomrd_modifieddate | datetime | NULL | last modified date | No | No | |||
| hwomrd_substitute_part_type | char(18) | NULL | substitute part type | No | No | |||
| Table Name hwo_hwomrh_wo_mat_req_hdr | ||||||||
| Table Comment Material Request is a document through which an user department communicates the need for material (required for execution of any activity) for a specific date to the respective stocking points i.e. warehouses. Document Status Details: 1)  Draft: Whenever all details are not entered the transaction can be created in draft status. 2)  Fresh: Whenever all details are entered the Material Request transaction can be created in fresh status. It can be also be attained while modifying the transaction, which is in ’draft’ status. 3) Authorized: MR attains this status in approve activity when the requirements are confirmed. An authorized MR transaction cannot be cancelled. Only ’Fresh’ transaction can be authorized. 4) Cancelled: Both draft as well as fresh transactions can be cancelled. Transactions of status ’draft’ can be cancelled in Create as well as Edit Material Request activity. Transactions of the type ’Fresh’ can be cancelled in Edit as well as Approve Material Request activity. 5) Partially issued: When some parts are issued against the material request and still some are balanced to be issued, MR document takes the Partially Issued Status. A Partially Issued MR can be Short Closed . 6) Issued : When the parts are issued on the  returnable basis ,till the time they are being returned ,they are tracked under the Issued Status. 7) Short closed: After some parts are issued, when the need of balance parts is no more felt, then MR can be short closed during short closing activity. A short closed MR can not be transacted further. 8) Closed: If parts are requested on non returnable basis, then MR attains this status automatically, when the all the parts quantities requested (authorized) are issued. If parts are requested on returnable basis, then MR attains this status automatically, when the corresponding parts are returned for all the parts requested (authorized). | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| hwomrh_ouinstance | float | NOT NULL | MR OUInstance | Yes | No | |||
| hwomrh_mr_no | varchar(18) | NOT NULL | Material Request Document No | Yes | No | |||
| hwomrh_class | varchar(5) | NULL | MR Class List of codes and values for MRClass Maintenance - Mnt General . - Gnrl | No | No | |||
| hwomrh_type | varchar(5) | NULL | The types of Material Request. List of codes and values for MR Types Planned - Pln Unplanned - UPln | No | No | |||
| hwomrh_priority | varchar(5) | NULL | Indicates the priority of the  Material Request Document. List of codes and values for MR Priority Normal - Nrm Aog - Aog | No | No | |||
| hwomrh_category | varchar(25) | NULL | User defined fields to categorize MR documents. This will have the list of active quick codes defined for MR category in the Quick Code activity | No | No | |||
| hwomrh_need_date | datetime | NULL | The date on which the parts are needed. | No | No | |||
| hwomrh_wh_ou | float | NULL | Warehouse OUInstance ID | No | No | |||
| hwomrh_wh_code | varchar(10) | NULL | The warehouse/stocking point from where user would collect the required material | No | No | |||
| hwomrh_user_status | varchar(25) | NULL | User defined statuses (QuickCode) of the MR document This will have the list of active quick codes defined for ’User Status’ in the Quick Code activity | No | No | |||
| hwomrh_mr_status | varchar(5) | NULL | MR Document Status. List of codes and values for MR Status Draft - Drft Fresh - Frsh Authorized - Auth Cancelled - Can Partially issued - PIss Issued - Iss Short closed - ShCls Closed - Cls | No | No | |||
| hwomrh_ac_ou | float | NULL | Aircraft OUInstance ID | No | No | |||
| hwomrh_ac_reg_no | varchar(30) | NULL | The aircraft for which the parts are required | No | No | |||
| hwomrh_component_id | varchar(90) | NULL | The component for which the material is required | No | No | |||
| hwomrh_work_center_ou | float | NULL | WorkCenter OUInstance ID | No | No | |||
| hwomrh_work_center | varchar(30) | NULL | The work centre where the parts are required | No | No | |||
| hwomrh_station_code | varchar(32) | NULL | Station (defined in Common Master) where the Parts are required | No | No | |||
| hwomrh_requesting_ou | float | NULL | This is the Requesting location’s OUInstance. This will be the Work Order, Line Work Order or the Flight Log OUInstance. This will be stored as 0 if the Ref Doc Type is ’Others’ | No | No | |||
| hwomrh_source_flag | varchar(5) | NULL | source flag | No | No | |||
| hwomrh_ref_doc_type | varchar(5) | NULL | This indicates the type of the reference document. List of codes and values for Ref Doc Type Component work order -  CWo Line work order -  LWo Tech Log -  TLog Others -  Oth | No | No | |||
| MRMN_REF_DOC_OU | float | NULL | reference document ouinstance | No | No | |||
| hwomrh_ref_doc_no | varchar(40) | NULL | Comp WorkOrder Or Line WorkOrder or TechLog Document Number | No | No | |||
| hwomrh_requestor_ou | float | NULL | OUInstance ID to which the Requestor belongs to. | No | No | |||
| hwomrh_requestor | varchar(15) | NULL | Employee Code of the Requestor | No | No | |||
| hwomrh_requestor_name | varchar(150) | NULL | Requestor name also can be specified directly without specifying the requestor code | No | No | |||
| hwomrh_hardalloc_reqd_flag | varchar(5) | NULL | Indicates whether the part need to be hard allocated | No | No | |||
| hwomrh_iss_in_single_lot | NULL | This indicates whether the parts can be issued in a staggered manner as and when available | No | No | ||||
| hwomrh_user_def_1 | varchar(25) | NULL | User defined - 1 | No | No | |||
| hwomrh_user_def_2 | NULL | User defined - 2 | No | No | ||||
| hwomrh_delivery_instruction | varchar(255) | NULL | Delivery Instructions for the MR | No | No | |||
| hwomrh_remarks | NULL | Remarks (if any) | No | No | ||||
| MRMN_PART_TYPE | varchar(5) | NULL | Part Type | No | No | |||
| hwomrh_auto_mr_flag | char(18) | NULL | If the MR is automatically generated by the system thru LineWo, CWo, etc AutoMR_Flag will be ’Yes’. This needs to be maintained because system should ensure that MR created thru the respective workorder component cannot be modified in ’Edit MR’. | No | No | |||
| hwomrh_createddate | datetime | NULL | created date | No | No | |||
| hwomrh_created_user | varchar(30) | NULL | created user | No | No | |||
| hwomrh_modifieddate | datetime | NULL | last modified date | No | No | |||
| hwomrh_modified_by | varchar(30) | NULL | last modified by | No | No | |||
| hwomrh_timestamp | float | NULL | timestamp | No | No | |||
| hwomrh_filename | varchar(50) | NULL | filename | No | No | |||
| hwomrh_approveddate | char(18) | NULL | approved date | No | No | |||
| hwomrh_approved_by | char(18) | NULL | approved by | No | No | |||
| hwomrh_cust_ou | char(18) | NULL | Customer OU | No | No | |||
| hwomrh_cust_code | char(18) | NULL | Customer Code | No | No | |||
| hwomrh_cust_order_ou | char(18) | NULL | Customer Order OU | No | No | |||
| hwomrh_cust_order_no | char(18) | NULL | Customer Order Number | No | No | |||
| hwomrh_ac_rel_date | char(18) | NULL | aircraft release date | No | No | |||
| hwomrh_requestfor | sql_variant | NULL | Request for | No | No | |||
| Table Name hwo_hwotlog_task_status_log | ||||||||
| Table Comment Status modification history of the workorder task is maintained here | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| hwotlog_ouinstance | numeric(10) | NOT NULL | ouinstance | Yes | No | |||
| hwotlog_visit_pkg_no | varchar(40) | NOT NULL | visit package number | Yes | No | |||
| hwotlog_wo_no | NOT NULL | workorder number | Yes | No | ||||
| hwotlog_seq_no | numeric(10) | NOT NULL | sequence number | Yes | No | |||
| hwotlog_modifieddate | datetime | NOT NULL | modified date | Yes | No | |||
| hwotlog_task_no | varchar(30) | NULL | task number | No | No | |||
| hwotlog_entity | varchar(5) | NULL | Indicates which status has been modified - C - Created T - Transient J - Job A - Authorization Status | No | No | |||
| hwotlog_job_status | varchar(5) | NULL | job status | No | No | |||
| hwotlog_auth_status | varchar(5) | NULL | authorization status | No | No | |||
| hwotlog_trans_status | varchar(5) | NULL | transient status | No | No | |||
| hwotlog_modified_by | varchar(30) | NULL | Last modified by | No | No | |||
| hwotlog_comments | varchar(255) | NULL | comments | No | No | |||
| Table Name hwo_mrfin_finance_info | ||||||||
| Table Comment This table holds the information required for financial postings | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| mrfin_ouinstance | numeric(10) | NOT NULL | ouinstance | Yes | Yes | |||
| mrfin_mr_no | varchar(40) | NOT NULL | Material request number | Yes | Yes | |||
| mrfin_visit_pkg_no | varchar(40) | NOT NULL | Visit Package Number | Yes | Yes | |||
| mrfin_wo_no | varchar(40) | NOT NULL | Work order number - Will be stored as ## if the request is at visit package level | Yes | Yes | |||
| mrfin_seq_no | numeric(10) | NOT NULL | Sequence Number | Yes | Yes | |||
| mrfin_part_no | varchar(40) | NOT NULL | Part Number | Yes | Yes | |||
| mrfin_fin_book_id | varchar(20) | NULL | Finace Book Id | No | No | |||
| mrfin_tran_type | varchar(25) | NULL | Transaction type MRNO | No | No | |||
| mrfin_bu_code | varchar(20) | NULL | Business Unit code | No | No | |||
| mrfin_company_code | varchar(10) | NULL | Company code | No | No | |||
| mrfin_erate_type | varchar(80) | NULL | Exschage Rate Type | No | No | |||
| mrfin_Parallel_base_Erate | numeric(28) | NULL | Parallel Base Exchange Rate | No | No | |||
| mrfin_Base_currency | varchar(5) | NULL | Base currency | No | No | |||
| mrfin_parallel_Base_currency | varchar(5) | NULL | Parllel base currency | No | No | |||
| mrfin_Con_cosr_Acc_Code | varchar(32) | NULL | Account code | No | No | |||
| mrfin_con_Cosr_CntAcc_Type | varchar(40) | NULL | No | No | ||||
| mrfin_con_cosr_aptacc_type | varchar(40) | NULL | No | No | ||||
| mrfin_con_cosr_anal_Code | varchar(5) | NULL | No | No | ||||
| mrfin_con_cosr_sub_anal_code | varchar(5) | NULL | No | No | ||||
| MRFIN_CON_COSR_ACC_CURR | varchar(5) | NULL | No | No | ||||
| mrfin_WIPSusp_acc_Code | varchar(32) | NULL | No | No | ||||
| mrfin_WIPSusp_CntAc_Type | varchar(40) | NULL | No | No | ||||
| mrfin_WIPSusp_aptacc_Type | varchar(40) | NULL | No | No | ||||
| mrfin_WIPSusp_anal_Code | varchar(5) | NULL | No | No | ||||
| mrfin_WIPSusp_Sub_anal_code | varchar(5) | NULL | No | No | ||||
| mrfin_WIPSusp_acc_curr | varchar(5) | NULL | No | No | ||||
| mrfin_StkSus_Acc_Code | varchar(32) | NULL | No | No | ||||
| MRFIN_COST_CENTER | varchar(40) | NULL | cost center | No | No | |||
| Table Name hwo_parameter_details | ||||||||
| Table Comment Stores Parameter detail information. | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| wo_componentname | varchar(80) | NOT NULL | Component Code | Yes | No | |||
| wo_paramcategory | varchar(40) | NOT NULL | This field will capture the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc. | Yes | No | |||
| wo_paramtype | varchar(40) | NOT NULL | Normally param type is the name of the control. This will allow us to store all the possible values for a combo in multiple rows. | Yes | No | |||
| wo_paramcode | varchar(5) | NOT NULL | Param code is the values to be filled in the combo box or guidance text. This is actually the meta data of this component | Yes | No | |||
| wo_langid | numeric(10) | NOT NULL | Language id. This is the language id of the record. | Yes | No | |||
| wo_paramdesc | varchar(254) | NULL | Description of the Param Code | No | No | |||
| wo_sort_by | numeric(10) | NULL | The order in which the values are populated. | No | No | |||
| wo_creationdate | datetime | NULL | Creation Date | No | No | |||
| Table Name HWO_WOCAPEX_PEND_AMT | ||||||||
| Table Comment Stores Details of Pending amount for capital work orders | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| WOCAPEX_WO_NO | varchar(40) | NULL | Work Order No. | No | No | |||
| WOCAPEX_WO_OU | numeric | NULL | Work Order Ou | No | No | |||
| WOCAPEX_LINE_NO | varchar(30) | NULL | Line No | No | No | |||
| WOCAPEX_PROPASAL_NO | varchar(40) | NULL | Capital Propasoal No | No | No | |||
| WOCAPEX_DOC_TYPE | varchar(10) | NULL | Document Type Vist Package, Hwo | No | No | |||
| WOCAPEX_PEND_AMT | bigint | NULL | Pending Amount | No | No | |||
| WOCAPEX_CAP_AMT | bigint | NULL | Total Capital amount | No | No | |||
| Table Name hwo_wocwod_descrepancy_list | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| wocwod_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | Yes | |||
| wocwod_wo_no | varchar(40) | NOT NULL | Corrective Work Order Number | Yes | Yes | |||
| WOCWOD_DOC_TYPE | varchar(5) | NOT NULL | Document Type MR, DP | Yes | No | |||
| wocwod_dp_no | char(18) | NOT NULL | discrepency no/dmr no | Yes | No | |||
| WOCWOD_DOC_NO | varchar(40) | NOT NULL | Ref Doc No. | Yes | No | |||
| WOCWOD_CRT_OUINSTANCE | numeric(10) | NOT NULL | OUinstance | Yes | No | |||
| wocwod_dp_status | varchar(5) | NULL | status of the dp pending, Deferred | No | No | |||
| wocwod_src_doc_no | varchar(40) | NULL | if reporting then workorderno/visitpackage no if techlog then techlogno if journey log then journey log no | No | No | |||
| wocwod_dp_ou | char(18) | NULL | dp ou | No | No | |||
| wocwod_modifieddate | datetime | NULL | Modification date | No | No | |||
| wocwod_modified_by | varchar(30) | NULL | Modified by | No | No | |||
| wocwod_timestamp | numeric(10) | NULL | Time stamp | No | No | |||
| wocwod_source_flag | varchar(5) | NULL | either REP/TL/JL/DP | No | No | |||
| wocwod_reported_ou | numeric(10) | NULL | Reported Ouinstance | No | No | |||
| wocwod_reported_by | varchar(30) | NULL | Reported by | No | No | |||
| wocwod_Findings | varchar(255) | NULL | Problem findings | No | No | |||
| wocwod_reported_date | datetime | NULL | Reporting date | No | No | |||
| wocwod_closed_by | varchar(30) | NULL | Closed by | No | No | |||
| wocwod_closed_date | datetime | NULL | Closing date | No | No | |||
| WOCWOD_SLFSRCOU | numeric(10) | NULL | Ouinstance | No | No | |||
| WOCWOD_ACTION_FLAG | varchar(5) | NULL | closed | No | No | |||
| Table Name hwo_wodfrq_deferral_req | ||||||||
| Table Comment Deferrals created in Central Planning | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| wodfrq_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No | |||
| wodfrq_def_req_no | varchar(40) | NOT NULL | deferment request number | Yes | No | |||
| wodfrq_vst_pkg_no | varchar(40) | NULL | Visit Package Number | No | No | |||
| wodfrq_num_type_no | varchar(5) | NULL | Numbering type number | No | No | |||
| wodfrq_aircraft_reg_no | varchar(30) | NULL | Aircraft Registration Number | No | No | |||
| WODFRQ_AIRCRAFT_OU | decimal(10) | NULL | Aircraft Ouinstance | No | No | |||
| wodfrq_job_type | varchar(5) | NULL | Job Type - Aircraft, Onwing or Component Removal | No | No | |||
| wodfrq_work_centre | varchar(30) | NULL | Work Centre | No | No | |||
| wodfrq_component_id | varchar(90) | NULL | Component Id | No | No | |||
| wodfrq_status | varchar(5) | NULL | Deferment Request Status | No | No | |||
| wodfrq_requestor_code | varchar(15) | NULL | Reuestor’s employee code | No | No | |||
| wodfrq_email | varchar(70) | NULL | Email id | No | No | |||
| wodfrq_phone_no | varchar(70) | NULL | Work Phone Number | No | No | |||
| wodfrq_created_by | varchar(30) | NULL | Created By | No | No | |||
| wodfrq_createddate | datetime | NULL | Created Date | No | No | |||
| wodfrq_modified_by | varchar(30) | NULL | Last Modified By | No | No | |||
| wodfrq_modifieddate | datetime | NULL | Last Modified Date | No | No | |||
| wodfrq_timestamp | numeric(10) | NULL | Timestamp | No | No | |||
| WODFRQ_COMPONENT_OU | numeric(10) | NULL | Component OU | No | No | |||
| WODFRQ_STAGE | varchar(20) | NULL | Workflow field | No | No | |||
| WODFRQ_DOCKEY | varchar(128) | NULL | Worklflow field | No | No | |||
| Table Name hwo_wodfwu_def_work_units | ||||||||
| Table Comment Deferral Work Unit list. | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| wodfwu_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | Yes | |||
| wodfwu_def_req_no | varchar(40) | NOT NULL | deferment request number | Yes | Yes | |||
| wodfwu_seq_no | numeric(10) | NOT NULL | Sequence Number | Yes | No | |||
| wodfwu_wo_no | varchar(40) | NOT NULL | Work Order Number | No | No | |||
| wodfwu_wo_seq_no | numeric(10) | NOT NULL | Workorder Sequence number | No | No | |||
| wodfwu_source | varchar(25) | NULL | Source of the Task - Can be thru forecast or thru EO | No | No | |||
| wodfwu_src_ou | numeric(10) | NULL | Source OU | No | No | |||
| wodfwu_source_doc_no | varchar(40) | NULL | Source Document Number | No | No | |||
| wodfwu_src_doc_rev_no | varchar(40) | NULL | Source document revision number | No | No | |||
| wodfwu_src_wu_seq_no | numeric(10) | NULL | Work unit sequence number | No | No | |||
| wodfwu_work_unit | varchar(30) | NULL | Work Unit Code | No | No | |||
| wodfwu_wu_type | varchar(5) | NULL | Work Unit Type | No | No | |||
| wodfwu_sch_date | datetime | NULL | Schedule Date | No | No | |||
| wodfwu_part_no | varchar(40) | NULL | Part Number | No | No | |||
| wodfwu_serial_no | varchar(40) | NULL | Serial Number | No | No | |||
| wodfwu_maintenance_type | varchar(5) | NULL | Maintenance Type | No | No | |||
| wodfwu_deferral_type | varchar(5) | NULL | Deferral Type | No | No | |||
| WODFWU_REMARKS | varchar(255) | NULL | Remarks | No | No | |||
| cpdfwu_remarks | char(18) | NULL | No | No | ||||
| wodfwu_deferred_by_in_days | numeric(28) | NULL | Deferred By in Days | No | No | |||
| wodfwu_alert_value_in_days | numeric(28) | NULL | Alert Value in days | No | No | |||
| wodfwu_deferred_till_date | datetime | NULL | Deferred Till Date | No | No | |||
| wodfwu_approval_no | varchar(30) | NULL | Approval Number | No | No | |||
| wodfwu_approval_date | datetime | NULL | Approval Date | No | No | |||
| wodfwu_reason_category | varchar(25) | NULL | Reason Category | No | No | |||
| wodfwu_reg_authority | varchar(25) | NULL | Regulatory Authority | No | No | |||
| wodfwu_approval_comments | varchar(255) | NULL | approval comments | No | No | |||
| wodfwu_action_flag | varchar(25) | NULL | action flag | No | No | |||
| wodfwu_wo_tsk_def_flag | varchar(25) | NULL | workorder task deferral flag | No | No | |||
| WODFWU_WU_OU | numeric(10) | NULL | Work Unit ou | No | No | |||
| WODFWU_WU_REV_NO | varchar(25) | NULL | work unit Revison Number | No | No | |||
| WODFWU_ALERT_DATE | datetime | NULL | lert Date The date on which the alert message is raised for the execution of the maintenance activity | No | No | |||
| Table Name hwo_wodmrd_dmr_discrepancy | ||||||||
| Table Comment This table stores the discrepancies associated with Maintenance Report. | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| wodmrd_modified_by | sql_variant | NULL | User who has modified the maintenance report details | No | No | |||
| wodmrd_createddate | datetime | Date on which Maintenance report details got created. | No | No | ||||
| wodmrd_modifieddate | datetime | Date on which maintenance report details got modified. | No | No | ||||
| wodmrd_timestamp | int | Timestamp details | No | No | ||||
| %AttName | int | NOT NULL | %AttDef | Yes | Yes | |||
| wodmrd_created_by | sql_variant | NULL | User who has created the details | No | No | |||
| wodmrd_discrepancy_no | sql_variant | NOT NULL | This is the discrepancy number which is associated with Maintenance report. This is from the Journey Log Number / Technical Log Number which is associated with Maintenance Report. | Yes | No | |||
| Table Name hwo_wodmrh_maint_report_hdr | ||||||||
| Table Comment This table contains Maintenance Report Details along with carry forward details. It also contains the DMR Parameters. | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| %AttName | int | NOT NULL | %AttDef | Yes | No | |||
| WODMRH_DMR_OUINSTANCE | decimal(10) | NOT NULL | Ouinstance | No | No | |||
| wodmrh_dmr_no | varchar(40) | NOT NULL | Maintenance Report Number is stored here. | No | No | |||
| wodmrh_dmr_desc | varchar(255) | NULL | Maintenance Report Description | No | No | |||
| wodmrh_dmr_status | varchar(25) | NULL | Maintenance Report Status ’FRSH’ - Fresh ’CNFIM’ - Confirmed ’CLS’ - Close ’CNCL’ - Cancel | No | No | |||
| WODMRH_AC_OU | decimal(10) | NULL | Aircraft Ouinstance | No | No | |||
| %AttName | int | NULL | %AttDef | No | No | |||
| wodmrh_ac_reg_no | varchar(30) | NULL | Aircraft Registration Number is stored here. | No | No | |||
| wodmrh_user_status | varchar(25) | NULL | This  Maintenance Report User Status Quick Code | No | No | |||
| %AttName | int | NULL | %AttDef | No | No | |||
| WODMRH_FAULT_OU | decimal(10) | NULL | Fault Ouinstance | No | No | |||
| wodmrh_fault_no | varchar(25) | NULL | This is the Fault Code associated with Maintenance Report. All Discrepancies associated with a MR can be assigned to a fault code. | No | No | |||
| wodmrh_ata_no | varchar(30) | NULL | ATA Chapter Number. - This gets associated 1) when a fault is associated to MR, the corresponding ATA Chapter Number is copied automatically. 2) When EAN Number is associated to MR, the corresponding ATA Chapter number is copied automatically. 3) User can specify the ATA Number. | No | No | |||
| wodmrh_cause_code | varchar(25) | NULL | This is Cause Code that will be assigned to the MR- fault code combination. | No | No | |||
| wodmrh_deferral_type | varchar(25) | NULL | This could be ’MDL’ or ’CDL’ or ’Pax Cabin’ | No | No | |||
| wodmrh_def_item_no | varchar(40) | NULL | Part Number of the deferred part is stored here. This could be the CDL or MEL  part as specified in the model configuration. | No | No | |||
| wodmrh_def_item_desc | varchar(150) | NULL | Deferred Item Description | No | No | |||
| wodmrh_comments | varchar(255) | NULL | Maintenance Report Comments | No | No | |||
| wodmrh_created_by | varchar(30) | NULL | This is the date on which MR got created | No | No | |||
| wodmrh_createddate | datetime | NOT NULL | created date | No | No | |||
| wodmrh_modified_by | varchar(30) | NULL | User who has modified the Maintenance Report | No | No | |||
| wodmrh_modified_date | datetime | NOT NULL | Date on which MR got modified. | No | No | |||
| wodmrh_timestamp | decimal(10) | NULL | Maintenance Report Timestamp is stored here. | No | No | |||
| Table Name hwo_wodmrwu_dmr_workunit | ||||||||
| Table Comment This table contains the list of workunits that should be performed against the maintenance report. Workunit will be task/Non-routine Task/Standard procedure. | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| %AttName | int | NOT NULL | %AttDef | Yes | Yes | |||
| WODMRWU_OUINSTANCE | decimal(10) | NOT NULL | Ouinstance | No | No | |||
| wodmrwu_seq_no | NOT NULL | Sequence Number for the workunit. Sequence number will form the order of execution. | No | No | ||||
| %AttName | int | NULL | %AttDef | No | No | |||
| WODMRWU_WU_OU | decimal(10) | NULL | Work Unit Ou | No | No | |||
| wodmrwu_workunit_no | varchar(30) | NULL | Work Unit Number which is getting associated with MR is stored here. | No | No | |||
| wodmrwu_work_unit_desc | varchar(255) | NULL | Work Unit Description - This detail will be captured for non-routine task. i.e MRWU_New_Exist_Flag = ’N’ | No | No | |||
| wodmrwu_workunit_type | varchar(25) | NULL | Work Unit Type - Task/ Standard Procedure. | No | No | |||
| wodmrwu_created_by | varchar(30) | NULL | User who creates the data. | No | No | |||
| wodmrwu_createddate | datetime | NOT NULL | Date on which data got created. | No | No | |||
| wodmrwu_modified_by | varchar(30) | NULL | User who modifies the data. | No | No | |||
| wodmrwu_modifieddate | datetime | NOT NULL | Date on which data got modified. | No | No | |||
| wodmrwu_timestamp | decimal(10) | NULL | TimeStamp Details | No | No | |||
| Table Name hwo_wodwus_dfwu_usage_sch | ||||||||
| Table Comment Value based Deferral Limits for the Work Units | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| wodwus_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | Yes | |||
| wodwus_def_req_no | varchar(40) | NOT NULL | deferment request number | Yes | Yes | |||
| wodwus_seq_no | numeric(10) | NOT NULL | Sequence Number | Yes | Yes | |||
| wodwus_param_code | varchar(40) | NOT NULL | Parameter Code | Yes | No | |||
| WODWUS_WO_NO | varchar(40) | NOT NULL | Work Order no | No | No | |||
| wodwus_wo_seq_no | char(18) | NULL | Work order sequence no | No | No | |||
| wodwus_alert_value | numeric(28) | NULL | Alert Value | No | No | |||
| wodwus_deferred_by | numeric(28) | NULL | Deferred By Value | No | No | |||
| wodwus_deferred_by_date | datetime | NOT NULL | deferred by date | No | No | |||
| WODWUS_PARAM_OU | numeric(10) | NULL | Param ou | No | No | |||
| WODWUS_ALERT_DATE | datetime | NULL | he date on which the alert message is raised for the execution of the maintenance activity | No | No | |||
| Table Name hwo_woemas_emp_assign | ||||||||
| Table Comment Employee Assignment details will be maintained here | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| woemas_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | Yes | |||
| woemas_wo_no | varchar(40) | NOT NULL | Work Order Number | Yes | Yes | |||
| woemas_emp_code | varchar(20) | NOT NULL | Assigned Employee Code | Yes | No | |||
| woemas_seq_no | numeric(10) | NOT NULL | Task Seq No | Yes | No | |||
| woemas_assign_seq_no | numeric(10) | NOT NULL | Resource assignment seq no | Yes | No | |||
| woemas_from_datetime | datetime | NOT NULL | From Date | No | No | |||
| woemas_assigneddate | datetime | NOT NULL | Assignment Date | No | No | |||
| woemas_task_no | varchar(30) | NULL | Task Code | No | No | |||
| woemas_to_datetime | datetime | NULL | To Date | No | No | |||
| woemas_hours_per_day | numeric(28,8) | NULL | Hours Per Day | No | No | |||
| woemas_assigned_hrs | numeric(28,8) | NULL | Assigned Hours | No | No | |||
| woemas_actual_hrs | numeric(28,8) | NULL | Actual hours | No | No | |||
| woemas_assign_comments | varchar(255) | NULL | assignment Commments | No | No | |||
| woemas_assign_flag | varchar(5) | NULL | No | No | ||||
| woemas_work_group | varchar(20) | NULL | Work group | No | No | |||
| WOEMAS_TIMESTAMP | numeric(10) | NULL | Time stamp | No | No | |||
| WOEMAS_WORK_CENTER | varchar(30) | NULL | Work center | No | No | |||
| woemas_emp_ou | numeric(10) | NULL | employee Ouinstance | No | No | |||
| Table Name hwo_wohdr_wo_header | ||||||||
| Table Comment Work Order Header Table | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| wohdr_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No | |||
| wohdr_wo_no | varchar(40) | NOT NULL | Work Order Number | Yes | No | |||
| wohdr_num_type_no | varchar(5) | NULL | Numbering Type Number | No | No | |||
| wohdr_wo_type | sql_variant | NULL | Work order Type - Planned or Unplanned | No | No | |||
| wohdr_job_type | sql_variant | NULL | Job Type - ’Aircraft’,’On-Wing’ or ’Component Removal’ | No | No | |||
| wohdr_wo_status | sql_variant | NULL | Workorder Status - | No | No | |||
| wohdr_auth_status | sql_variant | NULL | Authorization Status | No | No | |||
| wohdr_transient_status | sql_variant | NULL | Transient Status. The various values this can hold is ’Hold’, ’Released’, ’Deferred’, ’Pending Deferral’ | No | No | |||
| wohdr_nor_sub_split_flag | sql_variant | NULL | This flag indicates if the workorder is a Normal workorder  or Sub workorder or Spilt Workorder | No | No | |||
| wohdr_parent_wo | varchar(40) | NULL | Parent WO - Parent WO Number in case the WO is a Sub Work Order | No | No | |||
| wohdr_child_wo_count | numeric(10) | NULL | Number of child workorders generated for this workorder | No | No | |||
| wohdr_user_status | sql_variant | NULL | User Status - Quick Codes | No | No | |||
| wohdr_wo_category | sql_variant | NULL | Work Order Category -  Quick Codes of type ’WO Category’ | No | No | |||
| wohdr_wo_desc | varchar(150) | NULL | Work Order Description | No | No | |||
| wohdr_vst_pkg_no | varchar(40) | NULL | Visit Package Number | No | No | |||
| wohdr_vst_pkg_rev_no | varchar(40) | NULL | Visit Package Revision Number | No | No | |||
| wohdr_aircraft_reg_no | sql_variant | NULL | Aircraft Registration Number | No | No | |||
| wohdr_ac_ou | numeric(10) | NULL | Aircraft OU | No | No | |||
| wohdr_ata_no | sql_variant | NULL | Ata Number | No | No | |||
| wohdr_part_no | sql_variant | NULL | Part Number | No | No | |||
| wohdr_part_ou | numeric(10) | NULL | Part Ouinstance | No | No | |||
| wohdr_serial_no | varchar(40) | NULL | Serial Number | No | No | |||
| wohdr_component_id | varchar(90) | NULL | Component Id | No | No | |||
| wohdr_component_ou | numeric(10) | NULL | Component OUinstance | No | No | |||
| wohdr_position_code | varchar(25) | NULL | Position Code | No | No | |||
| wohdr_maintenance_type | sql_variant | NULL | Maintenance Type - Overhaul, Inspection, Repair and Others | No | No | |||
| wohdr_priority | numeric(10) | NULL | Priority - descriptions of the priority nos as identified in the Priority Master of the Common Masters component | No | No | |||
| wohdr_priority_ou | numeric(10) | NULL | Priority OU | No | No | |||
| wohdr_interuptable_flag | sql_variant | NULL | Interruptable Flag - Values ’Yes’ or ’No’ | No | No | |||
| wohdr_contact_person | varchar(80) | NULL | Contact Person | No | No | |||
| wohdr_work_centre | varchar(30) | NULL | Work Centre | No | No | |||
| wohdr_wc_ou | numeric(10) | NULL | Work Centre OU | No | No | |||
| wohdr_phone_no | varchar(70) | NULL | Phone Number | No | No | |||
| wohdr_est_man_hrs | numeric(28,8) | NULL | Estimated Man Hours | No | No | |||
| wohdr_est_elasped_time | numeric(28,8) | NULL | Estimated Elasped Time | No | No | |||
| wohdr_est_elapsed_time_uom | sql_variant | NULL | Estimated Elasped Time UOM | No | No | |||
| wohdr_est_elasped_time_in_min | numeric(28,8) | NULL | Estimated elasped time in minutes | No | No | |||
| wohdr_start_datetime | datetime | NULL | Start Date | No | No | |||
| wohdr_gmt_start_datetime | datetime | NULL | Starte Datetime in GMT | No | No | |||
| wohdr_end_datetime | datetime | NULL | End Date | No | No | |||
| wohdr_gmt_end_datetime | datetime | NULL | End Datetime in GMT | No | No | |||
| wohdr_compliance_date | datetime | NULL | Compliance Date | No | No | |||
| wohdr_auth_req_flag | sql_variant | NULL | Authorization Flag - Indicates if Authorization is required or not | No | No | |||
| wohdr_access_panel_flag | sql_variant | NULL | Access Panel Flag - Indicates whether a seperate WO has to be generated for the Access Panel or not. | No | No | |||
| wohdr_esr_no | varchar(40) | NULL | ESR Number | No | No | |||
| wohdr_esr_ou | numeric(10) | NULL | ESR OU | No | No | |||
| wohdr_ean_no | varchar(40) | NULL | Engg Advice Note Number | No | No | |||
| wohdr_ean_rev_no | varchar(40) | NULL | EAN Revision Number | No | No | |||
| wohdr_ean_ou | numeric(10) | NULL | EAN OU | No | No | |||
| wohdr_total_cost | numeric(28,8) | NULL | Total Cost | No | No | |||
| wohdr_est_material_cost | numeric(28,8) | NULL | Material Cost | No | No | |||
| wohdr_est_capital_cost | numeric(28,8) | NULL | Capital Cost | No | No | |||
| wohdr_labor_cost | numeric(28,8) | NULL | Labor Cost | No | No | |||
| wohdr_facilities_cost | numeric(28,8) | NULL | Facilities Cost | No | No | |||
| wohdr_misc_cost | numeric(28,8) | NULL | Miscelleneous Cost | No | No | |||
| wohdr_auth_comments | sql_variant | NULL | Comments | No | No | |||
| wohdr_createddate | datetime | NULL | Created Date | No | No | |||
| wohdr_created_by | sql_variant | NULL | Created By | No | No | |||
| wohdr_modifieddate | datetime | NULL | Last Modified Date | No | No | |||
| wohdr_modified_by | sql_variant | NULL | Last Modified By | No | No | |||
| wohdr_timestamp | numeric(10) | NULL | Timestamp | No | No | |||
| wohdr_act_material_cost | numeric(28,8) | NULL | Actual Material Cost | No | No | |||
| wohdr_act_capital_cost | numeric(28,8) | NULL | Actual Capital Cost | No | No | |||
| wodhr_act_start_datetime | datetime | NULL | Actual Start date and Time of the workorder | No | No | |||
| WOHDR_ACT_START_DATETIME | datetime | NULL | Actual Start time of the work order | No | No | |||
| wohdr_act_end_datetime | datetime | NULL | Actual End Time of the Workorder | No | No | |||
| wohdr_closeddate | datetime | NULL | wo closure date | No | No | |||
| wohdr_act_labor_cost | numeric(28,8) | NULL | actual labor cost | No | No | |||
| wohdr_act_faclity_cost | numeric(28,8) | NULL | actual facility cost | No | No | |||
| wohdr_zone_no | varchar(15) | NULL | zone number | No | No | |||
| wohdr_closure_comments | sql_variant | NULL | closure comments | No | No | |||
| wohdr_gen_comments | sql_variant | NULL | general comments | No | No | |||
| wohdr_descrepancy_count | numeric(10) | NULL | descrepancy count | No | No | |||
| wohdr_percentage_completed | numeric(28,8) | NULL | % completed | No | No | |||
| wohdr_act_elasped_time | numeric(28,8) | NULL | actual elasped time | No | No | |||
| wohdr_exec_comments | sql_variant | NULL | execution comments | No | No | |||
| wohdr_sch_comments | sql_variant | NULL | scheduling comments | No | No | |||
| wohdr_act_elasped_time_uom | sql_variant | NULL | uom of actual elasped time | No | No | |||
| wohdr_act_misc_cost | numeric(28,8) | NULL | Actual Miscellaneous cost | No | No | |||
| WOHDR_ACT_START_DATETIME_GMT | datetime | NULL | Actual Start Time in GMT | No | No | |||
| WOHDR_ACT_END_DATETIME_GMT | datetime | NULL | Actual End time In GMT | No | No | |||
| WOHDR_RESCH_COUNT | numeric(10) | NULL | Re schdule count | No | No | |||
| wohdr_cust_order_no | varchar(40) | NULL | customer order number | No | No | |||
| wohdr_cust_order_ou | numeric(10) | NULL | Customer order ou | No | No | |||
| wohdr_ac_release_date | datetime | NULL | aircraft release date | No | No | |||
| WOHDR_CUSTOMER_NO | varchar(18) | NULL | Customer code | No | No | |||
| WOHDR_CUSTOMER_OU | numeric(10) | NULL | Customer OU | No | No | |||
| WOHDR_AC_ZONE_NO | varchar(15) | NULL | The number identifying the zone to which the aircraft belongs | No | No | |||
| WOHDR_OTHER_OBSERVATION | varchar(255) | NULL | Other observations remarks | No | No | |||
| WOHDR_STAGE | varchar(10) | NULL | Stage col used for workflow | No | No | |||
| WOHDR_DOCKEY | varchar(128) | NULL | Col used for workflow | No | No | |||
| WOHDR_REPLACEMENT_TYPE | varchar(6) | NULL | the replacement type for the part Replacement, Restoration, Remove Only and Attach Only, The system leaves the field blank by default | No | No | |||
| Table Name hwo_womra_wo_mat_req_alloc | ||||||||
| Table Comment Material request can be created for 1 or more workorders or workorder tasks. This table maintains the sequence in which the material allocation has to be done. | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| womra_ouinstance | numeric(10) | NOT NULL | ouinstance | Yes | No | |||
| womra_mr_no | varchar(40) | NOT NULL | Material request number | Yes | No | |||
| womra_visit_pkg_no | varchar(40) | NOT NULL | Visit Package Number | Yes | No | |||
| womra_wo_no | varchar(40) | NOT NULL | Work order number - Will be stored as ## if the request is at visit package level | Yes | No | |||
| womra_seq_no | numeric(10) | NOT NULL | Sequence Number | Yes | No | |||
| womra_part_no | varchar(40) | NOT NULL | Part Number | Yes | No | |||
| womra_line_no | numeric(10) | NOT NULL | line no | No | No | |||
| womra_mr_ou | numeric(10) | NULL | Material Request  Ou | No | No | |||
| womra_task_no | varchar(30) | NULL | Task Number | No | No | |||
| womra_req_qty | numeric(28) | NULL | Requested Quantity | No | No | |||
| womra_uom | varchar(10) | NULL | Unit of measure in which the request is made | No | No | |||
| womra_issue_qty | numeric(28) | NULL | Issued Quantity | No | No | |||
| womra_createddate | datetime | NULL | Created Date | No | No | |||
| womra_created_by | varchar(30) | NULL | Created By | No | No | |||
| womra_modifieddate | datetime | NULL | Last Modified Date | No | No | |||
| womra_modified_by | varchar(30) | NULL | Last Modified By | No | No | |||
| womra_timestamp | numeric(10) | NULL | Timestamp | No | No | |||
| womra_wh_no | varchar(10) | NULL | Warehouse number | No | No | |||
| womra_est_qty | numeric(28) | NULL | Estimated quantity | No | No | |||
| womra_def_wh_no | varchar(10) | NULL | Default warehouse when the workorder got created. Request warehouse can be different | No | No | |||
| womra_stock_uom_qty | numeric(28) | NULL | Stock UOM | No | No | |||
| womra_planned_flag | varchar(25) | NULL | Planned Flag | No | No | |||
| womra_iss_qty_in_stk_uom | numeric(28) | NULL | issue quantity in stock uom | No | No | |||
| womra_part_ou | numeric(10) | NULL | Part OU | No | No | |||
| womra_wh_ou | numeric(10) | NULL | warehouse OU | No | No | |||
| womra_issue_part | varchar(40) | NULL | Issue Part | No | No | |||
| womra_priority | numeric(10) | NULL | Priority | No | No | |||
| womra_preclosed_qty | numeric(28) | NULL | Preclosed Quantity | No | No | |||
| womra_shclcomments | varchar(255) | NULL | Short Closure Comments | No | No | |||
| WOMRA_STAGE | varchar(10) | NULL | Work flow field | No | No | |||
| WOMRA_DOCKEY | varchar(128) | NULL | No | No | ||||
| WOMRA_PART_STATUS | varchar(40) | NULL | Part stauts, PBH, Loaned, Accepted | No | No | |||
| Table Name Hwo_womri_wo_mr_issdet | ||||||||
| Table Comment This table contains the information about the mr no and the issue doc no | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| womri_ouinstance | numeric(10) | NOT NULL | OUinstance | Yes | No | |||
| womri_mr_no | varchar(40) | NOT NULL | Material Request Number | Yes | No | |||
| womri_visit_pkg_no | varchar(40) | NOT NULL | Visit Package Number | Yes | No | |||
| womri_wo_no | varchar(40) | NOT NULL | Workorder Number | Yes | No | |||
| womri_seq_no | numeric(10) | NOT NULL | Sequence Number | Yes | No | |||
| womri_part_no | varchar(40) | NOT NULL | Part Number | Yes | No | |||
| womri_issuedoc_no | varchar(40) | NOT NULL | the issue doc no against which this part is issued. | Yes | No | |||
| womri_part_ou | numeric(10) | NULL | Part Ou | No | No | |||
| womri_stock_status | varchar(40) | NULL | Issue Stock Status | No | No | |||
| womri_issue_unitcost | numeric(28,8) | NULL | issue unit cost=total part cost/quantity of part issued.this cost will be in stock uom | No | No | |||
| womri_issue_basis | varchar(5) | NULL | issuen basis of the part.taken from part admin component | No | No | |||
| womri_part_type | varchar(5) | NULL | part type taken from part admn component. | No | No | |||
| womri_issdoc_approved_date | datetime | NULL | issdocno confirmed date | No | No | |||
| womri_stock_uom | varchar(5) | NULL | stock uom | No | No | |||
| womri_issue_uom | varchar(5) | NULL | issue uom | No | No | |||
| WOMRI_ISSUE_QTY_IN_STK_UOM | numeric(28) | NULL | Issue Qty In stock UOM | No | No | |||
| Table Name hwo_wonts_wo_notes | ||||||||
| Table Comment Workorder Notes will be maintained here | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| wonts_wo_no | varchar(40) | NOT NULL | Work Order Number | Yes | Yes | |||
| wonts_notes | varchar(2000) | NULL | Notes | No | No | |||
| wonts_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | Yes | |||
| Table Name hwo_woopt_wo_option_setting | ||||||||
| Table Comment Option Setting for Work Order Component | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| woopt_ouinstance | numeric(10) | NOT NULL | ouinstance | Yes | No | |||
| woopt_nrwo_auth_flag | varchar(25) | NULL | Authorization Option for non - routine workorder - Valid values are ’Yes’ and ’No’ | No | No | |||
| woopt_subwo_auth_flag | varchar(25) | NULL | Authorization Option for sub workorder - Valid values are ’Yes’ and ’No’ | No | No | |||
| woopt_corrwo_auth_flag | varchar(25) | NULL | Authorization Option for corrective workorder - Valid values are ’Yes’ and ’No’ | No | No | |||
| woopt_wo_mod_flag | varchar(25) | NULL | Workorder Modification Falg - valid values are ’allowed’, ’Not allowed after scheduling’, ’Requires re-authorization’ and ’only new tasks can be added’ | No | No | |||
| woopt_resch_compl_date_flag | varchar(25) | NULL | Rescheduling beyond compliance date - The Valid value are ’Allowed’ and ’Not Allowed’ | No | No | |||
| woopt_assgn_prior_sch_flag | varchar(25) | NULL | This flag indicates if assignments to the workorder be done before scheduling or not. | No | No | |||
| woopt_descrepancy_def_flag | varchar(25) | NULL | Deferment of Discrepancies - Allowed or Not Allowed | No | No | |||
| woopt_auth_def_req_flag | varchar(25) | NULL | Authorization of Deferals - Valid values are ’Required’ and ’Not Required’ | No | No | |||
| woopt_def_auth_flag | varchar(25) | NULL | Deferral Authorization Flag | No | No | |||
| woopt_task_grp_flag | varchar(25) | NULL | Task Grouping Flag - The values can be ’Task Type’ or ’Main WO’ | No | No | |||
| woopt_sub_alternate_flag | varchar(25) | NULL | Indicates if authorization is required for Substitute-Alternate material request | No | No | |||
| woopt_addln_part_flag | varchar(25) | NULL | Indicates if authorization is required for additional parts material request | No | No | |||
| woopt_substitute_nha_flag | varchar(25) | NULL | Substitute NHA Flag | No | No | |||
| woopt_addln_qty_flag | varchar(25) | NULL | Additional Quantity Flag | No | No | |||
| woopt_addln_kit_flag | varchar(25) | NULL | Additional Kit Flag | No | No | |||
| woopt_auto_mr_creation_flag | varchar(25) | NULL | Automatic MR generation flag | No | No | |||
| woopt_auto_mr_option_flag | varchar(25) | NULL | Option based on which the MR should be created - Work centre wise or workorder wise or workorder task wise | No | No | |||
| woopt_mr_num_type_num | varchar(25) | NULL | Numbering Type used for auto MR generation | No | No | |||
| woopt_mr_category | varchar(25) | NULL | Indicates the category in which the automatic MR has to be created - Quick codes defined in MR | No | No | |||
| woopt_auto_mr_status | varchar(25) | NULL | Indicates the status in which the automatic MR has to be created - Valid statuses are ’Draft’, ’Fresh’ and ’Authorized’ | No | No | |||
| woopt_modifieddate | datetime | NULL | last modified date | No | No | |||
| woopt_modified_by | varchar(30) | NULL | last modified by | No | No | |||
| woopt_timestamp | numeric(10) | NULL | timestamp | No | No | |||
| woopt_ap_task_wo_flag | varchar(25) | NULL | Access Panel Task Wo flag | No | No | |||
| Table Name HWO_WOPSL_PREF_SRL_LOT_INFO | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| WOPSL_OUINSTANCE | decimal(38) | NOT NULL | Ouinstance | Yes | No | |||
| WOPSL_WO_NO | varchar(40) | NOT NULL | Hanger work order No. | Yes | No | |||
| WOPSL_WU_SEQ_NO | char(18) | NOT NULL | Work unit seqence No. | Yes | No | |||
| WOPSL_PART_NO | varchar(40) | NOT NULL | Prefered Part no | Yes | No | |||
| WOPSL_SEQ_NO | decimal(38) | NOT NULL | Prefered Part seq no | Yes | No | |||
| WOPSL_DISP_SEQ_NO | NULL | Hidden Sequence no | No | No | ||||
| WOPSL_SERIAL_NO | varchar(40) | NULL | Part serial no | No | No | |||
| WOPSL_LOT_NO | varchar(18) | NULL | Part Lot No. | No | No | |||
| WOPSL_QUANTITY | decimal(28,8) | NULL | Quantity | No | No | |||
| WOPSL_AVL_FLAG | varchar(5) | NULL | Available flag yes no | No | No | |||
| WOPSL_PART_STATUS | varchar(40) | NULL | Part stauts Accepted, PBH, Loaned | No | No | |||
| Table Name hwo_woqc_quick_code | ||||||||
| Table Comment User defined Quick codes are maintained here | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| woqc_ouinstance | numeric(10) | NOT NULL | OUinstance | Yes | No | |||
| woqc_quick_code | sql_variant | NOT NULL | Quick Code | Yes | No | |||
| woqc_type | varchar(25) | NOT NULL | Type of the Quick Code | Yes | No | |||
| woqc_desc | sql_variant | NULL | Quick Code description | No | No | |||
| woqc_status | sql_variant | NULL | Status of the Quick Code - Can be ;Active’ or ’Inactive’ | No | No | |||
| woqc_createddate | datetime | NULL | Creation Date | No | No | |||
| woqc_created_by | sql_variant | NULL | Created By | No | No | |||
| woqc_modifieddate | datetime | NULL | Last Modified Date | No | No | |||
| woqc_modified_by | sql_variant | NULL | Last Modified By | No | No | |||
| woqc_timestamp | numeric(10) | NULL | Timestamp | No | No | |||
| Table Name hwo_woref_wo_references | ||||||||
| Table Comment References related to a Workorder | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| woref_ref_doc_type | varchar(15) | NOT NULL | Reference Document Type | Yes | No | |||
| woref_document_no | varchar(40) | Document Number | Yes | No | ||||
| woref_path | varchar(30) | NULL | Workorder reference Path | No | No | |||
| woref_wo_no | varchar(40) | NOT NULL | Work Order Number | Yes | Yes | |||
| woref_ouinstance | numeric(10) | Ouinstance | Yes | Yes | ||||
| Table Name hwo_woresch_reschedule_log | ||||||||
| Table Comment Rescheduling history is maintained here | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| woresch_ouinstance | numeric(10) | NOT NULL | ouinstance | Yes | No | |||
| woresch_visit_pkg_no | varchar(40) | NOT NULL | visit package number | Yes | No | |||
| woresch_wo_no | varchar(40) | NOT NULL | workorder number | Yes | No | |||
| woresch_seq_no | numeric(10) | NOT NULL | sequence number | Yes | No | |||
| woresch_rescheduled_on | datetime | NOT NULL | rescheduled on | Yes | No | |||
| woresch_resch_count | char(18) | NULL | Resduled count | No | No | |||
| woresch_old_sch_date | datetime | NULL | old schedule date | No | No | |||
| woresch_rescheduled_by | varchar(30) | NULL | rescheduled by | No | No | |||
| woresch_resch_startdate | datetime | NULL | rescheduled start date | No | No | |||
| woresch_resch_enddate | datetime | NULL | rescheduled end date | No | No | |||
| Table Name hwo_worsas_resource_assign | ||||||||
| Table Comment Resource Assignment 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 | |||
| worsas_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | Yes | |||
| worsas_wo_no | varchar(40) | NOT NULL | Work Order Number | Yes | Yes | |||
| worsas_resource | varchar(40) | NOT NULL | resource | Yes | No | |||
| worsas_res_type | varchar(5) | NOT NULL | Yes | No | ||||
| worsas_assign_seq_no | numeric(10) | NOT NULL | Yes | No | ||||
| worsas_seq_no | numeric(10) | NOT NULL | Yes | No | ||||
| worsas_from_datetime | datetime | NULL | From datetime | No | No | |||
| WORSAS_RESOURCE_OU | numeric(10) | NULL | Resource Ouinstance | No | No | |||
| worsas_to_datetime | datetime | NULL | To Datetime | No | No | |||
| worsas_hours_per_day | numeric(28,8) | NULL | Hours per day | No | No | |||
| worsas_assigned_hrs | numeric(28,8) | NULL | Assigned Hours | No | No | |||
| worsas_actual_hrs | numeric(28,8) | NULL | Actual Hrs | No | No | |||
| worsas_assigneddate | datetime | NULL | No | No | ||||
| WORSAS_TIMESTAMP | numeric(10) | NULL | Timestamp | No | No | |||
| Table Name hwo_woslog_wo_status_log | ||||||||
| Table Comment The status modification history of the workorder is maintained here | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| woslog_ouinstance | numeric(10) | NOT NULL | ouinstance | Yes | No | |||
| woslog_visit_pkg_no | varchar(40) | NOT NULL | visit package number | Yes | No | |||
| woslog_wo_no | varchar(40) | NOT NULL | workorder number | Yes | No | |||
| woslog_modifieddate | datetime | NOT NULL | Last modified date | Yes | No | |||
| woslog_entity | varchar(5) | NULL | No | No | ||||
| woslog_job_status | varchar(5) | NULL | job status | No | No | |||
| woslog_trans_status | varchar(5) | NULL | transient status | No | No | |||
| woslog_auth_status | varchar(5) | NULL | authorization status | No | No | |||
| woslog_modified_by | varchar(30) | NULL | last modified by | No | No | |||
| woslog_comments | varchar(255) | NULL | comments | No | No | |||
| Table Name hwo_wosrch_search_id_hdr | ||||||||
| Table Comment Search Id Master | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| wosrch_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No | |||
| wosrch_search_id | varchar(30) | NOT NULL | Search Id | Yes | No | |||
| wosrch_wo_desc | varchar(150) | NULL | WO desc | No | No | |||
| wosrch_task_desc | varchar(150) | NULL | Task Desc | No | No | |||
| wosrch_job_type | varchar(5) | NULL | Job Type | No | No | |||
| wosrch_wc_desc | varchar(150) | NULL | Work Center Description | No | No | |||
| wosrch_parent_wo | varchar(40) | NULL | Parent WO | No | No | |||
| wosrch_wo_catg | varchar(25) | NULL | WO Category | No | No | |||
| wosrch_wo_class | varchar(5) | NULL | WO Class | No | No | |||
| wosrch_wo_type | varchar(5) | NULL | WO Type | No | No | |||
| wosrch_dsc_no | varchar(15) | NULL | DSC Number | No | No | |||
| wosrch_user_status | varchar(25) | NULL | User Status | No | No | |||
| wosrch_plan_item_group | varchar(25) | NULL | Plan Item Group | No | No | |||
| wosrch_task_group | varchar(25) | NULL | Task Group | No | No | |||
| wosrch_project_code | varchar(30) | NULL | Project Code | No | No | |||
| wosrch_wc_search_basis | varchar(5) | NULL | Work Center Search Basis | No | No | |||
| wosrch_model_no | varchar(20) | NULL | Model Number | No | No | |||
| wosrch_tab_no | varchar(30) | NULL | Tab Number | No | No | |||
| wosrch_nose_no | varchar(30) | NULL | Nose Number | No | No | |||
| wosrch_msn_serial_no | varchar(40) | NULL | MSN Serial Number | No | No | |||
| wosrch_ata_no | varchar(16) | NULL | Ata Number | No | No | |||
| wosrch_zone_no | varchar(15) | NULL | Zone Number | No | No | |||
| wosrch_part_no | varchar(40) | NULL | Part Number | No | No | |||
| wosrch_serial_no | varchar(40) | NULL | Serial Number | No | No | |||
| wosrch_component_id | varchar(90) | NULL | Component Id | No | No | |||
| wosrch_position_code | varchar(25) | NULL | Position Code | No | No | |||
| wosrch_access_panel_no | varchar(15) | NULL | Access Panel Number | No | No | |||
| wosrch_work_area_code | varchar(15) | NULL | Work Area Code | No | No | |||
| wosrch_delayed_wo_flag | varchar(5) | NULL | Delayed WO Flag | No | No | |||
| wosrch_delay_catg | varchar(25) | NULL | Delay Category | No | No | |||
| wosrch_delay_code | varchar(25) | NULL | delay code | No | No | |||
| wosrch_delay_desc | varchar(80) | NULL | delay description | No | No | |||
| wosrch_mat_plan_status | varchar(5) | NULL | Material Plan Status | No | No | |||
| wosrch_mat_avl_status | varchar(5) | NULL | Material Availability Status | No | No | |||
| wosrch_assgn_status | varchar(5) | NULL | Assignment Status | No | No | |||
| WOSRCH_CUSTOMER_NO | varchar(18) | NULL | No | No | ||||
| WOSRCH_CUSTOMER_NAME | varchar(40) | NULL | No | No | ||||
| wosrch_createddate | datetime | NULL | Creation Date | No | No | |||
| wosrch_created_by | varchar(30) | NULL | Created By | No | No | |||
| wosrch_modifieddate | datetime | NULL | Last Modified Date | No | No | |||
| wosrch_cust_code | char(18) | NULL | customer code | No | No | |||
| wosrch_modified_by | varchar(30) | NULL | Last Modified By | No | No | |||
| wosrch_cust_name | char(18) | NULL | customer name | No | No | |||
| wosrch_timestamp | numeric(10) | NULL | Timestamp | No | No | |||
| Table Name hwo_wostsk_wotsk_sub_task | ||||||||
| Table Comment Work Order Task-Sub Task Details | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| wostsk_emp_code | sql_variant | NULL | employee code | No | No | |||
| wostsk_signoff_comments | sql_variant | NULL | Sign off comments | No | No | |||
| wostsk_signoff_date | datetime | NULL | sign off Date | No | No | |||
| wostsk_dis_rep_flag | sql_variant | NULL | flag | No | No | |||
| wostsk_sign_off_status | varchar(5) | NULL | Sign Off Status | No | No | |||
| wostsk_skill_ou | numeric(10) | NULL | Skill OUInstance | No | No | |||
| WOSTSK_TIMESTAMP | decimal(10) | NULL | Time stamp | No | No | |||
| WOSTSK_FILE_NAME | varchar(50) | NULL | file name | No | No | |||
| wostsk_filename | sql_variant | NULL | File name | No | No | |||
| wostsk_modifiedby | sql_variant | NULL | Modified BY | No | No | |||
| wostsk_modified_date | datetime | NULL | Modification date | No | No | |||
| WOSTSK_COMM_RECORDED_BY | varchar(20) | NULL | signed off by | No | No | |||
| wostsk_tsk_seq_no | numeric(10) | NOT NULL | Sequence Number of the Task - Unique number for design purpose | Yes | Yes | |||
| wostsk_seqno | numeric(10) | NOT NULL | Sequence no | Yes | No | |||
| wostsk_task_code | sql_variant | NOT NULL | Task Code | No | ||||
| wostsk_wo_no | varchar(40) | NOT NULL | Work Order Number | Yes | Yes | |||
| wostsk_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | Yes | |||
| wostsk_skill_code | varchar(5) | NULL | Skill Code | No | No | |||
| wostsk_sub_task_seqno | numeric(10) | NULL | Sub Task Sequence Number | No | No | |||
| wostsk_resource_group | varchar(25) | NULL | Resource Group | No | No | |||
| wostsk_task_ou | numeric(10) | NULL | Task OUInstance | No | No | |||
| wostsk_sub_task | varchar(2000) | NOT NULL | Sub Task # | No | No | |||
| wostsk_task_rev_no | varchar(40) | NULL | Task Revision Number | No | No | |||
| Table Name hwo_wotprt_wo_task_part | ||||||||
| Table Comment Task level Parts definition | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| wotprt_ouinstance | numeric(10) | NOT NULL | OUinstance | Yes | Yes | |||
| wotprt_wo_no | varchar(40) | NOT NULL | Work Order Number | Yes | Yes | |||
| wotprt_seq_no | numeric(10) | NOT NULL | Sequence Number - Unique Number for design pupose | Yes | Yes | |||
| wotprt_part_no | varchar(40) | NOT NULL | Yes | No | ||||
| wotprt_part_ou | numeric(10) | NULL | Part OU | No | No | |||
| wotprt_estimated_qty | numeric(28) | NULL | Estimated Quantity | No | No | |||
| wotprt_required_qty | NULL | Required Quantity of the part | No | No | ||||
| wotprt_substitute_part_no | varchar(40) | NULL | Substitute Part Number | No | No | |||
| wotprt_substitute_type | varchar(5) | NULL | Substitue Type - Can be a Part or the Next Higher Assembly. | No | No | |||
| wotprt_part_type | NULL | Part Type - Component, Spare Part, Raw Material, Tools, Kits and Consumables. | No | No | ||||
| wotprt_uom | varchar(10) | NULL | Unit Of measure | No | No | |||
| wotprt_wh_no | NULL | Warehouse Number | No | No | ||||
| wotprt_issue_basis | varchar(25) | NULL | issue basis - Returnable, Core Returnable and Non Returnable | No | No | |||
| wotprt_actual_qty | numeric(28) | NULL | Actual Qty used | No | No | |||
| wotprt_mr_qty | numeric(28) | NULL | Quantity for which MR is raised | No | No | |||
| wotprt_timestamp | numeric(10) | NULL | Timestamp | No | No | |||
| wotprt_req_qty_in_stk_uom | numeric(28) | NULL | No | No | ||||
| wotprt_wh_ou | numeric(10) | NULL | No | No | ||||
| wotprt_mr_qty_in_stkuom | numeric(28) | NULL | No | No | ||||
| wotprt_substitute_part_ou | numeric(10) | NULL | No | No | ||||
| WOTPRT_PART_BACKFLUSH_FLAG | varchar(5) | NULL | No | No | ||||
| WOTPRT_PART_STATUS | varchar(40) | NULL | No | No | ||||
| WOTPRT_NEED_FREQ | varchar(5) | NULL | No | No | ||||
| Table Name hwo_wotrel_tsk_relationship | ||||||||
| Table Comment one or more preceeding tasks for every task included in the standard procedure | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| wotrel_pred_task_no | varchar(30) | NULL | preceeding sequence number | No | No | |||
| wotrel_task_no | varchar(30) | NULL | Task no. | No | No | |||
| wotrel_relationship_type | varchar(5) | NULL | Relationship type | No | No | |||
| wotrel_lag_time | numeric(28,8) | NULL | Lag time | No | No | |||
| wotrel_lag_uom | varchar(10) | NULL | Uom in which the lag is specified | No | No | |||
| wotrel_wo_no | varchar(40) | NOT NULL | Work Order Number | Yes | Yes | |||
| wotrel_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | Yes | |||
| wotrel_pred_wo_no | varchar(40) | NOT NULL | preceeding workorder number | Yes | No | |||
| wotrel_seq_no | numeric(10) | NOT NULL | Sequence Number of the Task - Unique number for design purpose | Yes | Yes | |||
| wotrel_pred_seq_no | numeric(10) | NOT NULL | preceeding task sequence number | Yes | No | |||
| Table Name hwo_wotres_wo_task_resource | ||||||||
| Table Comment Task level resource definition | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| WOTRES_ESTIMATED_STD_TIME | numeric(28,8) | NULL | Estimated Standard time | No | No | |||
| wotres_estimated_time | numeric(28,8) | NULL | Estimated Time the resource is required | No | No | |||
| wotres_estimated_nos | numeric(28,8) | NULL | Estimated Number of the Resource required | No | No | |||
| wotres_approval_req_flag | varchar(5) | NULL | Approval Required Flag - Valid values are Yes and No | No | No | |||
| wotres_estimated_time_uom | varchar(5) | NULL | Time UOM in which the Estimated time is specified | No | No | |||
| WOTRES_ESTIMATED_TIME_MIN | numeric(28,8) | NULL | Estimated Time in | No | No | |||
| wotres_sign_off_req_flag | varchar(5) | NULL | Sign Off required flag - Valid values are Yes and No | No | No | |||
| wotres_wo_no | varchar(40) | NOT NULL | Work Order Number | Yes | Yes | |||
| wotres_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | Yes | |||
| wotres_res_ou | numeric(10) | NULL | Resource OU | No | No | |||
| wotres_resource | varchar(40) | NOT NULL | Resource | Yes | No | |||
| wotres_seq_no | numeric(10) | NOT NULL | Sequence Number - Unique Number for design pupose | Yes | Yes | |||
| wotres_res_type | varchar(5) | NOT NULL | Resource Type | Yes | No | |||
| Table Name hwo_wotsk_wo_task | ||||||||
| Table Comment Work Order Task Details | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| wotsk_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | Yes | |||
| wotsk_wo_no | varchar(40) | NOT NULL | Work Order Number | Yes | Yes | |||
| wotsk_seq_no | numeric(10) | NOT NULL | Sequence Number of the Task - Unique number for design purpose | Yes | No | |||
| wotsk_pos_no | NULL | position number | No | No | ||||
| wotsk_task_no | sql_variant | NULL | Task Number | No | No | |||
| wotsk_task_rev_no | varchar(40) | NULL | Task revision number | No | No | |||
| wotsk_task_ou | numeric(10) | NULL | Task OU | No | No | |||
| wotsk_task_status | sql_variant | NULL | Task Status | No | No | |||
| wotsk_trans_status | sql_variant | NULL | Transient Status - Pending, Deferred. | No | No | |||
| wotsk_auth_status | sql_variant | NULL | Authorization Status - Authorization Pending, Authorization Not Required, Returned and Authorized | No | No | |||
| wotsk_task_type | sql_variant | NULL | Task Type | No | No | |||
| wotsk_visit_pkg_no | varchar(40) | NULL | visit package number | No | No | |||
| wotsk_priority | numeric(10) | NULL | Priority - As defined in the Common Master | No | No | |||
| wotsk_time_uom | sql_variant | NULL | Time UOM | No | No | |||
| wotsk_est_elasped_time | numeric(28,8) | NULL | Estimated Elasped Time | No | No | |||
| wotsk_est_elasped_time_in_min | numeric(28,8) | NULL | Estimated Elasped Time in Minutes | No | No | |||
| wotsk_est_man_hrs | numeric(28,8) | NULL | Estimated Man Hours | No | No | |||
| wotsk_sch_start_date | datetime | NULL | Schedule Start Date | No | No | |||
| wotsk_sch_end_date | datetime | NULL | Schedule End Date | No | No | |||
| wotsk_compliance_date | datetime | NULL | Compliance Date | No | No | |||
| wotsk_gmt_sch_start_datetime | datetime | NULL | Schedule start date in GMT | No | No | |||
| wotsk_gmt_sch_end_datetime | datetime | NULL | Schedule End Date in GMT | No | No | |||
| WOTSK_TASK_GROUP | varchar(25) | NULL | Task Group | No | No | |||
| WOTSK_PLANITEM_GROUP | varchar(25) | NULL | Plan Item Group | No | No | |||
| wotsk_modified_by | sql_variant | NULL | Last Modified By | No | No | |||
| wotsk_modifieddate | datetime | NULL | Last Modified Date | No | No | |||
| wotsk_timestamp | numeric(10) | NULL | Timestamp | No | No | |||
| wotsk_comments | sql_variant | NULL | Comments | No | No | |||
| wotsk_source | sql_variant | NULL | Source - Indicates the source for the task...EO or PM Forecast etc | No | No | |||
| wotsk_main_task_no | sql_variant | NULL | main task number | No | No | |||
| wotsk_src_ou | numeric(10) | NULL | Source OU | No | No | |||
| wotsk_source_doc_no | varchar(40) | NULL | Source Document Number | No | No | |||
| wotsk_src_doc_rev_no | varchar(40) | NULL | Source document revision number | No | No | |||
| wotsk_src_seq_no | numeric(10) | NULL | source doc sequence number | No | No | |||
| wotsk_src_workunit_type | sql_variant | NULL | source work unit type | No | No | |||
| wotsk_act_start_datetime | datetime | NULL | actual start date & time | No | No | |||
| wotsk_act_end_datetime | datetime | NULL | Actual end date & time | No | No | |||
| wotsk_act_start_datetime_gmt | datetime | NULL | actual start date & time in gmt | No | No | |||
| wotsk_act_end_datetime_gmt | datetime | NULL | actual end date & time in GMT | No | No | |||
| wotsk_resch_count | numeric(10) | NULL | Number of times the task has been rescheduled | No | No | |||
| wotsk_std_proc_no | sql_variant | NULL | standard procedure number | No | No | |||
| wotsk_src_workunit | sql_variant | NULL | source workunit | No | No | |||
| WOTSK_SWP_CODE | varchar(30) | NULL | Work package code | No | No | |||
| WOTSK_STDPROC_SEQNO | numeric(10) | NULL | Standard Procedure seq No. | No | No | |||
| wotsk_planned_flag | sql_variant | NULL | planned flag | No | No | |||
| wotsk_tskmandatory_flag | sql_variant | NULL | Mandatory flag | No | No | |||
| WOTSK_MANDATORY_FLAG | varchar(5) | NULL | Mantatory flag | No | No | |||
| wotsk_act_elasped_time | numeric(28,8) | NULL | actual elasped time | No | No | |||
| wotsk_percentage_completed | numeric(10) | NULL | percentage completed | No | No | |||
| wotsk_exec_comments | sql_variant | NULL | execution comments | No | No | |||
| WOTSK_AUTH_COMMENTS | varchar(255) | NULL | Authorization comments | No | No | |||
| WOTSK_SCH_COMMENTS | varchar(255) | NULL | Scheduled comments | No | No | |||
| WOTSK_CLOSURE_COMMENTS | varchar(255) | NULL | Closure comments | No | No | |||
| wotsk_act_elasped_time_uom | sql_variant | NULL | uom of actual elasped time | No | No | |||
| wotsk_act_misc_cost | numeric(28,8) | NULL | actual miscellaneous cost | No | No | |||
| wotsk_act_elasped_time_min | numeric(28,8) | NULL | actual elasped time in minutes | No | No | |||
| WOTSK_ACCESS_PANEL | varchar(15) | NULL | Acess Panel no | No | No | |||
| WOTSK_MODEL_NO | varchar(20) | NULL | Model No | No | No | |||
| WOTSK_OTHER_OBSERVATION | varchar(255) | NULL | Other Observation | No | No | |||
| wotsk_expense_type | sql_variant | NULL | Expense Type | No | No | |||
| wotsk_capex_propno | sql_variant | NULL | CapEx Proposal No. | No | No | |||
| wotsk_roster_code_flag | nvarchar(25) | NULL | No | No | ||||
| WOTSK_EXEC_PHASE | varchar(25) | NULL | No | No | ||||
| WOTSK_JOB_ID | int | NULL | No | No | ||||
| WOTSK_PARENT_TSK | varchar(30) | NULL | No | No | ||||
| WOTSK_RELATION_TYPE | varchar(25) | NULL | No | No | ||||
| Table Name hwo_wotwg_wo_task_work_grp | ||||||||
| Table Comment Work Group Assignment 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 | |||
| wotwg_assigneddate | datetime | NULL | Assigned Date | No | No | |||
| wotwg_hours_per_day | numeric(28,8) | NULL | Hours per day | No | No | |||
| wotwg_to_datetime | datetime | NULL | To Date | No | No | |||
| wotwg_from_datetime | datetime | NULL | From Date | No | No | |||
| wotwg_task_no | varchar(30) | NULL | Task Number | No | No | |||
| wotwg_assign_comments | varchar(255) | NULL | Assignment Comments | No | No | |||
| wotwg_timestamp | numeric(10) | NULL | Timestamp | No | No | |||
| wotwg_assigned_hrs | numeric(28,8) | NULL | Assigned Hours | No | No | |||
| wotwg_wo_no | varchar(40) | NOT NULL | Work Order Number | Yes | Yes | |||
| wotwg_seq_no | numeric(10) | NOT NULL | Sequence Number of the Task - Unique number for design purpose | Yes | Yes | |||
| wotwg_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | Yes | |||
| WOTWG_WORK_CENTRE | varchar(30) | NULL | No | No | ||||
| wotwg_work_group_no | varchar(20) | NULL | Work Group Code | No | No | |||
| WOTWG_ASSIGN_SEQNO | numeric(10) | NOT NULL | Yes | No | ||||
| wotwg_assign_seq_no | char(18) | NOT NULL | Yes | No | ||||
| Table Name hwo_wowgem_work_group_emp | ||||||||
| Table Comment Employee details of the work group | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| wowgem_ouinstance | numeric(10) | NOT NULL | ouinstance | Yes | Yes | |||
| wowgem_work_group | varchar(20) | NOT NULL | Work group | Yes | Yes | |||
| wowgem_emp_code | varchar(15) | NOT NULL | Employee Code | Yes | No | |||
| wowgem_emp_ou | numeric(10) | NULL | Employee OU | No | No | |||
| Table Name hwo_wowgrp_work_group | ||||||||
| Table Comment Work Group Master | ||||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |||
| wowgrp_ouinstance | numeric(10) | NOT NULL | ouinstance | Yes | No | |||
| wowgrp_work_group | varchar(20) | NOT NULL | work group | Yes | No | |||
| wowgrp_name | varchar(150) | NULL | work group name | No | No | |||
| wowgrp_work_centre | varchar(30) | NULL | work centre | No | No | |||
| wowgrp_wc_ou | numeric(10) | NULL | work centre ouinstance | No | No | |||
| wowgrp_group_category | varchar(25) | NULL | Work Group Category - Group Category quick codes which are in active status | No | No | |||
| wowgrp_group_leader | varchar(15) | NULL | Group leader of the work group | No | No | |||
| wowgrp_lead_skill | varchar(40) | NULL | Lead Skill | No | No | |||
| wowgrp_remarks | varchar(255) | NULL | Remarks | No | No | |||
| wowgrp_createddate | datetime | NULL | creation date | No | No | |||
| wowgrp_created_by | varchar(30) | NULL | created by | No | No | |||
| wowgrp_modifieddate | datetime | NULL | last modified Date | No | No | |||
| wowgrp_modified_by | varchar(30) | NULL | last modified by | No | No | |||
| wowgrp_timestamp | numeric(10) | NULL | timestamp | No | No | |||
| wowgrp_status | varchar(5) | NULL | Work Group status | No | No | |||
| wowgrp_no_of_emp | numeric(10) | NULL | Number of employees in the work group | No | No | |||
| WOWGRP_APPL_HANGAR | varchar(3) | NULL | Applicaplity Hanger | No | No | |||
| WOWGRP_APPL_LINE | varchar(3) | NULL | Applicaplity_line | No | No | |||