Navigation:  Integration via database > Published interfaces > Risk >

RISTREATMENT – Treatment

Previous  Top  Next

This import template makes it possible to insert:

Treatments.

 

To insert each of these items, it is necessary to follow the standard documented below.

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 – Code of component SE Risk

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

16 – Insert Treatment

NMFIELD01

X

TEXT

50

Treatment ID #

NMFIELD02

X

TEXT

255

Treatment name

NMFIELD03

X

TEXT

50

Treatment type ID #

NMFIELD04

 

TEXT

255

Result name

NMFIELD05

 

NUMERIC

2

Action plan required:

1 – Yes;

2 – No.

NMFIELD06

 

TEXT

50

Action plan template ID #

DSFIELD01

 

TEXT

4000

Treatment description

 

X1 - The NMFIELD04 column must be disregarded if there is no evaluation method recorded in the ‘Response to treatment (Simple listing)’ field. If there is a method recorded, this field becomes mandatory.