Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectId of HNextofKinDetails |
InstanceHFCID | smallint | NOT NULL | Instance HFC(Healthcare Foundation Class) |
RecordId | int | NULL | RecordId of the Patient |
Description | varchar(184) | NULL | Client entered value. Can be the name of the person(Format : First name, Last Name). |
IsVersioned | bit | NOT NULL | Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified |
CreatedUserId | int | NULL | UserId of the user who created the HNextofKinDetails row |
CreationTime | smalldatetime | NULL | Date and time when the object was created. |
Relationship | varchar(50) | NULL | The particulars of the relationship that the patient and the related or the associated party share. Free text entered by the user. For example: Spouse, wife, etc. |
ContactRole | varchar(50) | NULL | The role that the related or the associated party plays with the patient. The possible roles can be emergency contact or other. This is entered by the user on the master ADT system. For example : EMCON for emergency contact. |
StartDate | datetime | NULL | The first date and time when the related or the associated party of the patient can be contacted. |
EndDate | datetime | NULL | The last date and time when the related or the associated party of the patient can be contacted. |
ContactPerson | varchar(75) | NULL | The names of the people that the related or the associated party(a healthcare organization) should contact in the event of a patient emergency. |
ConsentBeforeContacting | bit | NULL | Indicates if consent is required before contacting the related or the associated party of the patient. Allowable Values: 0 - False, 1 - True, or Null |
ExternalID | varchar(20) | NULL | External ID of the related or the associated party of the patient. |
PrimaryContact | bit | NULL | Indicates that the related or the associated party of the patient is the primary contact during an emergency. Allowable Values: 0 - False 1 - True |
Patient_oid | int | NULL | ObjectID of the patient the next of kin is related to. It must be the same as Objectid in HPatient table. |
LastCngDtime | datetime | NULL | Last system UTC date /time when row was updated. |
|