Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | bigint | NOT NULL | Object Identifier of this record. This field is a primary key for the associated table. Note: Not all environments / databases will have the datatype of BIGINT. Some will remain with the INT datatype. |
InstanceHFCID | smallint | NOT NULL | Healthcare Foundation Class(HFC) Identifier of the object.HFCID of this object is 1502. The value specified in the ObjectID field and in this field enables unique identification of an object instance across the application. |
RecordId | int | NULL | Not Valued in this table. Column exists as part of persistence framework implementation. |
Description | varchar(1) | NULL | Not Valued in this table. Column exists as part of persistence framework implementation. |
IsVersioned | bit | NOT NULL | When set to True, the object was modified. Once this field is set to True, you cannot reset it to False. Allowable Values: 0 - False, 1 - True. Note: The presence of this field in tables depends on the configuration at the time of table design. |
CreatedUserId | int | NULL | Object ID of the logged in user who created this record. |
| | | This field is linked to HSUser table to get details about the user. For more information see description of HSUser table |
CreationTime | smalldatetime | NULL | Date and time when the record is created. |
OrderOccurrenceStatus | varchar(64) | NOT NULL | Text value of the current status of the Occurrence |
OrderOccurrenceStatusCode | tinyint | NOT NULL | Code for the current status of the Occurrence |
| | | Allowable Values |
| | | 0 - Active |
| | | 1 - Suspend |
| | | 2 - Cancel |
| | | 3 - Discontinue |
| | | 4 - Complete |
| | | 5 - In Progress |
| | | 6 - Invalid |
| | | 7 - Not Complete |
StartDateTime | smalldatetime | NOT NULL | Original or Planned date time for this occurrence |
ActualDateTime | smalldatetime | NULL | Actual date time the occurrence was performed or actioned. |
StatusEnteredDatetime | smalldatetime | NULL | Date time of the most recent update to the status of this occurrence |
ChartedBy | varchar(30) | NULL | Username of the person who charted this occurrence. Contains the most recent value for the most recent charting |
ChartingComment | varchar(255) | NULL | Free Text comment entered by the user who updated the Occurrence |
IsCharged | bit | NULL | A charge has been created for this Occurrence |
SampleStatus | varchar(40) | NULL | SampleStatus String of the sample(HCollectedSample) associated with this occurrence. De-normalized from the HCollectedSample table |
SampleStatusCode | tinyint | NULL | SampleStatus Code of the sample(HCollectedSample) associated with this occurrence. De-normalized from the HCollectedSample table |
| | | Allowable Values |
| | | 10 - Pending Specimen to be collected |
| | | 11 - Pending Specimen to be printed |
| | | 12 - Specimen Collected |
| | | 13 - Specimen Not Collected |
OccurrenceOrderID | bigint | NOT NULL | This is system generated unique ID(other than objectID) for the occurrence which is communicated to external systems and can be used in printed reports. Note: Not all environments / databases will have the datatype of BIGINT. Some will remain with the INT datatype. |
GroupID | varchar(24) | NULL | ID of the group associated to this occurrence. Used for Lab order under sample grouping workflows |
IsResultSigned | bit | NOT NULL | When a Result is associated to this Occurrence, indicates when the result has been signed. |
| | | Allowable values: |
| | | 0/Null - No |
| | | 1 - Yes |
ServiceDetail_oid | int | NOT NULL | The Object ID of the Service Detail this Occurrence is for(HServiceDetail) |
Order_oid | int | NOT NULL | The object ID of the Order this Occurrence belongs to(HOrder) |
SampleForOrdOcc_oid | int | NULL | Object ID of the Sample(when an Occurrence has a specimen associated with it)(HCollectedSample) |
ReasonForDiscontinue | varchar(120) | NULL | When the Occurrence has been discontinued(by a user, job, workflow, etc), the Reason the Occurrence was discontinued |
WorklistItem_oid | int | NULL | Link between WorklistItem objectid from the New ResultAssement worklist category to the Occurrence. When the assessment is charted from the worklist category , it uses this link to update the status of the occurrence. |
ActualEndDateTime | smalldatetime | NULL | Actual Date time the activity or service for this Occurrence was completed |
OccModifierAbbr | varchar(4) | NOT NULL | The Modifier for the Occurrences Status . Links to ModifierAbbreviation column from HOccStatusModifier table. |
OccModifierCode | smallint | NOT NULL | The ModifierCode for the Occurrence Status . Links to ModifierCode column from HOccStatusModifier table. |
IsResulted | smallint | NOT NULL | Is there a Result associated with this Occurrence. |
| | | Allowable values: |
| | | 0/Null - No |
| | | 1 - Yes |
OccurrenceReason_oid | int | NULL | The Object ID of the coded reason for this Occurrence. |
OccurrenceHistoryGroupId | bigint | NULL | Always the object id of the Occurrence when first created. When occurrences are updated it creates a new history row with previous state marking it as IsExpired=1 in the same table with new objectid , but keeping the OccurrenceHistoryGroupID the same. This field is used to get the history of updates performed on a given occurrence. Note: Not all environments / databases will have the datatype of BIGINT. Some will remain with the INT datatype. |
OriginalOccurrenceID | bigint | NULL | Objectid of another row in HOccurrenceOrder(usually Expired rows) which represents the previous state of the occurrence. Null for newly created occurrence. Note: Not all environments / databases will have the datatype of BIGINT. Some will remain with the INT datatype. |
IsExpired | bit | NULL | is a history row. Row with value 1 should never be fetched in normal occurrence processing. Used to keep the history. Allowable values: 0/Null - Not a history row, 1 - Is a history row |
ProvidedBy | varchar(188) | NULL | Staff Name of the Staff that actually fulfilled(provided or performed the service) this Occurrence |
ProvidedBy_OID | int | NULL | The Object ID of the Staff that actually fulfilled this Occurrence. NULL when ProvidedBy is free text.(HStaff) |
ProviderUnitAbbr | varchar(10) | NULL | The Abbreviation for the Service Provider(HHealthCareUnit) |
ProviderUnit_OID | int | NULL | The Object ID of the Service Provider(HHealthcareUnit) |
SessionID | int | NULL | Identifier of the User Session this Occurrence was created/updated in(HOccStateTransRec) |
SupervisedBy_StaffOID | int | NULL | The Object ID of the Staff that actually supervised the activity or services associated with fulfilling this Occurrence. Zero when SupervisedByStaff is free text.(HStaff) |
SupervisedByStaff | varchar(188) | NULL | Staff Name of the Staff that actually supervised the activity or services associated with fulfilling this Occurrence(HStaff) |
ChartedbyUserOID | int | NULL | The Object ID of the User who entered the information for this Occurrence(HSUser) |
WorkGroupID | Varchar(10) | Null | For Non Med, Non Specimen, Non Recurring orders, when a GroupID has been configured for a Service Provider Unit, this is the Identifier assigned for orders placed in the same session for the same Provider Unit, Start date time, Service Type, Service SubType Priority Modifier and Patient Visit.(orders are sent outbound in a single message). |
HasAttentionFlag | tinyint | NULL | Indicator if the user has marked this occurrence as requiring attention. Allowable values: 0/Null - No, 1 - Yes |
AttentionComment | varchar(255) | NULL | User entered comments indicating why this order requires special attention. |
ClonedOrder_oid | int | NULL | Order this Occurrence(and associated order) should be grouped with when displaying activity for the patient. |
AssignedUser_oid | int | NULL | The Object ID of the User assigned by the Staff Assignment(HSUser) |
AssignedStaff_oid | int | NULL | The Object ID of the Staff assigned by the Staff Assignment(HStaff) |
AssignedUserName | VARCHAR(12) | NULL | The name of the User assigned by the Staff Assignment(HSUser) |
AssignedStaffName | VARCHAR(184) | NULL | The name of the Staff assigned by the Staff Assignment(HName) |
ManualChrgComplete | CHAR(1) | NULL | 'Y' if the manual charges are captured, NULL otherwise |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|