Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ConfigID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each calculation configuration, auto-incrementing integer |
|
| fkReportID | int | 4 | null |
|
|
Report reference - Foreign key linking to report that uses this calculation configuration (required field) |
||
| ColumnName | varchar | 50 | null |
|
|
Target column - Name of the data column that this calculation operates on (required field) |
||
| SummaryType | int | 4 | null |
|
|
Calculation type - Type of calculation to perform (e.g., Sum, Average, Count, Min, Max) as numeric code (required field) |
||
| CreatedDate | datetime | 16,3 | √ | null |
|
|
Creation timestamp - When the calculation configuration was first created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator user ID - Reference to user who created the configuration for accountability |
|
| UpdatedDate | datetime | 16,3 | √ | null |
|
|
Last modification timestamp - Most recent update to calculation settings |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Last modifier user ID - Reference to user who made the most recent update |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Soft delete timestamp - When configuration was logically deleted while preserving history |
|
| GroupByUser | bit | 1 | ((0)) |
|
|
User grouping flag - Boolean indicating if calculation should be grouped by user for personalized results |
||
| PinToApp | bit | 1 | ((0)) |
|
|
App pinning flag - Boolean indicating if calculation result should be pinned to application dashboard |
||
| TextLocation | varchar | 10 | √ | null |
|
|
Text positioning - Location specification for displaying calculation result text in reports |
|
| TextValue | varchar | 50 | √ | null |
|
|
Display text - Custom text to display alongside calculation result for context |
|
| DecimalMark | varchar | 10 | √ | null |
|
|
Number formatting - Decimal separator and formatting specification for numeric display |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_SummaryConfig | Primary key | Asc | ConfigID |
| IX_CalculationConfig | Performance | Asc/Asc | fkReportID + ColumnName |
| IX_Created | Performance | Asc | CreatedDate |
| IX_UndeletedPinCalculationConfig | Performance | Asc/Asc/Asc | DeletedDate + PinToApp + GroupByUser |