Field Name |
Screen / Field / Note |
Field Name in Database |
Student Table
|
Student ID |
In the URL at the top of the page when in the Student File
|
StudentID |
DateAdded |
N/A |
DateAdded |
ChangeDate |
N/A |
ChangeDate |
Employee Number
|
Student File > Contact Info Page > Job Details Tab
|
Empno |
StudentType |
Student File > Contact Info Page > Job Details Tab |
StudentType |
EmployeeType |
Student File > Contact Info Page > Job Details Tab
|
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 > Cotntact Details Tab |
HomeStreet2 |
HomeCity |
Student File > Contact Info Page > Cotntact Details Tab |
HomeCity |
HomeState |
Student File > Contact Info Page > Cotntact Details Tab |
HomeState |
HomeZip |
Student File > Contact Info Page > Cotntact Details Tab |
HomeZip |
HomeCountry |
Student File > Contact Info Page > Cotntact Details Tab |
HomeCountry |
WorkStreet1 |
Student File > Contact Info Page > Cotntact Details Tab |
WorkStreet1 |
WorkStreet2 |
Student File > Contact Info Page > Cotntact Details Tab |
WorkStreet2 |
WorkCity |
Student File > Contact Info Page > Cotntact Details Tab |
WorkCity |
WorkState |
Student File > Contact Info Page > Cotntact Details Tab |
WorkState |
WorkZip |
Student File > Contact Info Page > Cotntact Details Tab |
WorkZip |
WorkCountry |
Student File > Contact Info Page > Cotntact Details Tab |
WorkCountry |
Email |
Student File > Contact Info Page > Contact Details Tab - Home Email |
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 |
StudentMisc1-20 |
Student File > Student Misc Page > Misc 1-20
|
Misc1-Misc20 |
_StudentMisc1-20 |
Student File > Student Misc Page > Misc 1-20 |
Misc1-Misc20 |
Student Status |
Student File > Contact Info Page > Contact Tab (Active/Inactive)
|
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 |
DateAdded |
N/A |
DateAdded |
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 |
PrimaryEmail |
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 |
Company |
Student File > Contact Info Page Page > Job Details Tab |
Company |
Course Table |
CourseName |
Course File > Main Page > General Tab |
CourseName |
CourseID |
Course File > Main Page > General Tab |
CourseID |
CourseType |
Course File > Main Page > General Tab |
CourseType |
Active |
Course File > Main Page > General Tab |
Active |
Fee |
Course File > Main Page > General Tab |
|
InternalDesc |
Course File > Main Page > General Tab |
InternalDesc |
ExertnalDesc |
Course File > Main Page > General Tab |
ExternalDesc |
CourseMisc1-20 |
Course File > Main Page > Misc Tab |
Misc1-20 |
GradeType |
Course File > Main Page > General Tab |
GradeType |
Instructor |
N/A - There is not an instructor field in the Courses Tab - placeholder |
N/A |
Location |
N/A - While this is pulling from the Classes Table, the view is not connected to the Classes Table and therefore will not display information when used. |
Location |
Classes Table |
ClassStartDate |
Class File > Class Details Page > Location / Schedule / Content Tab |
Start Date |
Course Test Questions Table |
Question |
Course File > Course Test Page |
Question |
Order |
Course File > Course Test Page |
QuestionOrder |
IsRequired |
Course File > Course Test Page |
QuestionIsRequired |
Student Course Test Answers Table |
Answer |
Student File > Activity Page > Class Enrollment Tab - Test Link
|
Answer |
ChangeDate (v6.4) |
Date the student saves the test or submits the test |
ChangeDate |
Score |
Student File > Activity Page > Class Enrollment Tab |
AnswerScore |
Submitted |
Date the Student Submit the Test |
AnswerSubmitted |
Attempt |
N/A |
AnswerAttempt |