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