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. |
InstanceHFCID | smallint | NOT NULL | Healthcare Foundation Class(HFC) Identifier of the object.HFCID of this object is 1511. 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. |
ToOrderOccState | varchar(64) | NULL | State the occurrence is going to during this transition, i.e. Active, inprogress,etc. |
ActualDateTime | smalldatetime | NULL | Actual date time of the occurrence when it was charted. |
StatusEnteredDatetime | smalldatetime | NULL | Date and time when the status was entered. |
ChartedBy | varchar(30) | NULL | LoginID of the user who performed the occurrence state transition in the application. |
ChartingComment | varchar(255) | NULL | Comment that was entered by the user who performed the occurrence state transition in the application. |
SampleStatus | varchar(40) | NULL | Sample status if it is related to a lab order, i.e. Specimen Not Collected,etc. |
OccurrenceOrder_oid | bigint | NOT NULL | Object ID of HOccurenceOrder. Note: Not all environments / databases will have the datatype of BIGINT. Some will remain with the INT datatype. |
OccStatusCode | tinyint | NULL | Code associated with the status of the transition |
| | | Allowable Values |
| | | 0 - Active |
| | | 1 - Suspend |
| | | 2 - Cancel |
| | | 3 - Discontinue |
| | | 4 - Complete |
| | | 5 - In Progress |
| | | 6 - Invalid |
| | | 7 - Not Complete |
OccStatusModifierAbbr | varchar(4) | NULL | Abbreviation associated with the occurrence status modifier. |
SessionID | int | NULL | Unique ID for a user's ordering session when signed created this transition record. |
SessionStartDateTime | datetime | NULL | Start date time for a user's ordering session when signed created this transition record. |
SessionEndDateTime | datetime | NULL | End date time for a user's ordering session when signed created this transition record. |
StatusedSource | tinyint | NULL | System from which the status was updated |
| | | Allowable Values |
| | | 0 - Changes on this occurrence is through Soarian |
| | | 1 - Changes on this Occurrence is through Connectivity |
SampleStatusCode | smallint | NULL | Code associated with the sample status. |
| | | Allowable Values |
| | | 10 - Pending Specimen to be collected |
| | | 11 - Pending Specimen to be printed |
| | | 12 - Specimen Collected |
| | | 13 - Specimen Not Collected |
IsSampleRevised | bit | NULL | Whether sample has been revised. 0 indicates false, 1 indicates true. |
ChartedbyUserOID | int | NULL | ObjectID of the user that performed the occurrence state transition in the application. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|