Table Detail Report

OMF_CE_SUSCEPTIBILITY_ST



Column Section Top of Page


Table-level Detail

Description: Stores organism susceptibility data
Definition: omf_ce_susceptibility_st
Table Type: ACTIVITY





Column Detail - OMF_CE_SUSCEPTIBILITY_ST


Column Name Type Null? Definition
ANTIBIOTIC_CD DOUBLE N The type of antibiotic for microbiology susceptibility results
DETAIL_SUSCEPTIBILITY_CD DOUBLE N The actual susceptibility that an organism has to an antibiotic
EVENT_ID DOUBLE N Unique identifier to the event stored on the omf_clinical_event_st table.
MICRO_SEQ_NBR DOUBLE N Combined with the event_id to form foreign key to the omf_ce_microbiology_st table
RESULT_CD DOUBLE N The resistance of an organism to a particular antibiotic (susceptibility interpretation).
RESULT_DT_NBR DOUBLE Y The Julian date for the result
RESULT_DT_TM DATETIME Y The date and time of the results.
RESULT_MIN_NBR DOUBLE Y The minute that the result occurred.
RESULT_NUMERIC_VALUE DOUBLE Y The numeric value of the results.
RESULT_TEXT_KEY VARCHAR(255) Y RESULT_TEXT_KEY
RESULT_TEXT_VALUE VARCHAR(100) Y The free text description of the results.
RESULT_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
RESULT_UNIT_CD DOUBLE N The unit of measure for the susceptibility interpretation.
SUSCEPTIBILITY_TEST_CD DOUBLE N The type of susceptibility testing done (MIC, Kirby-Bauer).
SUSCEP_SEQ_NBR DOUBLE N Sequence number to make the primary key unique, when there are more than one susceptibility test per growth.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.


OMF_CHARGE_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores charge information related to a particular encounter
Definition: OMF_CHARGE_ST
Table Type: ACTIVITY





Column Detail - OMF_CHARGE_ST


Column Name Type Null? Definition
ACCESSION VARCHAR(20) Y An accession uniquely identifies a specimen.
ACTIVITY_TYPE_CD DOUBLE N Department to which the activity belongs
ACT_DIRECT_FIX_COST DOUBLE Y The actual direct fixed cost.
ACT_DIRECT_VAR_COST DOUBLE Y The actual direct variable cost.
ACT_INDIRECT_FIX_COST DOUBLE Y The actual indirect fixed cost.
ACT_INDIRECT_VAR_COST DOUBLE Y The actual indirect variable cost
ACT_SERVICE_TO_CHARGE DOUBLE Y act_service_to_charge. Used to calculate Service to Charge turnaround times
ADMIT_TYPE_CD DOUBLE N Stores the unique admission type for each patient
BILL_CODE_ID DOUBLE N Depending on the value in charge_mod_type_cd, this is either the value from 13030 that represents the suspense reason, or it is the value from 14002 that represents the bill code schedule.
BILL_ITEM_ID DOUBLE N The unique identifier for a bill item
CATALOG_CD DOUBLE N The coded value for the order catalog for this order.
CDM_DESC VARCHAR(200) Y The charge description master description.
CDM_NBR VARCHAR(200) Y The charge description master number.
CHARGE_DESCRIPTION VARCHAR(200) Y The free text description for the charge.
CHARGE_DT_NBR DOUBLE Y The Cerner internal system date representation of the day the person was charged
CHARGE_DT_TM DATETIME Y The date/time charge occurred
CHARGE_ITEM_ID DOUBLE N Charge Item ID uniquely identifies the charge. It is a foreign key to the Charge Table
CHARGE_MIN_NBR DOUBLE Y The minute of day the charge occurred (1..1440).
CHARGE_TYPE_CD DOUBLE N Represents the charge event: debit, credit, collection, no charge, etc.
CHARGE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
COST_CENTER_CD DOUBLE N Cost center code value
COST_CENTER_GRP_CD DOUBLE N The grouping of cost center cds (14058)
CPT4_DESC VARCHAR(200) Y The CPT4 description as it applies to the charge.
CPT4_ID DOUBLE N cpt4_id
CPT4_NBR VARCHAR(200) Y The CPT4 number as it applies to the charge
DEPARTMENT_CD DOUBLE N Performing Department Code
DISCOUNT_AMOUNT DOUBLE Y Discount Amount
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ICD9_DESC VARCHAR(200) Y The ICD9 description as it applies to the charge.
ICD9_ID DOUBLE N icd9_id
ICD9_NBR VARCHAR(200) Y The ICD9 number as it applies to the charge.
INSTITUTION_CD DOUBLE N Performing Institution
INTERFACED_DT_NBR DOUBLE Y The Cerner internal system date representation of the day the charge interfaced
INTERFACED_DT_TM DATETIME Y The date/time that the charge was interfaced
INTERFACED_MIN_NBR DOUBLE Y The minute of day (1..1440).
INTERFACED_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
ITEM_EXTENDED_PRICE DOUBLE Y item_extended_price
ITEM_PRICE DOUBLE Y The charge item price
ITEM_QUANTITY DOUBLE Y The number of charges
LOC_FACILITY_CD DOUBLE N Ordering institution
LOC_NURSE_UNIT_CD DOUBLE N The code_value that refers to the patient's nurse unit.
MANUAL_IND DOUBLE Y Indicates if this charge is currently on hold as a manual charge or if it has ever been on hold as a manual charge.
NOMENCLATURE_ID DOUBLE N Bill Code corresponding to the nomenclature Id
ORDER_DT_NBR DOUBLE Y The Cerner internal system date representation of the day the charge was ordered
ORDER_DT_TM DATETIME Y The date/time that the charge was ordered
ORDER_ID DOUBLE N Id of the order
ORDER_MIN_NBR DOUBLE Y The minute of day (1..1440).
ORDER_PHYS_GRP_CD DOUBLE N Grouping of ordering physicians
ORDER_PHYS_ID DOUBLE N The id of the ordering provider
ORDER_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
PAYOR_ID DOUBLE N ID from the organization table that represents the client organization associated with this charge.
PERF_PHYS_GRP_CD DOUBLE N Grouping of performing physicians
PERF_PHYS_ID DOUBLE N The performing physician person ID
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PROCESS_FLAG DOUBLE Y Indicates how to process data in batch mode.
PROCESS_FLG DOUBLE Y Indicates if the charge is pending, suspended/held, skipped, interfaced, combined or bundled.
REV_CAT_CD DOUBLE N The grouping of revenue codes (20769)
REV_CAT_GRP_CD DOUBLE N The grouping of revenue categories (25993)
REV_CODE_CD DOUBLE N The revenue codes assigned to the CDM
SECTION_CD DOUBLE N The performing section code
SERVICE_DT_NBR DOUBLE Y The date number when the service took place. Used to gather date information from the omf_date table
SERVICE_DT_TM DATETIME Y The date and time when the service took place
SERVICE_MIN_NBR DOUBLE Y The minute number when the service took place. Used to get time information from the omf_time table.
SERVICE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
STD_DIRECT_FIX_COST DOUBLE Y The standard direct fixed cost.
STD_DIRECT_VAR_COST DOUBLE Y The standard direct variable cost.
STD_INDIRECT_FIX_COST DOUBLE Y The standard indirect fixed cost
STD_INDIRECT_VAR_COST DOUBLE Y The standard indirect variable cost.
SUBSECTION_CD DOUBLE N The performing subsection code
TASK_ASSAY_CD DOUBLE N Foreign key to discrete_task_assay
TIER_GROUP_CD DOUBLE N The charge tier group code used to identity charges
TOTAL_ACT_COST DOUBLE Y The total actual cost.
TOTAL_STD_COST DOUBLE Y The total standard cost
TRANSACTION_IND DOUBLE Y Number of transactions
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - OMF_CHARGE_ST


