ProgramType


Description

Program and service type definitions that classify the different types of healthcare programs and services offered by agencies. This is the CENTRAL AUTHORITY table for program type definitions referenced across all client databases. Client databases like Sandbox reference this table through views such as agencySites_vw, CaseListing_VW, and PatientAdmin_vw to ensure consistent program classifications and billing rules across the entire multi-tenant healthcare system. Each program type defines specific billing rules, service codes, and regulatory requirements.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
BillingRules Unknown 0 null

Billing rules - Specific billing and reimbursement rules for this program type, applied consistently across all client databases
ComplianceRequirements Unknown 0 null

Compliance requirements - Regulatory and documentation requirements enforced across all integrated systems
IsActive Unknown 0 null

Active status - Whether this program type is currently available for use across all client databases
ProgramCategory Unknown 0 null

Program category - Higher-level classification (EI, CPSE, Private Pay, etc.) used for consistent program grouping across the multi-tenant system
ProgramDescription Unknown 0 null

Program description - Detailed explanation of the program’s purpose and scope, displayed in cross-database views for comprehensive program documentation
ProgramID int identity 4 √ null
AgencyProgramType.ProgramID FK_AgencyProgramType_ProgramType R
BillingMethodInProgType.fkProgramID FK__BillingMethodInProgType__ProgramType R
ClaimTypeInProgType.fkProgramID FK__ClaimTypeInProgType__ProgType C
DisTypeIDInProgType.ProgramID FK__DisTypeID__Progr__766C7FFC C
FormInProgType.fkProgramID FK__FormInPro__fkPro__1C7D1A4B C
IDTypesInProgramType.programID FK_IDTypesInProgramType_ProgramType C
PlaceServiceInProgType.ProgramID FK__PlaceServiceInProgType__ProgType C

Reference identifier - Foreign key reference to related entity or lookup table
ProgramName varchar 255 √ null

Program name - Descriptive name of the healthcare program or service type
ProgramFullName varchar 255 √ null

Name field - Descriptive name or identifier for ProgramType records
Municipalty varchar 50 √ null

Text field - Municipalty text information for ProgramType records
CountyCode varchar 2 √ null

Numeric value - Quantity, count, or numeric measurement for ProgramType records
RequiresAuthorization Unknown 0 null

Authorization required - Whether services under this program require prior authorization

Indexes

Constraint Name Type Sort Column(s)
PK__ProgramType__1DB06A4F Primary key Asc ProgramID

Relationships

Close relationships within degrees of separation