Files from any supplier of Prospect/Student data can be used, however the data MUST be in the following layout to be imported into CAMS. 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.
Field Name |
Field Type |
Comments |
CAMSImportGenericUID |
int |
Identity column (SQL Generated) |
JobID |
int |
Id created in the Identity column |
Salutation |
varchar(15) |
|
FirstName |
varchar(60) |
|
MiddleInitial |
varchar(60) |
|
LastName |
varchar(60) |
|
Suffix |
varchar(12) |
|
PreferredName |
varchar(60) |
|
Gender |
varchar(6) |
|
BirthDate |
varchar(10) |
|
SSN |
varchar(11) |
|
Address1 |
varchar(60) |
|
Address2 |
varchar(60) |
|
Address3 |
varchar(60) |
|
City |
varchar(60) |
|
State |
varchar(50) |
|
ZipCode |
varchar(10) |
|
County |
varchar(40) |
|
Country |
varchar(50) |
|
Phone1 |
varchar(20) |
|
Phone2 |
varchar(20) |
|
WorkPhone |
varchar(20) |
|
Fax |
varchar(20) |
|
Email1 |
varchar(50) |
|
Email2 |
varchar(50) |
|
Email3 |
varchar(50) |
|
HSGraduation |
varchar(10) |
|
HSGPA1 |
varchar(10) |
Student “HS GPA” or Prospect “GPA” |
HSGPA2 |
varchar(10) |
Student “HS GPA Scale” or Prospect (GPA) “of” |
HSCEEB |
varchar(15) |
|
EthnicGroup |
varchar(50) |
|
Degree |
varchar(50) |
Prospect: This will be entered into a Prospect Note and as the Initial Degree in Prospect Maintenance |
Major1 |
varchar(50) |
Prospect: this will be entered into a Prospect Note |
Major2 |
varchar(50) |
Prospect: this will be entered into a Prospect Note |
Major3 |
varchar(50) |
Prospect: this will be entered into a Prospect Note |
CollegeCEEB1 |
varchar(20) |
|
CollegeCEEB2 |
varchar(20) |
|
CollegeCEEB3 |
varchar(20) |
|
InterestCategory1 |
varchar(50) |
|
Interest1 |
varchar(50) |
|
InterestCategory2 |
varchar(50) |
|
Interest2 |
varchar(50) |
|
InterestCategory3 |
varchar(50) |
|
Interest3 |
varchar(50) |
|
InterestCategory4 |
varchar(50) |
|
Interest4 |
varchar(50) |
|
InterestCategory5 |
varchar(50) |
|
Interest5 |
varchar(50) |
|
InterestCategory6 |
varchar(50) |
|
Interest6 |
varchar(50) |
|
Recruiter |
varchar(60) |
|
Event |
varchar(50) |
|
AttendanceType |
varchar(50) |
|
UserDefinedCode |
varchar(50) |
|
EntranceProgram |
varchar(50) |
|
ExpectedEntranceTerm |
varchar(12) |
|
SourceOfLead |
varchar(80) |
Student: this will be entered into a Student Note |
Religion |
varchar(50) |
|
NativeLanguage |
varchar(50) |
|
NoteSubject |
varchar(120) |
|
Note |
varchar(2000) |
|
ProspectApplicantStatus |
varchar(50) |
|
ACTDate |
varchar(10) |
|
ACTEnglish |
varchar(12) |
|
ACTMath |
varchar(12) |
|
ACTReading |
varchar(12) |
|
ACTScience |
varchar(12) |
|
ACTWriting |
varchar(12) |
|
ACTComposite |
varchar(12) |
|
SATDate |
varchar(10) |
|
SATVerbal |
varchar(12) |
|
SATMath |
varchar(12) |
|
SATWriting |
varchar(12) |
|
SATCombined |
varchar(12) |
|
MobilePhone |
varchar(20) |
|