Table Detail Report

RXA_ORD_DISP_HP_OBS_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: RXA_ORD_DISP_HP_OBS_ST (summary table)
Definition: This table will store adjudicated health plan nformation per action and per dispense.
Table Type: ACTIVITY





Column Detail - RXA_ORD_DISP_HP_OBS_ST


Column Name Type Null? Definition
ACTION_SEQ DOUBLE N Action_Sequence from order_action table
DISPENSE_HX_ID DOUBLE N Dispense_hx_id from Dispense_hx table
DISP_FROM_SR_CD DOUBLE N Service_Resource_Cd from Service_Resource table
ORDER_ID DOUBLE N Order_id from orders table
ORD_DISP_HP_ID DOUBLE N Unique number per Row. NOTE: Will use sequence PHA_RANGE_SEQ.
RXA_AUTH_NBR_TXT VARCHAR(250) N Authorization number received from health plan
RXA_CLAIM_FLAG DOUBLE N Indicates whether the current fill has been claimed -1,"None",0,"Non-Adjudicated",1,"Adjudicated"
RXA_CLAIM_ID DOUBLE N Rx_claim_id from rx_claim table
RXA_CLAIM_STATUS_CD DOUBLE N Indicates the status of the claim transaction for current health plan
RXA_COPAY_AMT DOUBLE N Copay amount specified by the health plan
RXA_DUR_IND DOUBLE N Indicates whether health plan performed drug utilization review
RXA_HEALTH_PLAN_ID DOUBLE N The health plan used for this prescription
RXA_HEALTH_PLAN_SEQ DOUBLE N The sequence of the health plan in the list of health plans used for this prescription
RXA_LEVEL5_CD DOUBLE N The work station that requested the event
RXA_MANUAL_OVERRIDE_IND DOUBLE N indicates whether user manually overrode the claim status or not. 0 - no manual override 1 - manual override
RXA_PF_TYPE_CD DOUBLE N Indicates if a health plan supports NCPDP 51 partial fill submission process.
RXA_PRIOR_AUTH_NBR_TXT VARCHAR(250) N health plan's prior authorization number
RXA_PRIOR_AUTH_TYPE_CD DOUBLE N health plan's prior authorization type code
RXA_REIMB_AMT DOUBLE N Reimbursement amount received from health plan
RXA_SWITCH_CD DOUBLE N Switch used for Claim submission
RXA_TRANS_DT_TM DATETIME Y Transaction Date/Time for the claim
RXA_TRANS_DT_TZ DOUBLE N Transaction time zone for the claim
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 - RXA_ORD_DISP_HP_OBS_ST


Child Column in RXA_ORD_DISP_HP_OBS_ST(FK) Parent Table Name Parent Column Name
Parents: DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
RXA_HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
ORDER_ID ORDERS ORDER_ID
RXA_CLAIM_ID RX_CLAIM RX_CLAIM_ID
DISP_FROM_SR_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


RXA_PRESCRIPTION_MSG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Ambulatory Prescription Message
Definition: Stores various Surescript messages for New Prescriptions (NewRx), Refill Requests (RefReq), Refill Responses (RefRes), Verify, Status, and Error messages.
Table Type: ACTIVITY





Column Detail - RXA_PRESCRIPTION_MSG


