Prospect/Student Import Validation Rules

Files from any supplier of Prospect/Student data can be used, however the data MUST be in the correct Prospect/Student Import Layout to be imported into CAMS. The Validation Rules will also be applied during the import process.

Note: Because the import process can be lengthy and locks the Admissions Module while processing, it is strongly recommended that this data be imported during off-peak hours when users are not in CAMS Enterprise.

Once data has been correctly formatted, you can begin the import process by defining the Prospect/Student Import Parameters.

Prospect/Student Import Validation Rules:

FirstName, LastName, and Address1 are REQUIRED fields.
Gender needs to be M, F, Male, or Female or empty string.
BirthDate needs to be in MM/DD/YYYY format or Null or empty string.
SSN Picture needs to match the SSN Field Picture on CAMS Configuration/General 2.
State needs to match either UniqueID or DisplayText from the Glossary table (Category = 1003) or Null or empty string.
Country needs to match either UniqueID or DisplayText from the Glossary table (Category = 1002) or Null or empty string.
HSGPA1 needs to be numeric or Null or empty string.
HSGPA2 needs to be numeric or Null or empty string.
HSCEEB needs to match HighSchoolCode from the HighSchools table or Null or empty string.
EthnicGroup needs to match either UniqueID or DisplayText from the Glossary table (Category = 81) or Null or empty string.
Degree needs to match either UniqueID or DisplayText from the DegreeNameRef table or Null or empty string.
Major1 needs to match either MajorMinorID or MajorMinorName from MajorMinor table or Null or empty string.
Major2 needs to match either MajorMinorID or MajorMinorName from MajorMinor table or Null or empty string.
Major3 needs to match either MajorMinorID or MajorMinorName from MajorMinor table or Null or empty string.
CollegeCEEB1 needs to match CollegeCode in the Colleges table or Null or empty string.
CollegeCEEB2 needs to match CollegeCode in the Colleges table or Null or empty string.
CollegeCEEB3 needs to match CollegeCode in the Colleges table or Null or empty string.
InterestCategory1 needs to match either UniqueID or DisplayText from the Glossary table (Category = 60) or Null or empty string.
Interest1 needs to match either UniqueID or DisplayText from the Glossary table (Category = 62) or Null or empty string.
InterestCategory2 needs to match either UniqueID or DisplayText from the Glossary table (Category = 60) or Null or empty string.
Interest2 needs to match either UniqueID or DisplayText from the Glossary table (Category = 62) or Null or empty string.
InterestCategory3 needs to match either UniqueID or DisplayText from the Glossary table (Category = 60) or Null or empty string.
Interest3 needs to match either UniqueID or DisplayText from the Glossary table (Category = 62) or Null or empty string.
InterestCategory4 needs to match either UniqueID or DisplayText from the Glossary table (Category = 60) or Null or empty string.
Interest4 needs to match either UniqueID or DisplayText from the Glossary table (Category = 62) or Null or empty string.
InterestCategory5 needs to match either UniqueID or DisplayText from the Glossary table (Category = 60) or Null or empty string.
Interest5 needs to match either UniqueID or DisplayText from the Glossary table (Category = 62) or Null or empty string.
InterestCategory6 needs to match either UniqueID or DisplayText from the Glossary table (Category = 60) or Null or empty string.
Interest6 needs to match either UniqueID or DisplayText from the Glossary table (Category = 62) or Null or empty string.

Note: If InterestCategory1 is not Null or empty string, then Interest1 must not be Null or empty string. The same applies for InterestCategory2/Interest2 ,3,4,5,6.

Recruiter needs to match RecruiterID or Name in the Recruiter table or Null or empty string.
Event needs to match either UniqueID or DisplayText from the Glossary table (Category = 82) or Null or empty string.
AttendanceType needs to match either UniqueID or DisplayText from the Glossary table (Category = 12) or Null or empty string.
UserDefinedCode needs to match either UniqueID or DisplayText from the Glossary table (Category = 70 for Prospects, Category 11 for Students) or Null or empty string.
EntranceProgram needs to match either ProgramsID or Programs from the Programs table or Null or empty string.
ExpectedEntranceTerm needs to match either TermCalendarID or TextTerm from the TermCalendar table or Null or empty string.
Religion needs to match either UniqueID or DisplayText from the Glossary table (Category = 86) or Null or empty string.
NativeLanguage needs to match either UniqueID or DisplayText from the Glossary table (Category = 56) or Null or empty string.
ProspectApplicantStatus needs to match either the UniqueID or DisplayText from the ProspectApplicantStatusRef table or Null or empty string.
ACTDate and SATDate need to be in MM/DD/YYYY format or Null or empty string.

Note: All SAT and ACT score fields need to be numeric or Null or empty string.