Example Auxiliary Error Codes
The ERROR_CODES_AUX database table has columns called ERROR_CODE, MESSAGE_TYPE_ID, and AUX_CODE. The map worksheet that facilitates loading this table (Auxiliary Error Codes) is an example of a direct data load, meaning the configuration data goes "as is" into the database table.
| Error Code | Message Type | Auxiliary Error Code |
|---|---|---|
| error_code | message_type_id | aux_code |
Because is does not use complex field selects, Export can use the same map worksheet and the Query SQL can be a simple select all.
"select * from &schemaid.error_codes_aux"