Description: Codes used to classify the kind of admission? (emergency, elective, etc)
| Column Name |
Ordinal Position |
|
| Column Name |
Ordinal Position |
Referenced Table |
|
|
Name |
Type |
|
| 1 |
LKREGADMITTYPEID |
INT |
|
|
Description: The unique Id for the LkRegAdmitType table
|
|
Name |
Type |
|
| 2 |
CODE |
NCHAR |
|
|
Description: String symbol used to uniquely identify the concept within the terminology system
|
|
Name |
Type |
|
| 3 |
DESCLONG |
NVARCHAR |
|
|
Description: Description
|
|
Name |
Type |
|
| 4 |
DESCSHORT |
NVARCHAR |
|
|
Description: Short Description
|
|
Name |
Type |
|
| 5 |
EFFECTIVEDATE |
DATETIME2 |
|
|
Description: Effective Date
|
|
Name |
Type |
|
| 6 |
DISCONTINUEDATE |
DATETIME2 |
|
|
Description: Discontinue Date
|
|
Name |
Type |
|
| 8 |
CREATED |
DATETIME2 |
|
|
Description: Record created time
|
|
Name |
Type |
|
| 10 |
LASTMODIFIED |
DATETIME2 |
|
|
Description: Record Last Modified time
|