CI,222222,NW1234567,09/15/1977,W,M,3,120,N,186.5,.5,0,5,5,OH1234567,,”John”,”A.”,”Doe”, CI,222222,NW7654321,08/22/1965,B,F,2,0,*,210,3,0,0,0,ZX1234567,””,”L’Vonne”,”S.”,”Hoops”, CI,222222,NW4444444,07/23/1971,A,M,3,120,N,188,0,0,6,6,OH7654321,,”David”,”Hank”,”Good”,”Jr.”
Alpha fields which may contain a comma must be enclosed in quotes. Refer to the example above of the employee name field on the Staff Demographic record.
FA,333333,NW7654321,GX,10,M,2008/03,STR,11,NO,*,355 FA,333333,NG1234567,GY,**,43FA,2012/01,**,**,*,231 FA,333333,HG1234567,SA,12,ENG,6/23/2017,STR,12,**,*,220 FA,333333,HG1234567,GA,8,ELA,5/2017,ALT,8,Y2,*,402 FA,333333,HG1234567,GA,3,M,4/1/2017,ALT,3,Y2,*,273
Date fields must have the “/” in place in order for the record to import properly. For YYYYMMDD date fields, the date may be either MM/DD/YYYY or YYYY/MM/DD in the CSV file. For YYYYMM date fields, the date may be either MM/YYYY or YYYY/MM. In the case of a blank (null) date, the date cell may be left blank or it may be filled with zeroes (ie. 00/00/0000). There is one exception to this rule for dates, the YYYYMM date fields on the GG record need to be formatted as YYYYMM (no slash) or ******.Alpha fields which may contain a comma must be enclosed in quotes. Refer to the example above of the employee name field on the Staff Demographic record
FA records - Test Date
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.
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: