Date start and Date end

The start date can be a specific date or a relative date (for example - 30 days would include everything 30 days before the current date, - 3 months would go three months back from today).

The date filter will be based on dates according to their status:

• Planned: Will be filtered based on the following dates in the following order depending on the first one which is set:
  1. planned date (scheduled inspection date)
  2. booking date
  3. ETD
  For audits only planned date is applicable.

• In progress: Will be filtered based on start date.

• Report: Will be filtered based on end date.

Please note that since Qarma supports off-line operations, there can be a delay between the actual end date as measured on the mobile device and the time the data is available at Qarma’s server. This means if you filter for a daily extract of data, it needs to include data several days back to be sure all data is included.

Type

Inspections or Audits

Extra data

The basic data that is always exported is a list of inspections or audits, depending on type. In addition, the following data can be included:

• Checkpoints: For In progress and Report statuses, you can include a list of all checkpoints.

• Defects (inspections only): For In progress and Report statuses, you can include a list of all defects.

Only include checkpoints and defects if they are used, since they will contribute significantly to the size of the export file.

Status

Select one or more statuses:

• Planned

• In progress

• Report

Interval

Define how often the export job should run. This is quite flexible, so you can decide every day at 20:00, every Monday at 06:00, etc

Inspection id

Unique id for the inspection

Report inspection id

For combined inspections, this is the common id for all the inspections involved. For single inspections, the Report inspection id is the same as Inspection id (read more above).

Status

Can be Planned, In progress or Report

Order number

The order number

Order line id

This is the order line id used for data integrations to uniquely match order lines.

Item number

The item number

Item name

The item name

Supplier number

The supplier number

Supplier name

The supplier name

Inspection type

The type of inspection performed, e.g. Final or Inline.

Checklist name

The name of the checklist used to perform the inspection.

Inspector conclusion

The conclusion which the inspector selected when submitting the report.

Conclusion

The final conclusion chosen. This can differ from inspector conclusion if for example there is an approval flow. In most cases this is the conclusion to use for downstream analysis.

Inspector comment

This is the comment made by the inspector when submitting the inspection from the app.

Inspector name

The user name of the inspector that performed the inspection.

Inspector email

The email of the inspector.

Supplier qc

Will be TRUE if the inspector is member of the supplier’s group.

Etd

Estimated Time of Departure.

Inspection start time

The time when the first action was taken by the inspector (this could be taking a photo, marking the status of a checkpoint etc. ). It does not reflect the time of download.

Inspection end time

The time when the inspector submitted the inspection. Qarma supports off line operations, so there can be a difference between the Inspection end time and the time that the report is available in the system: if the inspector was offline for two hours, the app keeps track of the time when the inspection was submitted, and this time will be the Inspection end time, even if the Qarma server did not receive the data until two hours later.

Scheduled inspection date

When the inspection is planned.

Actual sample quantity

The sample qty is the number of pieces to be checked. Normally calculated based on AQL , but depending on permissions, this can be changed by the inspector.

Quantity available

The number of pieces available for the inspector. For split shipments, this will be the total qty for a specific shipment.

Quantity available source

Possible values are Combined inspection or Single inspection.

For combined inspections, the value can apply either to each individual inspection or the combined inspection as a whole, depending on how it was set by the inspector.

Original total quantity

The original qty on this order as derived from data integration with Qarma, or as manually set on the website prior to inspection.

Original sample quantity

The sample qty is the number of pieces to be checked. Unless the inspector makes changes during inspection, the Actual sample quantity and the Original sample quantity will be identical.

Re-inspection of

Shows the Report inspection id of the former inspection, e.g. if this is the 2nd inspection, then this field contains the 1st inspection's Report inspection id.

Split shipment of

Shows the Report inspection id of the inspection that was split.

Sequence identifier

A textual representation of the inspection sequence, derived from re-inspections and split shipments. For split shipments it will be marked with letters A-Z, and re-inspections with numbers.

As an example, B2 means a re-inspection of the second split shipment inspection.

Link to report

Can be used to open the report in Qarma

General minor defects

Number of general defects classified as minor

General major defects

Number of general defects classified as major

General critical defects

Number of general defects classified as critical

Minor defects pieces affected

Number of pieces affected by normal defects classified as minor

Major defects pieces affected

Number of pieces affected by normal defects classified as major

Critical defects pieces affected

Number of pieces affected by normal defects classified as critical

Actual sampling method

The sampling method used for the inspection. If the inspector changed the sampling method, the original one is listed in Original sampling method.

Original sampling method

See above

Minor defects threshold

The number of minor defects allowed according to AQL

Major defects threshold

The number of major defects allowed according to AQL

Critical defects threshold

The number of critical defects allowed according to AQL

Production unit number

If inspection is linked to a production unit, this will show the production unit’s number (if available)

Production unit name

If inspection is linked to a production unit, this will show the production unit’s name

