The data file used for the import must first be inserted into the CAMSImportGeneric SQL table before defining Import Parameters. Any method used by the institution to insert the data into this table must ensure that fields are mapped correctly and use the correct layout. Use of the import wizard in SQL is recommended.
This table will hold all the data that is to be imported into CAMS Enterprise. Previous data file entries (for previous jobs) will remain in this table unless manually deleted. This will allow for historical research.
The JobID field must match the current Import Job used for this file.
Related Topics