HTM-Reports

Table Owner Table Name Table Comment Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK
dbo QA_CAPANCR_NonConformance_Reports This table stores the data of non conformance details after capa processing CAPANCR_Ouinstance int NOT NULL current instance Yes Yes
      CAPANCR_AudRepNo sql_variant   Audit Report Number against which this non-conformance is being logged.   No
      CAPANCR_QAFNC_NCRNO int   Non-conformance number    
      CAPANCR_NCCategory varchar(20) NULL Non-conformance category. No  
      CAPANCR_NCUsrStatus     User Status    
      CAPANCR_Action     Action required to close the non-conformance    
      CAPANCR_ActByDt datetime   Date on or before which the non-conformance should be acted upon.    
      CAPANCR_Corr_Action sql_variant   Corrective Action required to close the non-conformance.    
      CAPANCR_Prevent_Action     Preventive Action required to ensure the non-conformance does not repeat in future.    
      CAPANCR_RootCause_RCCatg varchar(20)   Root cause category   Yes
      CAPANCR_RootCause_RC sql_variant NOT NULL Root cause that caused the Non-conformance    
      CAPANCR_Contri_Factor_RCCatg varchar(20) NULL Factor that contributed to the root cause    
      CAPANCR_Contri_Factor_RC sql_variant   contribution factor for the Root cause category    
      CAPANCR_RtCause_Anlys     Root cause Analysis   No
      CAPANCR_HuFact varchar(20)   Human factor that caused the non-conformance    
      CAPANCR_CasCat     Category of the Cause    
      CAPANCR_Impact_Anlys sql_variant   Impact Analysis    
      CAPANCR_Impt_Anlys_Ref     Reference to impact analysis    
      CAPANCR_Approver     Person who has to approve the closure of Non-conformance    
      CAPANCR_FileName varchar(20)   Name of any supporting document attached.    
      CAPANCR_AuditeeRemarks sql_variant   Remarks of the auditee.    
      CAPANCR_SrlNo int IDENTITY Running serial number. This is system generated value and unique.    
      CAPANCR_created_By sql_variant NOT NULL Created user name    
      CAPANCR_createdDate datetime   Created date    
      CAPANCR_Modified_By sql_variant NULL Modifed user name    
      CAPANCR_modifieddate datetime   modified date    
      CAPANCR_timestamp bigint NOT NULL timestamp value for not allowing more than one user to process the same data    
  QA_CAPAROB_Recommendations_Observations This table holds the data of Recomendations and observations for the corresponding report no CAPAROB_Ouinstance int   current instance Yes Yes
      CAPAROB_AudRepNo sql_variant   Audit Report Number    
      CAPAROB_QAFRO_SrlNo int   System generated serial number (Key)    
      CAPAROB_ActByDt datetime NULL Action due by date No No
      CAPAROB_Action varchar(20)   Action    
      CAPAROB_AuditeeRemarks sql_variant   Auditee remarks    
      CAPAROB_Updated_By     updated username    
      CAPAROB_UpdatedDate datetime   updated date    
      CAPAROB_Approver sql_variant   capa approver    
      CAPAROB_FileName varchar(20)   file name for reference    
      CAPAROB_Srl_No int IDENTITY serial no for multi value reference    
      CAPAROB_created_By sql_variant NOT NULL created user name    
      CAPAROB_createdDate datetime   created date    
      CAPAROB_Modified_By sql_variant NULL Modified user name    
      CAPAROB_modifieddate datetime   Modified date    
      CAPAROB_timestamp bigint NOT NULL timestamp value for not allowing more than one user to process the same data    
  QA_QAAUD_Quality_Audit This table holds the  quality audit header values QAAUD_Ouinstance int   current instance Yes  
      QAAUD_AudRepNo sql_variant   Audit Report Number    
      QAAUD_AudStatus   NULL Audit Status No  
      QAAUD_RefDocTyp varchar(20) NOT NULL Reference Document type    
      QAAUD_RefDocNo sql_variant NULL Reference Document Number    
      QAAUD_ReportType   NOT NULL Report Type    
      QAAUD_AudSchNo   NULL Audit Schedule Number    
      QAAUD_RefDocDet     Reference doc details. All documents saved against various Reference Document Type for the selected Audit Report#    
      QAAUD_AudTyp varchar(20) NOT NULL Audit Type (Supplier, Employee, Station, Warehouse, WorkCentre, Others)    
      QAAUD_AudEntity sql_variant   Audit Entity    
      QAAUD_AudEntityName     Audit Entity Name (If Audit Entity is ’supplier’ then entity name is a valid Supplier Name)    
      QAAUD_AudClass varchar(20) NULL Audit Class (Quick Code)    
      QAAUD_AudReason sql_variant   Audit Reason    
      QAAUD_AudObjective     Audit Objective    
      QAAUD_AudScope     Audit Scope    
      QAAUD_AddRef     Additional Reference    
      QAAUD_AudLocn int   Audit Location    
      QAAUD_Venue sql_variant   Audit Venue    
      QAAUD_Auditor   NOT NULL Auditor Name    
      QAAUD_Auditee     Auditee name    
      QAAUD_AudSchDateTime datetime   Audit Scheduled date and time    
      QAAUD_EstDuration bigint NULL Estimated duration of audit    
      QAAUD_AudInitComments sql_variant   Audit comments    
      QAAUD_FileName varchar(20)   file name for reference    
      QAAUD_created_By sql_variant   created user name    
      QAAUD_createdDate datetime   created date    
      QAAUD_modified_By sql_variant   Modified user name    
      QAAUD_modifieddate datetime   modified date    
      QAAUD_timestamp bigint NOT NULL timestamp value for not allowing more than one user to process the same data    
      QAAUD_Category varchar(20) NULL This field holds quality audit category    
      QAAUD_User_Status     This field holds quality audit user status    
  QA_QACAPA_Corrective_Preventive_Action This table holds the corrective and preventive actions for the audit QACAPA_Ouinstance int NOT NULL current instance Yes Yes
      QACAPA_AudRepNo sql_variant   Audit Report Number on which the CAPA is done    
      QACAPA_UserStatus varchar(20) NULL User Status of the corrective preventive action taken No No
      QACAPA_Approver sql_variant   Name of the approver    
      QACAPA_created_By   NOT NULL created user name    
      QACAPA_createdDate datetime   created date    
      QACAPA_Modified_By sql_variant NULL modified user name    
      QACAPA_modifieddate datetime   modified date    
      QACAPA_timestamp bigint NOT NULL timestamp value for not allowing more than one user to process the same data    
QA_QAEDREF_RefDoc_Dtls TO store reference document details of audit reports . QAEDREF_created_By varchar(20) NULL created user name    
    QAEDREF_timestamp int   timestamp for not allowing more than one person to process the same data    
    QAEDREF_Remarks sql_variant NOT NULL remarks    
    QAEDREF_createdDate datetime NULL created date    
    QAEDREF_Modified_By sql_variant NOT NULL modified user name    
    QAEDREF_modifieddate datetime NULL modified date    
    QAEDREF_AudRepNo sql_variant NOT NULL audit report no for which the reference document details were stored Yes Yes
    QAEDREF_Ouinstance int   current instance    
    QAEDREF_FileName varchar(20) NULL reference file name No No
    QAEDREF_DocumentId varchar(30)   unique id for the document    
    QAEDREF_LineNo int NOT NULL line no for identification of multiple reference documents for the same audit rep # Yes  
    QAEDREF_RefDocType char(20)   reference document type The values defeined  for reference document type No  
dbo QA_QAF_Quality_Audit_Findings This table stores the the problems identified for the audit QAF_Ouinstance int   current instance Yes  
      QAF_AudRepNo sql_variant   Audit Report Number    
      QAF_AudStatus     Audit Status No  
      QAF_RefDocTyp   NULL Reference Document Type    
      QAF_RefDocNo     Reference Document Number    
      QAF_AuditCat varchar(20)   Audit Category    
      QAF_UserStatus     User Status    
      QAF_RefDocDet sql_variant   Reference Document Details    
      QAF_ReportType     Report Type (Scheduled, Adhoc or Direct)    
      QAF_AudTyp varchar(20)   Audit Type (Quick Code)    
      QAF_AudSchNo sql_variant   Audit Schedule Number    
      QAF_ActStDt datetime   Actual Start Date of the audit    
      QAF_ActEnDt     Actual End Date of audit    
      QAF_ActManHrs bigint   Actual Man hours of audit    
      QAF_AudRating varchar(20)   Audit Rating    
      QAF_FileName     file name for reference    
      QAF_Venue sql_variant   Audit Venue    
      QAF_Auditor   NOT NULL Auditor Name    
      QAF_Auditee     Auditee Name    
      QAF_ResPers_CAPA     Person responsible for Corrective and Preventive Action    
      QAF_UsrName_Code     User Name    
      QAF_AppAuthority     Approval Authority    
      QAF_AudEntity     Audit Entity    
      QAF_AudEntityName     Audit Entity Name    
      QAF_RecoBy     Recommendation By    
      QAF_OthPersons   NULL Other Persons    
      QAF_AudFind     Audit findings    
      QAF_BestPract     Best Practice    
      QAF_CaryOvrItem     Carry Over Item    
      QAF_ClsComments     Audit Closure Comments    
      QAF_AudImpli varchar(20)   Audit Implications    
      QAF_ClsAud     Class of Audit    
      QAF_created_By sql_variant   Created user name    
      QAF_createdDate datetime   created date    
      QAF_Modified_By sql_variant   Modified user name    
      QAF_modifieddate datetime   Modified date    
      QAF_timestamp bigint NOT NULL timestamp value for not allowing more than one person to process the same data    
  QA_QAFNC_Nonconformance_Report This table holds the data of non conformance report when the details were entered in Record Audit findings page QAFNC_Ouinstance int   current instance Yes  
      QAFNC_AudRepNo sql_variant   Audit report no for the given schedule no    
      QAFNC_NCRNO     NCR no Line no auto generation    
      QAFNC_NCDesc     NC Description No  
      QAFNC_NCCat varchar(20) NULL NC Category like supplier , general    
      QAFNC_NCUserStatus     user status of the NC Quick codes defined for user status in maintain quick codes page    
      QAFNC_NCStatus     Status of NCs as defined in Maintain Quick code    
      QAFNC_Action     Defines the type of action taken can be report conformance Actioned Closed Pending action Cancel Depends on the user perference    
      QAFNC_Severity     Severity of the NC    
      QAFNC_RefProc sql_variant   Reference procedure for the NC    
      QAFNC_RiskIndex bigint   Risk Taken for the NC Processing    
      QAFNC_ObjEvidence sql_variant   Object Evidence    
      QAFNC_PropAction     Proposed action to be taken  for the Nc    
      QAFNC_ActByDt datetime   Action by date    
      QAFNC_ResPers_Capa sql_variant   Responsable person for CAPA    
      QAFNC_ObsTyp varchar(20)   observation type quick codes defined for observation type in Maintain Quick codes page    
      QAFNC_RootCause sql_variant   Root cause  defined under each root cause category values defined in Maintain Root cause category codes    
      QAFNC_Contri_RCCatg varchar(20)   contributing factor : All Active root cause categories will be given    
      QAFNC_Contri_RC sql_variant   Contributing root cause    
      QAFNC_RCA     root cause anlaysis have to be stored    
      QAFNC_HuFact varchar(20)   Human factor value Quick code defined for human factor from Maintain Quick codes page    
      QAFNC_CasCat     casual category quick codes defined for casual category in Maintain Quick codes page    
      QAFNC_FileName     file name    
      QAFNC_AuditorRemarks sql_variant   auditor Remarks    
      QAFNC_Cls_Comnt     Auditor Remarks    
      QAFNC_ExtByDays int   extended days    
      QAFNC_Fup_Act_Date datetime   Follow up action date    
      QAFNC_Fup_Veri_Comnt sql_variant   follow up comments    
      QAFNC_Dfrl_Count int   deferel count of NC    
      QAFNC_SrlNo   IDENTITY NC serial no    
      QAFNC_created_By sql_variant NOT NULL Created by    
      QAFNC_createdDate datetime   Created Date    
      QAFNC_Modified_By sql_variant NULL Modified BY    
      QAFNC_modifieddate datetime   Modified Date    
      QAFNC_timestamp bigint NOT NULL time stamp for not allowing more than one user to acess the same data    
  QA_QAFRD_Reference_Details This table holds the reference details of the quality audit reports QAFRD_Ouinstance int   current instance Yes  
      QAFRD_AudRepNo sql_variant   Audit Report Number    
      QAFRD_RefElement     Reference Element No  
      QAFRD_RefNo     Reference Number    
      QAFRD_RefDetails   NULL Reference Details    
      QAFRD_FileName varchar(20)   file name for reference    
      QAFRD_SrlNo int IDENTITY System Generated Serial Number    
      QAFRD_created_By sql_variant NULL Created user name    
      QAFRD_createdDate datetime   Created date    
      QAFRD_Modified_By sql_variant   Modified user name    
      QAFRD_modifieddate datetime   Modified date    
      QAFRD_timestamp bigint NOT NULL timestamp for not allowing more than one user to process the same data    
  QA_QAFRO_Recommendations_Observations This table holds the recommendations and observations to be recorded for the quality audit in record audit findings page QAFRO_Ouinstance int   current instance Yes  
      QAFRO_AudRepNo sql_variant   Audit Report Number    
      QAFRO_SrlNo int IDENTITY System generated Serial Number (Key)    
      QAFRO_Reco sql_variant NOT NULL Audit Recommendation No  
      QAFRO_ActReq varchar(20) NULL Action Required (Yes/No)    
      QAFRO_RecoCat     Recommendation Category    
      QAFRO_ActByDt datetime   Action due by date    
      QAFRO_ActBy sql_variant   Action by    
      QAFRO_FileName varchar(20) NOT NULL file name for reference    
      QAFRO_created_By sql_variant   created user name    
      QAFRO_createdDate datetime   created date    
      QAFRO_Modified_By sql_variant NULL Modified user name    
      QAFRO_modifieddate datetime   modified date    
      QAFRO_timestamp bigint NOT NULL timestamp for not allowing more than one user to process the same data    
  QA_QANCH_NC_Resul_Hist This table holds the details of the non confirmance details for each and every change in action. QANCH_SrlNo int IDENTITY NC Serial no    
      QANCH_created_By sql_variant NOT NULL Created by    
      QANCH_Cmnts     NC Comments    
      QANCH_Ext_Days int   If report extension is given as Action then extension days to be given    
      QANCH_modifieddate datetime NULL Modified Date    
      QANCH_createdDate   NOT NULL Created Date    
      QANCH_modified_By sql_variant NULL Modified BY    
      QANCH_timestamp bigint NOT NULL time stamp to avoid more than one user acessing the same data    
      QANCH_AudRepNo sql_variant   Audit Report no Yes Yes
      QANCH_NCRNO     NCR No    
      QANCH_Ouinstance int   current instance    
      QANCH_Act_By sql_variant NULL Action taken by person No No
      QANCH_NC_UsrStatus varchar(20) NOT NULL user status for NC    
      QANCH_Act_Dt datetime   Actioned Date Yes  
      QANCH_NC_Status varchar(20)   status of NC values will be like actioned, pending , closed No  
      QANCH_Action     Action Taken like penidng action , cancel, report conformance, close will be given    
  QA_QAPRM_parameter_dtl This table holds the details of all the descriptions of the design paramcodes handled in the component QAPRM_ComponentName     Component Name Yes  
      QAPRM_ParamCategory     Parameter Category    
      QAPRM_ParamType     Parameter Type    
      QAPRM_ParamCode     Parameter Code for the type of description given    
      QAPRM_Langid int   Languauge id    
      QAPRM_ParamDesc sql_variant   Parameter description for the specified parameter type No  
      QAPRM_Sort_By int NULL value used to sort the values    
      QAPRM_CreationDate datetime   created date    
  QA_QAQC_Quick_Code This table holds all the quick codes generated for the component with the combination of the quick code its description and for which category QAQC_createdDate   NOT NULL      
      QAQC_created_By sql_variant   created user name    
      QAQC_Default varchar(20)   default value    
      QAQC_modified_By sql_variant NULL modified user name    
      QAQC_modifieddate datetime   modified date    
      QAQC_timestamp bigint NOT NULL time stamp value for not allowing more than one user to process the same data    
      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 Yes Yes
      QAQC_OUInstance int   The Organization unit at which user has logged in the system, and created the quality audit    
      QAQC_Status varchar(20)   status No No
      QAQC_quick_code     the quick code to be created for each of the types Yes  
      QAQC_description sql_variant   description for the quick code No  
