串件管理2013-SORCSN SOR-010 LLD - Component Robberies Rev1 3

Component Robberies China Southern Airlines SOR-010 (PPC17) Low Level Design 2000-2005 VISaer, Inc. All Rights Reserved 100 Burtt Road, Andover, MA 01810 USA Phone: +1-978-570-1600 FAX: +1-978-570-1699 TABLE OF CONTENTS 1 HIGH-LEVEL DESIGN7 1.1 STATEMENT OF REQUIREMENT7 1.2 ASSUMPTIONS7 1.3 OPEN ISSUES8 1.4 FEATURES8 1.5 BUSINESS PROCESS/PROCEDURAL FLOW USE CASES9 1.6 FUNCTIONAL FLOW IMPLICATIONS AND CHANGES9 1.7 DATABASE IMPLICATIONS AND CHANGES10 2 DETAIL FUNCTIONAL DESIGN11 2.1 FUNCTIONS11 2.1.1 SYSTEM CONTROLLED NUMBERS (MC100QC.ASP)11 2.1.2 COMPONENTS AND ROTABLES MANAGEMENT MENU14 2.1.3 ROBBERY MAINTENANCE(TRIC0500.ASP)16 2.1.3 ROBBERY REMOVALS/INSTALLS26 2.1.6 ROBBERY INQUIRY (IQIC0500.ASP, IQIC0500FORM.ASP)27 2.2 LANGUAGE AND LOCALIZATION CHANGES30 2.3 MCBFILE LAYOUT ADDITIONS AND CHANGES30 2.4 REPORTING31 2.4.1 REPORTS filter look-aside will be on the ALTERNATE_PARTS table. -Status Default to O. Not enterable for a new record. -Notes Optional. -To Work Order the work order the part is being robbed for. Required entry; filter look-aside will be on the WIP table. SOR-010 Component Robberies五月 26, 2020 Design SpecificationPage: 17 2000-2005 VISaer, Inc. All Rights Reserved 100 Burtt Road, Andover, MA 01810 USA Phone: +1-978-570-1600 FAX: +1-978-570-1699 -From Work Order - the work order of the assembly the part is to be robbed from. Optional; but if entered, then From Assembly Part Number and From Assembly Serial Number must be left blank; filter look-aside will be on the WIP table. -From Assembly Part Number The assembly the robbed part is being robbed from. Required if From Work Order is blank. Issue error message if From Work Order is not blank (error message to be issued is “You can enter From Work Order or From Assembly Part Number/Serial Number, but not both.” ; filter look-aside will be on the ALTERNATE_PARTS table. -From Assembly Serial Number The serial number of the assembly the robbed part is being robbed from. Not required. Issue error message if From Work Order is not blank (error message to be issued is “You can enter From Work Order or From Assembly Part Number/Serial Number, but not both.” Filter look-aside will be on the SERIALISED_RECORDS table but the assembly part/serial does not have to be on SERIALISED_RECORDS. Programmers Notes: -The Robbery Control Number, whether the next number to be assigned by the system, or if manually entered, cannot already exist in the COMPONENT_ROBBERIES table for this entity. -Approved By field will accept any alphanumeric value entered by the user (no validations). -Default Station to User Login Station. -Part Number entered must be a valid ALTERNATE_PARTNO on the ALTERNATE_PARTS table. Note: the part/serial to be robbed does not have to exist in SERIALISED_RECORDS. The robbery may be for a non-configured part. -The To Work Order entered must be a valid open WORKORDERNO on the WIP_DETAILS table with WIP_DETAIL_STATUS not in (C,V). -Part numbers and Assembly Part Numbers entered must be a valid ALTERNATE_PARTNO on the ALTERNATE_PARTS table. Filter look-up will be on ALTERNATE_PARTS table. -If the From Work Order was entered, it must be a valid open WORKORDERNO on the WIP_DETAIL table (WIP_DETAIL_STATUS not in C,V). Get WIP_DETAILS via WORKORDERNO to retrieve the ALTERNATE_PARTNO and SERIALNO which represent the From Assembly Part Number and From Assembly Serial Number (which will be displayed on a successful add). If the From Assembly Part Number and Serial Number are entered, then the combination must exist in SERIALISED_RECORDS. Issue an error message that serialized records does not exist. Approved By field will accept any alphanumeric value entered by the user (no validations). The status will be system controlled. It will default to O (Open) when the component robbery record is added. SOR-010 Component Robberies五月 26, 2020 Design SpecificationPage: 18 2000-2005 VISaer, Inc. All Rights Reserved 100 Burtt Road, Andover, MA 01810 USA Phone: +1-978-570-1600 FAX: +1-978-570-1699 Employee verification screen will pop up when the component robbery record is added or updated manually (if the form is set up to prompt for employeeno/password in Forms Security). Programmers Note: Add the new record to the COMPONENT_ROBBERIES table as follows: Set COMPONENT_ROBBERY_CONTROL_NUMBER to the next number from Mmaster Ccontrol Next Robbery Control Number, if not manually entered, applying the prefix if Entity Prefix is Y. . Verify that the ROBBERY_CONTROL_NUMBER to be assigned does not already exist in COMPONENT_ROBBERIES. If it does, issue an error message. Set TO_WORKORDERNO to TOO Work Order entered by the user. Set ALTERNATE_PARTNO to the Part Number entered by the user. Set APPROVED_BY to the Approved By entered by the user. Set FROM_WORKORDERNO to FromROM Work Order entered by the user if entered. Set FROM_ASSY_PARTNO to FROM Assembly Part Number entered by the user. Set FROM_ASSY_SERIALNO to FromFROM Assembly Serial Number entered by the user. Set REM_SERIALNO to Serial Number entered by the user. Set ROBBERY_STATUS_CODE to O. Set ROBBERY_NOTES to Notes entered by the user. Employee verification screen will pop up when the component robbery record is added or updated manually (if the form is set up to prompt for employeeno/password in form security). Programmers Note: The CHANGED field for the screen TRIC0500 should be set up as A when the new SCREEN_HEADER record is created. A new record will be written to GENERAL_AUDITS for COMPONENT_ROBBERIES when the component robbery record is added. or its status is changed from Entered TABLE_NAME = COMPONENT_ROBBERIESWIP_DEFECTS AUDIT_INDEX = ROBBERY_CONTROL_NUMBERWORKORDERNO+ + ENTITY_CODE ACTION_CODE = AA AUDIT_INFORMATION = “New Record Added” After the ADD button is clicked, and if there are no errorscomponent robbery record is added, then keep the Robbery information on the form and display the display the description of the Part Number entered, the TO Work Orders information, and the FROM Work Orders information if From Work Order was entered. A/C Reg., description of the part entered, the status of the work order number entered, and the date/time of last status change on the Work Order entered. Programmers Notes: -Display the Part Description for the ALTERNATE_PARTNO by linking it to ALTERNATE_PARTS and then to PARTMASTER. -For the TO Work Order information, gGet the WIP_DETAILS record for the INSTO_WORKORDERNO via WORKORDERNO. If the SOURCE_TYPE of WIP_DETAILS is in (LP,NR,SS,SC,SP), then link the AIRCRAFT_PARTNO, SERIALNO of WIP_DETAILS to TAIL_NOS and display the FULL_REG in the To A/C Reg field. If the SOURCE_TYPE of WIP_DETAILS is not in (LP,NR,SS,SC,SP) then display the ALTERNATE_PARTNO and SERIALNO of WIP_DETAILS in the To Assembly Part Number and Assembly Serial Number fields. Display the A/C Reg. field as blank. SOR-010 Component Robberies五月 26, 2020 Design SpecificationPage: 19 2000-2005 VISaer, Inc. All Rights Reserved 100 Burtt Road, Andover, MA 01810 USA Phone: +1-978-570-1600 FAX: +1-978-570-1699 . and display the assembly part number and assembly serial number fields as blank.If the SOURCE_TYPE of WIP_DETAILS is not in (LP,NR,SS,SC,SP) then display the ALTERNATE_PARTNO and SERIALNO of WIP_DETAILS in the Assembly Part Number and Assembly Serial Number fields. Display the A/C Reg. field as blank. Display the Part Description for the REM_ALTERNATE_PARTNO by linking it to ALTERNATE_PARTS and then to PARTMASTER. Display the WIP_DETAIL_STATUS in the Work Order Status field (O-Open, C- Complete, D-Deferred, V-Voided, S-Scheduled, I-Incomplete). Just display the status description, not the code. Format TIMESTAMP of WIP_DETAILS and display as date and time. -If the From Work Order was entered, get the WIP_DETAILS record via WORKORDERNO for the FROM_WORKORDERNO If the SOURCE_TYPE of WIP_DETAILS is in (LP,NR,SS,SC,SP), then link the AIRCRAFT_PARTNO, SERIALNO of WIP_DETAILS to TAIL_NOS and display the FULL_REG in the From A/C Reg field, and display the Assembly Part Number and Assembly Serial Number fields as blank. If the SOURCE_TYPE of WIP_DETAILS is not in (LP,NR,SS,SC,SP) then display the ALTERNATE_PARTNO and SERIALNO of WIP_DETAILS in the From Assembly Part Number and Assembly Serial Number fields. Display the A/C Reg. field as blank. Display the WIP_DETAIL STATUS in the Work Order Status field (O-Open, C- Complete, D-Deferred, V-Voided, S-Scheduled, I-Incomplete). Just display the status description, not the code. Format TIMESTAMP of WIP_DETAILS and display as date and time. -If the From Work Order was NOT entered, get the WIP_DETAILS record via ALTERNATE_PARTNO and SERIALNO using the From Assembly Part/Serial and, if found and the WIP_DETAIL_STATUS is not C or V, populate the FROM_WORKORDERNO field, and Display the From Work Order on the form. Display the WIP_DETAIL STATUS in the Work Order Status field (O-Open, C- Complete, D-Deferred, V-Voided, S-Scheduled, I-Incomplete). Just display the status description, not the code. Format TIMESTAMP of WIP_DETAILS and display as date and time. If the SOURCE_TYPE of WIP_DETAILS is in (LP,NR,SS,SC,SP), then link the AIRCRAFT_PARTNO, SERIALNO of WIP_DETAILS to TAIL_NOS and display the FULL_REG in the From A/C Reg field. If there are no errors, aA new component robbery record will be added when the user clicks the ADD icon. Add the new record to the COMPONENT_ROBBERIES table as follows: -Set ROBBERY_CONTROL_NUMBER to the next number from Master Control Next Robbery Control Number, if not manually entered, applying the prefix if Entity Prefix is Y. -Set ALTERNATE_PARTNO to the Part Number entered by the user. -Set APPROVED_BY to the Approved By entered by the user. -Set FROM_WORKORDERNO to From Work Order entered by the user or determined by the program if the From Assembly Part Number and From Assembly Serial Number were entered. SOR-010 Component Robberies五月 26, 2020 Design SpecificationPage: 20 2000-2005 VISaer, Inc. All Rights Reserved 100 Burtt Road, Andover, MA 01810 USA Phone: +1-978-570-1600 FAX: +1-978-570-1699 -Set FROM_ASSY_ALT_PARTNO to From Assembly Part Number entered by the user, or determined by the program if the From Work Order was entered. -Set FROM_ASSY_SERIALNO to From Assembly Serial Number entered by the user. or determined by the program if the From Work Order was entered. -Set ROBBERY_STATUS_CODE to O. -Set ROBBERY_NOTES to Notes entered by the user. -Set TO_WORKORDERNO to TO Work Order entered by the user. -A new record will be written to GENERAL_AUDITS for COMPONENT_ROBBERIES when the component robbery record is added. -TABLE_NAME = COMPONENT_ROBBERIES AUDIT_INDEX = ROBBERY_CONTROL_NUMBER + ENTITY_CODE ACTION_CODE = A AUDIT_INFORMATION = “Component Robbery Added. Status Open.” The sub functions To Work Order and From Work Order will take the user to Aircraft Defects Inquiry, Aircraft Check Inquiry, or Work Accomplishment Inquiry depending on the work order being a defect, check, log page, or rotable shop order. The sub function for Audit Trail will take you to the General Audits form for the ROBBERY_CONTROL_NUMBER/ENTITY_CODE of COMPONENT_ROBBERIES. SOR-010 Component Robberies五月 26, 2020 Design SpecificationPage: 21 2000-2005 VISaer, Inc. All Rights Reserved 100 Burtt Road, Andover, MA 01810 USA Phone: +1-978-570-1600 FAX: +1-978-570-1699 Aircraft Defect Inquiry (iqln1000qc): SOR-010 Component Robberies五月 26, 2020 Design SpecificationPage: 22 2000-2005 VISaer, Inc. All Rights Reserved 100 Burtt Road, Andover, MA 01810 USA Phone: +1-978-570-1600 FAX: +1-978-570-1699 Aircraft Check Inquiry (iqoh1000qc): SOR-010 Component Robberies五月 26, 2020 Design SpecificationPage: 23 2000-2005 VISaer, Inc. All Rights Reserved 100 Burtt Road, Andover, MA 01810 USA Phone: +1-978-570-1600 FAX: +1-978-570-1699 Work Accomplishment Inquiry(iqwa0101qc): SOR-010 Component Robberies五月 26, 2020 Design SpecificationPage: 24 2000-2005 VISaer, Inc. All Rights Reserved 100 Burtt Road, Andover, MA 01810 USA Phone: +1-978-570-1600 FAX: +1-978-570-1699 Log Page Inquiry (iqln2001qc): SOR-010 Component Robberies五月 26, 2020 Design SpecificationPage: 25 2000-2005 VISaer, Inc. All Rights Reserved 100 Burtt Road, Andover, MA 01810 USA Phone: +1-978-570-1600 FAX: +1-978-570-1699 Robbery Maintenance Display/Update: Allow retrieval of existing Component Robbery records via: Robbery Control Number Part Number Station To Work Order To A/C Reg via TAIL_NOS (AIRCRAFT_PARTNO, AIRCRAFT_SERIALNO), to WIP_DETAILS (AIRCRAFT_PARTNO, AIRCRAFT_SERIALNO), to COMPONENT_ROBBERIES (TO_WORKORDERNO). From Work Order From A/C Reg via TAIL_NOS (AIRCRAFT_PARTNO, AIRCRAFT_SERIALNO), to WIP_DETAILS (AIRCRAFT_PARTNO, AIRCRAFT_SERIALNO), to COMPONENT_ROBBERIES (FROM_WORKORDERNO). FROM Work Order. From Assembly Part Number From Assembly Serial Number Display the current description for the status of an existing Component Robbery record as follows: O = Open C = Closed X = Cancelled If the Status of the Component Robbery changes when the record is updated, a General Audits record will be written to record the change in status. Programmers Note: -A new record will be written to GENERAL_AUDITS when the component robbery record status is updated. TABLE_NAME = COMPONENT_ROBBERIES AUDIT_INDEX = ROBBERY_CONTROL_NUMBER + ENTITY_CODE ACTION_CODE = U AUDIT_INFORMATION = “Component Robbery status is .” Ie: Open, Closed or Cancelled. . Allow changes to the fields Part Number, sAapproved Bby, Tto Wwork Oorder, Ffrom Wwork Oorder, From Assembly Part Number, From Serial Number, and Robbery Notes while the status is O. All edits done during entry will be applied again to validate any change to these fields. Programmers Note: A new record will be written to GENERAL_AUDITS when the component robbery record is updated. TABLE_NAME = COMPONENT_ROBBERIES AUDIT_INDEX = ROBBERY_CONTROL_NUMBER + ENTITY_CODE ACTION_CODE = U AUDIT_INFORMATION = “Component Robbery is updated.” The Status may be updated to Closed when a replacement part is found to install in place of the part robbed. The Component Robbery Record will be updated manually after the part is installed using the regular install transactions. In order to change the status to Closed, both SOR-010 Component Robberies五月 26, 2020 Design SpecificationPage: 26 2000-2005 VISaer, Inc. All Rights Reserved 100 Burtt Road, Andover, MA 01810 USA Phone: +1-978-570-1600 FAX: +1-978-570-1699 the FROM (if not blank) and TO Work Orders must be signed off. It will be the responsibility of the planner to make sure that the robbed part and replacement parts are installed on the FROM and TO Work Orders. No further changes to a Closed Component Robbery record will be permitted except to change the Status again, which may have been set to Closed in error. Programmers Note: -When the user sets the status to Closed and updates, gray out all fields on the robbery maintenance screen except for the Status field. -If the FROM_WORKORDERNO is blank, then allow the status to be updated to Closed if the TO_WORKORDERNO has WIP_DETAIL_STATUS = C. Issue error message The To Work Order must be signed off to close the robbery. -If the FROM_WORKORDERNO is not blank, then check the WIP_DETAIL_STATUS of WIP_DETAILS of both the FROM_WORKORDERNO and TO_WORKORDERNO and allow the ROBBERY_STATUS_CODE to be changed to C (Closed) if they are both = C (Complete). Issue an error message Both the From and To Work Orders must be signed off to close the robbery. If the user tries to close the robbery and the work order(s) are not signed off. Users will be able to set the status of the component robbery record to X (Cancelled). No further changes to a Cancelled Component Robbery record will be permitted except to change the Status again, which may have been set to Cancelled in error. Programmers Note: -When the user sets the status to Cancelled and updates, gray out all fields on the robbery maintenance screen except for the Status field. If a robbery has been closed or cancelled, users will still have access to the Status field to reset the status to Open, Closed or Cancelled in case the status was changed in error. General Audits will be written every time the status is changed. 2.1.3 Robbery Removals/Installs Robbery Removals will be done with Action Code of Remove Serviceable. It is advised that a removal reason code for robbery removals be set up (e.g. RR) and entered in the Removal Reason Code field. Robbery Installs will be done like regular installs. SOR-010 Component Robberies五月 26, 2020 Design SpecificationPage: 27 2000-2005 VISaer, Inc. All Rights Reserved 100 Burtt Road, Andover, MA 01810 USA Phone: +1-978-570-1600 FAX: +1-978-570-1699 2.1.6 Robbery Inquiry (iqic0500.asp, iqic0500form.asp) iqic500.asp: SOR-010 Component Robberies五月 26, 2020 Design SpecificationPage: 28 2000-2005 VISaer, Inc. All Rights Reserved 100 Burtt Road, Andover, MA 01810 USA Phone: +1-978-570-1600 FAX: +1-978-570-1699 Using the inquiry screen provided above users will be able to filter out component robbery records and display them in the grid format. They will then be able to drill down to the component robbery details. Users will not be able to modify any data displayed on the inquiry screens. Programmers Note: -Display the following fields in the grid with hyperlink on the ROBBERY_CONTROL_NUMBER. -ROBBERY_CONTROL_NUMBER -ROBBERY_STATUS_CODE -ALTERNATE_PARTNO -TO_WORKORDERNO - WIP_DETAIL_STATUS of the TO_WORKORDERNO -A/C REG for the TO_WORKORDERNO - link to TAIL_NOS by AIRCRAFT_PARTNO, AIRCRAFT_SERIALNO on the WIP_DETAILS record for the TO_WORKORDERNO -FROM_WORKORDERNO -WIP_DETAIL_STATUS of the FROM_WORKORDERNO -STATION -A/C REG for the FROM_WORKORD