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 |