Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkLocationID | int identity | 4 | √ | null |
|
|
Location primary key - Unique identifier for each service location |
|
| LocationCode | varchar | 10 | null |
|
|
Location code - Short code or abbreviation for the location |
||
| Location | varchar | 50 | null |
|
|
Location name - Descriptive name of the service location |
||
| DateCreated | smalldatetime | 16 | √ | (getdate()) |
|
|
Creation date - Date when this location was added to the system |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this location record |
|
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Last update date - Date when this location was last modified |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated this location |
|
| Deleted | bit | 1 | √ | ((0)) |
|
|
Deletion flag - Soft delete flag for audit trail purposes |
|
| Code837 | varchar | 2 | √ | null |
|
|
EDI 837 code - Standard place of service code for electronic billing |
|
| Address | varchar | 500 | √ | null |
|
|
Location address - Street address of the service location |
|
| City | varchar | 200 | √ | null |
|
|
Location city - City where the service location is situated |
|
| ZipCode | varchar | 50 | √ | null |
|
|
Location ZIP code - Postal code for the service location |
|
| UseDefaultAddress | bit | 1 | √ | null |
|
|
Use default address flag - Indicates if this location uses the agency’s default address |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Locations | Primary key | Asc | pkLocationID |
Relationships
Close relationships within degrees of separation
