AutoReconciliation

SIS File Format Requirements for Fund Sources

Please find enclosed the file format specifications required to use AutoReconciliation with any Student Information System (SIS). All fund sources will use the same file format as shown below. Additional questions can be directed to CampusLogic via the Contact Us page.
SSN StudentId FullName DisbursementAmount AwardAmount AidYear
100000001 ABC123123 John Smith 100.00 200.00 1415
100000002 ABC124124 Jane Doe 1050.00 2010.00 1415
100000003 ABC125125 John Doe 1250.50 2501.00 1415

Download a Sample Student Information System File (SampleSISFile.csv)
This file may be opened in any text editor, such as Notepad or spreadsheet program, such as Excel.

Please Note:
  • The columns (1-6) need to be in the exact order as listed above
  • No duplicate records
  • Only records that have had a disbursement in the specified date range
  • Use most recent disbursement transaction if there are multiple adjustments for the same disbursement id number
  • Add a date parameter option to ensure the Student Information System report can be pulled to mirror the COD data range
  • Determine which award amount field needs to be pulled from the Student Information System
  • One Student Information System file per fund source
  • SIS Files must be in either CSV (Comma Delimited) format and imported with a .csv or .txt extension or Excel (version 2007 or greater) format and imported with a .xlsx extension.

SIS File Format Requirements for Enrollment

Please find enclosed the file format specifications required to use AutoReconciliation with any Student Information System (SIS). Additional questions can be directed to CampusLogic via the Contact Us page.
SpridenID StudentSSN EnrollmentEffectiveDate EnrollmentStatus
000001 100000001 04/17/16 Q
000002 100000002 04/22/16 Q
000003 100000003 04/21/16 Q

Download a Sample Student Information System File (SampleSISNSDLSFile.csv)
This file may be opened in any text editor, such as Notepad or spreadsheet program, such as Excel.

Please Note:
  • The columns (1-4) need to be in the exact order as listed above
  • No duplicate records
  • Column 3 can be accept typical date formats such as mm-dd-yyyy or mm/dd/yy.
  • Only records that have had student enrollment changes in the specified date range
  • Use most recent student transaction if there are multiple records for the same student SSN
  • Add a date parameter option to ensure the Student Information System report can be pulled to mirror the NSDLS data range
  • SIS Files must be in either CSV (Comma Delimited) format and imported with a .csv or .txt extension.