| 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 |