Child Column in OMF_CHARGE_ST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID


OMF_CLINICAL_EVENT_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores clinical events relating to encounter.
Definition: omf_clinical_event_st
Table Type: ACTIVITY





Column Detail - OMF_CLINICAL_EVENT_ST


Column Name Type Null? Definition
BODY_SITE_CD DOUBLE N Body location where the collection was done (left arm, thumb, etc.)
CATALOG_CD DOUBLE N Foreign key to the order_catalog table.
CE_RESULT_DT_NBR DOUBLE Y The Cerner internal system date representation of the clinical event result.
CE_RESULT_DT_TM DATETIME Y The date/time clinical event result.
CE_RESULT_MIN_NBR DOUBLE Y The minute of day represented by the result.
CE_RESULT_NBR_VALUE DOUBLE Y The numeric result value.
CE_RESULT_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
EVENT_CD DOUBLE N Code_value associated with the clinical activity performed
EVENT_ID DOUBLE N Unique identification number for a clinical event associated with the encounter
EVENT_START_DT_NBR DOUBLE Y The Julian date of the optional clinical date time for the start of the event.
EVENT_START_DT_TM DATETIME Y Optional clinical date time for the start of the event.
EVENT_START_MIN_NBR DOUBLE Y The minute of the day of the optional clinical date time for the start of the event.
EVENT_START_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
EVENT_TITLE_TEXT VARCHAR(255) Y The title for document results.
NORMALCY_CD DOUBLE N The code_value identifying the normalcy of the clinical result
NORMAL_HIGH VARCHAR(20) Y The upper limit of the normal range for the clinical result
NORMAL_IND DOUBLE Y Indicator identifying whether or not the clinical result was normal
NORMAL_LOW VARCHAR(20) Y The lower limit of the normal range for the clinical result
ORDER_ID DOUBLE N Unique foreign key to the orders table.
PARENT_EVENT_ID DOUBLE N Provides a mechanism for logical grouping of events. I.e. supergroup and group tests. Same as EVENT_ID if current row is the highest level parent.
PERFORM_PRSNL_ID DOUBLE N Unique identification number for the person performing the clinical activity
PERFORM_PRSNL_POSITION_CD DOUBLE N The Cerner-defined position for the performing prsnl.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PROCESS_FLAG DOUBLE Y Flag used to determine how to process batched clinical event transactions.
RESULT_UNITS_CD DOUBLE N The units of the result.
RESULT_VAL VARCHAR(255) Y General Lab Clinical Event Results
SERVICE_DATE VARCHAR(25) Y The date that the clinical activity was performed
SERVICE_DAY DOUBLE Y The day of week that the clinical activity was performed
SERVICE_DT_NBR DOUBLE Y The Julian date on which the clinical event was performed
SERVICE_DT_TM DATETIME Y The date/time that the clinical activity was performed
SERVICE_HOUR DOUBLE Y The hour of the day that the clinical activity was performed
SERVICE_MIN_NBR DOUBLE Y The minute of the day on which the clinical event was performed
SERVICE_MONTH DOUBLE Y The month that the clinical activity was performed
SERVICE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
SOURCE_TYPE_CD DOUBLE N Source of collection (blood, sputum, stool, etc.)
SPECIMEN_ID DOUBLE N Unique identifier for the specimen on the v500_specimen table
TASK_ASSAY_CD DOUBLE N Unique foreign key to the discrete_task_assay table.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - OMF_CLINICAL_EVENT_ST


