Fields, Relations and their Definitions 1-4-3-3 HTP Comments

Description: 1. HTP_No. 2. HTP_I 3. Letter 4. Seq. Stage Heat_Rate Tempi Temp2 Hold_l 10. Medium 11. Cool_rate 12. Q_Time 13. Cool_Tol 14. Cool_To2 15. Hold_2 16. Remarks

This relation is designed as one o f sub-forms for Heat Treatment Procedure. It records all heat treatment cycles and comments.

Text o f 5, the first identifier in the HTP. Text o f 1, the second identifier in the HTP.

Text of 1, procedure letter, the third identifier in the HTP.

(The composite of those fields above is used to group all comments in one HTP.) Num. string of 2, Line Sequence number.

(Those four fields above can be used as the composite primary key in this relation.)

Number, showing the stage o f the heat treatment process. Text o f 6, showing the heating rate in 0 C/HR.

Text of 4, showing the Min. temperature to reach. Text o f 4, showing the Max. temperature to reach.

Number, showing the holding hours at the above temperature range. Choice o f cooling medium.

Text of 6, showing the cooling rate in ° C/HR. Text o f 5, showing the quench time to be taken. Text of 4, showing the Min. temperature to cool. Text o f 4, showing the Max. temperature to cool.

Number, showing the holding hours at the above temperature range. Text o f 56, for comment on the heat treatment.

1-4-4 Clean, Packing and Protection Procedures 1-4-4-1 CPP (Clean, Packing and Protection Procedure)

Description: This relation is designed to record Clean, Packing and Protection (CPP)

Procedures. It is used as main the form to draw information from other relations. It also records the manufacturing plan issuing to which the CPP procedure is issued in order to link these two plans together.

Text of 5, the first identifier in the CPP procedure. It has the same value as the MP_No. that the FEL Order Numbers apply.

Text o f 1, the second identifier in the CPP procedure.

(The composite of CPP_No. and CPP_I is the primary key in this relation.) The Manuf. Plan Issue when the CPP was issued.

Date, showing the editing date.

Text o f 15, showing the latest editing person's name. 1-4-4-2 CPP Comments

Description: This relation is designed as a sub-form for CPP Procedure. It records all sequence and instructions for the CPP Procedure.

1. CPP_No. Text of 5, the first identifier in the CPP. 2. CPP_I Text o f 1, the second identifier in the CPP.

(Those two fields are used to group all comments in one FP Procedure.) 3. Seq. Line sequence number.

(Those three fields above can be used as the composite primary key in this relation.)

4. Comment Text of 56, for the CPP comment. 1. CPP_No.

2. CPP_I 3. MP_I 4. Date_Edi 5. Initial

Appendix 1 Fields, Relations and their Definitions

1-4-5 Mechanical Testing Procedures 1-4-5-1 MT (Mechanical Testing Procedure)

Description: This relation is designed to record Mechanical Testing (MT) Procedures. It isused as the main form to draw information from MT_Comments. It also records the manufacturing plan issuing to which the MT Procedure is issued in order to link these two plans together.

1. MT_No. Text o f 5, the first identifier in the MT procedure. Its value is same as the MP_No.

that the FEL Order Numbers apply.

2. MT_I Text of 1, the second identifier in the MT procedure.

(The composite of MT_No. and MT_I is the primary key in this relation.) 3. MP_I The Manuf. Plan Issue when the MT was issued.

4. Date_Edi Date, showing the editing date.

5. Initial Text o f 15, showing the latest editing person's name. 1-4-5-2 M TCom m ents

Description: This relation is designed as sub-form for MT Procedure. It records all sequence and instructions for the MT Procedure.

1. MT_No. Text of 5, the first identifier in the MT procedure. 2. MT_I Text of 1, the second identifier in the MT procedure.

(These two fields are used to group all comments in one FP Procedure.) 3. Seq. Integer number, to indicate line sequence number.

(These three fields above may be used as the composite primary key in this relation.)

4. Comment Text of 56, to show the MT comment. 1-4-6 Special Procedures

1-4-6-1 SP (Special Procedure)

Description: This relation is designed to record Special Procedures. It is used as main form to draw information from other relation such as SP_Comments. It also records the manufacturing plan issue to which the Special Procedure is issued in order to link these two plans together.

1. SP_No. Text of 5, the first identifier in the SP procedure. Its value is taken from MP_No. to which the FEL Order Numbers apply.

2. SP_I Text of 1, the second identifier in the SP procedure.

(The composite of SP_No. and SP_I is the primary key in this relation.) 3. MP_I The Manuf. Plan Issue number when the SP is issued.

4. Date_Edi Date, showing the latest editing date.

5. Initial Text of 15, showing the latest editing person's name. 1-4-6-2 SP Comments

Description: This relation is designed as sub-form for SP Procedure. It records all sequence and instructions for the special procedure.

Appendix 1 Fields, Relations and their Definitions

1. SP_No. Text of 5, the first identifier in the SP procedure. 2. SP_I Text o f 1, the second identifier in the SP procedure.

(These two fields are used to group all comments in one SP Procedure.) 3. Seq. Integer number, to indicate line sequence number.

(These three fields above may be used as the composite primary key in this relation.)

4. Comment Text of 56, to show the SP comment. 1-4-7 Control Document Status Lists

1-4-7-1 CDSL (Control Document Status List)

Description: This relation is designed to record Control Document Status Lists. It is used as the main form to draw information from other relation such as

CDSL_Comments. It also records the manufacturing plan issuing to which the CDSL Procedure is issued in order to link these two plans together.

1. CDSL_No. Text of 5, the first identifier in the CDSL procedure. Its value is taken from the MP_No. to which the FEL Order Numbers apply.

2. CDSL_I Text of 1, the second identifier in the CDSL.

(The composite o f CDSL_No. and CDSL_I is the primary key in this relation.) 3. MP_I The Manuf. Plan Issue when the CDSL was issued.

4. Date_Edi Date, showing the latest editing date.

5. Initial Text of 15, showing the latest editing person's name. 1-4-7-2 CDSL Comments Description: 1. 2. CDSL_No. CDSL I 3. Seq. 4. Document 5. Title 6. Revision

This relation is designed as a sub-form for CDSL Procedure. It records all related documents, document titles and revision status.

Text o f 5, the first identifier in the CDSL. Text o f 1, the second identifier in the CDSL.

(These two fields are used to group all the records in one CDSL Procedure.) Integer number, to indicate line sequence number.

(These three fields above may be used as the composite primary key in this relation.)

Text of 20, showing the name of the documents listed. Text of 40, showing the document title.

Text of 12, showing the issue of the revision. 1-5 Fields in the Relations in the Steel Order Plan Planning Area 1-5-1 Steel Orders 1-5-1-1 Steelord Description: 1. 2. ST_No. Version

This relation records the main part o f Steel Order information. It indicates the approval of the Steel Order, the current related Manufacturing Plan, and the designed melting range.

Num.String 6, the first identifier in this relation. Text o f 1, the second identifier in this relation.

Appendix 1 Fields, Relations and their Definitions