Insert
|
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:
215 – SoftExpert Risk
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
21 – Insert evaluation
|
NMFIELD01
|
X
|
TEXT
|
255
|
Analysis ID #
|
NMFIELD02
|
X
|
NUMERIC
|
2
|
Analysis type:
1 – Risk;
2 – Control.
|
NMFIELD03
|
X
|
TEXT
|
255
|
Evaluation ID #
|
NMFIELD10
|
|
TEXT
|
50
|
1st Eval.: Criterion 1 ID #
|
NMFIELD11
|
|
NUMERIC
|
50
|
1st Eval.: Criterion 1 value
|
NMFIELD12
|
|
TEXT
|
50
|
1st Appr.: Criterion ID # 2
|
NMFIELD13
|
|
NUMERIC
|
50
|
1st Appr.: Criterion value 2
|
NMFIELD14
|
|
TEXT
|
50
|
1st Appr.: Criterion ID # 3
|
NMFIELD15
|
|
NUMERIC
|
50
|
1st Appr.: Criterion value 3
|
NMFIELD16
|
|
TEXT
|
50
|
1st Appr.: Criterion ID # 4
|
NMFIELD17
|
|
NUMERIC
|
50
|
1st Appr.: Criterion value 4
|
NMFIELD18
|
|
TEXT
|
50
|
1st Appr.: Criterion ID # 5
|
NMFIELD19
|
|
NUMERIC
|
50
|
1st Appr.: Criterion value 5
|
NMFIELD20
|
|
TEXT
|
50
|
1st Appr.: Criterion ID # 6
|
NMFIELD21
|
|
NUMERIC
|
50
|
1st Appr.: Criterion value 6
|
NMFIELD22
|
|
TEXT
|
50
|
1st Appr.: Criterion ID # 7
|
NMFIELD23
|
|
NUMERIC
|
50
|
1st Appr.: Criterion value 7
|
NMFIELD24
|
|
TEXT
|
50
|
1st Appr.: Criterion ID # 8
|
NMFIELD25
|
|
NUMERIC
|
50
|
1st Appr.: Criterion value 8
|
NMFIELD26
|
|
TEXT
|
50
|
1st Appr.: Criterion ID # 9
|
NMFIELD27
|
|
NUMERIC
|
50
|
1st Appr.: Criterion value 9
|
NMFIELD28
|
|
TEXT
|
50
|
1st Appr.: Criterion ID # 10
|
NMFIELD29
|
|
NUMERIC
|
50
|
1st Appr.: Criterion value 10
|
NMFIELD30
|
|
TEXT
|
50
|
1st Appr.: Criterion ID # 11
|
NMFIELD31
|
|
NUMERIC
|
50
|
1st Appr.: Criterion value 11
|
NMFIELD32
|
|
TEXT
|
50
|
1st Appr.: Criterion ID # 12
|
NMFIELD33
|
|
NUMERIC
|
50
|
1st Appr.: Criterion value 12
|
NMFIELD34
|
|
TEXT
|
50
|
1st Appr.: Criterion ID # 13
|
NMFIELD35
|
|
NUMERIC
|
50
|
1st Appr.: Criterion value 13
|
NMFIELD36
|
|
TEXT
|
50
|
1st Appr.: Criterion ID # 14
|
NMFIELD37
|
|
NUMERIC
|
50
|
1st Appr.: Criterion value 14
|
NMFIELD38
|
|
TEXT
|
50
|
1st Appr.: Criterion ID # 15
|
NMFIELD39
|
|
NUMERIC
|
50
|
1st Appr.: Criterion value 15
|
NMFIELD40
|
|
TEXT
|
50
|
2nd Eval.: Criterion 1 ID#
|
NMFIELD41
|
|
NUMERIC
|
50
|
2nd Eval.: Criterion 1 value
|
NMFIELD42
|
|
TEXT
|
50
|
2nd Appr.: Criterion ID # 2
|
NMFIELD43
|
|
NUMERIC
|
50
|
2nd Appr.: Criterion value 2
|
NMFIELD44
|
|
TEXT
|
50
|
2nd Appr.: Criterion ID # 3
|
NMFIELD45
|
|
NUMERIC
|
50
|
2nd Appr.: Criterion value 3
|
NMFIELD46
|
|
TEXT
|
50
|
2nd Appr.: Criterion ID # 4
|
NMFIELD47
|
|
NUMERIC
|
50
|
2nd Appr.: Criterion value 4
|
NMFIELD48
|
|
TEXT
|
50
|
2nd Appr.: Criterion ID # 5
|
NMFIELD49
|
|
NUMERIC
|
50
|
2nd Appr.: Criterion value 5
|
NMFIELD50
|
|
TEXT
|
50
|
2nd Appr.: Criterion ID # 6
|
NMFIELD51
|
|
NUMERIC
|
50
|
2nd Appr.: Criterion value 6
|
NMFIELD52
|
|
TEXT
|
50
|
2nd Appr.: Criterion ID # 7
|
NMFIELD53
|
|
NUMERIC
|
50
|
2nd Appr.: Criterion value 7
|
NMFIELD54
|
|
TEXT
|
50
|
2nd Appr.: Criterion ID # 8
|
NMFIELD55
|
|
NUMERIC
|
50
|
2nd Appr.: Criterion value 8
|
NMFIELD56
|
|
TEXT
|
50
|
2nd Appr.: Criterion ID # 9
|
NMFIELD57
|
|
NUMERIC
|
50
|
2nd Appr.: Criterion value 9
|
NMFIELD58
|
|
TEXT
|
50
|
2nd Appr.: Criterion ID # 10
|
NMFIELD59
|
|
NUMERIC
|
50
|
2nd Appr.: Criterion value 10
|
NMFIELD60
|
|
TEXT
|
50
|
2nd Appr.: Criterion ID # 11
|
NMFIELD61
|
|
NUMERIC
|
50
|
2nd Appr.: Criterion value 11
|
NMFIELD62
|
|
TEXT
|
50
|
2nd Appr.: Criterion ID # 12
|
NMFIELD63
|
|
NUMERIC
|
50
|
2nd Appr.: Criterion value 12
|
NMFIELD64
|
|
TEXT
|
50
|
2nd Appr.: Criterion ID # 13
|
NMFIELD65
|
|
NUMERIC
|
50
|
2nd Appr.: Criterion value 13
|
NMFIELD66
|
|
TEXT
|
50
|
2nd Appr.: Criterion ID # 14
|
NMFIELD67
|
|
NUMERIC
|
50
|
2nd Appr.: Criterion value 14
|
NMFIELD68
|
|
TEXT
|
50
|
2nd Appr.: Criterion ID # 15
|
NMFIELD69
|
|
NUMERIC
|
50
|
2nd Appr.: Criterion value 15
|
NMFIELD70
|
|
TEXT
|
50
|
3rd Eval.: Criterion 1 ID#
|
NMFIELD71
|
|
NUMERIC
|
50
|
3rd Eval.: Criterion 1 value
|
NMFIELD72
|
|
TEXT
|
50
|
3rd Appr.: Criterion ID # 2
|
NMFIELD73
|
|
NUMERIC
|
50
|
3rd Appr.: Criterion value 2
|
NMFIELD74
|
|
TEXT
|
50
|
3rd Appr.: Criterion ID # 3
|
NMFIELD75
|
|
NUMERIC
|
50
|
3rd Appr.: Criterion value 3
|
NMFIELD76
|
|
TEXT
|
50
|
3rd Appr.: Criterion ID # 4
|
NMFIELD77
|
|
NUMERIC
|
50
|
3rd Appr.: Criterion value 4
|
NMFIELD78
|
|
TEXT
|
50
|
3rd Appr.: Criterion ID # 5
|
NMFIELD79
|
|
NUMERIC
|
50
|
3rd Appr.: Criterion value 5
|
NMFIELD80
|
|
TEXT
|
50
|
3rd Appr.: Criterion ID # 6
|
NMFIELD81
|
|
NUMERIC
|
50
|
3rd Appr.: Criterion value 6
|
NMFIELD82
|
|
TEXT
|
50
|
3rd Appr.: Criterion ID # 7
|
NMFIELD83
|
|
NUMERIC
|
50
|
3rd Appr.: Criterion value 7
|
NMFIELD84
|
|
TEXT
|
50
|
3rd Appr.: Criterion ID # 8
|
NMFIELD85
|
|
NUMERIC
|
50
|
3rd Appr.: Criterion value 8
|
NMFIELD86
|
|
TEXT
|
50
|
3rd Appr.: Criterion ID # 9
|
NMFIELD87
|
|
NUMERIC
|
50
|
3rd Appr.: Criterion value 9
|
NMFIELD88
|
|
TEXT
|
50
|
3rd Appr.: Criterion ID # 10
|
NMFIELD89
|
|
NUMERIC
|
50
|
3rd Appr.: Criterion value 10
|
NMFIELD90
|
|
TEXT
|
50
|
3rd Appr.: Criterion ID # 11
|
NMFIELD91
|
|
NUMERIC
|
50
|
3rd Appr.: Criterion value 11
|
NMFIELD92
|
|
TEXT
|
50
|
3rd Appr.: Criterion ID # 12
|
NMFIELD93
|
|
NUMERIC
|
50
|
3rd Appr.: Criterion value 12
|
NMFIELD94
|
|
TEXT
|
50
|
3rd Appr.: Criterion ID # 13
|
NMFIELD95
|
|
NUMERIC
|
50
|
3rd Appr.: Criterion value 13
|
NMFIELD96
|
|
TEXT
|
50
|
3rd Appr.: Criterion ID # 14
|
NMFIELD97
|
|
NUMERIC
|
50
|
3rd Appr.: Criterion value 14
|
NMFIELD98
|
|
TEXT
|
50
|
3rd Appr.: Criterion ID # 15
|
NMFIELD99
|
|
NUMERIC
|
50
|
3rd Appr.: Criterion value 15
|
NMFIELD100
|
|
TEXT
|
50
|
Treatment ID #
|
DSFIELD01
|
|
TEXT
|
4000
|
Explanation
|