| 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 |
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 |
| Login |
Student File > Contact Info Page > Personal Details Tab |
Login |
| 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 |
| 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 |
Student File > Contact Info Page > Job Details Tab |
PrimaryOrg1-5 |
| Org Title 1-5 |
Student File > Contact Info Page > Job Details Tab
|
PrimaryOrg1-5Desc |
| 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 |
| 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 |
| IsEmp |
Student File > Contact Info Page > Job Details Tab |
IsEmp
|
| IsSupervisor |
Student File > Contact Info Page > Job Details Tab |
IsSupervisor |
| 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 |
Fee |
| Credits |
Course File > Main Page > General Tab |
Credits |
| CEU |
Course File > Main Page > General Tab |
CEU |
| CourseDesc |
Course File > Main Page > General Tab |
ExternalDesc |
| CourseMisc1-20 |
Course File > Main Page > Misc Tab |
Misc1-20 |
| CourseHours |
Course File > Main Page > General Tab |
Hours |
| 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 |
| Courses Taken Table |
| Date Needed |
Student File > Activity Page > Courses Taken Tab |
DateNeeded |
| Date Completed |
Student File > Activity Page > Courses Taken Tab |
JobRequirement |
| Date Expires |
Student File > Activity Page > Courses Taken Tab |
|
| Grade |
Student File > Activity Page > Courses Taken Tab |
Priority |
| Hours |
Student File > Activity Page > Courses Taken Tab |
|
| Note |
Student File > Activity Page > Courses Taken Tab |
Note |
| Manual Course |
Not being Used |
|
| Manual Provider |
Not being Used |
|
| Company Table |
| Company |
Admin > Codes > Companies (Code Only) |
Company |
| CompanyName |
Admin > Codes > Companies (Data Description Only) |
CompanyName |