Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Acid | int | 4 | null |
|
|
Attendance code ID - Unique identifier for the attendance code |
||
| code | varchar | 10 | √ | null |
|
|
Attendance code - Short code for the attendance status |
|
| codedescription | varchar | 255 | √ | null |
|
|
Code description - Description of what the attendance code represents |
|
| UpdatedByName | nvarchar | 100 | √ | null |
|
|
Updated by name - Name of the person who last modified this code (null for system codes) |
|
| UpdatedById | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last modified this code (null for system codes) |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Update date - Date of last modification (null for system codes) |
|
| locked | int | 4 | null |
|
|
Locked flag - Indicates if code is system-defined (1=locked) or custom (0=editable) |
Relationships
Close relationships within degrees of separation
