DateFieldsLogic


Description

Date field calculation logic defining calculated date fields based on existing date fields with interval logic. This table manages date field calculations including interval types, lengths, and source fields to support dynamic date calculations, reporting periods, and date-based business logic for healthcare analytics.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkDateFieldsLogic int 4 null

Primary key - Unique identifier for each date field logic definition
NewDateName varchar 50 √ null

Calculated date name - Name of the new calculated date field
IntervalType varchar 10 √ null

Interval type - Type of interval (days, months, years, etc.)
IntervalLength int 4 √ null

Interval length - Length of the interval for calculation
fkDateField int 4 √ null

Source date field - Links to DateFields table for the base date field

Relationships

Close relationships within degrees of separation