OdysseyGPT

Free template

Nuclear quality record index: record control and retention for one item (Excel and CSV)

For suppliers of nuclear-safety-related equipment: every quality record for one item, with the purchaser's clause, retention class, internal approval, purchaser review status and filing location.

By Ademola Afolabi, Founder, New Odyssey Ltd · Last reviewed:

The short answer

A quality record index lists every quality record for one item and shows who approved it, how long it is kept and where it is filed. This free Excel template has one row per record type: document number and revision, the purchaser's clause, the retention class the purchaser specifies, the approver, the purchaser's review status and location.

Key Takeaways

  • Retention comes from the purchaser's specification. The template has no periods of its own.
  • Each record needs a named approver inside your organisation before it goes to the purchaser.
  • Records that stay at your works, such as calibration records, still belong on the index.
  • The example has 13 record types for an invented heat exchanger order (PO-EX-6105), one of them rejected by the purchaser.

Download the nuclear quality record index

Both files are free under CC BY 4.0, with no form to fill in. The XLSX opens in Excel, Google Sheets, LibreOffice and Numbers. The CSV carries the table only; the header block is in the XLSX.

Records that outlast the order

On a nuclear order the records are part of the delivery, and some must stay retrievable for decades. Purchasers that work to a quality programme standard such as ASME NQA-1 pass its record requirements to suppliers through their own quality specification: which records, who approves them, which the purchaser reviews, and how long each is kept. This index is where a supplier writes those answers down, record by record, for a single item. Start it at order review, when the specification is read, and keep it current until the certificate of conformance is signed.

  • Records controllers and document controllers, who keep the index.
  • Quality managers, who approve it and sign the certificate at the end.
  • Purchasers' quality surveillance engineers, who use it to see what is still to be submitted.

It is a different tool from the MRB index template. The MRB index is the contents page of a record book: sections, page counts and the tags or heats each document covers. The record index is about control: approval, purchaser review, retention and location, including records that never go into the book. Many nuclear orders need both. Retention rules vary by purchaser, country and regulator. Check the governing standard or contract. See also nuclear equipment manufacturers.

Header block

Header block fields, with the invented example values
FieldExample
ProjectExample Nuclear Plant Auxiliary System (fictional)
PurchaserExample Nuclear Operator Ltd (fictional)
Purchase orderPO-EX-6105 (fictional)
ItemHeat exchanger HX-6105, classed as safety-related by the purchaser (fictional)
Purchaser's quality specificationQS-EX-N-01 Rev 3 (invented)
Quality programme standard named in the orderAs stated in the PO (for example ASME NQA-1), with its edition
Retention classesClass L and Class T, as defined in QS-EX-N-01 section 12 (invented purchaser classes)
Record index no.QRI-EX-6105
RevisionB
Date2027-07-30
Prepared byRecords controller
Approved byQuality manager

Example records: a safety-related heat exchanger

