Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectId of HVisitActivity 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(1) | NULL | Most of the time it is not valued(NULL) , but can be vaued to ActivityType( 1 - Admission, 2 - Discharge, 3 - Transfer, 4 - Outpatient) |
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 performed the activity |
CreationTime | smalldatetime | NULL | Date and time when row was created. |
Visit_oid | int | NOT NULL | ObjectID of the HPatientVisit table to which the activity belongs. |
ExternalID | varchar(75) | NULL | Alternate Visit Id of the HPatientVisit to which the activity belongs. |
StartDateTime | datetime | NULL | Date and time when the activity for the visit started. |
EndDateTime | datetime | NULL | Date and time when the activity for the visit ended. |
UserOID | int | NULL | ObjectId of the user who performed the activity for the visit. |
ActivityType | tinyint | NULL | ActivityType: 1 - Admission, 2 - Discharge, 3 - Transfer, 4 - Outpatient |
ActivitySort | varchar(64) | NULL | ActivitySort. Can be anything or DDI item type "Patient.Visit.ActivitySort" |
IsVisitCreated | bit | NOT NULL | Indicates if the activity created as a part of visit creation or something else like MRU Transfer |
PatientCategory | varchar(64), | | Patient Category . Example : Initial, Emergency, etc |
IsDeleted | tinyint | NOT NULL | Indicates that row was deleted. Allowable Values: 0 - Active row, 1- Row is deleted. |
UnitContacted_oid | int | NULL | Unit contacted at the time the visit activity was created. Must exist as Objectid in HHealthcareunit table. |
PatientClass_oid | int | NULL | Patient Class for the visit at the time the visit activity was created. Must exist in HPatientClass table. |
VisitTypeCode | varchar(30) | NULL | Contains visity type code from hpatientvisit at the time the visit activity was created |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|