Skip to main content
Version: 2.2.3

RISPOPULATIONDATA - Insert population data

This import template allows:

  • Inserting population data.

For the insertion of each one of these items, the standard documented below must be followed.

Insert population data​

ColumnRequiredTypePrecisionDescription
OIDINTERFACEXTEXT32Primary key - Identifies an item to be imported into SoftExpert Suite.
FGIMPORTXNUMERIC2Import status:
1 - New;
2 - In progress;
3 - Finished;
4 - Error.
CDISOSYSTEMXNUMERIC10Code of the system for which the integration will be performed:
215 - Code of the SoftExpert Risk component
FGOPTIONXNUMERIC2Code of the operation to be performed:
22 - Insert population data.
NMFIELD01XTEXT50Population ID #.
NMFIELD02XTEXT50Population data ID #.
info

Note:

  • The column in the spreadsheet to be filled out will depend on the number of created population fields:
  • If there is no population field recorded, only the fields above are necessary.
  • When there are fields that are not of the "Memo" type, the columns from NMFIELD03 to NMFIELD62 must be filled out (in accordance with the number of created fields).
  • When there are fields of the "Memo" type, the columns from DSFIELD01 to DSFIELD05 must be filled out (in accordance with the number of created fields).
  • The field must be filled if that is configured in the population field record.
  • The data type of the column will be defined in accordance with the type of the created population field:
    • When there is a field of the "Text", "Date", "Memo", "Business unit" or "Plan/Analysis" type, the data type will be TEXT.
    • When there is a field of the "Numeric" or "Currency" type, the data type will be NUMERIC.
  • The precision of the column will be defined in accordance with the data type of the created population field:
    • "Text" data types have a 255-character precision.
    • "Numeric" or "Currency" data types have a 28-character precision.
    • "Date", "Business unit" and "Risk plan" data types have a 50-character precision.
    • "Memo" data types have a 2000-character precision.
  • When there is a field of the "Business unit" or "Plan/Analysis" type, the record ID # must be entered.
Last updated on