OutputSource


Description

Report output source configuration managing report output templates, processing files, and source configurations for report generation. This table stores output processing configurations including template names, source files, and processing parameters, supporting flexible report generation, template management, and output customization for healthcare reporting systems.

Columns

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

Primary key - Unique identifier for each output source configuration
fkReportID int 4 √ null

Report reference - Links to the report that uses this output source configuration
fkOutputID int 4 √ null

Output reference - Links to the output configuration for this source
outputProcessingFile varchar 100 √ null

Processing file - Name of the file used for output processing
outputSrcFile varchar 100 √ null

Source file - Name of the source file for output generation
outputtemplatename varchar 300 √ null

Template name - Name of the template used for output formatting

Indexes

Constraint Name Type Sort Column(s)
PK_OutputSource Primary key Asc pkOutSrcID

Relationships

Close relationships within degrees of separation