What do I have to include in a document database for document control?

A

AnnaMarie

#1
What do I have to include on a document database for document control please? Do I need direct links to each and every document, etc? Thank you for any reply.
 
Elsmar Forum Sponsor
A

Al Dyer

#2
If you are using microsoft Access and can tell which version you are using I can send you an example.

If you can expand further about the details of your current document conrol systems I can give you a better answer.

ASD...
 
#3
Minimum Requirements:
1-Approval;
2-Revision status;
3-location;
4-Evidence that invalid/obsolete documents
have been removed;
5-Identification of obsolete documents retained for knowledge preservstion, if required.
Optional:
1-You may want to include customer data in the same database;
2-You may also want to include the document and data change history in your database.

And don't forget "and be readily available to preclude the use of . . . .
 
A

Al Dyer

#4
AnnaMarie,

Don't hold me to the new ISO9k2k but for QS and TS there are no requirements for a database or master document list.

Saying that, I have always believed in keeping a document database that can generate a master report of current document revisions. My personal preference is an MS Access database designed for the specific needs of the individual company. (That is why I asked for more details on your current system)

By using Access I can generate reports that include:

Document Number
Document Revision
Document Revision Date
Document Approvals
Document Change Requests
Document Changes
Who Approved Document Changes
What The Change Was
New Revision Level
Distribution Lists
Obsolete Document Retrieval List
Current Document Status
Hyperlinks To Related Documents
Document Ownership
Revision History
Yearly Verification (outside specs)
Retention Requirements
Disposal Verification

The list goes on......

The general requirements are set forth in the text of the manuals, be creative and make it seamless for your organization.

ASD...

[This message has been edited by Al Dyer (edited 22 May 2001).]
 
A

AnnaMarie

#5
Thanks Al and Sam for your replies. My current document control is really at it's early stages and it does not have to conform to ISO etc. What I have simply done, is to set up folders on our server and for the projects we are undertaking in the office, all correspondance, drawings, emails etc. go into these relevant folders and are available for viewing purposes to the general staff. I will scan in any hard copies and when the project is complete, I will then convert all files into PDF (if there's a real need).

Access 2000 is the version I use if you have any samples to forward.

Thanks again. Sorry for the delay in replying.

[This message has been edited by AnnaMarie (edited 23 May 2001).]
 
T

Trakman

#6
Hi AnnaMarie,

Good discussion;
w.r.t. the database; to facilitate changes i am seeking a method to show the relationship to higher and lower documents, preferably in the database for "one-stop-shopping". Some Product data management software packages do this, but I am looking for a simple method (cheap=keep boss happy...) without cluttering up the database page with lots of hyperlink fields.
Can anyone offer some suggestions?
Thanks and a big :D in advance!

(I am being inventive but gosh this one has me stumped! :eek: )

Trakman.
 
E

energy

#7
Sam,
How do you produce evidence that obsolete documents have been destroyed? They're gone. Are we saying that we have to have something in writing that says on 0/00/00 we destroyed an obsolete document? I never heard of such a thing. I think the evidence is the lack of evidence to the contrary.

energy
 
#8
Energy,
I can agree with that. If it works for your process that's fine.
The requirement is "Control shall ensure that invalid and/or obsolete documents are promptly removed . . . "
Lack of evidence of an invalid/obsolete document only means that it is not in its assigned location. It culd be in a drawer or tool box.

However, what we do, to be on the safe side, is to request that the existing document be returned to the document control clerk when a revision is issued. The DC clerk follows up within a three day period to ensure that the required documents have been returned.
Is it 100% effective?Probably not, but then again . . .
 
E

energy

#9
Sam,
I agree. Our procedure states that QA, me, assures that revised documents are to be returned to QA for disposal or archives. We also will include a acknowledgement sheet that states procedures, affected sheets, etc..that are to be replaced. I have actually had the wrong pages removed and replaced. This check allows you to see that this has not happened. I was just confused regarding "evidence" that obsolete documents were, in fact, destroyed or archived. Archived was easy. Thanks for the reply.

energy
 
