Configuring Data Sources

You can configure the properties of data sources required to set up CAPA and Audit Management.

See Properties for Data Sources

  1. Create or open the text file for customized properties. For more information, see Editing Properties Using MQL.
  2. To define data source types using which only corrective CAPA can be created, follow these steps:
    1. Add or edit this line in the file used to import properties into a page object:

      QIC.CorrectiveDataSource.Types=type_Complaint

      The property value can be names of the required data sources such as type_Complaint, type_EquipmentServiceRequest .

    2. Set the value for this property depending on your business requirements.
  3. To define data source types that the user can add to a CAPA Request or a CAPA, follow these steps:
    1. Add or edit this line in the file used to import properties into a page object:

      QIC.DataSource.SeachTypes=type_Complaint

      The property value can be names of the required data sources such as type_Complaint, type_EquipmentServiceRequest .

    2. Set the value for this property depending on your business requirements.
  4. To define the location to collect the description of the data sources, follow these steps:
    1. Add or edit this line in the file used to import properties into a page object:

      QIC.DataSource.ProblemStatementSelectable= type_ComplaintEvent|attribute[Complaint Event Detail].value.

      Below are the property values:

      For complaints, type_Complaint|from[Complaint Event].to.attribute[Complaint Event Detail].value.

      For events, type_ComplaintEvent|attribute[Complaint Event Detail].value.

      For equipment service requests, type_EquipmentServiceRequest|from[Complaint Event].to.attribute[Complaint Event Detail].value.

      For non-conformance reports, type_NCR|description.

      For audit findings, type_AuditFinding|description.

    2. Set the value for this property depending on your business requirements.
  5. To define the selectable to find the closed date for data sources, follow these steps:
    1. Add or edit this line in the file used to import properties into a page object:

      QIC.DataSource.ClosedDateSelectable=type_Complaint|attribute[Closed Date].value

      Below are the property values:

      For complaints, type_Complaint|attribute[Closed Date].value

      For events, type_ComplaintEvent|

      For Equipment Service Requests, type_EquipmentServiceRequest|attribute[Closed Date].value

      For Non-Conformance Reports, type_NCR|attribute[attribute[Closed Date].value].value

      For audit findings, type_AuditFinding|state[Closed].actual

      For example, for all data sources, the value of QIC.DataSource.ClosedDateSelectable must be type_Complaint|attribute[Closed Date].value,type_ComplaintEvent|,type_EquipmentServiceRequest|attribute[Closed Date].value,type_NCR|attribute[attribute[Closed Date].value].value,type_AuditFinding|state[Closed].actual .

    2. Set the value for this property depending on your business requirements.
  6. When you are finished updating the text file with all properties that you want to modify, use the text file to modify the LQICAPA.properties page object. For more information, see Editing Properties Using MQL.