Data Dictionary - Quality Audit

QA_CAPANCR_NonConformance_Report

CAPANCR_ActByDt

datetime

NULL

Date on or before which the non-conformance should be acted upon.

CAPANCR_Action

varchar(20)

Action required to close the non-conformance

CAPANCR_Approver

sql_variant

Person who has to approve the closure of Non-conformance

CAPANCR_AuditeeRemarks

Remarks of the auditee.

CAPANCR_AudRepNo

NOT NULL

Audit Report Number against which this non-conformance is being logged.

CAPANCR_CasCat

varchar(20)

NULL

Category of the Cause

CAPANCR_Contri_Factor_RC

sql_variant

CAPANCR_Contri_Factor_RCCatg

varchar(20)

Factor that contributed to the root cause

CAPANCR_Corr_Action

sql_variant

Corrective Action required to close the non-conformance.

CAPANCR_created_By

NOT NULL

Created user name

CAPANCR_createdDate

datetime

Created date

CAPANCR_FileName

varchar(20)

NULL

Name of any supporting document attached.

CAPANCR_HuFact

Human factor that caused the non-conformance

CAPANCR_Impact_Anlys

sql_variant

Impact Analysis

CAPANCR_Impt_Anlys_Ref

Reference to impact analysis

CAPANCR_Modified_By

Modified user name

CAPANCR_modifieddate

datetime

modified date

CAPANCR_NCCategory

varchar(20)

Non-conformance category.

CAPANCR_NCUsrStatus

User Status

CAPANCR_Ouinstance

int

NOT NULL

current instance

CAPANCR_Prevent_Action

sql_variant

NULL

Preventive Action required to ensure the non-conformance does not repeat in future.

CAPANCR_QAFNC_NCRNO

int

NOT NULL

Non-conformance number

CAPANCR_RootCause_RC

sql_variant

Root cause that caused the Non-conformance

CAPANCR_RootCause_RCCatg

varchar(20)

NULL

Root cause category

CAPANCR_RtCause_Anlys

sql_variant

Root cause Analysis

CAPANCR_SrlNo

int

IDENTITY

Running serial number. This is system generated value and unique.

CAPANCR_timestamp

bigint

NOT NULL

timestamp value for not allowing more than one user to process the same data

QA_CAPAROB_Recommendations_Observations

CAPAROB_ActByDt

datetime

NULL

Action due by date

CAPAROB_Action

varchar(20)

Action

CAPAROB_Approver

sql_variant

CAPAROB_AuditeeRemarks

Auditee remarks

CAPAROB_AudRepNo

NOT NULL

Audit Report Number

CAPAROB_created_By

created user name

CAPAROB_createdDate

datetime

created date

CAPAROB_FileName

varchar(20)

NULL

CAPAROB_Modified_By

sql_variant

Modified user name

CAPAROB_modifieddate

datetime

Modified date

CAPAROB_Ouinstance

int

NOT NULL

current instance

CAPAROB_QAFRO_SrlNo

System generated serial number (Key)

CAPAROB_Srl_No

IDENTITY

CAPAROB_timestamp

bigint

NOT NULL

timestamp value for not allowing more than one user to process the same data

CAPAROB_Updated_By

sql_variant

NULL

CAPAROB_UpdatedDate

datetime

QA_QAAUD_Quality_Audit

QAAUD_AddRef

sql_variant

Additional Reference

QAAUD_AudClass

varchar(20)

Audit Class (Quick Code)

QAAUD_AudEntity

sql_variant

NOT NULL

Audit Entity

QAAUD_AudEntityName

Audit Entity Name (If Audit Entity is ’supplier’ then entity name is a valid Supplier Name)

QAAUD_AudInitComments

NULL

QAAUD_Auditee

NOT NULL

Auditee name

QAAUD_Auditor

Auditor Name

QAAUD_AudLocn

int

NULL

Audit Location

QAAUD_AudObjective

sql_variant

Audit Objective

