cf_FileSource


Description

Custom form file sources managing file sources and templates for form generation and document management. This table links payment sources and program types to specific file paths and form templates, enabling automated form generation and document processing workflows for different payers and programs.

Columns

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

Primary key - Unique identifier for each file source
PaymentSource nvarchar 100 √ null

Payment source - Name of the payment source or payer
ProgramType int 4 √ null

Program type reference - Links to program type for this file source
FilePath nvarchar 2000 √ null

File path - Path to the file or template location
Label nvarchar 2000 √ null

Source label - Descriptive label for the file source
fkFormTemplateID int 4 √ null

Form template reference - Links to cf_FormTemplate for associated template

Indexes

Constraint Name Type Sort Column(s)
PK_cf_FileSource Primary key Asc FileSourceID

Relationships

Close relationships within degrees of separation