Activity


Description

Scheduled activities and appointments managing calendar events, appointments, and scheduled activities for healthcare providers and patients. This table serves as the foundation for scheduling, appointment management, and activity tracking within the healthcare system.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ActivityID int identity 4 √ null
Activity_Visit.fkActivityID FK_Activity_Visit_Activity R
ActivityAssignment.fkActivityID ActivityAssignment_FK_Activity_ID R

Primary key - Unique identifier for each scheduled activity
StartDateTimeUtc datetime 16,3 (getutcdate())

Start time UTC - Start date and time of the activity in UTC
Duration int 4 ((3600))

Duration - Duration of the activity in seconds
Subject nvarchar 510 √ null

Activity subject - Title or subject line for the activity
ActivityDescription ntext 1073741823 √ null

Description - Detailed description of the activity
AllDayEvent bit 1 ((0))

All day event - Flag indicating if this is an all-day event
Location nvarchar 128 √ null

Location - Physical location where the activity takes place
Status int 4 ((0))

Activity status - Current status of the activity (Scheduled, Completed, Cancelled, etc.)
EnableReminder bit 1 ((1))

Reminder enabled - Flag indicating if reminders are enabled
ReminderInterval int 4 ((900))

Reminder interval - Time interval for reminders in seconds
ShowTimeAs int 4 ((3))
ActivityShowTimeAs.pkShowTimeAs FK_Activity_ActivityShowTimeAs R

Show time as - Links to ActivityShowTimeAs for calendar display
Importance int 4 ((1))

Importance level - Priority or importance level of the activity
RecurrenceID int 4 ((-999))

Recurrence ID - Identifier for recurring activity patterns
OriginalStartDateTimeUtc datetime 16,3 √ null

Original start time - Original start time for rescheduled activities
VarianceID uniqueidentifier 16 √ null

Variance ID - Unique identifier for activity variations
_ts timestamp 8 √ null

Timestamp - Database timestamp for concurrency control
EnteredBy int 4 √ null

Entered by user - UserID of the person who created the activity
DateEntered smalldatetime 16 √ (getdate())

Entry date - Date when the activity was entered
UpdatedBy int 4 √ null

Updated by user - UserID of the person who last modified the activity
DateUpdated smalldatetime 16 √ null

Update date - Date when the activity was last updated
fkActivityCategoryID int 4 √ null
ActivityCategory.pkActivityCategoryID FK_Activity_ActivityCategory R

Category reference - Links to ActivityCategory for activity classification
fkActivityStatusID int 4 √ null
ActivityStatus.pkStatusID FK_Activity_ActivityStatus R

Status reference - Links to ActivityStatus for detailed status information

Indexes

Constraint Name Type Sort Column(s)
Activity_PK Primary key Asc ActivityID

Relationships

Close relationships within degrees of separation