Teacher Form
Field reference for teacher/faculty records. Teacher records are created when a person is assigned to teach.
Fields
| Field | Type | Required | Max Length | Validation | Notes |
|---|---|---|---|---|---|
| Teacher ID | Integer | Auto | - | - | System-generated identifier |
| Person | Select (FK) | Yes | - | Must exist | Parent person record |
| Employee ID | Text | No | 20 | - | HR employee ID |
| Hire Date | Date | No | - | Valid date | Employment start date |
| Status | Select (Lookup) | Yes | - | EMPLOYEE_STATUS | Active, Inactive, Retired |
| Department | Select (FK) | No | - | Must exist | Primary department |
Display First / Last Name (display_first_name, display_last_name) | Text | No | 100 each | - | Colleague's faculty listing name (FAC_NAME), written by the nightly teachers import step whenever Colleague has one. Not edited on a screen. Migration 298 |
Computed Fields (Read-Only)
| Field | Description |
|---|---|
| Display Name | records.instructor_display_name: the faculty listing name above, else the person's current Preferred Name, else the legal name (migration 298). This is the name course screens, rosters and grade reports show |
| Current Sections | Sections currently teaching |
| Section Count | Total sections taught |
| Credential Count | Number of credentials on file |
Credential Sub-Form
| Field | Type | Required | Notes |
|---|---|---|---|
| Credential Type | Select (Lookup) | Yes | CREDENTIAL_TYPE (Degree, Certificate, License) |
| Credential Name | Text | Yes | Name of credential |
| Issuing Institution | Text | No | Where earned |
| Date Earned | Date | No | When earned |
| Expiry Date | Date | No | If credential expires |
Credential Type Values
| Code | Description | Notes |
|---|---|---|
| DEGREE | Academic Degree | PhD, MA, MS, etc. |
| CERTIFICATE | Professional Certificate | Industry certifications |
| LICENSE | Professional License | State-issued licenses |
| OTHER | Other | Other qualifications |
Validation Rules
- Person must exist before creating teacher record
- One teacher record per person
- Department determines course subject eligibility
- Credentials with Expiry Date should be monitored
Section Assignment
Teachers are assigned to sections, not directly managed here. See:
- Sections - Instructor assignment sub-form
Related Screens
- Person - Parent person record
- Sections - Teaching assignments
- Departments - Department affiliation