Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPersonLanguage Contains person's Language information
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HPersonLanguage Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture.
RecordIdintNULL Patient Record ID
Descriptionvarchar(12)NULL Not Used
IsVersionedbitNOT NULL Indicates if the row has been modified. Allowable Values: 0 - False, 1 - True(Modified)
CreatedUserIdintNULL UserId of the user who created the HPersonLanguage row
CreationTimesmalldatetimeNULL Date and Time of the row creation
ModeofCommunicationvarchar(64)NULL Mode(e.g., written, verbal) in which the person communicates. Can be any free text value or null.
ProficiencytinyintNULL 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.
LanguageNamevarchar(64)NULL Language in which the person communicates.
Person_oidintNULL Person ObjectID, must exist in HPerson table. It can be patient or next of kin(NOK) related to the patient.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates