Table Detail Report

RXA_SUSPEND_ACT_LOG_DTL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Outpatient Pharmacy Suspend Activity Log Detail
Definition: Stores the failure reasons that occur when a suspended order moves to various stages.
Table Type: ACTIVITY





Column Detail - RXA_SUSPEND_ACT_LOG_DTL


Column Name Type Null? Definition
ACTIVITY_DTL_CD DOUBLE N The code value (Code set 4296005) representing the activity 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.
ACT_DTL_DT_TM DATETIME Y The date/time at which each activity detail row was added or modified.
DTL_SEQ DOUBLE N A number that identifies the sequence of failure details recorded during a suspend activity for a stage.
REASON_TXT VARCHAR(250) Y To document the detail/reason that is not mapped to detail code value in the refill workqueue batch detail status codeset (code set 4296005)
RXA_SUSPEND_ACT_LOG_DTL_ID DOUBLE N Unique generated number that identifies a single row on the RXA_SUSPEND_ACT_LOG_DTL table.
RXA_SUSPEND_ACT_LOG_ID DOUBLE N The activity taken on a suspended order.
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_DTL


Child Column in RXA_SUSPEND_ACT_LOG_DTL(FK) Parent Table Name Parent Column Name
Parents: RXA_SUSPEND_ACT_LOG_ID RXA_SUSPEND_ACT_LOG RXA_SUSPEND_ACT_LOG_ID


RXA_WORK_LOAD_OBS_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: RXA_WORK_LOAD_OBS_ST (Summary Table)
Definition: This table will store retail work load information
Table Type: ACTIVITY





Column Detail - RXA_WORK_LOAD_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
DISPENSE_STATUS_HX_ID DOUBLE N Dispense_Status_hx_id from Dispense_Status_hx table
DISP_FROM_SR_CD DOUBLE N Service_Resource_Cd from Service_Resource table
ORDER_ID DOUBLE N Order_id from orders table
RXA_LEVEL5_CD DOUBLE N work station that requested the event
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.
WORK_DT_TM DATETIME Y IF work_type is order_action, this date will be set to action_dt_tm (from pha_ord_act_obs_st table). If work_type is dispense_hx, this date will be set to disp_priority_dt_tm (from pha_disp_obs_st table) IF work_type is dispense tracking, this date will be set to completed_dt_tm (from dispense_status_hx table)
WORK_DT_TZ DOUBLE N Work time zone for work_dt_tm. For inpatient rows, this is the time zone of the encounter. For Retail Pharmacy, it is the time zone of the pharmacy's facility.
WORK_LOAD_ID DOUBLE N Unique number per Row. NOTE: Will use sequence PHA_RANGE_SEQ
WORK_TYPE_CD DOUBLE N If the type of work is an Order-Action, then it would come from codeset 6003 If type of work is a dispense event, then it would come from codeset 4032 If type of work is a dispense tracking step, then it would come from codeset 4502.
WORK_TYPE_CS_FLAG DOUBLE N Valid values are 6003, 4032, 4502
WORK_USER_ID DOUBLE N IF work_type is order_action, this field will be set to action_prsnl_id (from pha_ord_act_obs_st table). If work_type is dispense_hx, this field will be set to run_user_id (from pha_disp_obs_st table) IF work_type is dispense tracking, this field will be set to completed_user_id (from dispense_status_hx table)



Relationship Detail - RXA_WORK_LOAD_OBS_ST


Child Column in RXA_WORK_LOAD_OBS_ST(FK) Parent Table Name Parent Column Name
Parents: DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
DISPENSE_STATUS_HX_ID DISPENSE_STATUS_HX DISPENSE_STATUS_HX_ID
ORDER_ID ORDERS ORDER_ID
WORK_USER_ID PRSNL PERSON_ID
DISP_FROM_SR_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


RXNBR_STATUS_R



Column Section Top of Page


Table-level Detail

Description: RXNBR STATUS R
Definition: rxnbr_status_r - Relates a Pharmacy_range to a Legal_status and Rx Nbr Prefix.
Table Type: REFERENCE





Column Detail - RXNBR_STATUS_R


