Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| siteID | int | 4 | null |
|
|
Site reference - Unique identifier for the agency service site from local AgencySite table |
||
| siteName | varchar | 50 | null |
|
|
Site name - Descriptive name of the service location from local AgencySite table |
||
| SPID | int | 4 | null |
|
|
Site-program ID - Unique identifier for the site-program relationship from local SiteInProgramType table |
||
| programID | int | 4 | √ | null |
|
|
Program reference - Links to the program type offered at this site, referencing iCS2.dbo.ProgramType for centralized program definitions |
|
| ProgramName | varchar | 255 | √ | null |
|
|
Program name - Descriptive name of the healthcare program offered at this site from iCS2.dbo.ProgramType centralized program catalog |
Relationships
Close relationships within degrees of separation
