Regions


Description

Geographic region definitions managing regional classifications and geographic areas for service delivery and administrative organization. This lookup table defines regions with names and import identifiers, supporting geographic organization, regional reporting, service area management, and administrative structure for healthcare service delivery across different geographic areas.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkRegionID int identity 4 √ null
UserInRegion.fkRegionID FK__UserInReg__fkReg__2CBF3A63 C

Primary key - Unique identifier for each geographic region
RegionName nvarchar 510 √ null

Region name - Descriptive name of the geographic region or service area
IMPORTID int 4 √ null

Import identifier - External system identifier used during data import and migration processes

Indexes

Constraint Name Type Sort Column(s)
PK_Regions Primary key Asc pkRegionID

Relationships

Close relationships within degrees of separation