Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ReportID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each report, auto-incrementing integer |
|
| ReportCatName | int | 4 | √ | null |
|
|
Report category - Numeric reference to report category for organization |
|
| ReportName | nvarchar | 1073741823 | √ | null |
|
|
Report name - Display name of the report for user identification |
|
| ReportDesc | nvarchar | 1073741823 | √ | null |
|
|
Report description - Detailed description of report purpose and content |
|
| BillingTypeID | int | 4 | null |
|
|
Billing type reference - Reference to billing type this report applies to (required field) |
||
| Temp_ID | int | 4 | √ | null |
|
|
Template reference - Reference to report template used for this report |
|
| Type | int | 4 | √ | null |
|
|
Report type - Numeric classification of report type (e.g., Operational, Financial, Compliance) |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator user ID - Reference to user who created this report |
|
| DateCreated | smalldatetime | 16 | √ | (getdate()) |
|
|
Creation timestamp - When this report was first created (defaults to current date) |
|
| criteriaStr | varchar | 2147483647 | √ | null |
|
|
Report criteria - Serialized criteria and filter configuration for report generation |
|
| int | 4 | √ | null |
|
|
Sharing level - Numeric code indicating report sharing permissions and visibility |
||
| DateUpdated | smalldatetime | 16 | √ | (getdate()) |
|
|
Last modification timestamp - When this report was most recently updated (defaults to current date) |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Last modifier - User ID who made the most recent update |
|
| htmlStr | text | 2147483647 | √ | null |
|
|
HTML template - HTML template for report formatting and layout |
|
| sqlQuery | text | 2147483647 | √ | null |
|
|
SQL query - SQL query used to generate report data |
|
| reportForm | varchar | 1000 | √ | null |
|
|
Report form - Form configuration for report parameters and input |
|
| reportProcName | varchar | 300 | √ | null |
|
|
Stored procedure - Name of stored procedure used for report data generation |
|
| category | int | 4 | √ | null |
|
|
Category reference - Numeric reference to report category |
|
| catType | int | 4 | √ | null |
|
|
Category type - Numeric classification of category type |
|
| fkreportid | int | 4 | √ | null |
|
|
Parent report reference - Reference to parent report for hierarchical report structures |
|
| pageName | varchar | 100 | √ | null |
|
|
Page name - Name of page or section where report is displayed |
|
| Documentation | ntext | 1073741823 | √ | null |
|
|
Report documentation - Comprehensive documentation about report usage and interpretation |
|
| GetFormId | int | 4 | √ | (NULL) |
|
|
Associated form - Reference to form associated with this report (defaults to NULL) |
|
| PublishToId | int | 4 | √ | (NULL) |
|
|
Publication target - Reference to entity this report is published to (defaults to NULL) |
|
| FilterGridReport | nvarchar | 1073741823 | √ | null |
|
|
Grid filter configuration - Configuration for grid-based report filtering |
|
| LayerGridReport | nvarchar | 1073741823 | √ | null |
|
|
Layer grid configuration - Configuration for layered grid report display |
|
| FormattedReportLayout | varbinary | 2147483647 | √ | null |
|
|
Binary layout data - Binary data containing formatted report layout information |
|
| TypeLoadPage | nvarchar | 1000 | √ | null |
|
|
Page load type - Configuration for how report page should be loaded |
|
| UniqueCode | nvarchar | 100 | √ | null |
|
|
Unique identifier code - Unique code for report identification and referencing |
|
| DetailsKeyField | nvarchar | 600 | √ | null |
|
|
Detail key field - Field used as key for report detail views |
|
| DetailsReportId | int | 4 | √ | null |
|
|
Detail report reference - Reference to detailed report for drill-down functionality |
|
| TabsConfigurations | nvarchar | 1073741823 | √ | null |
|
|
Tab configuration - Configuration for tabbed report interfaces |
|
| DeleteDate | datetime | 16,3 | √ | null |
|
|
Deletion timestamp - When this report was logically deleted |
|
| CustomQuery | nvarchar | 1073741823 | √ | null |
|
|
Custom query - Custom query configuration for advanced report generation |
|
| CustomQueryXML | varchar | 2147483647 | √ | null |
|
|
Custom query XML - XML configuration for custom query parameters |
|
| DataSourceID | int | 4 | √ | null |
|
|
Data source reference - Reference to data source used by this report |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Reports | Primary key | Asc | ReportID |