Name |
Type |
Required |
Field Description |
Example
|
ID |
#B |
Yes* |
The unique numeric ID of the student, required if Other_ID isn't being used. |
19310045
|
Other_ID |
A40 |
Yes* |
A secondary ID or handle for the student, required if ID isn't being used. |
A19310045
|
Other_ID2 |
A40 |
|
An optional tertiary ID or handle for the student. |
dsmith1990
|
Barcode |
A80 |
|
A barcode ID for the student, required if scanners are used to log students in. |
A2609376378
|
Status |
A80 |
No |
The status of the student. This is set automatically. |
Active
|
OtherStatus |
A80 |
|
An optional secondary status. This can be set by the import process. |
Registered
|
Legal_First |
A80 |
Yes |
The legal first name of the student. |
Dave
|
First_Name |
A80 |
Yes |
The preferred first name of the student. |
Dave
|
Last_Name |
A80 |
Yes |
The last name of the student. |
Smith
|
Middle |
A80 |
|
The middle name or initial of the student. |
L.
|
Street |
A80 |
|
The street address of the student. |
1234 E. Nowhere St.
|
Apt |
A80 |
|
Apartment Number. |
#46
|
City |
A80 |
|
City of the student address. |
Tempe
|
State |
A80 |
|
The state of the student address. |
Arizona
|
Zip |
A10 |
|
The zip code of the student address. |
88881
|
Country |
A10 |
|
The country of the student address. |
USA
|
Home_Phone |
A20 |
|
The student's home phone number. |
555-555-5551
|
Work_Phone |
A20 |
|
The student's work phone number. |
555-555-5552
|
Cell_Phone |
A20 |
|
The student's cell phone number. |
555-555-5553
|
Email |
A80 |
* |
The student's email address. Required if students are going to be receiving emails from TracCloud. |
dsmith@school.edu
|
Preferred |
A20 |
|
The student's preferred phone number, 'Home', 'Work', or 'Phone'. |
Home
|
Username |
A80 |
* |
The student's username or handle, required if students are going to be logging into TracCloud. |
dsmith
|
Birthdate |
Date |
|
The student's birthdate. |
1970-01-01
|
Gender |
A8 |
|
The student's gender. |
Male
|
Ethnicity |
A80 |
|
The student's ethnicity. |
Caucasian
|
Major |
A120 |
|
The student's major. |
Accounting
|
Class |
A80 |
|
The student's class. |
SO
|
DegreeGoal |
A80 |
|
The student's class. |
AAS
|
Cohort |
A80 |
|
The student's cohort. |
2017SP
|
College |
A80 |
|
The student's college. |
Nowhere State University
|
Grad_Und |
A80 |
|
The student's graduate status. |
Und
|
DateStarted |
Date |
|
The student's start or enrollment date. |
2015-12-01
|
DateWithdrawn |
Date |
|
The student's withdrawn date. |
2015-12-02
|
ReasonWithdrawn |
A128 |
|
The student's withdrawn reason. |
Reasons
|
GradDate |
Date |
|
The student's graduation date. |
2020-10-05
|
GradDegree |
A128 |
|
The student's graduate degree. |
AAS
|
GPA |
Double |
|
The student's GPA. |
3.2
|
AccumHours |
Double |
|
The student's total accumulated hours. |
46
|
Fund |
A80 |
|
The student's fund. |
Federal Work Study
|
Pronouns |
A80 |
|
The student's preferred pronouns. |
He/Him/His
|
CustomData1-X |
A80 |
|
Custom fields, available for any purpose. Multiple custom fields can be used. |
?
|