Staging Control Layout

In order to load XML requests from flat sequential files, comma separated value (CSV) files and from database tables, you need to create a staging control record. The name of this table is CI_​​XML_​​STG_​​CTL. The following table describes each column on this table.

Column Name Length Req'd Data Type Comments
XML_​​STG_​​CTL_​​ID 10 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.
RUN_​​DTTM 26 N Date/Time Date and time this record was executed.
XAI_​​IN_​​SVC_​​ID 10 Y A/N This is the XAI service associated with this record. This service should have an adapter of CISStagingUpload.
XML_​​STG_​​FILE_​​NAME 250 N A/N This is the location and name of the file containing the data to be uploaded. This is used for comma delimited files and flat sequential files.
XML_​​INTFC_​​NAME 30 N A/N The name of the interface used to populate this table. This is simply information and is not used by the system.
XML_​​STG_​​STATUS_​​FLG 2 Y A/N Must be set to P (Pending).
NT_​​XID_​​CD 30 N A/N This field is not in use.
NT_​​UP_​​XTYPE_​​CD 30 N A/N This field is not in use.
USER_​​ID 8 Y A/N The ID of the user who created this record.
COMMENTS 254 N A/N Use the free format comments, if necessary.
NBR_​​RECORD_​​UPLD 10 N A/N Leave this blank. This will be populated by the process which creates upload staging records for this control record.