Table Detail Report

RX_INPT_CLAIM_HX



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Inpatient Claim History
Definition: Track the linking of Inpatient Dispense events and their related Outpatient claims
Table Type: ACTIVITY





Column Detail - RX_INPT_CLAIM_HX


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.
CHILD_ORDER_ID DOUBLE N Identifies an inpatient child order associated with an original inpatient order (i.e. pass med orders)
DETAIL_PROCESS_STATUS_CD DOUBLE N Identifies a more detailed status for the qualified dispense.
DISPENSE_HX_ID DOUBLE N Identifies an inpatient dispense that was processed
HEALTH_PLAN_ID DOUBLE N Identifies the health plan used to qualify the inpatient dispense
OP_ACTION_SEQUENCE DOUBLE N Identifies the outpatient action that initiated the fill action
OP_DISPENSE_HX_ID DOUBLE N Identifies an outpatient dispense that was created for the outpatient order
OP_ORDER_ID DOUBLE N Identifies an outpatient order associated to the inpatient order
OP_RX_CLAIM_ID DOUBLE N Identifies the outpatient claim that was created for the outpatient dispense
ORDER_ID DOUBLE N Identifies an inpatient order associated to the inpatient dispense
PROCESS_DT_TM DATETIME N Identifies the date of when the outpatient claim was processed
PROCESS_STATUS_CD DOUBLE N Identifies the status for the inpatient dispense
PROD_CLAIM_QTY DOUBLE N Identifies the net dispense quantity, in terms of base package unit, of the product that is being claimed
PROD_DISPENSE_HX_ID DOUBLE N Identifies a product associated with the inpatient dispense
RX_ADMIN_DISPENSE_HX_ID DOUBLE N Identifies a specific administration associated with the inpatient dispense
RX_ADMIN_PROD_DISPENSE_HX_ID DOUBLE N Identifies a product associated with a specific administration
RX_INPT_CLAIM_HX_ID DOUBLE N Unique generated number that identifies a single row on the RX_INPT_CLAIM_HX table.
SERVICE_END_DT_TM DATETIME Y Identifies the end date of when the service was provided
SERVICE_START_DT_TM DATETIME Y Identifies the begin date of when the service was provided
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 - RX_INPT_CLAIM_HX


Child Column in RX_INPT_CLAIM_HX(FK) Parent Table Name Parent Column Name
Parents: DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
OP_DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
CHILD_ORDER_ID ORDERS ORDER_ID
ORDER_ID ORDERS ORDER_ID
OP_ACTION_SEQUENCE ORDER_ACTION ACTION_SEQUENCE
OP_ORDER_ID ORDER_ACTION ORDER_ID
RX_ADMIN_DISPENSE_HX_ID RX_ADMIN_DISPENSE_HX RX_ADMIN_DISPENSE_HX_ID
RX_ADMIN_PROD_DISPENSE_HX_ID RX_ADMIN_PROD_DISPENSE_HX RX_ADMIN_PROD_DISPENSE_HX_ID
OP_RX_CLAIM_ID RX_CLAIM RX_CLAIM_ID


RX_MED_PROD_DESC



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Medical Product Description
Definition: Stores drug descriptors (such as color, flavor, markings, etc.)
Table Type: REFERENCE





Column Detail - RX_MED_PROD_DESC


Column Name Type Null? Definition
FIELD_TYPE_CD DOUBLE N Type of descriptor - example color, flavor, markings.
FIELD_VALUE_STR_TXT VARCHAR(255) N The description of a given type.
LONG_BLOB_ID DOUBLE N Stored image of a medication
MED_PRODUCT_ID DOUBLE N Unique, generated key of MED_PRODUCT.
MED_PROD_DESC_ID DOUBLE N Unique, generated key for RX_MED_PROD_DESC.
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 - RX_MED_PROD_DESC


Child Column in RX_MED_PROD_DESC(FK) Parent Table Name Parent Column Name
Parents: LONG_BLOB_ID LONG_BLOB_REFERENCE LONG_BLOB_ID
MED_PRODUCT_ID MED_PRODUCT MED_PRODUCT_ID


