Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectId of HStaffAssociations Rows generated by Architecture |
InstanceHFCID | smallint | NOT NULL | Instance HFC(Healthcare Foundation Class) ID generated by Architecture |
RecordId | int | NULL | RecordId of the Patient |
Description | varchar(21) | NULL | Not used. |
IsVersioned | bit | NOT NULL | Indicates if the row has been modified |
CreatedUserId | int | NULL | UserId of the user who created the row. |
CreationTime | smalldatetime | NULL | Date and time when the object is created. |
IsExternal | bit | NULL | When set to True, indicates that the staff is an external staff. An external staff does not belong to a healthcare unit, but is associated with the unit. |
| | | Allowable Values: 0 - False, 1 - True or NULL. |
RelationType | tinyint | NULL | Role of the staff associated with the patient or the patient visit. |
| | | Allowable values: 0 - AttendingDoctor 1 - PrimaryPhysician 2 - ReferringDoctor 3 - ConsultingDoctor 4 - AdmittingDoctor |
| | | 5 - OperatingDoctor 6 - DischargingDoctor 7 - ResponsibleDoctor 8 - DeathDeclaredDoctor 9 - OtherCareGiver |
| | | 10 - AdditionalDoctor 11 - DeathApprovedDoctor 12 - CoveringDoctor |
StartDate | smalldatetime | NULL | Date and Time when the association of the staff to the patient or the patient visit begins. |
EndDate | smalldatetime | NULL | Date and Time when the association of the staff to the patient or the patient visits ends. |
StartTime | smalldatetime | NULL | Not Used |
EndTime | smalldatetime | NULL | Not Used |
IsOrderAssociated | bit | NULL | Indicates that association has come from orders or through the Visit screen. Allowable Values: 0 - False, 1 - True or Null |
StaffAssocRefCounter | int | NULL | Incremental counter for every association of a staff with a visit. |
ExternalProfessional_oid | int | NULL | ObjectId for External staff , same as objectid in HExternalHCProfessional table. |
Patient_oid | int | NULL | Object ID of the patient associated with the staff. |
PatientVisit_oid | int | NULL | ObjectID of the patient visit associated with the staff. |
Staff_oid | int | NULL | Associated Staff Object ID. Must be in HStaff table. |
DeathInformation_oid | int | NULL | Object Id for the deceased patient as in HDeathInformation table. |
LastCngDtime | datetime | NULL | Last system UTC date /time when row was updated. |
|