Table Detail Report

OMF_MED_SERVICE_HIST_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores medical service history for a given encounter.
Definition: Stores medical service history by encounter.
Table Type: ACTIVITY





Column Detail - OMF_MED_SERVICE_HIST_ST


Column Name Type Null? Definition
BEG_TRANSACTION_DT_NBR DOUBLE Y The Julian date on which the patient was changed to this medical service.
BEG_TRANSACTION_DT_TM DATETIME Y The date/time on which the patient was changed to this medical service.
BEG_TRANSACTION_MIN_NBR DOUBLE Y The minute of the day at which the person was changed to this medical service.
BEG_TRANSACTION_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.
ENCNTR_LOC_HIST_ID DOUBLE N This is the value of the unique primary identifier of the encounter location history table. It is an internal system assigned number.
END_TRANSACTION_DT_NBR DOUBLE Y The Julian date on which the person was changed from this medical service.
END_TRANSACTION_DT_TM DATETIME Y The date/time on which the person was changed from this person was changed from this medical service.
END_TRANSACTION_MIN_NBR DOUBLE Y The minute of the day on which the person was changed from this medical service.
END_TRANSACTION_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
MED_SERVICE_CD DOUBLE N The code value for the medical service.
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_MED_SERVICE_HIST_ST


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


OMF_ORDER_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores order information related to a particular encounter
Definition: omf_order_st
Table Type: ACTIVITY





Column Detail - OMF_ORDER_ST


Column Name Type Null? Definition
ACTION_PERSONNEL_ID DOUBLE N The unique identifier for the person that placed the order..
ACTION_PRSNL_POSITION_CD DOUBLE N The Cerner-defined position for the prsnl placing the order.
ACTIVITY_TYPE_CD DOUBLE N A grouping mechanism within catalog type code.
CANCEL_DT_NBR DOUBLE Y The Julian date on which the order was cancelled.
CANCEL_DT_TM DATETIME Y The date/time on which the order was cancelled.
CANCEL_IND DOUBLE Y Indicates whether or not the order has been cancelled.
CANCEL_MIN_NBR DOUBLE Y The minute of the day on which the order was cancelled.
CANCEL_REASON_CD DOUBLE N The reason that an order was cancelled.
CANCEL_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
CATALOG_CD DOUBLE N The coded value for the order catalog for this order.
CATALOG_TYPE_CD DOUBLE N A grouping mechanism to bring order catalogs together.
CKI VARCHAR(255) Y For Meds processes
COMPLETE_DT_NBR DOUBLE Y The Julian date on which the order was completed.
COMPLETE_DT_TM DATETIME Y The date/time on which the order was completed.
COMPLETE_IND DOUBLE Y Indicates whether or not the order has been completed.
COMPLETE_MIN_NBR DOUBLE Y The minute of the day on which the order was completed.
COMPLETE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
CPT4_PROC_NOMENCLATURE_ID DOUBLE N The nomenclature id for the CPT4 procedure attached to the order.
CURRENT_START_DT_NBR DOUBLE Y The Julian date on which the order was started.
CURRENT_START_DT_TM DATETIME Y The date/time on which the order was started.
CURRENT_START_MIN_NBR DOUBLE Y The minute of the day on which the order was started.
CURRENT_START_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
DISCONTINUE_DT_NBR DOUBLE Y The Julian date on which the order was discontinued.
DISCONTINUE_DT_TM DATETIME Y The date/time on which the order was discontinued.
DISCONTINUE_MIN_NBR DOUBLE Y The minute of the day on which the order was discontinued.
DISCONTINUE_REASON_CD DOUBLE N The reason that an order was discontinued.
DISCONTINUE_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.
ICD9_DIAG_NOMENCLATURE_ID DOUBLE N The nomenclature id for the diagnosis code attached to the order.
ICD9_PRIN_PROC_DT_NBR DOUBLE Y The Julian date for the principle procedure
ICD9_PRIN_PROC_DT_TM DATETIME Y The date/time on which the ICD9 Principal Procedure was performed.
ICD9_PRIN_PROC_MIN_NBR DOUBLE Y The minute number for the icd9 principal procedure
ICD9_PRIN_PROC_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
ICD9_PROC_NOMENCLATURE_ID DOUBLE N The nomenclature id for the procedure attached to the orderable.
NEED_DOCTOR_COSIGN_IND DOUBLE Y Indicates whether or not the order requires a doctor cosign.
ORDER_FACILITY_CD DOUBLE N The coded value for the facility in which the patient was located at order time.
ORDER_FACILITY_GRP_CD DOUBLE N The grouping code for the order_facility
ORDER_ID DOUBLE N The unique identifier for the order.
ORDER_IND DOUBLE Y Indicates whether or not the order has been placed.
ORDER_NURSE_UNIT_CD DOUBLE N The nurse unit code at which the patient was located at order time.
ORDER_NURSE_UNIT_GRP_CD DOUBLE N The grouping code for the nurse unit.
ORDER_PROVIDER_ID DOUBLE N The unique identifier for the ordering physician
ORDER_PROVIDER_POSITION_CD DOUBLE N The Cerner-defined position for the ordering physician.
ORIG_ORDER_DT_NBR DOUBLE Y The Julian date on which the order took place.
ORIG_ORDER_DT_TM DATETIME Y The date/time on which the order took place.
ORIG_ORDER_MIN_NBR DOUBLE Y The minute of the day on which the order took place.
ORIG_ORDER_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PRIORITY_CD DOUBLE N The priority of the order.
REVIEW_COMPLETE_IND DOUBLE Y Indicates whether or not the review has been completed.
REVIEW_REQUIRED_IND DOUBLE Y Indicates whether or not a review is required.
STATUS_DT_NBR DOUBLE Y The Julian date for the last time the order was modified.
STATUS_DT_TM DATETIME Y The date/time on which the order was last modified.
STATUS_MIN_NBR DOUBLE Y The minute of the day on which the order was last modified.
STATUS_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
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.
VISIT_DT_NBR DOUBLE Y The Julian date for the admit date/time.
VISIT_DT_TM DATETIME Y The date/time on which the encounter visit occurred.
VISIT_MIN_NBR DOUBLE Y The minute number for the admit date/time.
VISIT_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.



