DateFields


Description

Date field definitions defining date fields available for reporting and filtering across the system. This metadata table manages date field definitions with their internal names, display names, types, and source tables to support dynamic date filtering, reporting, and date-based analytics for healthcare data analysis.

Columns

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

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

Internal field name - Internal system name for the date field
DateFieldName varchar 100 √ null

Display field name - User-friendly display name for the date field
DateFieldType varchar 50 √ null

Field type - Type or category of the date field
FromTable varchar 50 √ null

Source table - Database table containing this date field

Relationships

Close relationships within degrees of separation