Enrollments


Description

Student enrollment management - Core table managing student enrollments in educational programs and classes with comprehensive tracking of enrollment details, rates, schedules, and administrative information. This table supports enrollment workflows, class management, billing calculations, and educational program administration for healthcare-related educational services.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
AdmitID int 4 null
PatientAdministration.AdmitID FK_Enrollments_PatientAdministration R

Case reference - Links to PatientAdministration table for the case
AmountRate decimal 20,2 √ null

Rate amount - Monetary rate for this enrollment
CreatedBy int 4 √ null

Created by user - UserID of the person who created the enrollment
DateCreated datetime 16,3 √ null

Creation date - Date when enrollment was created
DateUpdated datetime 16,3 √ null

Last update date - Date when enrollment was last updated
Deleted Unknown 0 null

Deletion flag - Soft delete flag for audit trail purposes
DeletedBy Unknown 0 null

Deleted by user - UserID of the person who deleted the enrollment
pkEnrollmentID int identity 4 √ null
Attendances.fkEnrollmentID FK_Attendances_Enrollments R
EnrollmentCasePaysources.fkEnrollmentID FK_EnrollmentCasePaysources_Enrollments R
EnrollmentPaysources.fkEnrollmentID FK_EnrollmentPaysources_Enrollments R

Enrollment primary key - Unique identifier for each student enrollment
fkClassID int 4 null
Plans.pkClassID FK_Enrollments_Classes R

Class reference - Links to Plans table for the enrolled class/program
fkClassRate int 4 null
PlanRates.pkClassRateID FK_Enrollments_ClassRates R

Rate reference - Links to PlanRates table for billing rate
fkClassRoomID int 4 null
ClassRooms.Id FK_Enrollments_ClassRooms R

Classroom reference - Links to ClassRooms table for physical classroom
IntervalRate int 4 √ null

Rate interval - Billing interval for the rate (daily, weekly, monthly)
ScheduleJson nvarchar 1073741823 √ null

Schedule data - JSON data containing enrollment schedule information
StartDate datetime 16,3 √ null

Enrollment start date - Date when enrollment begins
EndDate datetime 16,3 √ null

Enrollment end date - Date when enrollment ends
UpdatedBy int 4 √ null

Updated by user - UserID of the person who last updated the enrollment
OtherRatesJson nvarchar 1073741823 √ null

Additional rates data - JSON data containing additional or alternative rate configurations for the enrollment
DeletedDate datetime 16,3 √ null

Deletion date - Date when enrollment was deleted
Status Unknown 0 null

Enrollment status - Current status of the enrollment (Active, Inactive, etc.)
WeekDays nvarchar 14 √ null

Weekly schedule - Days of the week when the enrollment is active (e.g., ‘MTWTHF’ for Monday-Friday)

Indexes

Constraint Name Type Sort Column(s)
PK_Enrollment Primary key Asc pkEnrollmentID

Relationships

Close relationships within degrees of separation