Column Name Type Null? Definition
CONTROL_SUBSTANCE_CLASS_FLAG DOUBLE N Identifies the controlled substance schedule for the prescribed drug
CREATE_DT_TM DATETIME Y The date and time when the row was inserted
DIGITAL_SIGNATURE_FLAG DOUBLE N Identifies whether the prescription has been digitally signed
DRUG_NAME VARCHAR(300) Y Drug name contained in the message
MSG_CLOB LONGTEXT Y Prescription message text that pertains to a specific transaction type
MSG_DOCTOR_SPI_TXT VARCHAR(50) Y The doctor's Surescripts Provider Identifier contained in the message
MSG_FORMAT_TYPE_CD DOUBLE N Identifies the format type of the message
MSG_IDENT VARCHAR(100) Y The identifier assigned to the message by the sender which can be external or internal to our system. For externally received messages, our system will append the prescriber SPI to the end of the message identifier separated by an underscore. The orig_msg_ident column will only contain the message identifier with no value appended to it.
MSG_NABP_TXT VARCHAR(50) Y The pharmacy's NABP number contained in the message
ORIG_MSG_IDENT VARCHAR(100) Y The identifier assigned to the message by the sender which can be external or internal to our system
PATIENT_FIRST_NAME VARCHAR(100) Y First name of the patient contained in the message
PATIENT_LAST_NAME VARCHAR(100) Y Last name of the patient contained in the message
PHYSICIAN_DEA_TXT VARCHAR(50) Y The doctor's Drug Enforcement Administration number contained in the message
PHYSICIAN_FIRST_NAME VARCHAR(100) Y First name of the doctor contained in the message
PHYSICIAN_LAST_NAME VARCHAR(100) Y Last name of the doctor contained in the message
PHYSICIAN_NPI_TXT VARCHAR(50) Y The doctor's National Provider Identifier contained in the message
REF_RXA_PRESCRIPTION_MSG_ID DOUBLE N Identifies the reference prescription message identifier that this row relates to
RXA_PRESCRIPTION_MSG_ID DOUBLE N Unique generated number that identifies a single row on the RXA_PRESCRIPTION_MSG table.
RX_MSG_REQUEST_TYPE_CD DOUBLE N Identifies a specific prescription message request type (ie. Generic Substitution, Prior Authorization, Therapeutic Interchange, Drug Usage Evaluation, Script Clarification, Out of Stock, Prescriber Authorization, etc)
RX_MSG_TRANS_TYPE_CD DOUBLE N Identifies the transaction type of the message (ie. NEWRX, REFREQ, REFRES, ERROR, STATUS, VERIFY)
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 - RXA_PRESCRIPTION_MSG


Child Column in RXA_PRESCRIPTION_MSG(FK) Parent Table Name Parent Column Name
Parents: REF_RXA_PRESCRIPTION_MSG_ID RXA_PRESCRIPTION_MSG RXA_PRESCRIPTION_MSG_ID




Parent Column in RXA_PRESCRIPTION_MSG (PK) Child Table Name Child Column Name
Children: RXA_PRESCRIPTION_MSG_ID ORDER_DISPENSE RXA_PRESCRIPTION_MSG_ID
RXA_PRESCRIPTION_MSG REF_RXA_PRESCRIPTION_MSG_ID
RX_PENDING_REFILL RXA_PRESCRIPTION_MSG_ID
RX_REFILL_HX RXA_PRESCRIPTION_MSG_ID
RX_REFILL_TRACK_HX REQUEST_MSG_ID
RX_REFILL_TRACK_HX RXA_PRESCRIPTION_MSG_ID


RXA_PRESCRIPTION_MSG_HX



Column Section Top of Page


Table-level Detail

Description: Pharmacy Outpatient Prescription Message History
Definition: Stores prescription message history information
Table Type: ACTIVITY





Column Detail - RXA_PRESCRIPTION_MSG_HX


Column Name Type Null? Definition
CONTROL_SUBSTANCE_CLASS_FLAG DOUBLE N Identifies the controlled substance schedule for the prescribed drug
CREATE_DT_TM DATETIME Y The date and time when the row was inserted
DIGITAL_SIGNATURE_FLAG DOUBLE N Identifies whether the prescription has been digitally signed
DRUG_NAME VARCHAR(300) Y Drug name contained in the message
MSG_CLOB LONGTEXT Y Prescription message text that pertains to a specific transaction type
MSG_DOCTOR_SPI_TXT VARCHAR(50) Y The doctor's Surescripts Provider Identifier contained in the message
MSG_FORMAT_TYPE_CD DOUBLE N Identifies the format type of the message
MSG_IDENT VARCHAR(100) Y The identifier assigned to the message by the sender which can be external or internal to our system. For externally received messages, our system will append the prescriber SPI to the end of the message identifier separated by an underscore. The orig_msg_ident column will only contain the message identifier with no value appended to it.
MSG_NABP_TXT VARCHAR(50) Y The pharmacy's NABP number contained in the message
ORIG_MSG_IDENT VARCHAR(100) Y The identifier assigned to the message by the sender which can be external or internal to our system.
PATIENT_FIRST_NAME VARCHAR(100) Y First name of the patient contained in the message
PATIENT_LAST_NAME VARCHAR(100) Y Last name of the patient contained in the message
PHYSICIAN_DEA_TXT VARCHAR(50) Y The doctor's Drug Enforcement Administration number contained in the message
PHYSICIAN_FIRST_NAME VARCHAR(100) Y First name of the doctor contained in the message
PHYSICIAN_LAST_NAME VARCHAR(100) Y Last name of the doctor contained in the message
PHYSICIAN_NPI_TXT VARCHAR(50) Y The doctor's National Provider Identifier contained in the message
REF_RXA_PRESCRIPTION_MSG_ID DOUBLE N Identifies the reference prescription message identifier that this row relates to
RXA_PRESCRIPTION_MSG_HX_ID DOUBLE N Unique generated number that identifies a single row on the RXA_PRESCRIPTION_MSG_HX table.
RXA_PRESCRIPTION_MSG_ID DOUBLE N Unique generated number that identified a single row on the rxa_prescription_msg table before moving to the history table
RX_MSG_TRANS_TYPE_CD DOUBLE N Identifies the transaction type of the message (ie. NEWRX, REFREQ, REFRES, ERROR, STATUS, VERIFY)
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.


