"Document Controlling" Queries run to obtain information reported to customer

L

lrl116

#1
Does anyone document control queries? My company would like to set some controls on queries that are run to obtain information that is reported to the customer.

Any comments?
 
Elsmar Forum Sponsor
D

D.Scott

#2
Re: "Document Controlling" Queries

Rose, you can control anything you think needs controlling. I am not sure what you mean by queries but your decision to control them should be based on your need for control. If it is a form you complete, would it matter if a facsimile of the form were used? Do all the blanks have to be filled in? Is the control needed for the form itself or for the form after it has been completed (data)? The type of control you use is again up to you. If, for example, you had a query that was later transferred to a computer, do you need to keep or control the original?

My preference is to not control every little thing in the company. Look at it and decide if it really needs to be controlled. If it does, decide to what extent and how you will do it.

Dave
 
L

lrl116

#3
Re: "Document Controlling" Queries

Some clarification - The queries are reports generated from an application similiar to MS Access. They are saved on a shared drive for all managers to access. They run the data and report the numbers to the customer. We are trying to control managers changing the reports and using an incorrect query and reporting the wrong numbers to the customer.
 

Wes Bucey

Prophet of Profit
#4
Re: "Document Controlling" Queries

lrl116 said:
Some clarification - The queries are reports generated from an application similiar to MS Access. They are saved on a shared drive for all managers to access. They run the data and report the numbers to the customer. We are trying to control managers changing the reports and using an incorrect query and reporting the wrong numbers to the customer.
It appears to me you may have a slightly different concept of "control" than we normally use in discussing Quality issues.

My working definition of Control means controlling who may
  • create
  • approve
  • edit or modify
  • delete
  • read
  • copy
  • use the data contained to conduct an activity (process)
of a particular document.

Dave is on the right track when he writes
The type of control you use is again up to you. If, for example, you had a query that was later transferred to a computer, do you need to keep or control the original?

My preference is to not control every little thing in the company. Look at it and decide if it really needs to be controlled. If it does, decide to what extent and how you will do it.
Obviously (to me), if you are
. . . trying to control managers changing the reports and using an incorrect query and reporting the wrong numbers to the customer.
you have a problem which needs to be addressed. You do not need to control DOCUMENTS, you need to control MANAGERS! The basic problem is that your managers do not understand that ANY document used in a process to direct the activity of folks has to be consistent with the intent of the organization, not some manager's whim. In that regard, the basic problem is the understanding of the managers. One of the tools of "mistake proofing" you might use is a software lock which prevents modification or deletion of ANY document without multiple approvals to eliminate a "rogue" manager changing the document in defiance of corporate will.
 
O

ontheopenroad

#5
Re: "Document Controlling" Queries

Do you need to control the query itself, or do you need to control the process for generating, reviewing, and releasing the data/reports to the customer?

I am familiar with a similar situation. I use MS Access to generate reports/deliverables regarding workload for our customer (the government--ugh). LOL

I can write my own queries to pull the information, but there is a process where my results are reviewed and approved by the Program Director before the information is released to the govt. We have a procedure documenting the process, and the process generates records to show the review and approval for final release.
 
L

lrl116

#6
I need to control the actual query. The reports and numbers generated from these reports are reviewed and that process seems ok.

I like the idea of a software lock and I am going to further research that idea.
 
J

Joe Cruse

#7
Depending on what you're using, you can "protect" the query and make it read-only. If using MS Access, make a datasheet form with your query as the recordsource, and then make the form read-only. There are other options within Access as well.
 
S

silly girl

#8
lrl116 said:
Does anyone document control queries? My company would like to set some controls on queries that are run to obtain information that is reported to the customer.

Any comments?
Hmmm interesting idea. We have report definitions that show exactly what data sources / fields / queries / criteria / formatting / manipulations, etc. are used for that report. We don't actually control these in our QMS, though we certainly could. The managers in my org are trained to get critical reports (such as you describe) from specific analysts, and that is the way we make sure the data is consistently drawn from the same report defintion. You might be able to do the same thing simply by creating a repository of report definitions and training everyone to use them...

Silly Girl
 