QA_QAQch_Quick_Code_Hdr This table holds the header values for the quick code defining Primary details for the quick code defined QAQch_OUInstance int   The Organization unit at which user has logged in the system, and created the quality audit Yes  
    QAQch_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    
    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. No  
    QAQch_Updated_Date datetime   Date on which Quick code was modified    
    QAQch_Updated_By varchar(20)   User who has modified the quick code    
    QAQch_Timestamp int   TimeStamp    
dbo QA_QARCC_Root_Cause_Codes This table holds the primary root cause codes for the root cause category defined QARCC_Ouinstance   NOT NULL current instance Yes  
      QARCC_RCCatg varchar(20)   Root cause category    
      QARCC_RC sql_variant   Root cause    
      QARCC_RCDesc     Root cause description No  
      QARCC_RCStat varchar(20)   Status of root cause    
      QARCC_Remarks sql_variant NULL Remarks    
      QARCC_created_By     created user name    
      QARCC_createdDate datetime   created date    
      QARCC_modified_By sql_variant   modified user name    
      QARCC_modifieddate datetime   modified date    
      QARCC_timestamp bigint NOT NULL timestamp for not allowing more than one user to process the same data    
  QA_QASAD_Quality_Audit_Schedule_AuditDetails This table holds the audit schedule details QASAD_Ouinstance int   current instance Yes  
      QASAD_AudSchNo sql_variant   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_AudDesc     Description of 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_AudEnt sql_variant   Audit  Entity    
      QASAD_AudEntName     entity name to which the  supplier belongs    
      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_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_timestamp bigint NOT NULL time stamp value to check for more than one user accessing the same data    
  QA_QASOD_Set_Options_Det This table holds the default set options detailed information at component level Information from multiline in set options page QASOD_Ouinstance int   current instance Yes  
      QASOD_AuditCat varchar(20)   Catogory of Audit Have values from Quick quodes generated for  Audit category in Maintain Quick codes    
      QASOD_RefElement sql_variant   Reference element    
      QASOD_Mandatory varchar(20)   Whether it is mandatory or not values will be like yes or no No  
      QASOD_Instructions sql_variant   Insttructions for the reference element    
      QASOD_SrlNo int IDENTITY serial no for unique identification for the reference elements mentioned in the multi line    
      QASOD_created_By sql_variant NULL Created user name    
      QASOD_createdDate datetime   created date    
      QASOD_modified_By sql_variant   Modified user name    
      QASOD_modifieddate datetime   Modified date    
      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 This table holds the information of the set options at component level hdr table -- header values from set options page QASOH_Ouinstance int   The Organization unit at which user has logged in the system, and created the quality audit    
      QASOH_EmpOU     The Organization unit at which employee  has logged in the system    
      QASOH_LeadAudit sql_variant   Default auditor    
      QASOH_DefNumTyp_Adhoc     Default numbering type for Adhoc Report    
      QASOH_DefNumTyp_Direct     Default numbering type for Direct Report    
      QASOH_StdDur_CA_Days int NULL Standard duration for corrective action (days)    
      QASOH_Confi_Aud_Rep varchar(20)   Confirmation of Audit Report (required or not required)    
      QASOH_App_NC     Approval of noncormaties is required/not required.    
      QASOH_App_CAPA     Approval (required/not required) for corrective and preventive action taken    
      QASOH_Edit_RC_CAPA     Editing of Root cause (allowed/not allowed)    
      QASOH_Edit_RC_Proc_NC     Editing of Root Cause during Process NC/Reports (Allowed/not allowed)    
      QASOH_Auto_Cls_Rep     Auto closure of report on all NC closure (Allowed/Not allowed)    
      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_All_Cls_NC_AR     Allow closure of NC during CAPA for Adhoc Reports    
      QASOH_created_By sql_variant   Created by    
      QASOH_createdDate datetime   Created Date    
      QASOH_modified_By sql_variant   Modified by    
      QASOH_modifieddate datetime   Modified Date    
      QASOH_timestamp bigint NOT NULL Timestamp value to avoid more than one person to process the same data    
  QA_QASSD_Quality_Audit_Schedule_ScheduleDetails This table holds the information about Quality Audit Schedule details QASSD_AudLoc sql_variant NULL Audit Location where the instance names having the quality audit  can be done    
      QASSD_SchStatus varchar(20)   schedule status  of audit schedule no values will be Active Inactive Terminated.    
      QASSD_ExecStatus     Execution status of schedule no values will be  like Pending Initiated Not Applicable.    
      QASSD_SchDtTime datetime   scheduled date and time for the audit scheduleno    
      QASSD_AudRepNoType sql_variant   Audit report no type . will be having the numbering types defined for the report no    
      QASSD_DefAuditor   NOT NULL Default auditor for the schedule    
      QASSD_modified_By   NULL Modified By    
      QASSD_modifieddate datetime   Modified Date    
      QASSD_Source varchar(20)   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_createdDate datetime   created date    
      QASSD_created_By sql_variant   created by    
      QASSD_timestamp bigint NOT NULL Time stamp value to check for more than one user acting on the same data    
      QASSD_EstDurn     Estimated duration . should be in hours    
      QASSD_RefProc sql_variant   Reference Procedure.    
      QASSD_IntvlDays int NULL interval days for next schedule    
      QASSD_AudSchNo sql_variant NOT NULL Audit Schedule no  defined Yes Yes
      QASSD_Ouinstance int   current instance    
      QASSD_Comments sql_variant NULL comments No No
      QASSD_NofOccur_Completed smallint   no of followups completed    
      QASSD_OthRef sql_variant   reference details    
      QASSD_LstPerDt datetime   last performed Date    
      QASSD_NxtDueDt     Next due date for the schedule    
      QASSD_NofOccur smallint   no of times follow up schedule can be generated    
      QASSD_EftTillDt datetime   effectivity till date for the schedule