Versions Compared

Old Version 51

changes.mady.by.user D.Pachula

Saved on

compared with

New Version 52

changes.mady.by.user D.Pachula

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The IATF audits have different types of data structures. The used data structure is a mix of data structure design and efficient structure to be used in the application and requirements during the development. Fields are only generated if they receive a value, by default a missing field is an undefined field.

Data types

data types

description

bit

has values 0 and 1 (used for yes/no questions) as string “1”

boolean

has true and false (used for selects and business logic)

string

not limited string value (checked with business logic where possible, example Auditor Id)

int

int have only positive values

double

double have only positive values

different option types

every type is described in the data definition

date

exported as text string “2019-11-06T00:00:00.000Z”

timestamp

int in milliseconds

file data

All files are saved as base64 encoded string. Files are limited to jpeg image files and pdf files for security reasons

Export Format

All data can be exported as json or xml file. We recommend the use of json due to it’s lesser overhead a simpler rule set.

...

Warning

A data import using data completely created by an external system (i.e. ERP) is not allowed. The import of master data from external system is allowed for audit data, organization information, processes, extended manufacturing sites, providing and receiving support sites

View file
nameCaraNcManagementtDataDescriptionCaraAuditReportDataDescription_1.2.2.1.xlsx
View file
nameCaraAuditReportDataDescriptionCaraNcManagementtDataDescription_1.2.2.xlsx

Data types for CARA reports

Note

Providing the DataType and the uuid field is the minimum requirement for CARA to accept a report. Due to the nature of the dynamic object structure bad formatted fields may cause problems on printing or opening of a report.

You can always use the developer console of the browser to check for any errors. You will quickly find the field responsible for the error in the stack trace.

Data type

Report Type

Stage1ReadinessReview

Stage 1 readiness review

AuditReport

Audit report

RemoteAuditReport

Remote support function audit report

SpecialReport

Special audit report

NcManagement

NC management report when exported on it’s own. In general the Nc management is connected to the report it belongs to

AdhocNcReport

Adhoc Nc report

JSON Schema files

Audit Report JSON Schema

...

Data Description Release Information

Version

Date

Changes

1.2.2.1

17.09.21

  • Correction of field value due to typo

    • auditTypeOptions Stage 2 / Letter of conformance = 20 is 2

1.2.2

26.07.21

  • Only correction of data field name typos in the document

    • ManufacturingProcesses

      • NoOperationalShifts0 was and is NoOperationalShifts, reamined for Stage1 was migrated NoOperationalShiftsX per Shift in audit report

      • AuditTypeShiftObject (fields are based on audit type id and on 2 is the letter of conformance)

        • NoOperationalShifts2 = NoOperationalShifts3

        • NoOperationalShifts3 = NoOperationalShifts4

        • NoOperationalShifts4 = NoOperationalShifts5

        • NoOperationalShifts5 = NoOperationalShifts6

        • NoOperationalShifts6 = NoOperationalShifts7

1.2

02.05.21

  • Nc Management data description

    • password (internal)

    • encActivatedByOrganisation (internal)

    • fileSizeAttachments (internal + check in meta information)

    • IsAdhocNcMangement (only adhoc)

    • Organization

      • EvidenceOfImplementationFiles

      • RootCauseAnalysisImpactOtherProcesses

    • CbPreviousAnswers

  • Audit data description

    • fileSizeAttachments (internal + check in meta information)

    • AuditorNotes

    • AuditData

      • LastPerformedAuditCycle

      • AuditDateWaiver

      • ReportIssueData (only adhoc)

      • ReasonForAdhoxNc (only adhoc)

    • Address

      • Street 3

    • OrganizationInformation

      • CertificateScopeLanguage

      • CertificateScopeNative (migrated to CertificateScopeOther)

      • CertificateScopeOther

        • CertificateScope

        • Language

      • CorporateSchemeReferenceNumber

    • Process

      • ProcessNotAudited

      • ProcessAuditRemotely

    • ProvidingSupportSites

      • CbCertificateNo

    • ReceivingSupportSites

      • CbCertificateNo

    • ManufacturingProcesses

      • ShiftProcess

        • NoOperationalShiftsx (Shifts now per process)

        • ShiftTimes (collect shift times)

    • CustomerInformation

      • CustomerRequirementsAuditedObject

        • DateCSRDocument (type changed to string from date)

    • Conclusion

      • HasPreviousAuditNonconformities

      • PreviousAuditNonconformitiesObject

        • Id (internal use random)

        • SpecialAuditConducted

        • CreatedBy (internal use ADP)

1.1.9

15.12.20

  • New remote audit report fields

1.1.8

03.10.20

  • Fixed wrong position of CustomerRequirementsAudited

1.1.6

19.08.20

  • Fixed typos on Activities (no option addded)

1.1.4

13.07.20

  • Added missing data description for already existing Stage 1 results section fields (marked blue)

1.1

01.06.20

  • Nc Management data description

    • Removed OfiPoitiveAspects data block

    • Added AuditTeam (for business logic use)

    • Added MinorDate60, MajorDate20, MajorDate60 (for business logic use)

  • Audit data description

    • Added OfiPositiveAspects data block (moved from Nc management, CARA will automatically move that data block to the report when a report is loaded)

    • Added AddressNative to organisation information and all sites of type adress

    • Added CertificateScopeNative

    • Added Id field to addresses

    • Moved NextScheduledAuditType and DateNextScheduledAudit from AuditData to Results section (will be moved by Cara automatically when report is loaded)

    • Changed LanguageByManagementPersonnel, LanguageBySupportingPersonnel, LanguageByManufacturingPersonnel to array of string (converted by CARA)

    • Changed AuditTeamRecommendation to array of boolean (converted by CARA)

1.0.2

14.01.20

  • added encode/decode for xml files for compatibility

  • fixed mixing NCs on merging

  • added auto calculation and NC sync on audit merging

1.0.1

12.01.20

  • Patches on

    • Nc Management report

    • Audit data merge

    • Remote support function audit report

    • printing

1.0.0

06.01.20

  • Changes are marked in red for better recognition

  • Changes in Cara report audit data structure

    • LanguagesBy changed to array for multiple languages

    • AuditMergeDataObject added for Processes

  • Changes in Nc management data structure

    • Added Clause and Process to Ofi and PA

    • Added Id and CreatedBy based on application auditor id for data merging

    • Added RootCauseResult, RootCauseResultFiles

0.98.20

  • Changed in CaraReportAuditData OrganizationInformation fields

    • Management Supporting, Manufacturing personnel to array of string

  • Changed NcManagement

    • Process Ids and Names are imported from report to the NcManagement

    • NcAction

      • Nonconformity observed in process was changed to reference field to a process id, to connect it exactly to a report process. Deleting a process in the report will result in deleting the reference

0.98.02

25.11.19

Audit report description:

Removed OpportunitiesImprovement and replaced by

NumberOpportunitiesImprovement

Removed PositiveAspects and replaced by NumberPositiveAspects

0.98.01

21.11.19

Added missing fields in audit data and organization information