Description: The Confidential Type Table establishes and maintains the various qualifiers to identify a patient?s confidentiality during registration
| Column Name |
Ordinal Position |
|
| Column Name |
Ordinal Position |
Referenced Table |
|
|
Name |
Type |
|
| 1 |
LKREGCONFIDENTIALTYPEID |
INT |
|
|
Description: Primary Key
|
|
Name |
Type |
|
| 2 |
CODE |
NCHAR |
|
|
Description: The code to Identify this confIdential type
|
|
Name |
Type |
|
| 3 |
DESCLONG |
NVARCHAR |
|
|
Description: The full description to further Identify this confidential type
|
|
Name |
Type |
|
| 4 |
DESCSHORT |
NVARCHAR |
|
|
Description: The abbreviated description of the confidential type
|
|
Name |
Type |
|
| 5 |
EFFECTIVEDATE |
DATETIME2 |
|
|
Description: The calendar date indicating when this confidential type becomes effective for use in the system
|
|
Name |
Type |
|
| 6 |
DISCONTINUEDATE |
DATETIME2 |
|
|
Description: The calendar date indicating when this confidential type is no longer available for use in the system
|