Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectId of HReferringInstitution Rows generated by Architecture |
InstanceHFCID | smallint | NOT NULL | Instance HFC(Healthcare Foundation Class) ID generated by Architecture |
RecordId | int | NULL | Record Id of the Patient |
Description | varchar(25) | NULL | Can be vaued by client to the name of the institution that referred the patient to the healthcare unit. |
IsVersioned | bit | NOT NULL | Indicates if the row has been modified. Allowable values: 0 - false, 1 - Modified |
CreatedUserId | int | NULL | UserId of the user who created the HReferringInstitution row |
CreationTime | smalldatetime | NULL | Date and time when the object is created. |
Name | varchar(75) | NULL | Name of the institution that referred the patient to the healthcare unit. |
Address | varchar(35) | NULL | Address of the institution that referred the patient to the healthcare unit. |
PhoneNumber | varchar(30) | NULL | Phone number of the institution that referred the patient to the healthcare unit. |
Remarks | varchar(255) | NULL | Comments related to the institution that referred the patient to the healthcare unit. |
StartDateOfValidity | datetime | NULL | First date and time the patient is referred to the healthcare unit. |
EndDateOfValidity | datetime | NULL | Last date and time the patient is referred to the healthcare unit. |
LastCngDtime | datetime | NULL | Last system UTC date /time when row was updated. |
|