AgencySite


Description

Agency service locations representing the physical sites where healthcare services are delivered. This table manages multiple service locations for each agency, enabling site-based operations, reporting, and user assignments for decentralized healthcare delivery.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
SiteID int identity 4 √ null
PaysourceInSite.fkSiteID FK_PaysourceInSite_AgencySite R
SiteInProgramType.siteid FK__SiteInPro__sitei__11EA7D3F C

Primary key - Unique identifier for each agency service site
AgencySiteID nvarchar 100 √ null

Site identifier - External or agency-specific identifier for the site
SiteName varchar 50 null

Site name - Descriptive name of the service location
AgencyID int 4 √ null

Agency reference - Links to iCS2.dbo.Agency for centralized parent organization management and multi-tenant data segregation
Address varchar 50 √ null

Site address - Street address of the service location
State varchar 20 √ null

State - State where the service site is located
City varchar 20 √ null

City - City where the service site is located
Zip varchar 10 √ null

ZIP code - Postal code for the service site location
Telephone varchar 15 √ null

Phone number - Primary telephone number for the service site
Extension int 4 √ null

Phone extension - Telephone extension number for the service site
Fax varchar 15 √ null

Fax number - Fax number for the service site
IPAddr varchar 30 √ null

IP address - Network IP address for site-specific system access and security
uncheckPayroll bit 1 √ null

Payroll exclusion flag - Boolean indicating if this site should be excluded from payroll processing

Indexes

Constraint Name Type Sort Column(s)
PK_ClientSite Primary key Asc SiteID

Relationships

Close relationships within degrees of separation