Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectId of HProcedure Rows generated by Architecture |
InstanceHFCID | smallint | NOT NULL | Instance HFC(Healthcare Foundation Class) ID generated by Architecture |
RecordId | int | NULL | Not Used. |
Description | varchar(255) | NULL | Not Used |
IsDeleted | tinyint | NOT NULL | Indicates if the row has been deleted. Allowable Values: 0 - False, 1 - True(deleted) |
IsVersioned | bit | NOT NULL | Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified |
CreatedUserId | int | NULL | Object ID of the user who created the object. This field is linked to HSUser table to get details about the user. For more information on HSUser table. |
CreationTime | smalldatetime | NULL | Date and time when the object is created. |
PatientVisit_oid | int | NULL | Patient Visit_oid. one-to-one relationship between HProcedure and HPatientVisit. |
CPTCode | varchar(30) | NULL | CPT code of the procedure. |
CodeDescription | varchar(255) | NULL | Description of the procedure associated with the CPT code |
Priority | int | NULL | Priority of the diagnosis. When set to high, it indicates that the diagnosis of the patient ailment must be immediately completed. |
| | | Value of this field can be any number(from 0 to 9 for example) and client can set up ADT preference "Maximumlimitofpriority" to the maximum available number. |
| | | It is up to the client to assign that number. |
Release | varchar(5) | NULL | Release number of the CPT code |
Version | varchar(64) | NULL | Version number of the CPT code |
StartDate | datetime | NULL | Start date and time of a procedure to be performed on a patient |
EndDate | datetime | NULL | Date and time when a procedure performed on a patient would end. |
Comments | varchar(255) | NULL | Comments(remarks) on a procedure as entered by the user. |
Localization | tinyint | NULL | Localization for the procedure. For example, if a patient's elbow requires surgery, LeftLocalization could mean that the surgical procedure needs to be performed on the patient's left elbow. Allowable Values: 0, 1, 2, 3, or NULL Key of allowable values: 0 - NoLocalization 1 - LeftLocalization 2 - RightLocalization 3 - BothLocalization |
IsPreliminary | bit | NULL | When set to True, indicates that the procedure is in preliminary stage. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - False 1 - True |
IsExtension | bit | NULL | When set to True, indicates that the procedure performed on the patient would take longer time than anticipated. Allowable Values: 0, 1, or NULL Key of allowable values: 0 - False 1 - True |
IsNurse | bit | NULL | When set to True, indicates that the procedure to be performed on a patient is assigned by a nurse. Allowable Values: 0, 1, or NULL Key of allowable values: 0 - False 1 - True |
IsSurgical | bit | NULL | When set to True, indicates that the procedure to be performed on a patient requires surgery. Allowable Values: 0, 1, or NULL Key of allowable values: 0 - False 1 - True |
AssignedBy | varchar(190) | NULL | The name of the physician who has assigned the procedure. |
ProcedureTime | datetime | NULL | The date and time when the procedure is assigned. |
ProcedureStatus | tinyint | NULL | The status of the procedure. Allowable Values: 3, 4, or 5. Key of allowable values: 3 - Completed, 4 - Aborted, 5 - Erroneous |
ExternalID | varchar(10) | NULL | The external ID of the procedure that belongs to a third-party application. |
ParentProcedureOID | int | NULL | The object ID of the parent procedure for linked procedure. |
AssociatedUnitOID | int | NULL | The object ID of the unit associated with the patient on whom a procedure is/will be performed. Must exist in HHealthCareUnit Table. |
ExternalObjectID | int | NULL | The object ID provided by a Soarian module. |
ExternalObjectType | varchar(64) | NULL | Type of the external object. This is a data dictionary item that is set up by client. |
CDM | varchar(64) | NULL | CDM code - the technical service code associated with the CPT code. |
PDM | varchar(30) | NULL | PDM code - the professional service code associated with the CPT code |
AssociationLevel | TinyInt | NULL | Not In Use |
VisitMoveNumber | varchar(75) | NULL | Move number of visit. A move occurs in a SAP external system, frequently when a patient changes MRU. For non-SAP users, this column should always be NULL. |
LastCngDtime | DATETIME | NULL | Last system UTC date /time when row was updated. |
CodeType | varchar(16) | NULL | Type of the code value. Allowable values: 'SNOMED' or NULL |
Source | varchar(16) | NULL | Procedure Source - whether this procedure was entered in Soarian Clinicals or it was interfaced from the financial system. Allowable values : 'Clinicals' or client defined external system(for example - 'External') |
IncisionDTimeMins | smalldatetime | NULL | Incision date time(if the procedure was surgical) |
AnesthesiaType | varchar(64) | NULL | Type of the anesthesia. The allowable value list is based on a data dictionary item with item type code "Ord.AnesthesiaType" |
AnesthesiaStartDTimeMins | smalldatetime | NULL | The start date and time of the anesthesia |
AnesthesiaEndDTimeMins | smalldatetime | NULL | The end date and time of the anesthesia |
PerformedByStaffName | varchar(188) | NULL | Name of the staff who performed the procedure. Format : Last name, First Name, Middle Name. |
PerformedByStaffOID | int | NULL | ObjectID of the staff who performed the procedure. Must exist in HStaff table. |
PatientOID | int | NOT NULL | ObjectID of the patient. Must exist in HPatient Table. |
IsPrimary | tinyint | NULL | Primary procedure indicator. Allowable Values: 0 - False, 1 - True |
ChangeNo | smallint | NULL | This field can be valued to NUll, 0 or next sequential number when procedure was edited. |
|