QAAUD_AudReason

Audit Reason

QAAUD_AudRepNo

NOT NULL

Audit Report Number

QAAUD_AudSchDateTime

datetime

Audit Scheduled date and time

QAAUD_AudSchNo

sql_variant

NULL

Audit Schedule Number

QAAUD_AudScope

Audit Scope

QAAUD_AudStatus

Audit Status

QAAUD_AudTyp

varchar(20)

NOT NULL

Audit Type (Supplier, Employee, Station, Warehouse, WorkCenter, Others)

QAAUD_Category

NULL

This field holds quality audit category

QAAUD_created_By

sql_variant

created user name

QAAUD_createdDate

datetime

created date

QAAUD_EstDuration

bigint

Estimated duration of audit

QAAUD_FileName

varchar(20)

QAAUD_modified_By

sql_variant

Modified user name

QAAUD_modifieddate

datetime

modified date

QAAUD_Ouinstance

int

NOT NULL

current instance

QAAUD_RefDocDet

sql_variant

NULL

Reference doc details. All documents saved against various Reference Document Type for the selected Audit Report#

QAAUD_RefDocNo

Reference Document Number

QAAUD_RefDocTyp

varchar(20)

NOT NULL

Reference Document type

QAAUD_ReportType

sql_variant

Report Type

QAAUD_timestamp

bigint

timestamp value for not allowing more than one user to process the same data

QAAUD_User_Status

varchar(20)

NULL

This field holds quality audit user status

QAAUD_Venue

sql_variant

Audit Venue

QA_QACAPA_Corrective_Preventive_Action

QACAPA_Approver

Name of the approver

QACAPA_AudRepNo

NOT NULL

Audit Report Number on which the CAPA is done

QACAPA_created_By

created user name

QACAPA_createdDate

datetime

created date

QACAPA_Modified_By

sql_variant

NULL

modified user name

QACAPA_modifieddate

datetime

modified date

QACAPA_Ouinstance

int

NOT NULL

current instance

QACAPA_timestamp

bigint

timestamp value for not allowing more than one user to process the same data

QACAPA_UserStatus

varchar(20)

NULL

User Status of the corrective preventive action taken

QA_QAEDREF_RefDoc_Dtls

TO store reference document details of audit reports .

QAEDREF_AudRepNo

sql_variant

NOT NULL

audit report no for which the reference document details were stored

QAEDREF_created_By

varchar(20)

NULL

created user name

QAEDREF_createdDate

datetime

created date

QAEDREF_DocumentId

varchar(30)

unique id for the document

QAEDREF_FileName

varchar(20)

reference file name

QAEDREF_LineNo

int

NOT NULL

line no for identification of multiple reference documents for the same audit rep #

QAEDREF_Modified_By

sql_variant

modified user name

QAEDREF_modifieddate

datetime

NULL

modified date

QAEDREF_Ouinstance

int

NOT NULL

current instance

QAEDREF_RefDocType

char(20)

reference document type The values defined  for reference document type

QAEDREF_Remarks

sql_variant

remarks

QAEDREF_timestamp

int

NULL

timestamp for not allowing more than one person to process the same data

QA_QAF_Quality_Audit_Findings

QAF_ActEnDt

datetime

Actual End Date of audit

QAF_ActManHrs

bigint

Actual Man hours of audit

QAF_ActStDt

datetime

Actual Start Date of the audit

QAF_AppAuthority

sql_variant

NOT NULL

Approval Authority

QAF_AudEntity

Audit Entity

QAF_AudEntityName

Audit Entity Name

QAF_AudFind

NULL

QAF_AudImpli

varchar(20)

Audit Implications

QAF_AuditCat

Audit Category

QAF_Auditee

sql_variant

NOT NULL

Auditee Name

QAF_Auditor

Auditor Name

QAF_AudRating

varchar(20)

NULL

Audit Rating

QAF_AudRepNo

sql_variant

NOT NULL

Audit Report Number

QAF_AudSchNo

NULL

Audit Schedule Number

QAF_AudStatus

NOT NULL

Audit Status

QAF_AudTyp

varchar(20)

NULL

Audit Type (Quick Code)

QAF_BestPract

sql_variant

Best Practice

QAF_CaryOvrItem

Carry Over Item

QAF_ClsAud

varchar(20)

QAF_ClsComments

sql_variant

Audit Closure Comments

QAF_created_By

Created user name

QAF_createdDate

datetime

created date

QAF_FileName

varchar(20)

QAF_Modified_By

sql_variant

Modified user name

QAF_modifieddate

datetime

Modified date

QAF_OthPersons

sql_variant

QAF_Ouinstance

int

NOT NULL

current instance

QAF_RecoBy

sql_variant

Recommendation By

QAF_RefDocDet

NULL

Reference Document Details

QAF_RefDocNo

Reference Document Number

QAF_RefDocTyp

Reference Document Type

QAF_ReportType

Report Type (Scheduled, Adhoc or Direct)

QAF_ResPers_CAPA

NOT NULL

Person responsible for Corrective and Preventive Action

QAF_timestamp

bigint

timestamp value for not allowing more than one person to process the same data

QAF_UserStatus

varchar(20)

NULL

User Status

QAF_UsrName_Code

sql_variant

NOT NULL

User Name

QAF_Venue

NULL

Audit Venue

QA_QAFNC_Nonconformance_Report

QAFNC_ActByDt

datetime

Action by date

QAFNC_Action

varchar(20)

Defines the type of action taken can be report conformance Action Closed Pending action Cancel Depends on the user preference

QAFNC_AuditorRemarks

sql_variant

auditor Remarks

QAFNC_AudRepNo

NOT NULL

Audit report no for the given schedule no

QAFNC_CasCat

varchar(20)

NULL

casual category quick codes defined for casual category in Maintain Quick codes page

QAFNC_Cls_Comnt

sql_variant

Auditor Remarks

QAFNC_Contri_RC

Contributing root cause

QAFNC_Contri_RCCatg

varchar(20)

contributing factor : All Active root cause categories will be given

QAFNC_created_By

sql_variant

NOT NULL

Created by

QAFNC_createdDate

datetime

Created Date

QAFNC_Dfrl_Count

int

NULL

deferral count of NC

QAFNC_ExtByDays

extended days

QAFNC_FileName

varchar(20)

file name

QAFNC_Fup_Act_Date

datetime

Follow up action date

QAFNC_Fup_Veri_Comnt

sql_variant

follow up comments

QAFNC_HuFact

varchar(20)

Human factor value Quick code defined for human factor from Maintain Quick codes page

QAFNC_Modified_By

sql_variant

Modified BY

QAFNC_modifieddate

datetime

Modified Date

QAFNC_NCCat

varchar(20)

NC Category like supplier , general

QAFNC_NCDesc

sql_variant

NOT NULL

NC Description

QAFNC_NCRNO

NCR no Line no auto generation

QAFNC_NCStatus

varchar(20)

NULL

Status of NCs as defined in Maintain Quick code

QAFNC_NCUserStatus

user status of the NC Quick codes defined for user status in maintain quick codes page

QAFNC_ObjEvidence

sql_variant

QAFNC_ObsTyp

varchar(20)

observation type quick codes defined for observation type in Maintain Quick codes page

QAFNC_Ouinstance

int

NOT NULL

current instance

QAFNC_PropAction

sql_variant

NULL

Proposed action to be taken  for the Nc

QAFNC_RCA

root cause analysis have to be stored

QAFNC_RefProc

Reference procedure for the NC

QAFNC_ResPers_Capa

Responsible person for CAPA

QAFNC_RiskIndex

bigint

Risk Taken for the NC Processing

QAFNC_RootCause

sql_variant

Root cause defined under each root cause category values defined in Maintain Root cause category codes

QAFNC_Severity

varchar(20)

Severity of the NC

QAFNC_SrlNo

int

IDENTITY

NC serial no

QAFNC_timestamp

bigint

NOT NULL

time stamp for not allowing more than one user to access the same data

QA_QAFRD_Reference_Details

QAFRD_AudRepNo

sql_variant

Audit Report Number

QAFRD_created_By

NULL

Created user name

QAFRD_createdDate

datetime

Created date

QAFRD_FileName

varchar(20)

file name for reference

QAFRD_Modified_By

sql_variant

Modified user name

QAFRD_modifieddate

datetime

Modified date

QAFRD_Ouinstance

int

NOT NULL

current instance

QAFRD_RefDetails

sql_variant

NULL

Reference Details

QAFRD_RefElement

NOT NULL

Reference Element

QAFRD_RefNo

Reference Number

QAFRD_SrlNo

int

IDENTITY

System Generated Serial Number

QAFRD_timestamp

bigint

NOT NULL

timestamp for not allowing more than one user to process the same data

QA_QAFRO_Recommendations_Observations

QAFRO_ActBy

sql_variant

NULL

Action by

QAFRO_ActByDt

datetime

Action due by date

QAFRO_ActReq

varchar(20)

Action Required (Yes/No)

QAFRO_AudRepNo

sql_variant

NOT NULL

Audit Report Number

QAFRO_created_By

created user name

QAFRO_createdDate

datetime

created date

QAFRO_FileName

varchar(20)

file name for reference

QAFRO_Modified_By

sql_variant

NULL

Modified user name

QAFRO_modifieddate

datetime

modified date

QAFRO_Ouinstance

int

NOT NULL

current instance

QAFRO_Reco

sql_variant

Audit Recommendation

QAFRO_RecoCat

varchar(20)

NULL

Recommendation Category

QAFRO_SrlNo

int

IDENTITY

System generated Serial Number (Key)

QAFRO_timestamp

bigint

NOT NULL

timestamp for not allowing more than one user to process the same data

QA_QANCH_NC_Resul_Hist

QANCH_Act_By

sql_variant

NULL

Action taken by person

QANCH_Act_Dt

datetime

NOT NULL

Actioned Date

QANCH_Action

varchar(20)

Action Taken like pending action , cancel, report conformance, close will be given

QANCH_AudRepNo

sql_variant

Audit Report no

QANCH_Cmnts

NC Comments

QANCH_created_By

Created by

QANCH_createdDate

datetime

Created Date

QANCH_Ext_Days

int

If report extension is given as Action then extension days to be given

QANCH_modified_By

sql_variant

NULL

Modified BY

QANCH_modifieddate

datetime

Modified Date

QANCH_NC_Status

varchar(20)

NOT NULL

status of NC values will be like actioned, pending , closed

QANCH_NC_UsrStatus

user status for NC

QANCH_NCRNO

sql_variant

NCR No

QANCH_Ouinstance

int

current instance

QANCH_SrlNo

IDENTITY

NC Serial no

QANCH_timestamp

bigint

NOT NULL

time stamp to avoid more than one user accessing the same data

QA_QAPRM_parameter_dtl

QAPRM_ComponentName

varchar(20)

Component Name

QAPRM_CreationDate

datetime

NULL

created date

QAPRM_Langid

int

NOT NULL

Language id

QAPRM_ParamCategory

varchar(20)

Parameter Category

QAPRM_ParamCode

Parameter Code for the type of description given

QAPRM_ParamDesc

sql_variant

Parameter description for the specified parameter type

QAPRM_ParamType

varchar(20)

Parameter Type

QAPRM_Sort_By

int

NULL

value used to sort the values

QA_QAQC_Quick_Code

QAQC_created_By

sql_variant

NOT NULL

QAQC_createdDate

datetime

QAQC_Default

varchar(20)

QAQC_description

sql_variant

QAQC_modified_By

NULL

QAQC_modifieddate

datetime

QAQC_OUInstance

int

NOT NULL

The Organization unit at which user has logged in the system, and created the quality audit

QAQC_quick_code

varchar(20)

QAQC_Status

QAQC_timestamp

bigint

QAQC_Type

varchar(20)

The applicable values for this filter are: Audit Class, Audit Category, User Status, Root Cause Category, Severity, NC User Status, Recommendation Category, NC Category, Human Factor, Causal Category, Observation Type, Audit Rating. These values would be Pre defined

QA_QAQch_Quick_Code_Hdr

QAQch_Mandatory_Flag

NULL

Mandatory "Yes" or "No" flag Provision to set whether the Quick Code Type selected in header combo should be Mandatory or Non-mandatory, for the different User-Interfaces, in quality audit and other business components. The system would ensure that the Quick Code values of all the mandatory quick code types are specified during any transactions. Can be reset again.

QAQch_OUInstance

int

NOT NULL

The Organization unit at which user has logged in the system, and created the quality audit

QAQch_Timestamp

NULL

TimeStamp

QAQch_Type

varchar(20)

NOT NULL

The applicable values for this filter are: Audit Class, Audit Category, User Status, Root Cause Category, Severity, NC User Status, Recommendation Category, NC Category, Human Factor, Causal Category, Observation Type, Audit Rating. These values would be Pre defined

QAQch_Updated_By

NULL

User who has modified the quick code

QAQch_Updated_Date

datetime

Date on which Quick code was modified

QA_QARCC_Root_Cause_Codes

QARCC_created_By

sql_variant

created user name

QARCC_createdDate

datetime

created date

QARCC_modified_By

sql_variant

modified user name

QARCC_modifieddate

datetime

modified date

QARCC_Ouinstance

int

NOT NULL

current instance

QARCC_RC

sql_variant

Root cause

QARCC_RCCatg

varchar(20)

Root cause category

QARCC_RCDesc

sql_variant

Root cause description

QARCC_RCStat

varchar(20)

Status of root cause

QARCC_Remarks

sql_variant

NULL

Remarks

QARCC_timestamp

bigint

NOT NULL

timestamp for not allowing more than one user to process the same data

QA_QASAD_Quality_Audit_Schedule_AuditDetails

QASAD_AudAgency

varchar(20)

Auditing agency  and the values will be like Internal External Audit Department Regulatory Authority

QASAD_AudClass

Quick codes for Audit class quick codes defined in Maintain quick codes page

QASAD_AudDesc

sql_variant

Description of Audit Schedule

QASAD_AudEnt

QASAD_AudEntName

entity name to which the  supplier belongs

QASAD_AudSchNo

unique code for  identification for schedules can be given by the user. or else auto generated depending on the numbering type defined for Audit schedule no

QASAD_AudScope

Scope of audit

QASAD_AudTyp

varchar(20)

Type of Audit. will be having values like Warehouse supplier employee station workcenter others

QASAD_created_By

sql_variant

NULL

created by name

QASAD_createdDate

datetime

Created Date

QASAD_modified_By

sql_variant

Modified BY

QASAD_modifieddate

datetime

Modified Date

QASAD_Ouinstance

int

NOT NULL

current instance

QASAD_timestamp

bigint

time stamp value to check for more than one user accessing the same data

QA_QASOD_Set_Options_Det

QASOD_AuditCat

varchar(20)

Category of Audit Have values from Quick Codes generated for  Audit category in Maintain Quick codes

QASOD_created_By

sql_variant

NULL

Created user name

QASOD_createdDate

datetime

created date

QASOD_Instructions

sql_variant

NOT NULL

Instructions for the reference element

QASOD_Mandatory

varchar(20)

Whether it is mandatory or not values will be like yes or no

QASOD_modified_By

sql_variant

NULL

Modified user name

QASOD_modifieddate

datetime

Modified date

QASOD_Ouinstance

int

NOT NULL

current instance

QASOD_RefElement

sql_variant

Reference element

QASOD_SrlNo

int

IDENTITY

serial no for unique identification for the reference elements mentioned in the multi line

QASOD_timestamp

bigint

NOT NULL

timestamp value to avoid more than one person to process the same data Integer  value

QA_QASOH_Set_Options_Hdr

QASOH_All_Cls_NC_AR

varchar(20)

NULL

Allow closure of NC during CAPA for Adhoc Reports

QASOH_All_Cls_NC_DR

Allow closure of NC during CAPA for Direct Reports

QASOH_All_Cls_NC_SR

Allow closure of NC during CAPA for Scheduled Reports

QASOH_App_CAPA

Approval (required/not required) for corrective and preventive action taken

QASOH_App_NC

Approval of non-conformities is required/not required.

QASOH_Auto_Cls_Rep

Auto closure of report on all NC closure (Allowed/Not allowed)

QASOH_Confi_Aud_Rep

Confirmation of Audit Report (required or not required)

QASOH_created_By

sql_variant

Created by

QASOH_createdDate

datetime

Created Date

QASOH_DefNumTyp_Adhoc

sql_variant

NOT NULL

Default numbering type for Adhoc Report

QASOH_DefNumTyp_Direct

Default numbering type for Direct Report

QASOH_Edit_RC_CAPA

varchar(20)

NULL

Editing of Root cause (allowed/not allowed)

QASOH_Edit_RC_Proc_NC

Editing of Root Cause during Process NC/Reports (Allowed/not allowed)

QASOH_EmpOU

int

NOT NULL

The Organization unit at which employee  has logged in the system

QASOH_LeadAudit

sql_variant

Default auditor

QASOH_modified_By

NULL

Modified by

QASOH_modifieddate

datetime

Modified Date

QASOH_Ouinstance

int

NOT NULL

The Organization unit at which user has logged in the system, and created the quality audit

QASOH_StdDur_CA_Days

NULL

Standard duration for corrective action (days)

QASOH_timestamp

bigint

NOT NULL

Timestamp value to avoid more than one person to process the same data

QA_QASSD_Quality_Audit_Schedule_ScheduleDetails

QASSD_AudLoc

sql_variant

NULL

Audit Location where the instance names having the quality audit  can be done

QASSD_AudRepNoType

Audit report no type . will be having the numbering types defined for the report no

QASSD_AudSchNo

NOT NULL

Audit Schedule no  defined

QASSD_Comments

NULL

comments

QASSD_created_By

created by

QASSD_createdDate

datetime

created date

QASSD_DefAuditor

sql_variant

NOT NULL

Default auditor for the schedule

QASSD_EftTillDt

datetime

NULL

effectivity till date for the schedule

QASSD_EstDurn

bigint

NOT NULL

Estimated duration . should be in hours

QASSD_ExecStatus

varchar(20)

NULL

Execution status of schedule no values will be  like Pending Initiated Not Applicable.

QASSD_IntvlDays

int

interval days for next schedule

QASSD_LstPerDt

datetime

last performed Date

QASSD_modified_By

sql_variant

Modified By

QASSD_modifieddate

datetime

Modified Date

QASSD_NofOccur

smallint

no of times follow up schedule can be generated

QASSD_NofOccur_Completed

no of follow-ups completed

QASSD_NxtDueDt

datetime

Next due date for the schedule

QASSD_OthRef

sql_variant

reference details

QASSD_Ouinstance

int

NOT NULL

current instance

QASSD_RefProc

sql_variant

Reference Procedure.

QASSD_SchDtTime

datetime

NULL

scheduled date and time for the audit schedule no

QASSD_SchStatus

varchar(20)

schedule status  of audit schedule no values will be Active Inactive Terminated.

QASSD_Source

from where this schedule is generated whether by follow-up or by regular values like Regular Follow-up As Required

QASSD_SourceRefNo

sql_variant

source reference schedule no

QASSD_timestamp

bigint

NOT NULL

Time stamp value to check for more than one user acting on the same data