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 |