Invented example rows for order PO-EX-6105
No.Record typeDocument no. and revRequirement sourceRetention class as the purchaser specifiesApproved byPurchaser review statusLocation in the packageRemarks
1Certificate of conformanceCoC-EX-6105QS-EX-N-01 12.1Class L (purchaser's own class, invented)Quality managerNot submittedSection 1Signed last, when every record below is accepted.
2Inspection and test plan, signed off at each pointITP-EX-6105 Rev CQS-EX-N-01 5.1Class L (purchaser's own class, invented)Quality engineerAcceptedSection 2, pp. 1-9
3Certified material test reportsCMTR-EX-6105-01 to -14 Rev 0QS-EX-N-01 6.2Class L (purchaser's own class, invented)Quality engineerAcceptedSection 3, pp. 1-41
4Material traceability listMTL-EX-6105 Rev BQS-EX-N-01 6.4Class L (purchaser's own class, invented)Quality engineerAcceptedSection 3, pp. 42-44
5Welding records: procedures, qualification records, welder qualifications and weld logWR-EX-6105 Rev AQS-EX-N-01 7.1Class L (purchaser's own class, invented)Welding engineerSubmittedSection 4Sent 2027-07-12. No answer yet.
6Heat treatment charts and furnace recordsHT-EX-0098 Rev 0QS-EX-N-01 7.4Class L (purchaser's own class, invented)Welding engineerAcceptedSection 5, pp. 1-6
7Non-destructive examination (NDE) reports, with examiner qualificationsNDE-EX-0611 to -0629 Rev 0QS-EX-N-01 8.1Class L (purchaser's own class, invented)NDE supervisorAccepted with commentSection 6The purchaser asked for the radiograph interpretation sheets to be added. Reissue the set.
8Pressure test recordPT-EX-6105QS-EX-N-01 9.1Class L (purchaser's own class, invented)Test engineerNot submittedSection 7Test planned for 2027-08-12. Purchaser hold point.
9Dimensional and final inspection reportsFIR-EX-6105QS-EX-N-01 9.3Class L (purchaser's own class, invented)Quality engineerNot submittedSection 8After the pressure test.
10Nonconformance reports with dispositionsNCR-EX-0044, NCR-EX-0051 Rev 1QS-EX-N-01 11.2Class L (purchaser's own class, invented)Quality managerRejectedSection 9NCR-EX-0051: the purchaser rejected the use-as-is disposition and asked for a repair proposal.
11Calibration records for the measuring and test equipment usedList CAL-EX-6105 with certificates Rev AQS-EX-N-01 10.1Class T (purchaser's own class, invented)Metrology supervisorNot requiredKept at works, records store R2Available at audit. Not sent with the package.
12Cleaning, preservation and packing recordsCPP-EX-6105QS-EX-N-01 13.2Class T (purchaser's own class, invented)Quality engineerNot submittedSection 10Raised at dispatch.
13Data report, where the design code named in the order requires oneDR-EX-6105QS-EX-N-01 12.1; design code named in the POClass L (purchaser's own class, invented)Quality managerNot submittedSection 1The form, and who signs it, come from the design code. Check the governing code.

Class L and Class T are retention classes of an invented purchaser, defined in an invented specification (QS-EX-N-01). They are not taken from NQA-1 or from any regulator, and the example gives no retention period in years. Every example value is invented: the project, customer, bidders, purchase order, prices and every document, certificate, serial and report number do not exist. Standards are named but not quoted.

Purchaser review status values

StatusUse it when
Not submittedThe record exists or is still to come, and the purchaser has not been sent it.
SubmittedSent to the purchaser, with no answer yet.
AcceptedThe purchaser has accepted the record as it stands.
Accepted with commentAccepted, with a comment to deal with. Say in the remark what the comment asks for.
RejectedThe purchaser has sent the record back. It has to be corrected and submitted again.
Not requiredThe purchaser's specification does not ask to review this record. It is still kept.

Columns and what to write

ColumnWhat to write
No.Running number of the record or record set.
Record typeWhat the record is, in the words the purchaser's specification uses.
Document no.The record's number, or the first and last number of a set.
RevThe revision held as the record.
Requirement sourceThe clause of the purchaser's specification, or of the purchase order, that asks for the record.
Retention class as the purchaser specifiesThe class or period the purchaser's specification gives this record, with the clause. Copy it from the purchaser's document. Do not enter a period from memory of a standard or a regulation.
Approved byThe role that approved the record inside your organisation.
Purchaser review statusNot submitted, Submitted, Accepted, Accepted with comment, Rejected or Not required (drop-down). Rejected rows turn red; Accepted with comment rows amber.
Location in the packageThe section and page range of the quality record package, or where the record is kept if it stays at your works.
RemarksWhat is open on the record, and what closes it.

How to keep the index

  1. Fill in the header block: the item, the purchaser's quality specification with its revision, and the quality programme standard and edition the order names.
  2. Read the records section of the purchaser's specification and list every record type it asks for, one row each, with the clause in Requirement source.
  3. Copy the retention class or period for each record from the purchaser's specification into the retention column, with its clause. If the specification is silent, ask the purchaser in writing. Do not fill the cell from another project.
  4. As each record is produced, enter its number and revision and the role that approved it. A record nobody approved is not yet a record.
  5. Set the purchaser review status when a record is submitted and again when the answer comes back. Rejected rows turn red and Accepted with comment rows amber.
  6. Enter where each record sits in the package, or where it is kept if it stays at your works.
  7. Before the certificate of conformance is signed, filter the review column for anything other than Accepted or Not required, and close each row.
  8. Keep the approved index with the records for as long as the longest retention class on it.

Checking the package against the purchaser's record requirements

Before the package is submitted, somebody has to confirm that each record the specification lists is present, at the right revision, and says what the index claims. In OdysseyGPT's Handover & MRB module, MRB Readiness Check (beta) reads the purchaser's document requirements and the records on file and reports what is absent or inconsistent, with page citations. MRB Compiler (beta) assembles the accepted records into the package order. Approval of each record stays with your quality organisation. Tools marked beta are open on request, and we onboard each team ourselves.

Want us to run the check for you?

Send your MRB index and the customer's document requirements. We send back an MRB readiness report: what is in place, what is missing and what does not match.

Get the free MRB readiness report

New templates by email (optional)

Your download does not depend on this.

We use your email only for this. See our privacy policy.

Frequently asked questions

What are quality records on a nuclear order?

The documents that show an item was made, inspected and tested as required: material test reports, welding and NDE records, heat treatment charts, test records, nonconformance reports, calibration records and the certificate of conformance, among others. The purchaser's specification lists the ones it wants.

How long must nuclear quality records be kept?

For as long as the purchaser's specification and the applicable regulations say, which differs between purchasers and countries. Take the class or period from the purchaser's document and write its clause beside it. Check the governing standard or contract.

Is this the same as a manufacturing record book index?

No. A record book index lists what is in the book and on which pages. This index tracks approval, purchaser review, retention and filing location for each record, whether or not it is in the book.

Does the template follow NQA-1?

It is a general layout and makes no claim of conformity with any standard. Your quality programme and the purchaser's specification decide what the index must contain. Add or rename columns to suit them.

Where does the data report go?

Where the design code named in the order requires one, list it as its own record. The code sets the form and who signs it, so check the code itself.

References

Creative Commons Attribution 4.0 International

Creative Commons

Visit source

Related Pages