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 |