ARMS allows you to pull student-athlete data into seven different reports available to import into Compliance Assistant. To generate these reports, go to the Compliance -> NCAA Reporting Page. The first tab will be the CA Integration area, where you can filter by academic year, term, and sport to generate these seven files. Simply click Generate Data Files and the files will begin to process (this is usually a 30-second process).
Once the files have been generated, you will see the Step 2 - Review Data column appear with hot links to download each file. The files will download as a CSV that you can open to review the data in columns and rows.
Once the files are downloaded to your computer, you can import the CSV into the Compliance Assistant (CAi 2.0), by logging into CAi 2.0 and Click on Admin -> CSV Import/Export. From there select the Table that corresponds with the file you are attempting to import.
Tips when importing into Compliance Assistant 2.0:
All student-athletes must have an NCAA Eligibility Center Number,
When importing the "CA2_SA_YEAR_AID_AWARD" file, the action column must list "Insert, Update, or Delete";
When importing the "CA2_SA_DETAIL" file, the majorDegreeDate column must have a date listed
The NCAA created a video for importing CSV files into Compliance Assistant 2.0. Please review their video below.
Here are other videos created by the NCAA related to Compliance Assistant 2.0 management.