Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| PkTrackingFieldValueID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each tracking field instance |
||||
| fkTrackingFieldID | int | 4 | √ | null |
|
|
Field definition reference - Links to TrackingFields table for field definition |
||||
| fkTrackingFieldCategoryID | int | 4 | √ | null |
|
|
Category reference - Links to TrackingFieldsCategory for categorization |
||||
| fkPrimaryID | int | 4 | √ | null |
|
|
Primary record reference - Links to the primary record being tracked (patient, case, etc.) |
||||
| fkAssignmentID | int | 4 | √ | null |
|
|
Assigned user - UserID of the person assigned to complete this tracking item |
||||
| Status | int | 4 | √ | null |
|
|
Tracking status - Current status of the tracking item (Open, Closed, Exempt, etc.) |
||||
| TrackingValue | nvarchar | 510 | √ | null |
|
|
Tracking value - Current value or data associated with the tracking field |
||||
| FromDate | smalldatetime | 16 | √ | null |
|
|
From date - Start date for the tracking period or validity |
||||
| DueExpireDate | datetime | 16,3 | √ | null |
|
|
Due/expire date - Date when the tracking item is due or expires |
||||
| TargetDate | smalldatetime | 16 | √ | null |
|
|
Target date - Target completion date for the tracking item |
||||
| ActualDate | smalldatetime | 16 | √ | null |
|
|
Actual date - Actual completion or occurrence date |
||||
| SubmittedDate | smalldatetime | 16 | √ | null |
|
|
Submitted date - Date when the tracking item was submitted |
||||
| Notes | varchar | 2000 | √ | null |
|
|
Tracking notes - Notes and comments about the tracking item |
||||
| TrackingFieldValueIMPORTID | nvarchar | 510 | √ | null |
|
|
Import identifier - External import identifier for data migration tracking |
||||
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this tracking instance |
||||
| CreatedDate | smalldatetime | 16 | √ | null |
|
|
Creation date - Timestamp when the tracking instance was created |
||||
| ModifiedBy | int | 4 | √ | null |
|
|
Modified by user - UserID of the person who last modified this tracking instance |
||||
| ModifiedDate | smalldatetime | 16 | √ | null |
|
|
Modification date - Timestamp of the most recent modification |
||||
| Link | varchar | 500 | √ | null |
|
|
Reference link - URL or reference link associated with the tracking item |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_TrackingFieldValues | Primary key | Asc | PkTrackingFieldValueID |
Relationships
Close relationships within degrees of separation
