OutcomesCustom


Description

Custom outcomes extensions providing additional custom fields and extended data for IFSP outcomes management. This extension table stores organization-specific outcome data, custom tracking fields, and additional attributes to support specialized outcome management, progress tracking, and reporting requirements beyond standard outcome data for early intervention services.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkID int identity 4 √ null

Primary key - Unique identifier for each custom outcomes record
fkOutcomeID int 4 null

Outcome reference - Links to Outcomes table for the associated IFSP outcome
DateCreated datetime 16,3 √ null

Creation timestamp - Date and time when the custom outcome data was created
CreatedBy int 4 √ null

Creator reference - Links to AccessUser table for the user who created this custom outcome data
DateUpdated datetime 16,3 √ null

Update timestamp - Date and time when the custom outcome data was last modified
UpdatedBy int 4 √ null

Updater reference - Links to AccessUser table for the user who last updated this custom outcome data
DeletedDate datetime 16,3 √ null

Deletion timestamp - Date and time when the custom outcome data was soft deleted

Indexes

Constraint Name Type Sort Column(s)
OutcomesCustom_pkID Primary key Asc pkID

Relationships

Close relationships within degrees of separation