Our Master Document list includes the list itself as a document.

We also have a Master Record list which, of course, includes all sorts of records; that is, except for a couple of exceptions: we have a separate list for the Corrective Actions and another for Preventive Actions.

I believe that the Master Record list should be included in the Master Document list, correct?

2. Where should the Corrective Action and Preventive Action lists be included: in the Master Document list, in the Master Record List, or both?

Alex

I have assigned a document number for all master lists and included them in the Document Overview (master document list). The list is just an overview of the items and the actual completed forms will be your record. IMHO

I keep all documents in an Excel file that is filtered and sorted. The master file is only in my computer, and listes all the documents, revision number, date, and latest change. This is my master list. I don't think one needs a separate printed list for each category, or list of master lists. Trying to "keep it simple"

I keep all documents in an Excel file that is filtered and sorted. The master file is only in my computer, and listes all the documents, revision number, date, and latest change. This is my master list. I don't think one needs a separate printed list for each category, or list of master lists. Trying to "keep it simple" Ralph:

Records are a special type of document.



Do you identify where the records are kept, who is responsible for the records and how long they are kept?
Do you back-up your computer regularly and have additional off-site back-ups as well as a disaster recovery program?
This is important if you keep all your documents on your computer or even if it is just the list of documents since the master list is a document that I believe should be controlled.

Al,
Yes we do, thanks for your reply.
1.-Records procedure identifies record keeping resp., and where

2.-Computers are backed up weekly and back up files stored off site at a bank downtown.

Al,
Yes we do, thanks for your reply.
1.-Records procedure identifies record keeping resp., and where

2.-Computers are backed up weekly and back up files stored off site at a bank downtown.
Excellent! Many overlook this.

We have a list of all the documents that make up our QA Manual in the Table of Contents. All of the blank forms that turn into records are listed there.

We also have a Control of Records Matrix (Excel spreadsheet) that lists all of the information about the records as required by Control of Records (storage, ID, disposal, etc.). This Matrix is not a record but rather a procedure, so it is reviewed and approved when it is changed.

Our Continual Improvements, Preventive Actions and Corrective Actions are in an MS Access Database. Push one button and a sorted list of CIs, PAs, and CAs is produced along with totals # of each.

A sample excel worksheet that has all the required columns for a records MasterList?

I need it in transition, to make sure I request all the required information, before I load everything into the 'forms' database.

:o

A sample excel worksheet that has all the required columns for a records MasterList?

I need it in transition, to make sure I request all the required information, before I load everything into the 'forms' database.

:o Take a look at this in word. I'm sure you can convert it to excel.
MASTER LIST OF QUALITY RECORDS (http://elsmar.com/Forums/attachment.php?attachmentid=323)

TownDawg, look at this file which is mentioned in previous post. Not exactly a simple Excel list, but one that is easily and readily accessible. All the files are hyper linked to specific document in folders shown in drop down filters

I have checked them both out.. thanks!!... btw.. ralph.. I WANT

Procedures, Reference Document, "How to survive an Audit example"

//QC Documents\How to survive an audit.ppt

;) May I check it out of your library?

I have checked them both out.. thanks!!... btw.. ralph.. I WANT

Procedures, Reference Document, "How to survive an Audit example"

//QC Documents\How to survive an audit.ppt

;) May I check it out of your library?

Don't you use the Records List Database module in QSI?

Learning ... still learning.. didn't even know it existed..

;)

I keep all documents in an Excel file that is filtered and sorted. The master file is only in my computer, and listes all the documents, revision number, date, and latest change. This is my master list. I don't think one needs a separate printed list for each category, or list of master lists. Trying to "keep it simple"


I would like to put this on our network so all can check for the lastest rev. It would be read only for all except myself. In doing this, can this take the place of having a revision history for each sheet?

I would like to put this on our network so all can check for the lastest rev. It would be read only for all except myself. In doing this, can this take the place of having a revision history for each sheet?

There is a revision history included for each file scroll over on the right side past the hyperlinks. Hope this helps.