Column Name Type Null? Definition
LEGAL_STATUS_CD DOUBLE N Legal Status Code value
RANGE_ID DOUBLE N Range id
RXNBR_CD DOUBLE N Rx 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.


RX_CLAIM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rx Claim
Definition: Table used to store the claims information.
Table Type: ACTIVITY





Column Detail - RX_CLAIM


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_IDENT_TXT VARCHAR(50) N Unique identifier of activity within a claim/prior request.
ADDL_DRUG_IDENT_VALUE_TXT VARCHAR(255) Y Identifies a drug other than NDC that is required for non-US clients to send in as part of a claim.
ATTACHMENT_BLOB_ID DOUBLE N Stores the Long_blob_id of the attachment blob data attached during a transaction
ATTACHMENT_NAME VARCHAR(100) N Stores the name of the attachment file sent during a transaction
AUTHORIZATION_IDENT_TXT VARCHAR(50) N This column holds the value of pre-generated authorization ID that will be sent for pharmacy prior request transactions. The unique identifier assigned by the health provider to identify the Authorization; must be globally unique and start with EncounterFacilityID followed by a unique identifier assigned by the facility information system, followed by date/time of the transaction.
AUTHORIZATION_NBR_TXT VARCHAR(50) Y Authorization number for claims
CARD_HOLDER_IDENT VARCHAR(100) N The member number of the subscriber to the health plan.
CLAIM_FORMAT_CD DOUBLE N Format used in building the Message string, containing the claims information, that is sent in the transaction.
CLAIM_FORMAT_TYPE_CD DOUBLE N Claim Format type cd
CLAIM_SEQ DOUBLE Y When multiple claims are submitted in one transaction, sequence indicates the position of a particular claim within the transaction.
CLAIM_STATUS_CD DOUBLE N Status of claim
CLAIM_TEXT_ID DOUBLE N Message string containing claims information that is sent in the transaction.
CLAIM_TRANS_CD DOUBLE N Type of claims transaction.
COMMENT_CD DOUBLE N Stores the Code value of the Predefined comment from Reason codes codeset# 4031 (with event type of Internal Complaint)
COMMENT_TXT_ID DOUBLE N stores the long_text_id of the free textComment entered by user in Internal complaint, Upto 1000 Characters need to be supported
COPAY_AMT DOUBLE N Copay amount of dispense transaction
DENIED_CD DOUBLE N Stores the code value of Denied Code that came back during a prior authorization response from payer
DISPENSE_HX_ID DOUBLE N dispense hx id
DUR_IND DOUBLE Y This field indicates the presence of DUR (Drug Utilization Review) information in the response record from the Health Plan (i.e. Medicaid). This piece of the response record contains various Health Plan specific information with regards to the drug prescribed. The DUR information is only returned within a Claim Process.
HEALTH_PLAN_ID DOUBLE N Health Plan ID
LEVEL5_CD DOUBLE N Location of the Workstation (PC) that was used in filling the prescription.
MANUAL_ADJUDICATED_IND DOUBLE N Indicates whether the adjudication is manual or electronic. 0 - Electronic, 1 - Manual
MANUAL_OVERRIDE_AUTH_NAME VARCHAR(250) Y Free Text name of the personnel who authorized manual override
MANUAL_OVERRIDE_IND DOUBLE N Indicates whether user manually overrode the claim status or not. 0 - No manual override 1 - Manual override
MANUAL_OVERRIDE_NOTE_TXT VARCHAR(250) Y Any additional notes related to manual override entered by the user.
MANUAL_OVERRIDE_REASON_CD DOUBLE N Reason for the manual override.
ORIG_CLAIM_STATUS_CD DOUBLE N Status of claim on previous attempt. Applicable only when a claim submission is attempted more than once.
PRE_OVERRIDE_CLAIM_STATUS_CD DOUBLE Y Claim status that was received from the switch before the status was automatically overridden by the system
PRINT_FLAG DOUBLE N Determines whether rejected Claim Labels should print or not.
REIMBURSEMENT_AMT DOUBLE N Reimbursement amount for this dispense transaction
RESEND_ACTIVITY_IDENT_TXT VARCHAR(50) N Stores the activity_ident_txt for the activities to be resent under new prior-request authorization transaction
RESEND_AUTH_IDENT_TXT VARCHAR(50) N Stores the authorization_ident_txt under which the Activities will be resent for Prior request authorization transaction
RESEND_ORDERED_DT_TM DATETIME Y Stores the date and time for resending the activities(orders) under new prior request authorization transaction
RESEND_ORDERED_TZ DOUBLE N Stores the time zone in which the ordered_dt will be sent for resend prior request authorization transaction
RESPONSE_TEXT_ID DOUBLE N Message string containing response fort he submitted claim transaction.
RX_CLAIM_ID DOUBLE N Unique ID per claim
SKIP_COB_REASON_CD DOUBLE N Reason for skipping the Coordination of Benefit process.
SUBSECTION_CD DOUBLE N Location of the pharmacy that filled the prescription.
SWITCH_CD DOUBLE N Switch to which the claim transaction was sent.
SYSTEM_ERROR_CD DOUBLE N DO NOT USE - use system_err_cd instead
SYSTEM_ERR_CD DOUBLE N Error, if any, encountered during claim submission.
TRANSACTION_NBR DOUBLE N Stores the auto generated ID of a HAAD Transaction that happens on an authorization. This will be non-unique as multiple claim records can share a single transaction_id. Value from sequence rx_claim_seq
TRANS_DT_TM DATETIME Y Date this transaction was created.
TRANS_TZ DOUBLE N Time zone for the claim transaction
UNCLAIMED_IND DOUBLE Y Identifies if this claim was ever in an unclaimed status.
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_CLAIM


