Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HMod2CPTCode This table stores the CPT (Current Procedure Terminology) Modifiers associated with an Non-Medication Order/Occurrence
Column Name Column Datatype Column Null Option Column Comment
ObjectIDbigintNOT NULL Object Identifier of this record. This field is a primary key for the associated table.
InstanceHFCIDsmallintNOT NULL Healthcare Foundation Class(HFC) Identifier of the object.HFCID of this object is 1510. The value specified in the ObjectID field and in this field enables unique identification of an object instance across the application.
RecordIdintNULL Not Valued in this table. Column exists as part of persistence framework implementation.
Descriptionvarchar(1)NULL Not Valued in this table. Column exists as part of persistence framework implementation.
IsDeletedtinyintNOT NULL Specifies whether the record is soft deleted.
Allowable Values
0 - Active
1 - Marked as Deleted.
Note: The presence of this field in tables depends on the configuration at the time of table design.
IsVersionedbitNOT 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.
CreatedUserIdintNULL 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
CreationTimesmalldatetimeNULL Date and time when the record is created.
CPTCodevarchar(20)NULL Current Procedural Terminology(CPT) Code - published by the American Medical Association.
CPTCodeDescvarchar(64)NULL Description of the CPT Code
CPTModCodevarchar(20)NULL Current Procedural Terminology(CPT) Modifier - can be either two letters or a letter and a number. This is a custom modifier configured by each client in the soarian catalog item “CPT Modifiers” which the user associated with the order at the time of placing the order. It is not mandatory to associate a modifier while placing the order.
CPTModCodeDescvarchar(64)NULL Description of the CPT Modifier
Order_oidintNULL ObjectID of HOrder table. Links Order to the Modifier. This relation is valued during order entry. Rows which value this relation won't value the Occurrence_oid relation
IsPrimarytinyintNULL Whether the Modifier is primary or not. Allowable Values: 0 - Not Primary , 1 - Primary
Occurrence_oidbigintNULL ObjectID of HOccurrrenceOrder table. Links the occurrence to the Modifier. This record is created when Occurrence gets created. Rows which value this relation won't value the Order_oid relation. Note: Not all environments / databases will have the datatype of BIGINT. Some will remain with the INT datatype.
As Occurrences are sent to external system and for billing events , the CPT modifiers at occurrence level are the ones used for reporting/business processing.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates