Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| POSID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
||||
| POS | nvarchar | 4 | √ | null |
|
|
Text field - POS text information for PlaceService records |
||||
| Description | nvarchar | 100 | √ | null |
|
|
Description field - Detailed description or explanation of PlaceService information |
||||
| Code837 | varchar | 2 | √ | null |
|
|
Code identifier - Standardized code or identifier for PlaceService classification |
||||
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this place of service is currently valid |
|||||
| PlaceCode | Unknown | 0 | null |
|
|
Place code - Standard place of service code |
|||||
| PlaceDescription | Unknown | 0 | null |
|
|
Place description - Description of the service location |
|||||
| PlaceServiceId | Unknown | 0 | null |
|
|
Primary key - PlaceService unique identifier for each place of service |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_PlaceService | Primary key | Asc | POSID |