The default file name for the Annual Financial Report (ST3) report is ST3 Report__FY<Reporting Year>.ASC.
SAMS has several crucial requirements for the import file:
-
The file must contain a header line with the first six characters being the district code. Additionally, columns 14-17 must represent the form year XXYY (for example, 2223 for the 2022-23 school year). Columns 7-13 remain unedited.
-
The import file must end with a line containing only six capital letters Xs (example: XXXXXX). The DEA files always had this as an end-of-file marker, so incompletely transmitted files could be rejected.
-
Each data record is coded in the following fixed-width column format:
-
Five spaces, the digit one, two-digit form number, three-digit item number (right justified space filled on the left), the symbols #= followed by the value to be loaded. For the ST-3, all values are whole numbers (no decimals).
-
The form and item numbers are NOT the printed line numbers on the ST-3 but the internal legacy item numbers. For more information about the current year crosswalk file, contact the State Education Department (SED).
-
Columns 7-8 - two-digit form number
-
Columns 9-11 - three-digit item number, right-justified
-
Columns 12-13 - #=
-
Columns 14 to end - data value
-
-
-
SAMS has strict rejection criteria. Any file containing a form and item data record unknown to SAMS (for example, deleted accounts), data records with invalid numeric data, or data that violates edit rules in SAMS (for example, project numbers must be at least six characters) is rejected.
-
SAMS displays an appropriate message if the file is rejected.
For example, for the 2022-23 school year, the sample file has the following format:
123456SAMS 2223
148 1#=1342948
148 6#=3357
148 7#=551849
148 9#=1797
148 11#=1797
148 13#=7849
148 15#=1435
XXXXXX