Relationship Detail - OMF_ORDER_ST


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


OMF_OUTCOME_CLIENT



Column Section Top of Page


Table-level Detail

Description: OMF OUTCOME CLIENT
Definition: Stores the list of OMF OUTCOMES SCORECARD CLIENTS
Table Type: REFERENCE





Column Detail - OMF_OUTCOME_CLIENT


Column Name Type Null? Definition
CLIENT_NBR DOUBLE N This is a Cerner defined number describing each client
HEALTH_PLAN_NAME CHAR(80) Y This is the parent organization for this client
HEALTH_SYSTEM_NAME CHAR(80) Y This is the parent of the health plan
HOSPITAL_NAME CHAR(80) Y This is the name of the client
JCAHO_HCO_NBR DOUBLE Y This is the JCAHO number
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_OUTCOME_CONTINUOUS



Column Section Top of Page


Table-level Detail

Description: OMF OUTCOME CONTINUOUS
Definition: omf outcomes indicators stored here
Table Type: ACTIVITY





Column Detail - OMF_OUTCOME_CONTINUOUS


Column Name Type Null? Definition
CLIENT_NBR DOUBLE N client number
GROUP_NUMBER_CASES DOUBLE Y number of cases in peer group
GROUP_NUMBER_CASES_MAX DOUBLE Y maximum number of cases in peer group
GROUP_NUMBER_CASES_MEAN DOUBLE Y average number of cases in peer group
GROUP_NUMBER_CASES_MEDIAN DOUBLE Y median number of cases in peer group
GROUP_NUMBER_CASES_MIN DOUBLE Y minimum number of cases in peer group
GROUP_NUMBER_HCO DOUBLE Y peer group number
GROUP_OBS_MAX_OVERALL_MEAN DOUBLE Y peer group observed overall mean
GROUP_OBS_MEAN_OVERALL_MEAN DOUBLE Y peer group observed mean overall mean
GROUP_OBS_MEDIAN_OVERALL_MEAN DOUBLE Y peer group observed median overall mean
GROUP_OBS_MIN_OVERALL_MEAN DOUBLE Y peer group observed min overall mean
GROUP_OBS_OVERALL_MEAN DOUBLE Y peer group observed overall mean
GROUP_OBS_STD_DEV_OVERALL_MEAN DOUBLE Y peer group observed standard deviation overall mean
HCO_DIFF_OBS_RISK_ADJ_STD_DEV DOUBLE Y healthcare organization's differential observed risk adjusted standard deviation
HCO_NUMBER_OF_CASES DOUBLE Y healthcare organization's number of cases
HCO_OBS_MAX DOUBLE Y healthcare organization's observed maximum
HCO_OBS_MEAN DOUBLE Y healthcare organization's observed mean
HCO_OBS_MEDIAN DOUBLE Y healthcare organization's observed median
HCO_OBS_MIN DOUBLE Y healthcare organization's observed minimum
HCO_OBS_STD_DEV DOUBLE Y healthcare organization's observed standard deviation
HCO_RISK_ADJ_MAX DOUBLE Y healthcare organization's risk adjusted maximum
HCO_RISK_ADJ_MEAN DOUBLE Y healthcare organization's risk adjusted mean
HCO_RISK_ADJ_MEDIAN DOUBLE Y healthcare organization's risk adjusted median
HCO_RISK_ADJ_MIN DOUBLE Y healthcare organization's risk adjusted minimum
HCO_RISK_ADJ_NUMBER_OF_CASES DOUBLE Y health care organizations risk adjusted number of cases
HCO_RISK_ADJ_STD_DEV DOUBLE Y healthcare organization's risk adjusted standard deviation
HCO_TOTAL_CASES DOUBLE Y healthcare organization's total cases
INDICATOR_NBR DOUBLE N This is the Cerner defined number for this indicator
JCAHO_REPORTED_MEASURE_IND DOUBLE Y indicates whether indicator is reported to jcaho
REPORTING_PERIOD DATETIME N reporting period
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_OUTCOME_INDICATOR



Column Section Top of Page


Table-level Detail

Description: OMF_OUTCOME_INDICATOR
Definition: Contains the list of indicators
Table Type: REFERENCE





Column Detail - OMF_OUTCOME_INDICATOR


Column Name Type Null? Definition
BEGIN_EFFECTIVE_DT_TM DATETIME Y date when we started using this indicator
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.
INDICATOR_LONG_NAME VARCHAR(200) Y This is the long description for this indicator
INDICATOR_NBR DOUBLE N This is the Cerner defined number for this indicator
INDICATOR_SHORT_NAME CHAR(50) Y Short description of the indicator
JCAHO_MEASURE_NBR DOUBLE Y jcaho oryx indicator number
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.