File Import Specs

Top  Previous  Next

File Import Specifications for the July Release of SAMS:

SAMS will require that the import file contain a header line in which the first six characters contain the districts code and that columns 14-17 must be the form year (1011). Columns 7-13 are not edited;

The import file must end with a line containing only 6 capital letter Xs. XXXXXX The files produced by the DEA always had this as an end of file marker so that incompletely transmitted files could be rejected;

SAMS will reject any file containing a form and item data record unknown to SAMS (such as deleted accounts) or data records containing invalid numeric data or data which otherwise violates hard edit rules in SAMS (such as project numbers must be at least 6 characters etc.). This is unlike the DEA so vendors must be certain to remove any extraneous records.

SAMS will display an appropriate message if the file is rejected.

 

For example for the upcoming year a sample file would look like:

 

123456SAMS   1011

     148  1#=1342948

     148  6#=3357

     148  7#=551849

     148  9#=1797

     148 11#=1797

     148 13#=7849

     148 15#=1435

XXXXXX