Versions Compared

Key

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

...

View file
nameCaraAuditReportDataDescription_1.34.xlsx
View file
nameCaraNcManagementtDataDescription_1.34.xlsx

Data types for CARA reports

...

NC Management JSON Schema

Example files for different report types

View file
name04.May.22-Stage1ReadinessReview-23-02.Jan.2020-23.Jan.2020.json
View file
name04.May.22-RemoteAuditReport-12-121-22.Jan.2020-04.Feb.2020.json
View file
name04.May.22-SpecialReport-45-67-20.Mar.2020-26.Mar.2020.json

...

Functionality on import

On import the data is not checked against the business logic. The only transformation is handled on xml data integrating into arrays where required and removing the Xz on tags starting with a number. At the moment checks are connected to the page in which that content will be entered. This is due to avoid to many calculations within the browser on each change of any data.

...

Data Description Release Information

Version

Date

Changes

1.4RC1

31.05.22

  • added ReasonForLetterOfConformance in AuditData

  • Receiving support from location

    • added NotYetAudited

  • changed Customer Information

    • Customers container added to collect customer information

      • part of CustomerRequirementsAuditedObject moved to CustomerKpiObject

      • part of CustomerRequirementsAuditedObject moved to CustomerCsrObject rest to CustomerObject

      • full legacy support with data migration from old to new data structure

  • Manufacturing processes was moved to legacy support and is replaced by Shifts data migration not possible

  • changed ProcessObject

    • added Shifts array of new ShiftsObject for manufacturing shifts in Stage 1 and Audit report

    • added ExtendedShifts of new ShiftsObject for extended manufacturing shifts in Stage 1 and Audit report

    • added AuditNotes of AuditNoteObject replacing AuditInformation with full legacy support migrating AuditInformation into AuditNotes

    • added CustomerCsrReference referencing id in CustomerCsrObject from CustomerObject

  • NcManagment

    • AudiData

      • added IsCertificateRequired, IsUsiRequired business logic helpers

      • added IATFCertificateNo, Usi

      • added text field for all nc client answer section for translations

    • NcActionsObject

      • added MajorSubmissions of array SubmissionObject

For example data creation and testing please use the development site. Data description files:

1.3.2

02.10.22

  • added IATF USI to

    • Organization Information

    • Extended Manufacturing Sites

    • Providing Support Locations

    • Receiving Support Locations

  • AuditData

    • WitnessedBy

      • added Witnessed Auditors as array of AuditorIds

  • Extended Manufacturing sites

    • TotalNumberEmployees

  • CustomerInformation

    • CustomerrRequirementsAudited

      • added EmsSupplierCodes as Object with Object: { ExtendedManufacturinSite.Id : string, … }

1.3.1

18.07.22

  • Audit report

    • Conclusion

      • PreviousAuditNonconformitiesObject

        • added ProcessAuditLead; for merge of audit reports

  • added Complaint; for preformance complaint data attachment

1.3

12.04.22

This update added a lot of fields due to business rules and inheritance functionality capabilities. Most noticable are new mandatory NcObservedProcess and the PreviouslyAudited for the process audited history.

  • Audit reports

    • IsRemoteSupportLocation

    • InternalNotes

    • ReportPdf (base64 encoded reporrts)

    • OrganizationInfromation

      • HasChangesSinceLastAudit

    • Process

      • ProcessObject

        • ProcessEntryState

      • PreviouslyAudited

        • 1 (Stage2)

        • 3 (Surveillance 1)

        • 4 (Surveillance 2)

        • 5 (Surveillance 3)

        • 6 (Surveillance 4)

        • 7 (Surveillance 5)

      • Activities (inheritance field)

      • ProcessPerformance

        • History (array of HistoryObjects)

          • AuditType

          • CurrentTarget

          • Achieved

          • Results

          • TrendLastAudit

    • ExtendenManufacturingSite

      • Comments

    • CustomerInformation

      • CustomerPerformance

        • Id

      • CustomerRequirementsAudited

        • LinkedCustomerPerformanceId

    • Conclusion

      • PreviousAuditNonconformities

        • NcObservedProcess

        • StatementOfNonconformity

        • ObjectiveEvidence

        • SystemicEvidenceOfImplementation

        • ActionTakenVerifyImplementation

  • Nc managamenet

    • Signature

      • AuditorId

    • State as enum(AuditorNcEntry,OrganizationNcEntry, CbNcEntry, NcCompleted)

    • ReportPdf

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

...