Production unit address

If inspection is linked to a production unit, this will show the production unit’s address (if available)

Latitude

Tracking based on the last photo taken in this inspection

Longitude

Tracking based on the last photo taken in this inspection

Accuracy

For the GPS coordinates, this is the accuracy

Booking date

If chosen, this will show the booking date of the inspection

Booking note

Will show the booking note of the order

Booking last confirmed at

The date of last confirmation of booking date

Open corrective actions

Not in use yet

Resolved corrective actions

Not in use yet

Total corrective actions

Not in use yet

Checkpoint id

The id of the inspection’s checkpoint. It's unique to the inspection, meaning that the same checkpoint on another inspection will have a different Checkpoint id even though the same checklist has been used.

Master checkpoint id

The id of the master checkpoint. This will only appear for combined inspections where the inspector has made an action on the sub-checkpoint level. This means several Checkpoint ids can refer to the same Master checkpoint id.

Checkpoint type

Shows the type of checkpoint, e.g. Standard, Measurements, Barcode.

Inspection id

Unique id for the inspection.

Report inspection id

For combined inspections, this is the common id for all the inspections involved. For single inspections, the Report inspection id is the same as Inspection id. This is the id to map with the Report inspection id of the inspections table.

Checkpoint header

The name of the checkpoint-header in the checklist.

Checkpoint

The name of the checkpoint (often a sub-level to the Checkpoint header).

Status

The reported status of the checkpoint by the inspector.

Comment

The inspectors comments given when setting the status of the checkpoint.

Multiple choice

The value selected if the checkpoint is a multiple choice.

Score

The score if the checkpoint is a multiple choice.

max score

The maximum score possible to obtain for a checkpoint with multiple choice.

Raw data

The raw data of the entire checkpoint presented in json format.

Report inspection id

The id of the report that map to the Report inspection id of the inspections table.

Defect id

The id of the reported defect. This id is unique to this record, not to be confused with the defect code.

Checkpoint id

The id of the checkpoint where the defect was reported (can be empty).

Defect severity

The severity selected for the reported defect: Minor, Major or Critical.

Quantity affected

The quantity affected by the reported defect. For General defects, there will be an empty value.

General defect

Is it a general defect or not; If "false" then it's not a general defect, if "true" then it's a general defect.

Code hierarchy

This information is presented in a json format. It shows the hierarchy of the defect code that was reported, showing all the levels above the reported defect.

Top defect type code

Shows the defect code of the top level for the defect that was reported.

Top defect type name

Shows the defect name of the top level for the defect that was reported.

Parent defect type code

This will only have a value of you have a 3-layered defect list. Then it will show the name of the mid-level defect.

Parent defect type name

This will only have a value of you have a 3-layered defect list. Then it will show the code of the mid-level defect.

Defect type code

Shows the code of the reported defect.

Defect type name

Shows the name of the reported defect.

Defect type description

The description of the defect type

Comment

Textual description of the defect made by the inspector.

Audit id

Unique id for the Audit. Used to map the Audits sheet with Checkpoints.

Status

Can be Planned, In progress or Report

Planned date

The planned date for performing the audit

Audit start time

The time and date the first action was taken on the Audit.

Audit end time

The time and date the Audit was submitted

Supplier name

The name of the audited supplier

Supplier number

The number of the audited supplier

Auditor name

Name of the user who performed the Audit

Auditor email

Email of the user who performed the Audit

Production unit name

If the audit is linked to a production unit, this will show the production unit’s name

Production unit number

If the audit is linked to a production unit, this will show the production unit’s number (if available)

Production unit address

If the audit is linked to a production unit, this will show the production unit’s address (if available)

Latitude

Tracking based on the last photo taken in this inspection

Longitude

Tracking based on the last photo taken in this inspection

Accuracy

For the GPS coordinates, this is the accuracy

Auditor comment

Ending comment made by auditor

Checklist name

The name of the checklist used

Link to report

URL link to the report

Audit type

The type of audit performed

Checkpoint id

The id of the Audit’s checkpoint. It's unique to the inspection, meaning that the same checkpoint on another inspection will have a different Checkpoint id even though the same checklist has been used.

Checkpoint type

Shows the type of checkpoint, e.g. Standard, Measurements, Multiple Choice, Text.

Audit id

Unique id for the Audit. Used to map the Checkpoints sheet with Audits.

Checkpoint header

The header from the checklist.

Checkpoint

The title of the checkpoint

Status

Status of the checkpoint, e.g. Checked OK, Checked Not OK, Pending.

Comment

Comments made on the specific checkpoint

Multiple choice

The value selected if the checkpoint is a multiple choice.

Score

The score if the checkpoint is a multiple choice.

Max score

The maximum score possible to obtain for a checkpoint with multiple choice.

Raw data

The raw data of the entire checkpoint presented in json format.