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. |