Import parameters

Directory

/data/stop-reasons

Files reference

  • filename : header

Other parameters

Import mode

Imports can be done with "full" or "update" mode.

  • Full mode : All entities in the file but not in the target application are created. All entities present in the target application but not in the file are deleted. The others are updated.

  • Update mode : same as "full" mode except that the entities present in the target application but not in the file are not deleted.

Files content

Data structure

Field Column Data type Required Business rules

Code

Login

String

X

15 characters max
All characters in uppercase accepted except characters \ ; | " < > µ and spaces at the beginning and at the end

Company code

companyCode

String

X

2 characters max

Establishment code

establishmentCode

String

X

2 characters max

Label

label

String

X

50 characters max

Stop reason family code

stopReasonFamilyCode

String

X

10 characters max

Type

type

String

X

IN(PLANNED=Planned,UNPLANNED=Unplanned)

VIF type

vifType

String

X

IN(FAILURE=Failure,MICRO_STOP=Micro stop,BREAK=Break,INDUCED_STOP=Induced stop,LINE_PREPARATION=Line preparation,OTHER=Other reason)

Restriction

restriction

String

X

IN(ONLY_WHEN_WORKING=Only when MO is in progress,ONLY_WHEN_OPENED=Only when MO is opened,NONE=No restriction)

To be included in OEE

includedInOee

Boolean

X

Default duration second

defaultDurationSecond

Integer

X

Has induced stop reason

hasInducedStopReason

Boolean

Induced stop reason code

inducedStopReasonCode

String

15 characters max

Trigger labor pause

triggerPauseInLabor

Boolean

Trigger control plan pause

triggerPauseInControl

Boolean

Loss reason code

lossReasonCode

String

15 characters max

Loss unit code

lossUnitCode

String

5 characters max

Loss quantity

lossQuantity

Double

Image

imageCode

String

Validity end date

validityEndDate

String (ISO-8601)

YYYY-MM-DDTHH:MM:SSZ Set a passed date to make the entity inactive.

Example

code;companyCode;establishmentCode;label;stopReasonFamilyCode;type;vifType;restriction;includedInOee;defaultDurationSecond;hasInducedStopReason;inducedStopReasonCode;triggerPauseInLabor;triggerPauseInControl;lossReasonCode;lossUnitCode;lossQuantity;imageCode;validityEndDate
01;02;03;Motif1;FAM1;PLANNED;FAILURE;NONE;true;1;true;MOT2;false;false;PER1;BOI;10;M1;2014-05-28T12:00:00Z
02;02;03;Motif2;FAM1;PLANNED;FAILURE;NONE;true;1;;;;;;;;;
03;02;03;Motif3;FAM1;PLANNED;FAILURE;NONE;true;1;;;;;PER1;BOI;10;M1;2014-05-28T12:00:00Z