# Action types

Description:
Action not complete and/or not validated


Description:
Action is complete, validated, and effective


Description:
Action is complete but not valid or ineffective


Description:
Action is complete, but validation is needed


# Actions

Action:
investigate risk of eliminating  problem.


# CAR Status

Description:
Long Term Corrective Action confirmed effective.  CAR closed.


Description:
Registered problem and Short Term Corrective Action in place in house.


Description:
Long Term Corrective Action developed but not implemented.


# CAR Types

Desc:
Initiated as a result of an internal audit


Desc:
Customer complaint (both valid and invalid)


Desc:
Vendor or supplier delivered NC material


Desc:
Initiated from an external source (not a Customer Complaint)


# CAR_data

Containment:
Isolated event - no containmnet required


Subject:
CAR Created from Nonconformance NC2014-00004


Subject:
Damaged shipment received by Customer B on BC delivery

Containment:
Examine current packaging methods; investigate damage pictures provided by Customer


Subject:
CAR Created from Nonconformance NC2014-00005


Comment:
JUSTIFICATION for CANCELLATION:  justicication for cancellation!
Cancelled By:  administrator   10/9/2014 1:50:31 PM


Subject:
CAR generated from Audit Number:  AR-01205

Problem Desc:
Audit Number: AR-01205  Lead Auditor:  FF; Shiping procedures and recordkeeping


Subject:
CAR Created from Nonconformance NC-00003


Problem Desc:
SCAR-00068 prob description.  See attachment xxx.doc

Containment:
determined this was an isolated shipment - no continuing risk


Problem Desc:
CAR-00075 description of what went wrong


Subject:
CAR Created from Nonconformance NC-00062


# Category

Description:
pertains to all aspects of the organization


# t_Audit

AuditTeam:
Terry V, Mary Q, Troy, Margo, Tim, Rick, Jim, Todd, Garrett, Jakir, Dan

AuditReason:
Make sure operators are following work cells processes.


AuditTeam:
Harry Doolittle, Nancy Goodale, John Cwynar


AuditReason:
What is the status and importance of the process or area audited?


AuditReason:
Training gaps creeping up in monthly review metrics


# t_AuditFindings

FindingDescription:
80% did not know the policy; 25% didn't know the location


FindingDescription:
90% did know or partial knew the company objective
85% did not know the company objective and about 39% did not know the location


FindingDescription:
Poor record keeping; shipping records lost / destroyed; no clear storage process is evident


# t_AuditTypes

AuditTypeDescription:
Internal Quality management System Audit


AuditTypeDescription:
Customer audit of our internal processes


# t_ChangeLogMemo

NewVal:
SCAR-00068 prob description.  See attachment xxx.doc


OldVal:
Make sure operators are following work cells processes. BUTTFACE

NewVal:
Make sure operators are following work cells processes.


# t_Classification

DescriptionFull:
Critical Characteristic, Safety or Government Regulation


DescriptionFull:
Form, fit, or function, affect Customer satisfaction


DescriptionFull:
Significant Characteristic, affects Customer satisfaction


# t_DBRevisions

Changes:
New product release with CFR21 Part 11 complaince and electronic signature


Changes:
Changed Delete method:  Eliminated DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 - use DoCmd.RunCommand acCmdDeleteRecord; added erroro trapping for delete_click


Changes:
Eliminated all DoCmd.DoMenuItem acFormBar… commands - converted to DoCmd.runcommand…;


Changes:
use f_RootCause_Simple; modify FA, NC, PAR reports for Rs_RootCause_Simple


Changes:
Eliminate references to QMS in form and associated reports


Changes:
Changed delete button code from run SQL to DoCmd.RunCommand acCmdDeleteRecord
 to trigger the on delete event (log change)


Changes:
add site to CAR+PAR creation; fix bug in delete CAR/PAR logic afterupdate


Changes:
eliminate logic to set status to "Cancelled" - this should be a manual process


Changes:
Modify status_select_afterUpdate (if cancelled status is seleted) to test for null date closed


Changes:
add  CAPAInitiate; Add logic to user level to set Me!CAPAInitiate


