Table Detail Report

EPRESCRIBE_AUDIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Eprescribe Audit
Definition: This table contains order related information for every prescription order that is electronically routed to a pharmacy.
Table Type: ACTIVITY





Column Detail - EPRESCRIBE_AUDIT


Column Name Type Null? Definition
EPRESCRIBE_AUDIT_ID DOUBLE N Unique generated number that identifies a single row on the EPRESCRIBE_AUDIT table.
FORMULARY_BENEFIT_IND DOUBLE N Indicates if the formulary benefit information was made available to the provider.
ORDER_ID DOUBLE N Identifies the order being audited.
PHARMACY_IDENT VARCHAR(100) Y External pharmacy identifier to which the order has been routed.
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 - EPRESCRIBE_AUDIT


Child Column in EPRESCRIBE_AUDIT(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID


GS_MED_CLAIM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Grid Services - Medical Claims
Definition: Pharmacy benefit claims reported by the payer or pharmacy.
Table Type: ACTIVITY





Column Detail - GS_MED_CLAIM


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
CATALOG_CD DOUBLE N The internal value for the report order catalog item.
CATALOG_CKI VARCHAR(250) N Knowledge index of the order catalog entry that corresponds to the claimed product.If CATALOG_CD is NULL, might contain CKI id that does not correspond to an order catalog entry; e.g., the claim corresponds to a known drug in the Multum vocabulary that is not in the order catalog.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
CREATE_DT_TM DATETIME N Timestamp when the entry was first entered into the database. (The UPDT_DT_TM is when the row was entered into the table.)
DAYS_SUPPLY_QTY DOUBLE Y The number of days the product will last.
DISPENSE_QTY DOUBLE N Product-level order catalog synonym entry that corresponds to the "claim"ed product.
DOSAGE_INSTRUCTIONS VARCHAR(1000) Y The dosage instructions for the claim, detailing the administration of the product in doses.
EXT_PHARMACY_IDENT VARCHAR(50) Y The identifier of the external pharmacy where the claim might be dispensed.
EXT_PHARMACY_IDENT_TYPE_CD DOUBLE N The type of pharmacy identifier.
EXT_PRESCRIBER_IDENT VARCHAR(200) Y The external identifier of the person prescribing the claim.
EXT_PRESCRIBER_IDENT_TYPE_CD DOUBLE N The type of the identifier of the person prescribing the claim.
EXT_PRODUCT_IDENT VARCHAR(50) Y The Identifier of the product dispensed in this claim.
EXT_PRODUCT_IDENT_TYPE_CD DOUBLE N The type of the product identifier (NDC, HIN, Etc.)
FILL_NUMBER_TXT VARCHAR(50) Y The fill number for the medication dispense, 0 being the initial fill.
GS_MED_CLAIM_ID DOUBLE N Identifies a pharmacy benefit claim reported by the payer or pharmacy.
LAST_FILL_DT_TM DATETIME Y The date the patient last refilled the claim.
OBTAINED_DT_TM DATETIME Y The date when the claim was obtained from the external services.
ORIGINAL_REFILLS_TXT VARCHAR(50) Y The original number of refills for the claim.
ORIG_GS_MED_CLAIM_ID DOUBLE N The identifier of the original claim that this claim was renewed from. If it is the original claim this ID will be 0.
PAYER_NAME VARCHAR(100) Y The name of the payer.
PAYER_ORG_ID DOUBLE N The millennium identifier of the organization responsible for paying the claim expenses.
PERSON_ID DOUBLE N It is the person for whom the pharmacy benefit claim is reported on by the payer or pharmacy.
PHARMACY_IDENTIFIER VARCHAR(100) N Identifier for the pharmacy
PHARMACY_NAME VARCHAR(100) N Name of dispensing pharmacy that submitted the claim. (As transmitted with the claim)
PRESCRIBER_ID DOUBLE N Identifier of the physician that prescribed the "claim"ed product.
PRESCRIBER_NAME VARCHAR(135) N Name of the physician that prescribed the "claim"ed product. (As received in the claim)
PRESCRIBER_ORDER_NUMBER VARCHAR(100) Y Identifies the prescriber order number.
PRESCRIPTION_HEALTH_PLAN_ID DOUBLE N The identifier of the health plan the claim was created from.
PRN_REFILL_FLAG DOUBLE N Indicates if refills are to be given as needed. Values: 0 - Unknown, 1 - Not PRN, 2 - PRN.
PRODUCT_DESCRIPTION VARCHAR(250) N Describes the product that was the subject of the claim. (As transmitted with the claim)
PRODUCT_DOSE_TXT VARCHAR(100) Y The product dose description.
PRODUCT_SYNONYM_CKI VARCHAR(250) N Knowledge Index of the order catalog synonym that corresponds to the claimed product, at the product level. If the SYNONYM_ID is null, this column might be populated with a CKI id that does not correspond to an order catalog entry.
PRODUCT_SYNONYM_ID DOUBLE N Product-level order catalog synonym entry that corresponds to the claimed product.
RECEIVED_QTY_TXT VARCHAR(50) Y The received quantity display.
RECEIVED_QTY_UNIT_CD DOUBLE N The claim's received quantity unit.
REFILL_NBR DOUBLE N Indicates whether this claim was based on a refill of an original prescription, and which refill this is. (0 if this is the first claim on the prescription). NOTE: This column has been replaced with Fill_Number_Txt and is no longer supported.
REFILL_NBR_NOT_APPLIED_IND DOUBLE N Indicates if the refilled number was applied or not. 0 - The refill number applies. 1 - The refill number does not apply.
REMAINING_REFILLS_TXT VARCHAR(50) Y The remaining number of refills for the claim.
SERVICE_DT_TM DATETIME N Date of service associated with the claim.
SOURCE_TYPE_FLAG DOUBLE N Describes the source type of the claim. The value is 0 if it is unknown, 1 if it is a payer, 2 if it is a pharmacy.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VERSION_NBR DOUBLE N The version of the claim. This number will increase each time a claim is renewed. A new claim will have a version of 0.
WRITTEN_DT_TM DATETIME Y The date the prescription was written for the associated claim.



Relationship Detail - GS_MED_CLAIM


Child Column in GS_MED_CLAIM(FK) Parent Table Name Parent Column Name
Parents: ORIG_GS_MED_CLAIM_ID GS_MED_CLAIM GS_MED_CLAIM_ID
PRESCRIPTION_HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
CATALOG_CD ORDER_CATALOG CATALOG_CD
PRODUCT_SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
PAYER_ORG_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
PRESCRIBER_ID PRSNL PERSON_ID




Parent Column in GS_MED_CLAIM (PK) Child Table Name Child Column Name
Children: GS_MED_CLAIM_ID GS_MED_CLAIM ORIG_GS_MED_CLAIM_ID


MED_HISTORY_AUDIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Medical History Audit
Definition: This table will be used to audit incoming external medical history transactions. This auditing table will provide troubleshooting capabilities.
Table Type: ACTIVITY





Column Detail - MED_HISTORY_AUDIT


Column Name Type Null? Definition
AUDIT_DT_TM DATETIME N The time at which this entry was logged for the transaction
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
ENCNTR_ID DOUBLE N The unique identifier to the encounter table. When populated, medication history was requested during the given encounter.
FACILITY_ORGANIZATION_ID DOUBLE N The unique identifier to the organization table. Defines the facility where the patient was located at the time medication history was requested.
MED_HISTORY_AUDIT_ID DOUBLE N Unique generated number that identifies a single row on the med_history_audit table.
MESSAGE_TXT VARCHAR(255) Y The message corresponding to the provided status for the transaction
ORIGIN_MED_HISTORY_AUDIT_ID DOUBLE N The unique identifier to the med_history_audit table. Identifies the initial transaction to link together medication history transactions that are a part of a group.
PERSON_ID DOUBLE N The person_id corresponding to the external medications to be imported.
PRESCRIBER_PRSNL_ID DOUBLE N The unique identifier of the patient's prescribing provider.
PRSNL_ID DOUBLE N The ID of the person who originally requested the transaction.
REASON_CD DOUBLE N Further defines the reason for the status of the transaction.
REQUEST_IDENT VARCHAR(36) N The Universally Unique Identifier(UUId) assigned to all database entries for the transaction.
RESPONSE_DT_TM DATETIME Y The date and time the response to the request for medication history was received inbound.
STATUS_CD DOUBLE N The status of the external med history transaction.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VENUE_TYPE_CD DOUBLE N Defines the venue from where the transaction was submitted.



Relationship Detail - MED_HISTORY_AUDIT


Child Column in MED_HISTORY_AUDIT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
ORIGIN_MED_HISTORY_AUDIT_ID MED_HISTORY_AUDIT MED_HISTORY_AUDIT_ID
FACILITY_ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
PRESCRIBER_PRSNL_ID PRSNL PERSON_ID
PRSNL_ID PRSNL PERSON_ID




Parent Column in MED_HISTORY_AUDIT (PK) Child Table Name Child Column Name
Children: MED_HISTORY_AUDIT_ID MED_HISTORY_AUDIT ORIGIN_MED_HISTORY_AUDIT_ID


MED_HISTORY_STATUS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Medical History Status
Definition: Track the status of incoming external medical history.
Table Type: ACTIVITY





Column Detail - MED_HISTORY_STATUS


Column Name Type Null? Definition
MED_HISTORY_STATUS_ID DOUBLE N Unique generated number that identifies a single row on the med_history_status table.
PERSON_ID DOUBLE N The person_id corresponding to the external medications to be imported.
START_DT_TM DATETIME N The original start time of the transaction
STATUS_CD DOUBLE N The status of the external med history transaction.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - MED_HISTORY_STATUS


Child Column in MED_HISTORY_STATUS(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID


NOMEN_ENTITY_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: NOMEN ENTITY RELTN
Definition: Nomenclature and Diagnosis Reltns
Table Type: ACTIVITY





Column Detail - NOMEN_ENTITY_RELTN


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.
ACTIVITY_TYPE_CD DOUBLE N Activity type code of the order. It's blank for non-order related relationships.
BEG_EFFECTIVE_DT_TM DATETIME N 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.
CHILD_ENTITY_ID DOUBLE N The Cerner internal id number of the entity that is getting related to the nomenclature item
CHILD_ENTITY_NAME VARCHAR(32) N Table Name of the Child_Entity_id
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
END_EFFECTIVE_DT_TM DATETIME N 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.
FREETEXT_DISPLAY VARCHAR(255) Y Free-text descripion of the generic entity item
INACTIVE_ORDER_ACTION_SEQUENCE DOUBLE Y This is the action_sequence column in table Order_Action. It is used to indicate that the relationship of the Order_Action table to the Diagnosis table is inactivated by this particular Order_Action_Sequence.
NOMENCLATURE_ID DOUBLE N Identifier for the nomenclature item being related
NOMEN_ENTITY_RELTN_ID DOUBLE N Unique Identifier for the relation
ORDER_ACTION_SEQUENCE DOUBLE Y This is the action_sequence column in table Order_Action. It is used to indicate that the relationship to the Diagnosis table is associated to a particular order action as opposed to an entire order.
PARENT_ENTITY_ID DOUBLE N The Cerner internal id number for the nomenclature item
PARENT_ENTITY_NAME VARCHAR(32) N The table for the parent_entity_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.
PRIORITY DOUBLE Y The priority of the relationships.
RELTN_SUBTYPE_CD DOUBLE N Supports the ability to further define a relationship. For example, the reltn_type_cd will specify that a diagnosis is being related to another diagnosis. The reltn_subtype_cd will specify that nature of that relationship, i.e. caused by, complication of, etc.
RELTN_TYPE_CD DOUBLE N Relation type between parent_entity and child_entity
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 - NOMEN_ENTITY_RELTN


Child Column in NOMEN_ENTITY_RELTN(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
PERSON_ID PERSON PERSON_ID