The below chart outlines the mapping of the Compliance Assistant integration files that can be exported out of ARMS. The File Name is the "table" that it will be imported into CA (column 1), the field it will be imported into Compliance Assistant is the CA Column (column 2), and the ARMS Field is the corresponding field in ARMS (column 3).

Notes on the Integration

Compliance Assistant allows for users to create "User Defined Fields" which they term 'udf' in their database. We will not have any way to reference these fields properly from ARMS custom fields, so they are excluded from the below chart, but will all show in your exports with blank values.

There are a handful of fields that are either old CA fields no longer in use, or rarely utilized fields that we do not support in ARMS. These are denoted as "NOT MAPPED" in column 3 of the below chart. They will still appear in the exported spreadsheet from ARMS, so if these are fields that your institution uses you can either update the values in the spreadsheet before importing into CA or manually make those updates after the base import.

ARMS automatically calculates some fields based off of an aggregation of data inside the SA's profile. The values for the seasons of participation and years receiving aid are automatically calculated and not directly editable inside the SA's profile. These fields are denoted as such in column 3 of the below chart.

Compliance Assistant Mappings Chart

File

CA Column

ARMS Field

Students

address1

Campus Street 1

Students

address2

Campus Street 2

Students

birthDate

Birth Date

Students

cellPhone

Mobile Phone

Students

city

Campus City

Students

comments

NOT MAPPED

Students

email

Email

Students

firstName

First Name

Students

fulltimeEnrollmentTermAny

First Term Enrolled Anywhere

Students

fulltimeEnrollmentTermHere

First Term Enrolled Here

Students

fulltimeEnrollmentYearAny

First Term Enrolled Anywhere (Year)

Students

fulltimeEnrollmentYearHere

First Term Enrolled Here (Year)

Students

gender

Gender

Students

hsGraduationDate

High School Grad Date

Students

lastName

Last Name

Students

middleName

Middle Name

Students

ncaaId

NCAA Eligibility Center ID

Students

onCampus

On Campus

Students

phone

Home Phone

Students

postalCode

Postal Code

Students

raceCode

Ethnicity

Students

recruited

Recruited per bylaw 13

Students

recruitedBylaw15

NOT MAPPED

Students

schoolSidNumber

University ID

Students


state

Campus State

Students

stateResident

In State Resident

Students

transferredTo

Transferred To

File

CA Column

ARMS Field

Student Sports

academicYear

Year Selected

Student Sports

aidExemptFlag

NOT MAPPED

Student Sports

amateurismCertStatus

Amateurism Status

Student Sports

changeDate

Effective Date of State Change

Student Sports

changeStatus

Roster Status

Student Sports

comments

NOT MAPPED

Student Sports

countableActivitiesChampseg

Participant

Student Sports

departCoachNonpartFlag

Depature of Head Coach

Student Sports

eligExhaustedFlag

Exhausted Eligibility

Student Sports

eligibleS1Flag

Competition Eligible First Term

Student Sports

eligibleS2Flag

Competition Eligible Second Term

Student Sports

eligibleS3Flag

Competition Eligible Third Term (quarter school only)

Student Sports

fbOverallCounterFlag

Football Counter (automatically calculated by ARMS)

Student Sports

hardshipFlag

Medical Hardship

Student Sports

initialCounterFlag

Initial Counter

Student Sports

letteredFlag

Lettered

Student Sports

medicallyUnableFlag

Medically Unable to Participate

Student Sports

midYearReplaceFlag

Midyear Replacement

Student Sports

nonCertificationFlag

NonCounter Certification on File

Student Sports

nonqualifierFlag

Nonqualifer

Student Sports

otherStatusDescription

NOT MAPPED

Student Sports

overallCounterFlag

Counter (automatically calculated by ARMS)

Student Sports

partSubVarsityFlag

Participant JV

Student Sports

partialQualifierFlag

Partial Qualifier

Student Sports

participatedFlag

Competed

Student Sports

redshirtFlag

Redshirt (Automatically calculated by ARMS)

Student Sports

replaceIneligibleSaFlag

Replaced Ineligible SA

Student Sports

saAffirm

SA Affirmation

Student Sports

schoolSidNumber

University ID

Student Sports

seasonsUsed

Automatically Calculated by ARMS

Student Sports

sportCode

Sport Code

Student Sports

transferResidenceFlag

Transfer Status

Student Sports

yearsOfAid