Changes:
Add before_update code to ensure Date closed < now()


Changes:
add logic to check privileges and restrict access


Changes:
added  logic to check privileges and restrict access


Changes:
add first name to emp log comment when password is changed


Changes:
eliminated f_Validation; combined fields into [f_Actions Ncsubf]


Changes:
fixed blank name showing comma; root cause can shrink = yes


Changes:
eliminated 2 subforms for Actions / Validations; substituted Single actions form for corrective actions / PA; changed locking strategy on current


Changes:
eliminated 2 subforms for Actions / Validations; substituted Single actions form for  actions; changed locking strategy on current


Changes:
changed 3rd row top=0.3639 and 2nd row can grow


Changes:
Added test for date closed < date init; date closed after updae bug fix: "If Me![CAR status select] = 1 Or Me![CAR status select] = 6 Then" was "If Me![CAR status select] = 1 Or 6 Then"


Changes:
fixed bug in auto number (#) where code would always set pWriteChange2Log =  true


Changes:
set CAR_ID identity specification NOT FOR REPLICATION = YES to avoid insetion bug in SQL 2005(see http://support.microsoft.com/kb/908711)


Changes:
new subreport Rs_Team-meeting specifically for Meetings (Name heading instead of team member)


Changes:
added code to populate owners if null before save


Changes:
1)open password form without requiring old password. 2)implement requirement that there be no spaces in the username


Changes:
implement requirement that there be no spaces in the username


Changes:
Added code to set     pVALIDPW = False when click Cancel button


Changes:
Added code to the autopopulate button to set the ECDs based on the goals


Changes:
Fix bug where action was still editable after Plan was approved (requeried action subf  to trigger On Current Code)


Changes:
Add button to delete username and password


Changes:
Add new table; Add new f_NCDisposition subform to f_NC


Changes:
Fixed bug where [CAR_ID] is needed before entry to t_Nonconformance


Changes:
Add code to detect a new record = Addition (ChangeType = 3); modify record source of f_ChangeLogDisplay to include t_ChangeType


Changes:
if deleting e-sig, require e-Sig of user that is logged in


Object:
f_NC; add t_NC Disposition;  modify associated reports; add t_Disposition; f_Disposition; change f_Set-up

Changes:
Added new disposition schema; update all associated reports


Changes:
Add Closure approval; verify 1) no open actions 2) approved dispo before close


Changes:
Add form and code to link to the back-end SQL server without the need for a ODBC connection


Changes:
specify pdf format for email report - validate all reports have proper error trap if no data
 (Audited all NC config rpts and PAR Config Rpts --> all OK)


Object:
R_AllOpenAuditRecords; R_AuditRecords4DateRage; R_AuditRecords4DateRage-Detail; R_AuditFindingSummary; R_ListScheduledAudits; R_List all IA for a date range; R_OpenAudits with Actions Pending; R_CIProjects-config
C_CIGraph-Category;

Changes:
Added error trapping for no data (On Activate)


Changes:
Added error trapping for no data (On Activate) -  (Audited all Change Log rpts --> all OK)


Changes:
change heading from containment to corrective


Changes:
correct minor querry errors in NC reports; minor format changes in  NC reports


Changes:
Change CAR_data.[CAR Type] to CAR_data.CARTypeID
Change [CAR Types].[CAR Type ID] to [CAR Types].CARTypeID


Changes:
Added new reports for closed and approved audits; modified scheduled audits to exclude any started audits


Changes:
Add new report to f_ConfigRpts; f_ConfigNCRpts


Changes:
Add recordsource to main report; add proper No data error


Object:
C_CARGraph-PN; C_RootCauseTypes; C_CARGraph-Category; C_CurrentStatus; C_CARGraph-Type


Changes:
fix bug:  [Date Cont App] was set to = NULL; eliminated = NULL


Object:
f_DashBoard; f_DashB_OpenPARs; f_DashB_OpenCARs; f_DashB_Detail; q_DashB_OpenTotal; q_DashB_OpenCARs; q_DashB_DelinquentTotal; q_DashB_ActionsValReq; q_DashB_ActionsOpen; q_DashB_ActionsDel

Changes:
New Management Dashboard; new Switchboard items


Changes:
modify autonumber button code to handle case where ECD goals are null


Changes:
Add code to update KeyIndex in Change Log after update


Changes:
Fix bug where Memo changes were not logged


Changes:
2/13/2015 Function AddHist:  strip out any single quotes, which will screw up the SQL string


Changes:
t_ChangeLog:  Added "Source" field to capture changes from Q-Med DB; modify Module1 to write "Q" to the source field


Changes:
Change ActID to Unb_ActID; add code to exclude all Unb_ prefixes from logging change in ChangeLog


Changes:
change btn_delete  code to         DoCmd.RunSQL "DELETE CAR_data.*, CAR_data.CAR_ID FROM CAR_data WHERE CAR_data.CAR_ID=" & Me!CAR_ID


Changes:
fixed bug that under reported the number of open actions


Changes:
delete "containment" from column heading


Changes:
Add Check for previous use before allow employee to be deleted; add Public Function EmployeeUsedInDB to Module1


Changes:
Fix bug in query referring to old CAR Type


Changes:
changed getLoginAttemptCount function strSQL statement to work on all SQL servers


Changes:
Automatically Close form after successful update


Changes:
changed label Customer to Supplier; no query change needed


Changes:
Set input mask to password for all key fields; Set Popup=yes; modal = yes


Changes:
Change delete button code to SQL delete statement and form refresh;              'delete record
        stSQL = "DELETE CAR_data.*, CAR_data.CAR_ID FROM CAR_data WHERE CAR_data.CAR_ID=" & Me!CAR_ID
        DoCmd.RunSQL stSQL
        Me.Requery


Changes:
add code to save record on team form entry


Changes:
fix problem where Add new button did not work (event was not assigned to button)


Changes:
fix bug preventing additional details from displaying correctly


Object:
f_SplashScreen; f_Password_Entry; f_PasswordAdminReset; f_PasswordCreate; f_PasswordUpdate


Changes:
change title to NC Reports and Charts; ; change back color to #FFFFFF (white)


Changes:
change title to CAR Reports and Charts; change back color to #FFFFFF (white)


Changes:
Add code to save record when click any function button (    If Me.Dirty Then DoCmd.RunCommand acCmdSaveRecord )


Changes:
make Aduit Type yellow to indicate required field


Changes:
add double click event to take you to the desired record


Changes:
Add filters for Open, Closed, and All NCs


Changes:
Change "Part#" label to "Root Cause" label


Changes:
Add Change log button to open f_ChangeLog


Changes:
Add option to email Open NC Action report to all action owners


Object:
f_NC; R_PrintNC; R_PrintFA; misc NC Reports

Changes:
Chagne "Downgrade" to "Re-grade" on NC forms and reports to be consistent wit h ISO 9001:2015


Changes:
changed pic sizemode to stretch to avoid Access 2016 bug


Changes:
Add Hold report button / new report to NC form


Changes:
add HoldNoticeTitle; HoldNoticeSubTitle; HoldDocNumber fields; add fields to set-up forms


Changes:
eliminate Details section; add Rs_Header-NC


Changes:
Add new menu system; add global open actions report/querries


Changes:
strip out any single quotes, which will screw up the SQL string


Object:
f_SWOTOpportunities, q_SWOTOpportunities, f_SWOTStrengths, f_SWOTThreats, q_SWOTThreats, q_SWOTThreats,f_SWOTWeakness, q_SWOTWeakness

