Reports

Reference identifier - Foreign key reference to related entity or lookup table

Report category reference - Reference to the category classification for organizing and grouping related reports

Report name - Descriptive name of the report

Report description - Detailed description of the report’s purpose, content, and business value

Template reference - Reference to the report template or base structure used for this report

Report type code - Numeric code indicating the technical type of report (SQL query, Crystal Report, dashboard, etc.)

Creator reference - Reference to the user who originally created this report definition

Creation date - Date and time when this report was first created

Criteria string - Serialized filter criteria and parameters used to customize report output

Sharing level - Access level determining who can view and run this report (private, shared, public)

Last update date - Date and time when this report definition was last modified

Last updater reference - Reference to the user who last modified this report

HTML template - HTML template string used for formatting report output in web browsers

SQL query - The actual SQL query that retrieves data for this report

Report form - Form or interface used for collecting report parameters and filters

Stored procedure name - Name of the stored procedure that generates this report’s data

Category reference - Reference to the business category for organizing reports by functional area

Category type - Type of category classification (financial, clinical, administrative, etc.)

Parent report reference - Reference to a parent or master report if this is a sub-report

Page name - Name of the web page or interface where this report is displayed

Report documentation - Comprehensive documentation including usage instructions, data sources, and business rules

Form reference - Reference to the form used for collecting report parameters

Publisher reference - Reference to the user who published or approved this report for general use

Publication target - Reference to the target audience or group for report publication

Filter grid configuration - Configuration settings for filter grids and parameter selection interfaces

Layer grid configuration - Configuration for layered or hierarchical report displays

Formatted layout - Binary data containing the formatted layout template for report presentation

Layer market reference - Reference to market-specific layer configurations for multi-market reports

Detail key field - Field name used as the key for drill-down or detail report linking

Detail report reference - Reference to a detailed report that can be accessed from this summary report

Active status - Whether this report is currently available

Report category - Classification for organizing reports

Report description - Purpose and content of the report

Report type - Technical type (SQL, Crystal, etc.)

Permission requirements - User permissions needed to run this report

Scheduling options - Whether report can be scheduled for automatic generation

Load page type - Type of page or interface used for loading and displaying this report

Unique code - Unique identifier or code for referencing this report in external systems

Tab configurations - Configuration settings for tabbed report interfaces and multi-section reports

Deletion date - Date when this report was marked for deletion or archived

Billing type reference - Reference to the billing type for reports related to financial processing