Description: Codes used to indicate from where the patient came prior to admission
| Column Name |
Ordinal Position |
|
| Column Name |
Ordinal Position |
Referenced Table |
|
|
Name |
Type |
|
| 1 |
LKREGADMITSOURCEID |
INT |
|
|
Description: Primary key for Admit Source table
|
|
Name |
Type |
|
| 2 |
CODE |
NCHAR |
|
|
Description: The value to identify the source of admission
|
|
Name |
Type |
|
| 3 |
DESCLONG |
NVARCHAR |
|
|
Description: The full description used to identify the admit source code
|
|
Name |
Type |
|
| 4 |
DESCSHORT |
NVARCHAR |
|
|
Description: The abbreviated description used to identify the admit source
|
|
Name |
Type |
|
| 5 |
NEWBORNRELATED |
BIT |
|
|
Description: Flag if record is new born related
|
|
Name |
Type |
|
| 6 |
EFFECTIVEDATE |
DATETIME2 |
|
|
Description: The calendar date indicating when this admit source becomes effective for use in the system
|
|
Name |
Type |
|
| 7 |
DISCONTINUEDATE |
DATETIME2 |
|
|
Description: The calendar date indicating when this admit source is no longer available for use in the system
|
|
Name |
Type |
|
| 9 |
CREATED |
DATETIME2 |
|
|
Description: Record created time
|
|
Name |
Type |
|
| 11 |
LASTMODIFIED |
DATETIME2 |
|
|
Description: Record Last Modified time
|