Student Table
|
| Student ID |
In the URL at the top of the page when in the Student File
|
StudentID |
| DateAdded |
N/A |
DateAdded |
EmpNo
|
Student File > Contact Info Page > Job Details Tab
|
Empno |
| StudentType / _StudentType- |
Student File > Contact Info Page > Job Details Tab (StudentType pulls the code and _StudentType pulls the full data description) |
StudentType |
| EmployeeType / _EmpType |
Student File > Contact Info Page > Job Details Tab (Employee Type pulls the code and _EmpType pulls the full data description)
|
EmpType |
| FirstName |
Student File > Contact Info Page > Contact Details Tab
|
First Name |
| LastName |
Student File > Contact Info Page > Contact Details Tab
|
Last Name |
| MiddleName |
Student File > Contact Info Page > Contact Details Tab |
MiddleName |
| FullName |
Student File > Contact Info Page > Contact Details Tab
|
First Name + Last Name |
| PreferredName |
Student File > Contact Info Page > Contact Details Tab > Nickname |
PreferredName |
| HomeStreet1 |
Student File > Contact Info Page > Contact Details Tab |
HomeStreet1 |
| HomeStreet2 |
Student File > Contact Info Page > Contact Details Tab |
HomeStreet2 |
| HomeCity |
Student File > Contact Info Page > Contact Details Tab |
HomeCity |
| HomeState / _HomeState |
Student File > Contact Info Page > Contact Details Tab (HomeState pulls the code and _HomeState pulls the full data description) |
HomeState |
| HomeZip |
Student File > Contact Info Page > Contact Details Tab |
HomeZip |
| HomeCountry |
Student File > Contact Info Page > Contact Details Tab |
HomeCountry |
| Login |
Student File > Contact Info Page > Peraonal Info Tab |
Login |
| WorkStreet1 |
Student File > Contact Info Page > Contact Details Tab |
WorkStreet1 |
| WorkStreet2 |
Student File > Contact Info Page > Contact Details Tab |
WorkStreet2 |
| WorkCity |
Student File > Contact Info Page > Contact Details Tab |
WorkCity |
| WorkState / _WorkState |
Student File > Contact Info Page > Contact Details Tab (WorkState pulls the code and _WorkState pulls the full data description) |
WorkState |
| WorkZip |
Student File > Contact Info Page > Contact Details Tab |
WorkZip |
| WorkCountry |
Student File > Contact Info Page > Contact Details Tab |
WorkCountry |
| HomeEmail |
Student File > Contact Info Page > Contact Details Tab |
Email |
| WorkEmail |
Student File > Contact Info Page > Contact Details Tab |
WorkEmail |
| HomePhoneNumber |
Student File > Contact Info Page > Contact Details Tab |
HomePhone |
| WorkPhoneNumber |
Student File > Contact Info Page > Contact Details Tab |
WorkPhone |
| WorkCellPhone |
Student File > Contact Info Page > Contact Details Tab |
WorkCellPhone |
| CellPhoneNumber |
Student File > Contact Info Page > Contact Details Tab |
CellPhone |
| FaxNumber |
Student File > Contact Info Page > Contact Details Tab |
Fax |
| WorkExt |
Student File > Contact Info Page > Contact Details Tab |
WorkExt |
| WorkFax |
Student File > Contact Info Page > Contact Details Tab |
WorkFax |
| StudentMisc 1-20 |
Student File > Student Misc Page > Misc 1-20 (Pulls the code only)
|
Misc1-Misc20 |
| _StudentMisc 1-20- |
Student File > Student Misc Page > Misc 1-20 (Pulls the data description) |
MiscStudentCaption |
| PrimaryJobCode |
Student File > Contact Info Page > Job Details Tab |
PrimaryJobCode |
| PrimaryJobTitle |
Student File > Contact Info Page > Job Details Tab |
PrimaryJobTitle |
| PrimaryJobStartDate |
Student File > Contact Info Page > Job Details Tab |
PrimaryJobStartDate |
| Primary Org Code 1-5 / _PrimaryOrg1-5 |
Student File > Contact Info Page > Job Details Tab (PrimaryOrg1-5 pulls the code and _PrimaryOrg1-5 pulls the full data description) |
PrimaryOrg1-5 |
| Status |
Student File > Contact Info Page > Contact Tab
|
Status |
| SupervisorName |
Student File > Contact Info Page > Job Details Tab |
SupervisorName |
| Supervisor |
N/A |
Supervisor |
| SupervisorName2 |
Student File > Contact Info Page > Job Details Tab |
SupervisorName2 |
| Supervisor2 |
N/A |
Supervisor2 |
| SSN |
Student File > Contact Info Page > Personal Details Tab |
SSN |
| BirthDate |
Student File > Contact Info Page > Personal Details Tab |
BirthDate |
| HireDate |
Student File > Contact Info Page > Job Details Tab |
HireDate |
| Email |
Student File > Contact Info Page > Job Details Tab |
PrimaryEmail |
| PrimaryPhone |
Student File > Contact Info Page > Job Details Tab |
PrimaryPhone |
| IsEmp |
Student File > Contact Info Page > Job Details Tab |
IsEmp
|
| IsSupervisor |
Student File > Contact Info Page > Job Details Tab |
IsSupervisor |