Import parameters

Directory

/data/quality-records

Files reference

  • filename : header

Files content

Data structure

Field Column Data type Required Business rules

Company code

companyCode

String

X

2 characters max

Establishment code

establishmentCode

String

X

2 characters max

Batch number

batch

String

X

20 characters max

Item code

itemCode

String

X

20 characters max

Record type

recordType

String

X

Within (CRITERION, STATUS)

Generation date

generationDate

String (ISO 8601)

X

YYYY-MM-DDTHH:MM:SSZ

Effective date

effectiveDate

String (ISO 8601)

YYYY-MM-DDTHH:MM:SSZ

Status code

statusCode

String

5 characters max

Criteria code

criterionCode

String

15 characters max

Measure date

measureDate

String (8601)

YYYY-MM-DDTHH:MM:SSZ

Criterion value

criterionValue

String

50 characters max
required if criterionCode is not empty

Examples

companyCode;establishmentCode;batch;itemCode;generationDate;recordType;criterionCode;measureDate;criterionValue
01;01;11;01;2012-10-09T00:00:00Z;CRITERION;C1;2012-10-09T00:00:00Z;V1
01;01;11;01;2012-10-09T00:00:00Z;CRITERION;$DATEFAB;2012-10-09T00:00:00Z;2012-10-09
companyCode;establishmentCode;batch;itemCode;generationDate;recordType;effectiveDate;statusCode
01;01;11;01;2012-10-09T00:00:00Z;STATUS;2012-10-09T00:00:00Z;S1
01;01;11;01;2012-10-09T00:00:00Z;STATUS;2012-12-01T00:00:00Z;S2
companyCode;establishmentCode;batch;itemCode;generationDate;recordType;effectiveDate;statusCode;criterionCode;measureDate;criterionValue
01;01;11;01;2012-10-09T00:00:00Z;CRITERION;;;C1;2012-10-09T00:00:00Z;V1
01;01;11;01;2012-10-09T00:00:00Z;CRITERION;;;$DATEFAB;2012-10-09T00:00:00Z;2012-10-09
01;01;11;01;2012-10-09T00:00:00Z;STATUS;2012-10-09T00:00:00Z;S1;;;
01;01;11;01;2012-10-09T00:00:00Z;STATUS;2012-12-01T00:00:00Z;S2;;;