Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AccessLevel | Unknown | 0 | null |
|
|
Access level - Required access level for viewing this layer |
||
| CssClass | Unknown | 0 | null |
|
|
CSS class - CSS class for layer styling and appearance |
||
| DeletedDate | Unknown | 0 | null |
|
|
Deletion timestamp - When this layer was logically deleted |
||
| DisplayOrder | Unknown | 0 | null |
|
|
Display order - Numeric order for layer presentation in user interface |
||
| pkLayerID | int identity | 4 | √ | null |
|
|
Primary key layer ID - Primary key identifier for the layer |
|
| fkReportID | int | 4 | √ | null |
|
|
Report reference - Foreign key to report associated with this layer |
|
| LayerName | varchar | 200 | null |
|
|
Layer name - Descriptive name of the interface layer |
||
| LayerDesc | varchar | 500 | √ | null |
|
|
Layer description - Alternative description field for the layer |
|
| pageName | varchar | 2147483647 | √ | null |
|
|
Page name - Name of the page where this layer appears |
|
| criteriaStr | varchar | 5000 | √ | null |
|
|
Criteria string - String representation of layer display criteria |
|
| sqlQuery | varchar | 1000 | √ | null |
|
|
SQL query - SQL query used to populate dynamic layer content |
|
| htmlStr | ntext | 1073741823 | √ | null |
|
|
HTML string - HTML content for the layer |
|
| Documentation | ntext | 1073741823 | √ | null |
|
|
Layer documentation - Documentation and help text for the layer |
|
| DateCreated | smalldatetime | 16 | √ | (getdate()) |
|
|
Creation timestamp - When this layer was first created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator user ID - Reference to user who created this layer |
|
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Last modification timestamp - When this layer was most recently updated |
|
| Deleted | bit | 1 | √ | null |
|
|
Deletion flag - Boolean indicating if layer has been logically deleted |
|
| IsShowEveryOne | bit | 1 | √ | null |
|
|
Show everyone flag - Boolean indicating if layer is visible to all users |
|
| CollapseOnDefault | bit | 1 | √ | null |
|
|
Collapse default flag - Boolean indicating if layer should be collapsed by default |
|
| IconUrl | Unknown | 0 | null |
|
|
Layer icon - URL to icon image for layer representation |
||
| ID | Unknown | 0 | null |
|
|
Primary key - Unique identifier for each interface layer, auto-incrementing integer |
||
| IsActive | Unknown | 0 | null |
|
|
Active status - Boolean indicating if layer is currently active |
||
| IsVisible | Unknown | 0 | null |
|
|
Visibility flag - Boolean controlling whether layer is visible to users |
||
| itemOrder | int | 4 | √ | null |
|
|
Item order - Order of items within the layer |
|
| JavaScriptCode | Unknown | 0 | null |
|
|
JavaScript code - Client-side code for layer behavior |
||
| LayerDescription | Unknown | 0 | null |
|
|
Layer description - Detailed description of layer purpose and content |
||
| LayerType | nvarchar | 6 | √ | ('SY') |
|
|
Layer type - Classification of layer type (Navigation, Content, Functional, Administrative) |
|
| OriginalLayerID | int | 4 | √ | null |
|
|
Original layer reference - Reference to original layer if this is a copy |
|
| ParentLayerId | Unknown | 0 | null |
|
|
Parent layer reference - Reference to parent layer for hierarchical organization |
||
| TargetAudience | Unknown | 0 | null |
|
|
Target audience - Intended user audience for this layer |
||
| UpdatedBy | int | 4 | √ | null |
|
|
Last modifier - User ID who made the most recent update |
|
| TemplateId | int | 4 | √ | null |
|
|
Template reference - Reference to template used for this layer |
|
| Status | nvarchar | 40 | ('Live') |
|
|
Layer status - Current status of the layer (Active, Inactive, Draft) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Layers | Primary key | Asc | pkLayerID |