Changes:
Change record source from Views to querys (views were non updateable


Changes:
add code to update RPN after S/O/D was updated


# t_Detection

DescriptionFull:
Sure that the potential failure will be found or prevented before reaching the next customer


DescriptionFull:
Almost certain that the potential failure will be found or prevented before reaching the next customer


DescriptionFull:
Low likelihood that the potential failure will reach the next customer undetected


DescriptionFull:
Controls may detect or prevent the potential failure from reaching the next customer


DescriptionFull:
Moderate likelihood that the potential failure will reach the next customer


DescriptionFull:
Controls are unlikely to detect or prevent the potential failure from reaching the next customer


DescriptionFull:
Poor likelihood that the potential failure will be detected or prevented before reaching the next customer


DescriptionFull:
Very poor likelihood that the potential failure will be detected or prevented before reaching the next customer


DescriptionFull:
Current controls probably will not even detect the potential failure


DescriptionFull:
Absolute certainty that the current controls will not detect the potential failure


# t_Disposition

Description:
Release product - use without concession


# t_FMEAActions

Action:
implement automation to print all labels directly from Work Order number

ValidationCriteria:
labels automatically printed without errors


# t_FMEAActionStatus

Description:
Action not complete and/or not validated


Description:
Action is complete, validated, and effective


Description:
Action is complete but not valid or ineffective


Description:
Action is complete, but validation is needed


# t_FMEADetail

Effect:
overheat: burned product = scrap
Under temp:  poor seal = rework or escape to customer complaint

Cause:
sensor failure
wrong recipe selected
manual override of recipe


Cause:
Human error
Poor Training
Bad lighting / environment


Effect:
ship weong product
ship improperly labeled product

Cause:
Human error
Poor Training
manual process - no automation


Requirement:
No damage to material; correct material as per job traveler; at proper stage in process

Cause:
mixed paperwork; drop/damage in transport


Effect:
scrap, re-work, customer complaint (if escape)


Cause:
part transfer scratches, part dropped human error


# t_MyCompanyInfo

Confidential:
Confidential - do not duplicate or distribute without permission


# t_NonConformance

Disposition:
downgrage SN 8757465346 and SN09796865 and change part# designation  to 55-9876


# t_Occurrence

DescriptionFull:
Low failure rate with supporting documentation


DescriptionFull:
Low failure rate without supporting documentation


DescriptionFull:
Relatively moderate failure rate with supporting documentation


DescriptionFull:
Moderate failure rate without supporting documentation


DescriptionFull:
Relatively high failure rate with supporting documentation


DescriptionFull:
High failure rate without supporting documentation


DescriptionFull:
Failure is almost certain based on warranty data or test results


DescriptionFull:
Assured of failure based on warranty data or test results


# t_QType

Description:
Answer is  score from 1 to 10 (ten is the highest)


# t_RootCuaseType

Description:
Training was not effective in preventing the non-conformance


Description:
Technician failed to follow existing procedures


Description:
Technician accidentally made an error or mistake


Description:
Equipment malfunction causing the  non-conformance


Description:
Procedure was available but inadequate or incorrect


Description:
Poor resource or project planning and execution


Description:
Non-conformance results from the fundamental design


Description:
Non-conformance results from the fundamental process


# t_Severity

DescriptionFull:
Customer will not notice the adverse effect or it is insignificant


DescriptionFull:
Customer will probably experience slight annoyance


DescriptionFull:
Customer will experience annoyance due to the slight degradation of performance


DescriptionFull:
Customer dissatisfaction due to reduced performance


DescriptionFull:
Customer is made uncomfortable or their productivity is reduced by the continued degradation of the effect


DescriptionFull:
Warranty repair or significant manufacturing or assembly complaint


DescriptionFull:
High degree of customer dissatisfaction due to component failure without complete loss of function.  Productivity impacted by high scrap or rework levels.


DescriptionFull:
Very high degree of dissatisfaction due to the loss of function without a negative impact on safety or governmental regulations


DescriptionFull:
Customer endangered due to the adverse effect on safe system performance with warning before failure or violation of governmental regulations


DescriptionFull:
Customer endangered due to the adverse effect on safe system performance without warning before failure or violation of governmental regulations


# t_SWOT

Description:
SWOT for the company wide marketing organization including structure, and objectives


# t_SWOTActions

Action:
get quote on print media; add to budget;


# t_SWOTDetail

ItemDescription:
highly subject to google index algorithm


ItemDescription:
Increase marketing budget to include social media ads


ItemDescription:
Competitors gaining google rank at our expense


ItemDescription:
Product is 10 years old and technology may be changing


ItemDescription:
Cash is available for new product development


ItemDescription:
Competitor A may get to market before we can release new product