RXA_SERVICE



Column Section Top of Page


Table-level Detail

Description: PharmNet Ambulatory Service
Definition: Stores parameters for retail application services.
Table Type: ACTIVITY





Column Detail - RXA_SERVICE


Column Name Type Null? Definition
ACCOUNT_TXT VARCHAR(255) Y Account number of the service.
GROUPID_TXT VARCHAR(255) Y Group ID of all the NABPs that this Service services.
IP_TXT VARCHAR(255) Y IP Address the Service connects to.
NABP_TXT VARCHAR(255) Y The name of the NABP(s) serviced by this Service.
NAME_TXT VARCHAR(255) N Name of the application service.
PORT_TXT VARCHAR(255) Y Port the service connects to.
PROTOCOL_TXT VARCHAR(255) Y Protocol the service connects to.
RXA_SERVICE_ID DOUBLE N Unique, generated number that identifies a single row on the RXA_SERVICE 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.


RXA_SUSPEND_ACT_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Outpatient Pharmacy Suspend Activity Log
Definition: Stores the activities that were taken on suspended orders
Table Type: ACTIVITY





Column Detail - RXA_SUSPEND_ACT_LOG


Column Name Type Null? Definition
ACT_DT_TM DATETIME Y The date/time at which each activity log row is recorded/added to the table.
DISPENSE_HX_ID DOUBLE N The dispense row that is pending to be refilled. This can be 0 when the refill action has not been initiated on the order.
ORDER_ID DOUBLE N The order id tied to the fill request. This can be 0.
ORIG_RXA_SUSPEND_ACT_LOG_ID DOUBLE N The unique identifier to the RXA_SUSPEND_ACT_LOG table. Identifies the initial log entry to link together ones that are part of a group.
RXA_SUSPEND_ACT_LOG_ID DOUBLE N Unique generated number that identifies a single row on the RXA_SUSPEND_ACT_LOG table.
SUSPEND_ACT_SEQ DOUBLE N A number that identifies the sequence of activities performed on a particular suspended refill request.
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 The code value (Code set 4636007) representing the status detail of the suspended order within the current stage during the suspend order workflow. This can be 0, when there is no additional detail for the current stage. Ex: Cancel Back, Claim Failure Cancel, Pending Fulfillment
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 - RXA_SUSPEND_ACT_LOG


Child Column in RXA_SUSPEND_ACT_LOG(FK) Parent Table Name Parent Column Name
Parents: DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
ORDER_ID ORDERS ORDER_ID
ORIG_RXA_SUSPEND_ACT_LOG_ID RXA_SUSPEND_ACT_LOG RXA_SUSPEND_ACT_LOG_ID




Parent Column in RXA_SUSPEND_ACT_LOG (PK) Child Table Name Child Column Name
Children: RXA_SUSPEND_ACT_LOG_ID RXA_SUSPEND_ACT_LOG ORIG_RXA_SUSPEND_ACT_LOG_ID
RXA_SUSPEND_ACT_LOG_DTL RXA_SUSPEND_ACT_LOG_ID
RX_PENDING_REFILL RXA_SUSPEND_ACT_LOG_ID
RX_REFILL_HX RXA_SUSPEND_ACT_LOG_ID