AttendanceCode


Description

Attendance code definitions managing standardized codes for tracking student and client attendance in educational and therapeutic programs. This lookup table provides attendance status codes (Present, Absent, Late, Early Dismissal) with descriptions and administrative tracking for attendance management and reporting.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ACID int identity 4 √ null

Primary key - Unique identifier for each attendance code
Code varchar 10 √ null

Attendance code - Short code for the attendance status (P=Present, A=Absent, L=Late, etc.)
CodeDescription varchar 255 √ null

Code description - Detailed description of what the attendance code represents
DeletedDate datetime 16,3 √ null

Deletion date - Soft delete timestamp for audit trail purposes
Status bit 1 ((1))

Active status - Boolean indicating if the attendance code is currently active
UpdatedById int 4 √ null

Updated by user - UserID of the person who last modified this code
DateUpdated datetime 16,3 √ null

Update date - Date and time of the last modification
UpdatedByName nvarchar 100 √ null

Updated by name - Name of the person who last modified this code

Indexes

Constraint Name Type Sort Column(s)
PK__AttendanceCode__75A40FA3 Primary key Asc ACID
IX_Code Performance Asc Code

Relationships

Close relationships within degrees of separation