Thread starter Similar threads Forum Replies Date
T Controlling Expandable Forms in Paper-Based Document Control System Document Control Systems, Procedures, Forms and Templates 10
A Document Control: Controlling Electronic Email (E-mail) Document Control Systems, Procedures, Forms and Templates 7
T Ensuring Document Review AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 3
T TipQA Document Management AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 1
A Document control system for QMS in Google Drive? Document Control Systems, Procedures, Forms and Templates 6
M On-demand EU MDR Compliance toolkit with online training courses, templates & document management system Training - Internal, External, Online and Distance Learning 0
C Document Record/Template Minimum Requirements ISO 13485:2016 - Medical Device Quality Management Systems 3
E Do anyone have document of automotive production risk and control of risk? Lean in Manufacturing and Service Industries 1
Q Document representation ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
J Document Control of Online Management Software ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
W Document control Document Control Systems, Procedures, Forms and Templates 10
D Increasing efficiency - Capt. Proj. Document Review Matrix Document Control Systems, Procedures, Forms and Templates 4
A ISO 9001:2015 8.5.6 and 7.5.3 Document Control Questions ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
qualprod Sheets into a spreadsheet document control ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
J Document Changes that don't have to be approved Document Control Systems, Procedures, Forms and Templates 11
D Electronic Document Management System ISO 13485:2016 - Medical Device Quality Management Systems 16
M Document Control - Applying Suitable Identification to Obsolete Documents ISO 13485:2016 - Medical Device Quality Management Systems 5
D Document Control Question involving DocuSign US Food and Drug Administration (FDA) 6
M Document Control ISO and FDA ISO 13485:2016 - Medical Device Quality Management Systems 7
D Document Change Approval ISO 13485:2016 - Medical Device Quality Management Systems 6
R Does anyone use iQMS for their ISO based document control? Manufacturing and Related Processes 1
C Document Identification Question ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
B Document retention Policy for Japan's PMDA Japan Medical Device Regulations 1
B Document Retention Policy for NMPA China Medical Device Regulations 1
B Document Retention period for MHRA submission UK Medical Device Regulations 0
A If document coding is change will there be a revision Document Control Systems, Procedures, Forms and Templates 1
S Document numbering question? ISO 13485:2016 - Medical Device Quality Management Systems 7
R Quality policy review document IATF 16949 - Automotive Quality Systems Standard 3
dpenbert AS9100 7.5.3 - Manual Document Control AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 6
S Software design document NMPA guidance and consultant China Medical Device Regulations 4
qualprod Is it worth to document all the processes? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
S Help in document control procedure Document Control Systems, Procedures, Forms and Templates 14
P Which MDCG Document should I use for PMS Plan and PSUR? EU Medical Device Regulations 2
N API Q1, Management of Change & Document Change Request Oil and Gas Industry Standards and Regulations 4
J Project management Document. IATF 16949 - Automotive Quality Systems Standard 4
S Master Document Register Document Control Systems, Procedures, Forms and Templates 3
M Preparing a document for Raw Material of Medical Device EU Medical Device Regulations 1
R Regulations on Controlled Document Size (Paper Size) Document Control Systems, Procedures, Forms and Templates 4
M Document Architecture ISO 13485:2016 - Medical Device Quality Management Systems 8
cgaro62 Using internal audits as part of document reviews Document Control Systems, Procedures, Forms and Templates 21
J Training on the importance of Document Control Document Control Systems, Procedures, Forms and Templates 3
Ed Panek External Standards List - Should this document include previously revised standards? ISO 13485:2016 - Medical Device Quality Management Systems 4
H Document retention period Canada Medical Device Regulations 2
S Document Notes ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
M ISO 13485 and document control for programs ISO 13485:2016 - Medical Device Quality Management Systems 6
Ed Panek MR Mandate Document EU Medical Device Regulations 1
C Document Index Document Control Systems, Procedures, Forms and Templates 5
K ASME, ANSI, ASTM and similar specifications and their requirements for document control. Inspection, Prints (Drawings), Testing, Sampling and Related Topics 8
H If we use agile - do we still need to document TF as a waterfall just for the notified bodies need? IEC 62304 - Medical Device Software Life Cycle Processes 2
Q ISO 9001/IATF 16949 Audit Finding Question - Document Retention IATF 16949 - Automotive Quality Systems Standard 11

Similar threads

Top Bottom