Child Column in OMF_CLINICAL_EVENT_ST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PARENT_EVENT_ID OMF_CLINICAL_EVENT_ST EVENT_ID
PERSON_ID PERSON PERSON_ID




Parent Column in OMF_CLINICAL_EVENT_ST (PK) Child Table Name Child Column Name
Children: EVENT_ID OMF_CLINICAL_EVENT_ST PARENT_EVENT_ID


OMF_CODING_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Care Profiling - stores ICD9 and CPT4 coding data.
Definition: omf_coding_st
Table Type: ACTIVITY





Column Detail - OMF_CODING_ST


Column Name Type Null? Definition
ANESTHESIA_CD DOUBLE N anesthesia code value
ANESTHESIA_MINUTES DOUBLE Y anesthesia minutes
ANESTHESIOLOGIST_FT_NAME VARCHAR(255) Y The free text name of the anesthesiologist.
ANESTHESIOLOGIST_ID DOUBLE N The unique identifier for the anesthesiologist
ANESTHESIOLOGIST_KEY VARCHAR(255) Y The concatenation of the anesthesiologist_id and free text name used for grouping within PowerVision
ANESTH_POSITION_CD DOUBLE N The Cerner-defined position for the anesthesiologist.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
NOMENCLATURE_ID DOUBLE N This is the value of the unique primary identifier of the nomenclature table. It is an internal system assigned number.
OMF_CODING_ST_ID DOUBLE N The unique identifier for the omf_coding_st.
PRINCIPLE_TYPE_CD DOUBLE N A general category used to group strings.
PRIORITY DOUBLE Y The priority for the coded data.
PROCEDURE_DT_NBR DOUBLE Y The Julian date on which the ICD9 procedure was performed.
PROCEDURE_DT_TM DATETIME Y The date/time on which the ICD9 Procedure was performed
PROCEDURE_MINUTES DOUBLE Y The number of minutes for the ICD9 procedure.
PROCEDURE_MIN_NBR DOUBLE Y The minute of the day on which the ICD9 procedure was performed.
PROCEDURE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
SERVICE_CATEGORY_CD DOUBLE N Codified field which identifies the category of service the patient is receiving; tied to the codified data from the coding system.
SOURCE_VOCABULARY_CD DOUBLE N The external vocabulary or lexicon that contributed the string, e.g. ICD9, SNOMED, etc.
TISSUE_TYPE_CD DOUBLE N tissue type code value
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - OMF_CODING_ST


Child Column in OMF_CODING_ST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID


OMF_COST



Column Section Relationship Section Top of Page


Table-level Detail

Description: OMF COST
Definition: Stores the standard cost information.
Table Type: REFERENCE





Column Detail - OMF_COST


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
BEG_EFFECTIVE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
BILL_ITEM_ID DOUBLE N The unique identifier assigned to a bill item OR the code value for a specific cost basis.
COST_BASIS_TYPE_CD DOUBLE N Describes the cost basis for the standard cost (i.e. bill item, revenue code, revenue category, etc.).
DIRECT_FIX_COST DOUBLE Y The direct fixed cost associated to the bill item.
DIRECT_VAR_COST DOUBLE Y The direct variable cost associated with the bill item.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
END_EFFECTIVE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
INDIRECT_FIX_COST DOUBLE Y The indirect fix cost associated with the bill_item
INDIRECT_VAR_COST DOUBLE Y The indirect variable cost associated with the bill item.
OMF_COST_ID DOUBLE N The unique identifier for a row on the OMF_COST table
ORGANIZATION_ID DOUBLE N The unique identifier for the organization for which the costs are to be applied.
STD_IND DOUBLE Y Indicates whether the row is a standard cost or an actual cost for a bill item (1=standard cost; 0=actual cost).
TOTAL_COST DOUBLE Y Total cost is used when sending totals only across the interface.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - OMF_COST


Child Column in OMF_COST(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID