BasQAAudit

Column Table Name	Column Table Comment	Column Name	Column Datatype	Column Null Option	Column Comment
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			Modifed 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, WorkCentre, 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 defeined  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 Actioned Closed Pending action Cancel Depends on the user perference
		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	deferel 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 anlaysis have to be stored
		QAFNC_RefProc			Reference procedure for the NC
		QAFNC_ResPers_Capa			Responsable 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 acess 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 penidng 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 acessing the same data
QA_QAPRM_parameter_dtl		QAPRM_ComponentName	varchar(20)		Component Name
		QAPRM_CreationDate	datetime	NULL	created date
		QAPRM_Langid	int	NOT NULL	Languauge 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 genrated 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)		Catogory of Audit Have values from Quick quodes 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	Insttructions 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 noncormaties 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 followups 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 scheduleno
		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 followup 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