Master List - Does anyone have an equivalent method that they would care to share?

#1
Master List

QS states; "A master list or equivalent documentation control procedure identifying the current revision status of documents shall be established . . . ."
A master list seems to be the choice that most people pick, however; does anyone have an equivalent method that they would care to share? And how would it be made readily available to operators.
 
Elsmar Forum Sponsor
L

Laura M

#2
An on-line look-up of the actual document. In other words, if a print is out in a tool shop, the employees don't go to a master list, but to a terminal, look up the rev level on the actual drawing - is one example.
No need for a master list.

We also had a documentation control area which held process specifications. The master document in the file was the "master list." If new ones were issued to the floor, the manufacturing area had to remove the old. If there was a question of a document on the floor, the master file in the documentation control area served as the "master list." There were thousands of part numbers, so to keep a master list would have been a redundant waste of time.
Further control on those documents was the engineering rev level which the doc center could look up on line if there was further question. The only list kept was a log of what was issued to the floor when. This was a record of change in addition to a quick look up.

I'd be interested in other schemes too. The creation of a master list is some cases seems like a big waste of time.
 
A

AJPaton

#3
One of the schemes here is an electronic ECO tracking system. All parts are on the system, along with information about pending ECO effectivity dates for Engineering, Document Control, Materials and Production.
Type in a part #, get the associated drawing # and the last ECO's effectivity dates, along with the revision level.
Nice, since you also get a warning about prospective changes.
AJP
 

pbojsen

Involved In Discussions
#4
Re: Master List - Does anyone have an equivalent method that they would care to share

Well, this is a very old thread, but I have to reply anyway since Document Control is my primary job at this time.

"Document Control" is an FDA requirement, and makes good business sense as well. It is difficult to control a document if you don't know what the most current revision is. It is also difficult to control your documents if you don't really know "what" and "how many" you really have. This is especially true if you're going to migrate to an electronic system. How will you know when you're finished? Are you sure you got them all?

A Master Document Register can be as simple as an Excel spreadsheet, which is what we're currently using. The information is put in when an ECO is processed. Everyone can read it, but only Doc Control can write to it.

We have tabs for DMRs, drawings, components, forms, protocols, reports, customer supplied documents, etc. - all controlled documents, all in the same spreadsheet.

It is SO MUCH faster to look at a MDR that you know is correct and current than to have to try to find - either on the PC or physically - a document that can very well be misplaced, misfiled, at the wrong revision, or just missing. It's also very easy to search to see if there already exists a document that you need, or are thinking of creating because you don't know it's there, and everyone else forgot about it too. This is easy to do if you have enough documents.

Electronic systems make this easier as most of them will have an automatically created MDR.

So, what's in our MDR? We have the following fields:

Doc number, Doc title, revision, Customer's doc number if applicable, last author, date of last revision, customer name, and engineering project file number. Most of this doesn't change, so you put it in one time only. We also change the text to red if the document or component has been obsoleted. It's very easy to see what's been obsoleted, which has come in handy many times when engineers are researching documentation.
 
Q

qualitychic

#5
Re: Master List

I would use a simple Excel spreadsheet that is accessible for everyone. However, the key is to only allow read-only access. The only one who will have a full access will be the document controller.
 
V

vandenbar

#6
Re: Master List - Does anyone have an equivalent method that they would care to share

I'm at a relatively small facility so distribution and training are pretty easy to keep control of, but this is the document that I use. I have about 4 in an excel file, one for procedures, work instructions, lab wki, external documents.
 

Attachments

Russ

Quite Involved in Discussions
#7
Re: Master List - Does anyone have an equivalent method that they would care to share

Our system documentation is kept in a QM folder and floor documents are kept in our "Master Production Documents" folder. We control our QM documents with a database, the floor documents are controlled by Engineering and only the latest & greatest reside in the "MPD" folder. It's working very well and allows quick changes of QM documents with good tracking of: what, who, when, & why!:agree1:
 

pbojsen

Involved In Discussions
#8
Re: Master List - Does anyone have an equivalent method that they would care to share

