Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| fkActivityID | int | 4 | null |
|
|
Activity reference - Links to Activity table for the scheduled appointment |
|||||
| CaseID | int | 4 | √ | null |
|
|
Case reference - Links to CaseCategory table for the case type |
||||
| CaseSite | int | 4 | √ | null |
|
|
Case site - Reference to the site where the visit occurs |
||||
| AuthID | int | 4 | √ | null |
|
|
Authorization reference - Links to Authorize table for service authorization |
||||
| ServiceTypeID | int | 4 | √ | null |
|
|
Service type - Links to iCS2.dbo.ServiceType for centralized service type definitions and standardized service codes across the multi-tenant healthcare system |
||||
| ModifierID | int | 4 | √ | null |
|
|
Modifier reference - Links to iCS2.dbo.Modifier for centralized billing modifier definitions and standardized modifier codes used across all healthcare billing processes |
||||
| PatientID | int | 4 | √ | null |
|
|
Patient reference - Links to Patient table for the client receiving services |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Activity_Visit | Primary key | Asc | fkActivityID |
Relationships
Close relationships within degrees of separation
