Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectId of HPersonLanguage Rows generated by Architecture |
InstanceHFCID | smallint | NOT NULL | Instance HFC(Healthcare Foundation Class) ID generated by Architecture. |
RecordId | int | NULL | Patient Record ID |
Description | varchar(12) | NULL | Not Used |
IsVersioned | bit | NOT NULL | Indicates if the row has been modified. Allowable Values: 0 - False, 1 - True(Modified) |
CreatedUserId | int | NULL | UserId of the user who created the HPersonLanguage row |
CreationTime | smalldatetime | NULL | Date and Time of the row creation |
ModeofCommunication | varchar(64) | NULL | Mode(e.g., written, verbal) in which the person communicates. Can be any free text value or null. |
Proficiency | tinyint | NULL | Person's proficiency level in the language |
| | | Allowable Values: 0 - FirstLanguage, 1 - Preferred, 2 - Fluent, 3 - Fair, 4 - Poor, 5 - None, 6 - CanSpeak, 7 - CanRead, 8 - CanWrite, Null - Not valued. |
LanguageName | varchar(64) | NULL | Language in which the person communicates. |
Person_oid | int | NULL | Person ObjectID, must exist in HPerson table. It can be patient or next of kin(NOK) related to the patient. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|