Vandenbar, that is a pretty decent MDR for a small company.

I noticed that you also have a distribution matrix. I remember those days, and not happily. When I first came to my current company, we too had paper copies of documents all over the place. The frustrating part was during audits when we found that some people had stashed old revisions of the documentation in their desks and were using them. That, of course, is a "no no" but they did it anyway. That happens in lots of companies. If it was an external audit, we got a finding. Mostly, we got them on internal audits. I have also spent a lot of time replacing those paper copies and once again telling people not to keep personal copies of specs. There had to be a better way without spending thousands of dollars on an electronic document management system (EDMS) to organize and control the distribution of documentation.

Having worked in a couple of larger medical device and pharma companies that had an EDMS, what I did was have our Doc Control procedures mimic an EDMS. We have each doctype (DMR, BOM, work instruction, SOP, component spec - all controlled documents) each in their own folder on a common drive on the computer. Everyone has access to read, but only Document Control can add, revise, or delete these documents. The native formats (Word, Excel, Pro-E, etc.) have been either scanned in or transformed to PDF so they are not alterable, and kept on a separate drive accessible only by Doc Control. Only Doc Control has full Adobe, so nobody else can revise the PDFs.

This has made the use of these specifications SO MUCH easier and user-friendly. Gone are the days of misfiled and lost specs, and having to go around finding and replacing documents and drawings. Everyone knows where they are and can bring them up fast. If a spec needs to be revised, then the engineer gets the native format to change. We also mimic the check in and check out functionality of an EDMS. We're just using Explorer as an EDMS, pretty much. We also now only have one paper original of the document that is vaulted for disaster recovery purposes.

This has also sped up the ECO process tremendously from around 3 weeks to less than a day from creation to implementation. Not too shabby.
 
V

vandenbar

#9
Re: Master List - Does anyone have an equivalent method that they would care to share

Thanks for the reply pbojsen!

I've got a controlled document folder on our server with all the restrictions, etc too. It's the transition from a predominant paper system and getting some old dogs on board. (Our production manager doesn't even have email on his computer.) I've removed several doc locations over my year here, thinned out binders and combined lots of documents so it is still a work in progress. I was at a company that used QSI in Lotus Notes to control everything for about 12 years and now I'm at a small family owned business where I'm creating a controlled system first and then eventually a paperless.

Thanks again for the comments, they reassure me I'm going in the right direction.
 

Russ

Quite Involved in Discussions
#10
Re: Master List - Does anyone have an equivalent method that they would care to share

Our system documentation is kept in a QM folder and floor documents are kept in our "Master Production Documents" folder. We control our QM documents with a database, the floor documents are controlled by Engineering and only the latest & greatest reside in the "MPD" folder. It's working very well and allows quick changes of QM documents with good tracking of: what, who, when, & why!:agree1:
Guess I forgot to mention this is all on our Intranet:bonk:
 
Thread starter Similar threads Forum Replies Date
H Does ISO 9001:2000 require a Master List of Procedures, Work Instructions, etc? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
Q Forms Master List versus Record Matrix ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
E Part 11 Compliance, Excel living documents (i.e. document master list, equipment list, approved supplier list) Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 3
T Master Document List - Obsolete Documents Document Control Systems, Procedures, Forms and Templates 23
H Is "Master Documents and Records list" required per ISO 9001 ? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
T Document Control Master List for Obsolete Documents Document Control Systems, Procedures, Forms and Templates 6
A Master Document List Control ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
S Required Complete calibration SOP, calibration Plan and master list template! IATF 16949 - Automotive Quality Systems Standard 3
T Defining (Identifiying) Key Processes in a Company - "Key Process Master List" Misc. Quality Assurance and Business Systems Related Topics 45
K Master Document List and Unalterable Electronic Forms ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
N Master List of Records Required? ISO9001:2008 Clause 4.2.4 Control of Records ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
A Examples of Quality Records Master List ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
L Master Document List - Is it necessary? Document Control Systems, Procedures, Forms and Templates 15
J IQ, OQ, PQ and Validation Master List Qualification and Validation (including 21 CFR Part 11) 16
J Master List of Records, req 8.2.4 entry ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
O AIAG Manual Master List with Current Revision Level IATF 16949 - Automotive Quality Systems Standard 2
N For Reference Only gages to appear on Master List of Gages? General Measurement Device and Calibration Topics 10
N Records: Should they be stamped and should ALL be listed on the Master List? Records and Data - Quality, Legal and Other Evidence 40
J 7.5.3 prod id and traceability master list of records ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
P Form Number for Master List of Controlled Documents - ISO 9001:2000 Document Control Systems, Procedures, Forms and Templates 8
H Formats for Master List of Quality Records (MQR) & Document Change Request Form (DCR) ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
A Product Manufacturing Specifications - Do I need to maintain a master list? Document Control Systems, Procedures, Forms and Templates 6
M Master List of records - for multiple projects/departments in a software industry Records and Data - Quality, Legal and Other Evidence 5
Q Master List of Documents-Is there another way? Document Control Systems, Procedures, Forms and Templates 29
I Where are Records listed? A Master Record list? Records and Data - Quality, Legal and Other Evidence 14
A Control of Current Revision of Tool Drawings - Master List? Document Control Systems, Procedures, Forms and Templates 6
Q Aspects and Impacts Master List - ISO 14001 ISO 14001:2015 Specific Discussions 44
A Master List done on a Web Browser for an Intranet Document Control Systems, Procedures, Forms and Templates 12
E Hyperlink/Word Protection - Procedures hyperlinked from a master list Document Control Systems, Procedures, Forms and Templates 7
J Drawing Control - Bill of materials as our master list? Document Control Systems, Procedures, Forms and Templates 6
I Master Document Access - ISO 9001:2015 clause 7.5.3 Document Control Systems, Procedures, Forms and Templates 5
R No design history file or device master record ISO 13485:2016 - Medical Device Quality Management Systems 5
Sam Lazzara Medical Device File (MDF per 13485:2016 4.2.3) versus FDA Device Master Record (DMR) ISO 13485:2016 - Medical Device Quality Management Systems 3
D Virtual Documentation via Master Flow Chart? Process Maps, Process Mapping and Turtle Diagrams 4
M Master Dot for quality planning/improvement Manufacturing and Related Processes 1
M Medical Device Master File - We are a contract manufacturer ISO 13485:2016 - Medical Device Quality Management Systems 7
G Comparing Gauge Blocks - Translating the calibration between the master set and the QA set General Measurement Device and Calibration Topics 2
R Are DMR (device master record) and DHR (device history record) inspected by FDA or audited by an NB ISO 13485:2016 - Medical Device Quality Management Systems 6
S Foreign Manufacturer and DMR - Who keeps the DMR (Device Master Record)? ISO 13485:2016 - Medical Device Quality Management Systems 2
S DMR (Device Master Record) for Medical Device Software IEC 62304 - Medical Device Software Life Cycle Processes 3
D Design Outputs vs DMR (Design Master Record) 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 2
V Carbon Black (Master Batch) - Basic Requirements Manufacturing and Related Processes 5
H Korea DMF (Drug Master File) Fees Various Other Specifications, Standards, and related Requirements 5
K Computerized system Master Validation Plan, IQ-OQ-PQ Draft or Template Qualification and Validation (including 21 CFR Part 11) 4
R Master Gage Block Calibration (We have 2 sets) question General Measurement Device and Calibration Topics 3
P DMF (Drug Master File) type V for Sterilization Processes for USFDA Submission Other US Medical Device Regulations 3
Q Master FMEA for "like processes" - Does an FMEA have to match the CP and PM directly? FMEA and Control Plans 7
S Looking for templates of Master Production Record and Master Batch record Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 3
V Site Master File for multiple business units within same premises/facility Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 1
rob73 Digital DMF (Device Master File) Records EU Medical Device Regulations 3

Similar threads

Top Bottom