Child Column in RX_CLAIM(FK) Parent Table Name Parent Column Name
Parents: DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
ATTACHMENT_BLOB_ID LONG_BLOB LONG_BLOB_ID
CLAIM_TEXT_ID LONG_TEXT LONG_TEXT_ID
COMMENT_TXT_ID LONG_TEXT LONG_TEXT_ID
RESPONSE_TEXT_ID LONG_TEXT LONG_TEXT_ID




Parent Column in RX_CLAIM (PK) Child Table Name Child Column Name
Children: RX_CLAIM_ID RXA_ORD_DISP_HP_OBS_ST RXA_CLAIM_ID
RX_CLAIM_RESPONSE RX_CLAIM_ID
RX_INPT_CLAIM_HX OP_RX_CLAIM_ID


RX_CLAIM_AUTH_ALERT_LOG



Column Section Top of Page


Table-level Detail

Description: Pharmacy Claim Authorization Alert Log
Definition: Table used to record error and warnig messagess for authorization alerts to HAAD
Table Type: ACTIVITY





Column Detail - RX_CLAIM_AUTH_ALERT_LOG


Column Name Type Null? Definition
ADDL_REFERENCE_TXT VARCHAR(150) N Reference pertaining to the object that has warning or error associated.
ALERT_CD DOUBLE N Field will house code value representing ALERT_IDENT_TXT from code set 4003364 and 4003365.
ALERT_IDENT_TXT VARCHAR(12) N Contains an alert identifier from a foreign system.
AUTHORIZATION_IDENT_TXT VARCHAR(100) N This column holds the value of pre-generated authorization ID that will be sent for pharmacy prior request transactions. The unique identifier assigned by the health provider to identify the Authorization; must be globally unique and start with EncounterFacilityID followed by a unique identifier assigned by the facility information system, followed by date/time of the transaction.Authorization identifier for multiple claim/activity rows in rx_claim table.
FIELD_NAME VARCHAR(50) N The field of the object that has warning or error associated
FIELD_VALUE VARCHAR(50) N Value that was set in the field identified by field column.
MESSAGE_TXT VARCHAR(300) N Text explaining the error or warning.
MESSAGE_TYPE_FLAG DOUBLE N Identifies if information is for Error or Warning when any data is received upon upload of the transaction. 0 - Success, 1 - Error, and 2 - Warning
OBJECT_NAME VARCHAR(15) N Identifies if issue is with activity or authorization part or the transaction.
RX_CLAIM_AUTH_ALERT_LOG_ID DOUBLE N Unique generated number that identifies a single row on the rx_claim_auth_alert_resp table.
TRANSACTION_NBR DOUBLE N The transaction sequence associated with this authorization. The highest transaction number indicates active transaction for the authorization.
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.