Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkTrackingFieldID | int | 4 | null |
|
|
Primary key - Unique identifier for the tracking field definition |
||
| TrackingFieldName | nvarchar | 510 | √ | null |
|
|
Tracking field name - Display name of the tracking field used in user interfaces |
|
| TrackingFieldDesc | nvarchar | 510 | √ | null |
|
|
Tracking field description - Detailed description explaining the purpose and usage of the tracking field |
|
| TableNameLink | nvarchar | 100 | √ | null |
|
|
Linked table name - Database table name that this tracking field is associated with |
|
| FieldNameLink | nvarchar | 100 | √ | null |
|
|
Linked field name - Specific field name within the linked table that this tracking field monitors |
|
| AutoCreateTrigger | int | 4 | √ | null |
|
|
Auto-create trigger - Flag indicating whether tracking field values should be automatically created when linked records are created |
|
| fkCategory | int | 4 | √ | null |
|
|
Category foreign key - Links to tracking field category for organizational grouping |
|
| tfUserFName | varchar | 50 | √ | null |
|
|
Tracking field user first name - First name of the user who created or owns the tracking field definition |
|
| tfUserLName | varchar | 50 | √ | null |
|
|
Tracking field user last name - Last name of the user who created or owns the tracking field definition |
|
| PkTrackingFieldValueID | int | 4 | null |
|
|
Value primary key - Unique identifier for the specific tracking field value record |
||
| fkTrackingFieldID | int | 4 | √ | null |
|
|
Tracking field foreign key - Links to the tracking field definition this value belongs to |
|
| fkTrackingFieldCategoryID | int | 4 | √ | null |
|
|
Category foreign key - Links to the category classification for this tracking field value |
|
| fkPrimaryID | int | 4 | √ | null |
|
|
Primary record foreign key - Links to the primary record (patient, case, etc.) this tracking value applies to |
|
| fkAssignmentID | int | 4 | √ | null |
|
|
Assignment foreign key - Links to specific assignment or authorization this tracking value relates to |
|
| Status | int | 4 | √ | null |
|
|
Tracking status - Current status of the tracking field (Pending, Complete, Overdue, Not Applicable, etc.) |
|
| TrackingValue | nvarchar | 510 | √ | null |
|
|
Tracking value - The actual value or data entered for this tracking field instance |
|
| FromDate | smalldatetime | 16 | √ | null |
|
|
Effective from date - Date when this tracking field value becomes effective or relevant |
|
| DueExpireDate | datetime | 16,3 | √ | null |
|
|
Due/expiration date - Date when this tracking field value is due or expires |
|
| TargetDate | smalldatetime | 16 | √ | null |
|
|
Target completion date - Planned or target date for completing this tracking requirement |
|
| ActualDate | smalldatetime | 16 | √ | null |
|
|
Actual completion date - Date when the tracking requirement was actually completed |
|
| SubmittedDate | smalldatetime | 16 | √ | null |
|
|
Submission date - Date when the tracking field value was submitted or finalized |
|
| Notes | varchar | 2000 | √ | null |
|
|
Tracking notes - Additional notes or comments related to this tracking field value |
|
| TrackingFieldValueIMPORTID | nvarchar | 510 | √ | null |
|
|
Import identifier - External system identifier used during data import processes |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - User ID of the person who created this tracking field value |
|
| CreatedDate | smalldatetime | 16 | √ | null |
|
|
Creation date - Timestamp when this tracking field value was created |
|
| ModifiedBy | int | 4 | √ | null |
|
|
Modified by user - User ID of the person who last modified this tracking field value |
|
| ModifiedDate | smalldatetime | 16 | √ | null |
|
|
Modification date - Timestamp when this tracking field value was last modified |
|
| Link | varchar | 500 | √ | null |
|
|
Reference link - URL or reference link related to this tracking field value |
|
| TrackingFieldCategoryTitle | varchar | 255 | √ | null |
|
|
Category title - Display name of the tracking field category for grouping and organization |
|
| CreatedFname | varchar | 50 | √ | null |
|
|
Creator first name - First name of the user who created this tracking field value |
|
| CreatedLname | varchar | 50 | √ | null |
|
|
Creator last name - Last name of the user who created this tracking field value |
|
| TrackFldStatusName | varchar | 6 | √ | null |
|
|
Status name - Human-readable name of the current tracking field status |
Relationships
Close relationships within degrees of separation
