Choice of Yes/No, to indicate whether U/S block is applied. Text 62, to indicate the test position requirements.
Test 62, to indicate the test position requirements. Test 62, to indicate the test position requirements. Choice of Yes/No, to indicate if a sketch is attached. Choice field, to indicate the QA. standard.
Choice field, to indicate the QA. standard. Text field, to indicate other QA. standard. Text field, to indicate other QA. standard. Text field, for the general comment. Text field, for the general comment. Text field, for the general comment. Text field, for the general comment. Text field, for the general comment. 1-3-2 MP Status
(Already listed in Appendix 1.2) 1-3-3 Operations Description: 1. 2. MP_No. MP I 3. Seq. 4. Op_No. 5. Operation 6. Comment 7. Act 8. Prod Time
This relation is designed as the main sub-form for Manufacturing Plan. It records operational sequences, comments to each operation, QA control codes and production time.
Text of 5, the first identifier in the Manufacturing Plan relation.
Text of 1, Issue Letter, the second identifier in the Manufacturing Plan relation. (MP_No. and MP_I are used to group all the operations in one Manufacturing Plan.)
Number 2, for the line sequence number o f operations. Number 2, for the operation number.
Choice of operations.
Text 41, for comment on each operation. Text 3, to record QA control codes.
Appendix 1 Fields, Relations and their Definitions
1-3-4 Test_Units
Description: This relation is designed to record manufacturing plan test requirements. Several test requirements can be recorded in this relation and shown as a sub-form in Manufacturing Plan.
1. MP_No. Text o f 5, the first identifier in the Manufacturing Plan relation
2. MP_I Text of 1, Issue Letter, the second identifier in the Manufacturing Plan relation. (MP_No. and MP_I are used to group all the tests in one Manuf. Plan for the same MP_No. and MP_I.)
3. Test_No. Number, to indicate the test number.
(The composite of MP_No., MP_I and Test_No. can be used to identify each unique test required in the Manufacturing Plan.)
4. Tests Choice o f tests to be undertaken, 5. Unit Choice of units for each test. 6. Test_Com. Text o f 40, for each test comment. 1-3-5 RMCjScrap
Description: This relation records RMC (Raw Material Control) scrap codes. Each manufacturing plan needs to record RMC code to draw information in its relation for handling turning and scrapping o f forgings.
1. RMC Num.String 7, Primary key for each unique RMC record. 2. Scrap_Code Text of 4, to indicate the scrap code.
3. Turnings Text o f 4, to indicate the turnings code. 4. Comment Text o f 35, for any comment on the RMC. 1-4 Fields in the Relations in the Quality Plan planning Area 1-4-1 Quality Plans 1-4-1-1 Quality Plan Description: 1. QP_No. 2. QP_I 3. MP_I 4. Date_Edi 5. Initial 6. Discards 7. Insp._Notice 8. Insp.l 9. Insp.2 10. Insp.3 11. Insp.4
This relation is designed to record basic information in quality plan.
It is used as the main form which can be used to draw data from other relations. Other relations may have several records related to the record stored in this relation and these records are normally shown as sub-forms.
Text o f 5, the first identifier in this relation.
(It has the same value as the MP_No. to which the FEL Order Numbers are applied.)
Text of 1, the second identifier in this relation.
(the primary key is the composite field of QP_No. and QP_I to identify an unique record.)
The Manuf. Plan Issue at the time the Quality Plan was issued, (used to trace the historical issues of the Manuf. Plan.)
Date, to indicate the latest editing date.
Text of 15, to indicate the editing person's name. Text o f 18, to indicate the ingot discards required.
Text o f 18, to indicate the notice time to be given to the inspection authority. Text o f 4, to indicate the inspection authority 1.
Text o f 4, to indicate the inspection authority 2. Text o f 4, to indicate the inspection authority 3. Text o f 4, to indicate the inspection authority 4.
Appendix 1 Fields, Relations and their Definitions
1-4-1-2 QP_Status
(Already listed in Appendix 1.3) 1-4-1-3 QP_Operations
Description: This relation is designed as the main sub-form for Quality Plan. It records quality plan operational sequences, comments to each operation, document control and inspection instructions.
1. QP No. Text of 5, the first identifier in the Quality Plan. 2. QP_I Text o f 1, the second identifier in the Quality Plan.
(QP_No and QP_I are used to group all operations together in one Quality Plan.) 3. Seq. Number 2, for line sequence number for operations.
(Fields 1, 2 & 3 are used as the composite primary key in this relation.) 4. Op_No. Number, to indicate the operation number in Quality Plan.
5. Op_Comment Text o f 56, to show the operation and comment. 6. Docu._Ref. Text o f 18, to show the relevant reference document. 7. Docu._Rec. Text of 18, to show the record document.
8. Inspect 1 Text o f 4, to indicate the first inspection authority requirement for this operation. 9. Inspect2 Text o f 4, to indicate the second inspection authority requirement for this
operation.
10. Inspect3 Text o f 4, to indicate the third inspection authority requirement for this operation.
11. Inspect4 Text of 4, to indicate the fourth inspection authority requirement for this operation.
1-4-2 Forging Procedures
1-4-2-1 FP (Forging Procedure)
Description: This relation is designed to record forging procedures. It is used as the main form to draw information from other relations. It also records the manufacturing plan issue letter to which the forging procedure is issued in order to link these two plans together.
1. FP_No. Text o f 5, the first identifier in this relation.
(It has the same value as the MP_No. to which the FEL Order Numbers apply. 2. F P J Text of 1, the second identifier in this relation.
3. Letter Procedure Letter, the third identifier. (The composite o f FP_No., FP_I and Letter is the primary key in this relation.)
4. MP_I The Manuf. Plan Issue when the Quality Plan was issued. 5. Date_Edi Date, the latest editing date.
6. Initial Text of 15, to indicate the editing person's name. 1-4-2-2 FP Status
Description: This relation is used to record forging status such as identifiers, ST_No., Version and Ingot_No., that can uniquely identify each piece o f ingots to be forged. 1. FP_No.
2. F P J 3. Letter
Text of 5, the first identifier in the FP_Status. Text of 1, the second identifier in the FP_Status. Procedure Letter, third identifier in the FP_Status.
(The composite of FP_No., FP_I and Letter is used to group all the ingots in one Forging Procedure (FP).)
Appendix 1 Fields, Relations and their Definitions
4. ST_No. Num.String 6, the first identifier in the Steel Order. 5. Version Text o f 1, the second identifier in the Steel Order. 6. Ingot_No. Text of 1, showing the ingot number in the steel order.
(The composite of ST No., Version and Ingot_No. is the primary key in Ingot_Status relation.)
1-4-2-3 FP Comments
Description: This relation is designed as one of sub-forms for Forging Procedure. It records forging sequences and instructions.
1. FP No. Text of 5, the first identifier in the FP_Status. 2. F P J Text of 1, the second identifier in the FP_Status. 3. Letter Procedure Letter, the third identifier in the FP_Status.
(Those three fields are used to group all the comment records in one FP.) 4. Seq. Number, to indicate the line sequence number for the FP comments.
(Those four fields above can be used as the composite primary key in this relation.)
5. Comment Text of 56, for any comment on the procedure. 1-4-3 Heat Treatment Procedures
1-4-3-1 HTP (Heat Treatment Procedure) Description: 1. HTP_No. 2. H TPJ 3. Letter 4. M PJ 5. Date_Edi 6. Initial 7. Processes Description: 1. HTP_No. 2. HTP I 3. Letter
4. FEL Order No.
This relation is designed to record heat treatment procedures. It is used as the main form to draw information from other relations. It also records the manufacturing plan issuing to which the forging procedure is issued in order to link these two plans together.
Text of 5, the first identifier in the relation.
(Its value is generated from Manuf. Plan for the same target FEL Order Numbers.)
Text of 1, the second identifier in the relation. Procedure Letter, the third identifier in the relation.
(The composite of those three fields above is the primary key in this relation.) The Manuf. Plan Issue when the HTP was issued.
Date, showing the editing date.
Text of 15, showing the editing person's name. Text o f 14, to indicate the heat treatment processes. 1-4-3-2 HTP Status
This relation is used to record heat treatment status such as FEL Order Numbers that are grouped to go through the same heat treatment. Text of 5, the first identifier in the HTP.
Text o f 1, the second identifier in the HTP.
Text o f 1, procedure letter, the third identifier in the HTP.
(The composite of HTP_No., HTP_I and Letter is used to group all target FEL Order Numbers in one HTP.)
Num.String of 11, showing the target FEL Order No.(s).
(It is different from the FEL Order No. in Ingot_Status and is grouped in general for certain numbers according to the steel forging cast or cut.)
Appendix 1 Fields, Relations and their Definitions