Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each custom activity note |
|
| fkActivityID | int | 4 | √ | null |
|
|
Activity reference - Links to Activity_Visit table for the service visit |
|
| DateCreated | datetime | 16,3 | √ | (getdate()) |
|
|
Creation date - Timestamp when the note was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created the note |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last update date - Timestamp of the most recent note update |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last modified the note |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Soft delete timestamp for audit trail purposes |
|
| ActivityDate | datetime | 16,3 | √ | null |
|
|
Activity date - Date when the activity/visit occurred |
|
| ActivityNotes | nvarchar | 1073741823 | √ | null |
|
|
Clinical notes - Detailed clinical notes and observations from the visit |
|
| ActivityStartTime | nvarchar | 50 | √ | null |
|
|
Start time - Time when the activity/visit started |
|
| ActivityEndTime | nvarchar | 50 | √ | null |
|
|
End time - Time when the activity/visit ended |
|
| NonClientActivityCodes | nvarchar | 510 | √ | null |
|
|
Non-client codes - Codes for non-client activities or administrative time |
|
| ANStarttime | datetime | 16,3 | √ | null |
|
|
Activity start timestamp - Precise timestamp when activity began |
|
| Tottime | decimal | 20,2 | √ | null |
|
|
Total time - Total time spent on the activity in decimal format (hours.minutes) |
|
| ActivityCode | int | 4 | √ | null |
|
|
Activity code - Numeric code identifying the type of activity performed |
|
| TotalMinutesAreCalculatedFrom | nvarchar | 510 | √ | null |
|
|
Time calculation source - Source field or method used to calculate total minutes for the activity |
|
| Hours | int | 4 | √ | null |
|
|
Hours component - Number of hours portion of the total activity time |
|
| Minutes | int | 4 | √ | null |
|
|
Minutes component - Number of minutes portion of the total activity time |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ActivityNotesCustom | Primary key | Asc | pkID |
Relationships
Close relationships within degrees of separation
