AUSPOPULATIONDATA - Population data

This import template allows:

• Inserting population data;
• Deleting population data.

To insert each of these items, the standard documented below must be followed.

Insert population data

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	Code of the system for which the integration will be performed: 90 - Code of the SoftExpert Audit component.
FGOPTION	X	NUMERIC	2	Code of the operation to be performed: 22 - Insert population data.
NMFIELD01	X	TEXT	50	Population ID #.
NMFIELD02	X	TEXT	50	Population 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 created, 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 NMFIELD01 and NMFIELD02 fields must contain a maximum of 50 characters, as this is the limit for identification 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", or "Business unit" 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" data types have a 50-character precision.
  • "Memo" data types have a 2000-character precision.
• When there is a field of the "Business unit" type, the record ID # must be entered.

To delete each of these items, the standard documented below must be followed.

Delete population data

Column	Required	Type	Precision	Description
OIDINTERFACE	X	NUMERIC	10	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	Code of the system for which the integration will be performed: 90 - Code of the SoftExpert Audit component.
FGOPTION	X	NUMERIC	2	Code of the operation to be performed: 23 - Delete population's data completely.
NMFIELD01	X	TEXT	50	Population ID #.