Automatically Calculated by ARMS

File

CA Column

ARMS Field

Student Aid Limits

academicYear

Year Selected

Student Aid Limits

aidExceptionFlag

NOT MAPPED

Student Aid Limits

aidRciExceptionFlag

NOT MAPPED

Student Aid Limits

comments

Comments from FA widget

Student Aid Limits

costAttendAmt

COA Amount

Student Aid Limits

costAttendCode

COA Code

Student Aid Limits

equivCompDenom

Denominator Chosen (GIA or COA)

Student Aid Limits

giaAmtS1

NOT MAPPED

Student Aid Limits

giaAmtS2

NOT MAPPED

Student Aid Limits

giaAmtS3

NOT MAPPED

Student Aid Limits

grantInAidAmt

GIA Amount

Student Aid Limits

grantInAidCode

GIA Code

Student Aid Limits

institutionCoaAmount

Institutional COA Amount

Student Aid Limits

institutionCoaCode

Institutional COA Code

Student Aid Limits

schoolSidNumber

University ID

Student Aid Limits

sportCode

Sport Code

Student Aid Limits

sportTrackAidCounts

NOT MAPPED

File

CA Column

ARMS Field

Student Awards

academicYear

Year Selected

Student Awards

awardAmount

Amount of Award

Student Awards

awardDate

Date of Award

Student Awards

awardPeriod

Period of Award

Student Awards

awardPeriodExceptionCode

NOT MAPPED

Student Awards

fundCode

Fund Code

Student Awards

infoMessage

NOT MAPPED

Student Awards

rolloverFlag

Always N (CA specific rollover of Aid)

Student Awards

saAidId

NOT MAPPED

Student Awards

schoolAidId

Unique Aid ID number generated by ARMS

Student Awards

schoolSidNumber

University ID

Student Awards

sportCode

Sport Code

File

CA Column

Student General Eligibility

academicYear

Year Selected

Student General Eligibility

comment1

NOT MAPPED

Student General Eligibility

comment2

NOT MAPPED

Student General Eligibility

comments

NOT MAPPED

Student General Eligibility

competitionCertDate

Date of Competition Eligible

Student General Eligibility

divisionIiUsed

NOT MAPPED

Student General Eligibility

drugTest

Drug Test Complete

Student General Eligibility

faCertDate

Financial Aid Certification Date

Student General Eligibility

fullTime

Full Time Enrolled

Student General Eligibility

medicalExamDate

Medical Exam Date

Student General Eligibility

practiceCertDate

Eligible for Practice Date

Student General Eligibility

saStatement

SA Statement Complete

Student General Eligibility

schoolSidNumber

University ID

File

CA Column

ARMS Field

Student Degree Progress

academicIneligible

Academically Ineligible

Student Degree Progress

academicYear

Year Selected

Student Degree Progress

classDescription

Class Year

Student Degree Progress

comments

NOT MAPPED

Student Degree Progress

degreeDate

Degree Date

Student Degree Progress

degreeDeclareDate

Degree Declared Date

Student Degree Progress

degreeId

Degree Code (Ncaa code)

Student Degree Progress

degreeReqHours

Required Credit Hours

Student Degree Progress

degreeYears

Five Year Program

Student Degree Progress

goodAcademic

Good Academic Standing

Student Degree Progress

ineligibleViolation

Inelgible due to violation

Student Degree Progress

minorCertificate

Minor

Student Degree Progress

minorCertificateDate

Minore Declared Date

Student Degree Progress

overallCumulativeGpa

NOT MAPPED

Student Degree Progress

saCumulativeGpa

NOT MAPPED

Student Degree Progress

schoolSidNumber

University ID

Student Degree Progress

totalDegreeHours

NOT MAPPED

File

CA Column

ARMS Field

Student Terms

academicYear

Year Selected

Student Terms

cumGpa

Cumulative GPA

Student Terms

degreeApplicableHours

Degree Applicable Hours

Student Terms

fullTimeFlag

NOT MAPPED

Student Terms

gpa

Term GPA

Student Terms

hoursAttempted

Hours Attempted

Student Terms

hoursCompleted

NOT MAPPED

Student Terms

hoursEarned

Hours Earned

Student Terms

remedialHours

NOT MAPPED

Student Terms

schoolSidNumber

University ID

Student Terms

termCode

Fall, Winter or Spring (User Picked)

Did this answer your question?