Upload Staging Layout

You create an XAI upload staging record directly for each XML request you wish to make. The name of this table is CI_​​XML_​​STGUP. The following table describes each column on this table.

Column Name Length Req'd Data Type Comments
XML_​​STGUP_​​ID 15 Y N This is the unique identifier of the record. This value does NOT have to be a random number, but it does need to be unique.
APP_​​SVC_​​ID 20 Y A/N This is the foreign key to the application service table, and identifies the application service that is being requested.
COMPLETE_​​DTTM 26 N Date/Time Completion date and time.
CRE_​​DTTM 26 Y Date/Time Creation date and time.
RETRY_​​COUNT 3 Y N Number of retries to process the request.
XML_​​REQUEST 30,000 Y A/N The XML request document.
XML_​​RESPONSE 30,000 Y A/N The XML response document.
XML_​​STG_​​CTL_​​ID 10 Y A/N The id of the staging control record linked to this record.
XML_​​STG_​​STATUS_​​FLG 2 Y A/N Must be set to P (Pending).