...
Beginning FY17, the test date for assessments has been changed to a full eight character date rather than just month and year. The day is only required in cases where the same assessment is offered more than once during a month. This is currently true for ACT and SAT tests. The FA record may be imported into EMISFFE using either MM/YYYY or MM/DD/YYYY formats. In the case where day is not supplied, it will be defaulted to '01'. The FA CSV example above shows various formats that may be used for importing into EMISFFE.
FW records
ODE supplies a flat file thru the data collector to be used for import the FW data. However, if a district so desires, they may create their own CSV import file for this data. In order for the FW record to import in CSV format, each row must include a comma after the cell that represents 'Other Followup Status' (position 163 in the flat file record layout).
| Code Block | ||
|---|---|---|
| ||
FW,222222,KQ1234567,First,,Last,Y,N,N,A0,123456,******,000111,Y,OT,UN,U,U,U,U,N,U,N,TC,A,N,Y,Y,U,
FW,222222,LE7654321,Firstname,Middle,Last,Y,N,N,M3,123456,******,111000,N,05,20,N,N,N,N,N,U,N,CR,A,N,N,N,D,
FW,222222,FF1234567,Name,,Lastname,Y,N,N,L0,123456,******,******,Y,12,UN,U,U,U,U,N,A,Y,TC,A,N,Y,Y,U, |
Financial records
Financial (QC) Records must include the following elements that are the KEY to the records, these elements will always be the first six columns of any QC record:
...
CSV Invalid format error, this error will occur when the CSV layout does not match the Chapter 5 layout minus the filler, fiscal year and reporting period fields.
CN file, ODE has deleted element CN240 replacing it with filler. This update is not reflected in Chapter 5. If this element is included in a CSV import file, the user will receive the CSV invalid format error. This element should be omitted from the CN CSV file.
GG File, the identification dates for the Gifted record need to be formatted as YYYYMM, without the slash, or ******.
- Negative numbers, must be formatted with a minus ( - ) sign. Negative values that are represented using parenthesis rather than a minus sign will cause an error during the import.
...