Description: Languages used to communicate to a patient group practitioner etc. HL7 Value Set.
| Column Name |
Ordinal Position |
|
| Column Name |
Ordinal Position |
Referenced Table |
|
|
Name |
Type |
|
| 1 |
LKLANGUAGEID |
INT |
|
|
Description: Primary Key
|
|
Name |
Type |
|
| 2 |
SYSTEM |
NVARCHAR |
|
|
Description: The URI or OID of the defining terminology system
|
|
Name |
Type |
|
| 3 |
CODE |
NVARCHAR |
|
|
Description: The code used to Identify the language
|
|
Name |
Type |
|
| 4 |
DESCRIPTION |
NVARCHAR |
|
|
Description: The full description used to Identify the language code
|
|
Name |
Type |
|
| 5 |
FOREIGNSYSTEMCODE |
NVARCHAR |
|
|
Description: to be deprecated
|
|
Name |
Type |
|
| 6 |
STARTDATE |
DATETIME2 |
|
|
Description: The calendar date indicating when this language becomes effective for use in the system
|
|
Name |
Type |
|
| 7 |
ENDDATE |
DATETIME2 |
|
|
Description: The calendar date indicating when this language is no longer available for use in the system
|