Insert/edit
|
Column
|
Required
|
Type
|
Precision
|
Description
|
OIDINTERFACE
|
X
|
TEXT
|
32
|
Sequential code - Identifies an item to be imported into SoftExpert Suite.
|
FGIMPORT
|
X
|
NUMERIC
|
2
|
Import status:
1 – New;
2 – In progress;
3 – Finished;
4 – Error.
|
CDISOSYSTEM
|
X
|
NUMERIC
|
10
|
System code where the integration will be performed to:
109 - Code of component SoftExpert Asset.
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
21 – Add activity plan;
22 – Edit activity plan.
|
NMFIELD01
|
X¹
|
TEXT
|
255
|
Plan type:
1 – Verification;
2 – Preventive maintenance;
3 – Calibration.
|
NMFIELD02
|
X
|
TEXT
|
255
|
Plan ID #
|
NMFIELD03
|
X¹
|
TEXT
|
255
|
Plan name
|
NMFIELD04
|
X¹
|
TEXT
|
255
|
Standard activity ID #
|
NMFIELD05
|
X¹
|
TEXT
|
255
|
Plan configuration:
1 – Inherit activity data;
2 – Copy activity data.
|
NMFIELD06
|
X¹
|
TEXT
|
255
|
Asset ID #. For multiple assets separate the identifiers with semicolons.
E.g.: IDATIVO01;IDATIVO02;IDATIVO03
|
NMFIELD07
|
X¹
|
TEXT
|
255
|
Responsible team ID # for the plan
|
NMFIELD08
|
X²
|
TEXT
|
255
|
Responsible team ID # for planning
|
NMFIELD09
|
X²
|
TEXT
|
255
|
Responsible team ID # for execution
|
NMFIELD10
|
|
TEXT
|
255
|
Date-based frequency:
1 – Enable;
2 – Disable.
|
NMFIELD11
|
X³
|
TEXT
|
255
|
Frequency type:
1 – Execution date;
2 – First use;
3 – Usage time.
|
NMFIELD12
|
X³
|
TEXT
|
255
|
Frequency
|
NMFIELD13
|
X³
|
TEXT
|
255
|
Frequency unit:
1 – Day(s);
2 – Week(s);
3 – Month(s);
4 – Year(s);
5 – Working day(s).
|
NMFIELD14
|
X³
|
TEXT
|
255
|
Date visualization:
1 – Month/Day/Year;
2 – Month/Year.
|
NMFIELD15
|
X³
|
TEXT
|
255
|
Date of the next execution. The expected format must be YYYY-MM-DD (Year-Month-Day).
If this is an import via spreadsheet, format the cell as a text; otherwise, the import will not be successful.
|
NMFIELD16
|
|
TEXT
|
255
|
Calendar ID #
|
NMFIELD17
|
|
TEXT
|
255
|
Frequency based on asset meter:
1 – Enable;
2 – Disable.
|
NMFIELD18
|
X4
|
TEXT
|
255
|
Frequency
|
NMFIELD19
|
X4
|
TEXT
|
255
|
Anticipation
|
NMFIELD20
|
X4
|
TEXT
|
255
|
Next execution
|
NMFIELD21
|
|
TEXT
|
255
|
Create activity automatically:
1 – Enable;
2 – Disable.
|
NMFIELD22
|
X5
|
TEXT
|
255
|
Activity step created automatically:
1 – Planning;
2 – To be started.
|
NMFIELD23
|
X5
|
TEXT
|
255
|
Number of days that the automatic activity will be created previously
|
NMFIELD24
|
X6
|
TEXT
|
255
|
Evaluation method ID #
|
NMFIELD25
|
X5
|
TEXT
|
255
|
Continue to create activities automatically even if there are already pending activities?
1 - Yes;
2 - No.
|
NMFIELD30
|
|
TEXT
|
255
|
Number of days in advance of notification between 0 and 999.
|
DSFIELD01
|
X7
|
TEXT
|
255
|
For quantitative method:
▪For list of values: [id criterion 1]=[id result1];[id criterion 2]=[id result2] ▪For indeterminate value: [id criterion 1]=[value 1];[id criterion 2]=[value 2] ▪Mix: [id criterion 1]=[id result1];[id criterion 2]=[value 2]
For simple listing method:
▪[id result] |