RX_ORDER_REVIEW



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Review
Definition: Stores the review information for outpatient orders, performed by Retail pharmacist.
Table Type: ACTIVITY





Column Detail - RX_ORDER_REVIEW


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.
ORDER_ID DOUBLE N Order_id from ORDERS table.
ORDER_REVIEW_ID DOUBLE N Unique id for the row
REVIEWED_BY_PRSNL_ID DOUBLE N person_id from PRSNL table. Indicates the personnel performing the review.
REVIEW_ACTION_SEQ_NBR DOUBLE N Last action sequence of the order, from Orders table, at the time order was rejected.
REVIEW_DT_TM DATETIME Y The date/time the review was performed.
REVIEW_REASON_CD DOUBLE N Reason for rejecting the order.
REVIEW_SEQ_NBR DOUBLE N The sequence in which reviews have been performed.
REVIEW_SR_CD DOUBLE N Pharmacy Service Resource from which review has been performed.
REVIEW_TYPE_FLAG DOUBLE N Type of review performed.
REVIEW_TZ DOUBLE N Time zone of the pharmacy reviewing the order.
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 - RX_ORDER_REVIEW


Child Column in RX_ORDER_REVIEW(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
REVIEWED_BY_PRSNL_ID PRSNL PERSON_ID


RX_PENDING_REFILL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Prescription Pending Refill
Definition: Work queue of pending prescriptions that need to be refilled from interactive voice reponse foreign system.
Table Type: ACTIVITY





Column Detail - RX_PENDING_REFILL


Column Name Type Null? Definition
ACTION_PERSONNEL_ID DOUBLE N Action personnel id from the Order_Action table.
ACTION_PROVIDER_ID DOUBLE N Order Provider from order_action table.
ACTION_SEQUENCE DOUBLE Y Action sequence that last modified the script. From the Order_Action table.
AGENT_FULL_NAME VARCHAR(200) Y The full name of the proxy prescriber for the doctoras provided on the prescription.
BATCH_REFILL_DETAIL_STATUS_CD DOUBLE Y Identifies a more detailed status for the batch refill processing
BATCH_REFILL_STATUS_CD DOUBLE Y For a Refill Request that was requested via IVR, it indicates the Overall status of request.
CALLBACK_PHONE_NBR_TXT VARCHAR(50) N Displays the 10-digit phone number entered by the patient.
CALL_DT_TM DATETIME N The date and time the patient made the call.
CLAIM_PROCESS_STATUS_CD DOUBLE Y For a Refill Request that was requested via IVR, it indicates the Status of Claims Processing
CLIN_CHECK_STATUS_CD DOUBLE Y For a Refill Request that was requested via IVR, it indicates the Status of Clinical Checking Business Rules Check.
COMMUNICATION_TYPE_CD DOUBLE N Communication type from the Order_Action table.
COMM_STATUS_CD DOUBLE N Indicates communication status.
CONTROL_SUBSTANCE_FLAG DOUBLE Y identifies the controlled substance schedule for the prescribed drug.
CREDIT_CARD_TXT VARCHAR(50) N Credit card number
DATE_WRITTEN_TXT VARCHAR(50) Y The date the electronic prescription was created
DAW_TXT VARCHAR(100) Y The dispense as written text associated to the electronic prescription
DEA_TXT VARCHAR(200) Y The drug enforcement administration text associated to the electronic prescription
DISPENSE_HX_ID DOUBLE N Dispense_hx_id of the dispense row that is pending to be refilled - primary key of dispense_hx table
DISPENSE_QTY_TXT VARCHAR(50) Y The dispense quantity associated to the electronic prescription
DISP_PRIORITY_CD DOUBLE N Dispensing priority of refill event
DISP_PRIORITY_DT_TM DATETIME N As determined by the Dispense Priority assigned by the interface.
DISP_PRIORITY_TZ DOUBLE N The time zone used in evaluating the Dispense Priority Date/Time.
DISP_SR_CD DOUBLE N Service Resource tied to the pharmacy location dispensing the prescription code. Code set 221
DR_STATUS_CD DOUBLE N Indicates Dr status
EASY_RX_PRIORITY_NBR DOUBLE Y A value indicating the priority of the Easy Script order.
ENCNTR_ID DOUBLE N Refers to the encounter id of the person tied to the refill request.
ESI_LOG_ID DOUBLE N Indicates related ESI_LOG record.
FILL_SR_CD DOUBLE N Service Resource tied to the pharmacy location filling the prescription. Code Set 221.
FORMULARY_STATUS_CD DOUBLE Y Defines the acceptance of this product by the institution.
INTERVENTIONS_FLAG DOUBLE Y Whether an intervention (documentation) has been done or not on prescription orders placed via powerchart.
ITEM_DESC VARCHAR(400) Y The drug description for the electronic prescription
ITEM_NAME VARCHAR(400) Y The drug mnemonic for the electronic prescription
LATEST_AUTH_STATUS_CD DOUBLE N The most recent status for a refill request.
LATEST_NOTIFY_DT_TM DATETIME N Date and time when the doctor was last notified.
MED_SERVICE_CD DOUBLE N Med service code for the Script's encounter, from the Encounter table.
MSG_IDENT_TXT VARCHAR(100) Y The unique identifier assigned to the message by the sender.
MSG_TEXT_ID DOUBLE N The message received from the Rx transaction.
NDC_TXT VARCHAR(200) Y The national drug code associated to the electronic prescription
NOTES_TXT VARCHAR(250) N Notes related to interface transaction.
NOTIFY_CNT DOUBLE N The number of times the doctor was notified that a request has been made for a refill.
NURSE_UNIT_CD DOUBLE N Nurse Unit Code for the Script's encounter, from the Encounter table.
ORDER_COMMENT_IND DOUBLE Y Indicates the existence of order comment.
ORDER_DESC VARCHAR(400) Y The order description for the electronic prescription
ORDER_ID DOUBLE N A unique internal identifier for this order.
ORDER_PRIORITY_CD DOUBLE N oe_field_value, from order_detail table, with oe_field_meaning_id = 141
PATIENT_BIRTH_DT_TXT VARCHAR(50) Y The birth date of the patient associated to the electronic prescription
PATIENT_FIRST_NAME VARCHAR(100) Y The first name of the patient associated to the electronic prescription
PATIENT_GENDER_TXT VARCHAR(50) Y The gender of the patient
PATIENT_LAST_NAME VARCHAR(100) Y The last name of the patient associated to the electronic prescription
PAYMENT_METHOD_CD DOUBLE N Method of payment rendered by the patient.
PERSON_ID DOUBLE N Person id of the refill request
PHARM_CHECK_STATUS_CD DOUBLE Y For a Refill Request that was requested via IVR, it indicates the Status of Pharmacy Refill Business Rules Check.
PHYSICIAN_FIRST_NAME VARCHAR(100) Y The first name of the doctor associated to the electronic prescription
PHYSICIAN_FULL_NAME VARCHAR(200) Y The full name of the doctor associated to the electronic prescription
PHYSICIAN_LAST_NAME VARCHAR(100) Y The last name of the doctor associated to the electronic prescription
PHYSICIAN_ROUTING_SELECTION_CD DOUBLE Y Holds the physician's prescription order mailing preference.
PROJECTED_FILL_DT_TM DATETIME Y Projected date/time when outpatient pharmacy order will be refilled.
REFILL_AUTH_COMM_TYPE_CD DOUBLE Y Identifies how the refill authorization request was communicated
REFILL_NBR_TXT VARCHAR(50) Y The number of refills for the electronic prescription
REFILL_STATUS_CD DOUBLE N Indicates refill status
RENEWAL_FLAG DOUBLE Y Identifies a renewal for a prescription.
RXA_PRESCRIPTION_MSG_ID DOUBLE Y The unique identifier for the electronic prescription message associated to the external prescription
RXA_SUSPEND_ACT_LOG_ID DOUBLE N This is the primary key of rxa_suspend_act_log table. Helps in getting all the suspended activity logs tied to this suspended order.
RX_ACTION_DT_TM DATETIME Y The action that generated the script. From the ORDER_ACTION table.
RX_ACTION_SEQUENCE DOUBLE Y Action sequence that generated the script. From the Order_Action table.
RX_ACTION_TZ DOUBLE Y Action Time Zone of the action that generated the script. From the order_action table.
RX_COMMENT_IND DOUBLE Y Indicates the existence of rx_comment
RX_PENDING_REFILL_ID DOUBLE N Unique id for rx_pending_refill table
SENDER_MSG_IDENT DOUBLE N *** OBSOLETE *** Replaced by MSG_IDENT_TXT.
SHORT_SIG_TXT VARCHAR(400) Y The short version of the patient instructions
SIG_TXT VARCHAR(4000) Y The patient instructions for the electronic prescription
SKIP_LOOK_FORWARD_IND DOUBLE N To deliver medicines through a mailer, system should process early to qualify the orders, and package and transfer through the mailer. Also, if a patient's order got qualified and the same patient is having refill for another order within a close period, we would want to bundle the orders for delivery. SKIP_LOOK_FORWARD_IND will determine whether the qualification should consider these preferences. If SKIP_LOOK_FORWARD_IND is 1, preferences will be considered, else not considered.
SOURCE_TYPE_FLAG DOUBLE N A flag indicating the source of the order.
SUPPLY_FLAG DOUBLE Y Identifies whether the prescription is for a supply item.
SUSPEND_ROUTING_TYPE_CD DOUBLE N To store the specified delivery type of the medicine to the patient on the suspended order in queue. Examples: CMOP Certified Mail, Local Regular Mail, Window (in person)
SUSPEND_STAGE_CD DOUBLE N Stores the stage in which the suspended order is in during the suspend order workflow. System will run a qualification at regular intervals to create batch of orders to be sent to CMOP location, from where the medicines will be packaged and delivered through a mailer to patients. During this process, an order will travel through various points until it reaches the patient. These points are called stages. A stage will help in identifying where the order is currently.
SUSPEND_STATUS_CD DOUBLE N To store the status in which each suspend stage is in during the suspend order workflow.
SUSPEND_STATUS_DETAIL_CD DOUBLE N To store the failure detail type code if suspend status is fail.
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.
XRX_PATIENT_FIRST_NAME_KEY VARCHAR(200) Y For X-Rx orders, this is the Patient's first name with all capitals and punctuation removed. Used for indexing and searching for a Patient first name
XRX_PATIENT_LAST_NAME_KEY VARCHAR(200) Y For X-Rx orders, this is Patient's last name all capitals with punctuation removed. Used for indexing and searching for a Patient by last name



Relationship Detail - RX_PENDING_REFILL


Child Column in RX_PENDING_REFILL(FK) Parent Table Name Parent Column Name
Parents: DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
ESI_LOG_ID ESI_LOG ESI_LOG_ID
NURSE_UNIT_CD LOCATION LOCATION_CD
MSG_TEXT_ID LONG_TEXT LONG_TEXT_ID
ORDER_ID ORDERS ORDER_ID
PERSON_ID PERSON PERSON_ID
RXA_PRESCRIPTION_MSG_ID RXA_PRESCRIPTION_MSG RXA_PRESCRIPTION_MSG_ID
RXA_SUSPEND_ACT_LOG_ID RXA_SUSPEND_ACT_LOG RXA_SUSPEND_ACT_LOG_ID


RX_PERSON



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Person
Definition: Retail Pharmacy person information
Table Type: ACTIVITY





Column Detail - RX_PERSON


Column Name Type Null? Definition
COB_STATUS_CD DOUBLE N Identifies the whether a person accepted/rejected the co-ordination of benefits feature.
GEN_PREF_CD DOUBLE N Identifies if generics are preferred for dispensing
MAILING_PREF_CD DOUBLE N The mailing preference for the medication for this person
PBS_TYPE_OVERRIDE_CD DOUBLE N Only used by Australia. Used to determine proper billing for a patient's order.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
SAFETY_CAP_CD DOUBLE N Indicates a patient's preference for child resistant safety caps.
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 - RX_PERSON


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