Thread starter Similar threads Forum Replies Date
C Document Control - Details to include on Documents Document Control Systems, Procedures, Forms and Templates 2
D Include as an attachment or make a separate document? Advise on Document Numbering Document Control Systems, Procedures, Forms and Templates 1
G Any good examples of CAPA forms that include a risk based approach? ISO 13485:2016 - Medical Device Quality Management Systems 5
A EN ISO 14971:2019 does not include the Annex Zs ISO 14971 - Medical Device Risk Management 4
R Do Medical Device Complaints include Clinical Trials? Medical Device and FDA Regulations and Standards News 3
S 510k: What to include if your own device is the predicate US Food and Drug Administration (FDA) 5
B Include cost of quality (and other wastes) in an ISO 9001 system? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
Watchcat Does 820.30 include the manufacturing process? 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 2
Watchcat Does ISO 13485 7.3 include the manufacturing process? ISO 13485:2016 - Medical Device Quality Management Systems 14
G Control Plan - Include the processes for each sub component? APQP and PPAP 2
B Does EN ISO 15223-1:2016 include the graphic symbols to be added to software and IFU? Other Medical Device Related Standards 9
M Technical File (STED) labelling - When you compile tech files do we have to include all the product labels? EU Medical Device Regulations 2
B MDSAP for OEM products in Canada for in vitro diagnostic test kit to include lancing device Other Medical Device Related Standards 0
F Determining what type of scrap to include in my internal PPM calculation Quality Manager and Management Related Issues 5
Q ISO 9001:2015 Clause 8.3 - Is it possible to exclude one product but include it in other? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
Q Calibration laboratory scope - Include software such as Gagetrak or Mini tab used? General Measurement Device and Calibration Topics 3
M Include IFU in Class II Medical Device Marketing Brochure? US Food and Drug Administration (FDA) 2
Q MDSAP Regions and how to include in procedures Other Medical Device Related Standards 2
G How to include machine error in uncertainty calculations? Measurement Uncertainty (MU) 5
P Quality objectives - must they include CAPA and internal audit topic? ISO 13485:2016 - Medical Device Quality Management Systems 28
B Quality Policy does not include a commitment to comply with legal requirements Quality Management System (QMS) Manuals 5
K Does ISO 13485:2016 - 7.2.3 Customer Communication include Marketing? ISO 13485:2016 - Medical Device Quality Management Systems 1
M Does nonconforming product include reagents/disposables? ISO 13485:2016 - Medical Device Quality Management Systems 1
S Manufacturing Work Instruction examples that include process pictures Manufacturing and Related Processes 3
Q To include Context and Interested Parties in Process Map? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
Q Does CE Marking include compliance to WEEE and packaging waste? CE Marking (Conformité Européene) / CB Scheme 4
T Does nonconforming product disposition include parts bought from the supplier? IATF 16949 - Automotive Quality Systems Standard 15
shimonv Does 510(k) submission need to include UDI Data Other US Medical Device Regulations 6
Q Where to include other types of Nonconformities ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
Paul Simpson Does Knowledge Management include aspects of Information Security? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
J How to understand the word "include" in IATF 16949 IATF 16949 - Automotive Quality Systems Standard 2
Crimpshrine13 IATF 16949 Audits to include Processes and Products from Non Subscribing Customers IATF 16949 - Automotive Quality Systems Standard 20
E Updating DHF (Design History File) to include Alternative Component 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 2
N Include homogeneity uncertainty into budget table for thermocouples Measurement Uncertainty (MU) 1
J What does "other relevant management roles" include? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
I As a part of validation, should i include the acceptance criteria of CPk index >1.33? Qualification and Validation (including 21 CFR Part 11) 4
M Changing FMEA template to include Detection Ranking for the PFMEA FMEA and Control Plans 2
WEAVER Gage R&R Sample Selection - Can we include NG Samples? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 12
V ICH Q3 - To "Include OR Not to Include" impurities below reporting threshold General Measurement Device and Calibration Topics 2
P What to include in a Clinical Evaluation Plan EU Medical Device Regulations 2
D Include non-automotive in TS16949 Registration Scope IATF 16949 - Automotive Quality Systems Standard 1
G Does AS9100 Certificate include ISO 9001 Certification? AS9100, IAQG 9100, Nadcap and related Aerospace Standards and Requirements 9
B COA (Certificate of Analysis) - What information should they include? ISO 13485:2016 - Medical Device Quality Management Systems 2
H What does the PEM-gate review include? Manufacturing and Related Processes 3
P What should a Quality Plan Include and Examples Misc. Quality Assurance and Business Systems Related Topics 3
D Need to include Premise of Outsourced Call Center in ISMS Surveillance Audit? IEC 27001 - Information Security Management Systems (ISMS) 4
C Include *ALL* business processes in QMS? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
F Wireless Dongle - Include in Medical Device Testing? IEC 60601 - Medical Electrical Equipment Safety Standards Series 7
M How to include Gas Measurement Equipment Servicing & Calibration Scope to ISO 9001 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
D IMR (Individuals and Moving Range) Chart for Short-Run SPC - How much data to include Statistical Analysis Tools, Techniques and SPC 1
Similar threads


















































Top Bottom