Table Detail Report

RX_METHOD_RANGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: PharmNet Method Range
Definition: Contains ranges of values that the Method is valid for. For example, a method might only be valid for use with persons 18 years or older.
Table Type: REFERENCE





Column Detail - RX_METHOD_RANGE


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.
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.
DEMOG_TYPE_FLAG DOUBLE N Flag for determining what type of demographic is stored on this row (age, weight, height, serum creatinine, result )
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.
MAX_VALUE DOUBLE Y The maximum value for the range.
MIN_VALUE DOUBLE Y The minimum value for the range.
RX_METHOD_ID DOUBLE N The method this range is related to.
RX_METHOD_RANGE_ID DOUBLE N Unique generated number that identifies a single row on the RX_METHOD_RANGE table.
RX_METHOD_RANGE_P_ID DOUBLE N Used to group versions of Method Ranges.
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.
VALUE_UOM_CD DOUBLE N The unit code for the given values.



Relationship Detail - RX_METHOD_RANGE


Child Column in RX_METHOD_RANGE(FK) Parent Table Name Parent Column Name
Parents: RX_METHOD_ID RX_METHOD RX_METHOD_ID
RX_METHOD_RANGE_P_ID RX_METHOD_RANGE RX_METHOD_RANGE_ID




Parent Column in RX_METHOD_RANGE (PK) Child Table Name Child Column Name
Children: RX_METHOD_RANGE_ID RX_METHOD_RANGE RX_METHOD_RANGE_P_ID


RX_METHOD_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: PharmNet Method Relation
Definition: One of the calculation types, (Adjusted Body Weight) is dependent on having an Ideal Body Weight. This will let the user specify Ideal Body Weight method they want to use for this calculation.
Table Type: REFERENCE





Column Detail - RX_METHOD_RELTN


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.
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_METHOD_ID DOUBLE N User selected method of performing some formula. If this field contains a zero, the system selected the method.
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.
PARENT_METHOD_ID DOUBLE N A method that can have multiple choices for implementation. Example Adjusted Body Weight.
RX_METHOD_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the RX_METHOD_RELTN table.
RX_METHOD_RELTN_P_ID DOUBLE N Used for grouping versions of a method relation.
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_METHOD_RELTN


Child Column in RX_METHOD_RELTN(FK) Parent Table Name Parent Column Name
Parents: CHILD_METHOD_ID RX_METHOD RX_METHOD_ID
PARENT_METHOD_ID RX_METHOD RX_METHOD_ID
RX_METHOD_RELTN_P_ID RX_METHOD_RELTN RX_METHOD_RELTN_ID




Parent Column in RX_METHOD_RELTN (PK) Child Table Name Child Column Name
Children: RX_METHOD_RELTN_ID RX_METHOD_RELTN RX_METHOD_RELTN_P_ID


RX_PENDING_CHARGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Pending Charge table
Definition: The Pharmacy Pending Charge identifies Medication Administration Record (MAR) events and ingredients that have charges waiting for Pharmacist Verification. Once verified, the Pending charge is either deleted, posted or appears in PhaChargeCredit.
Table Type: ACTIVITY





Column Detail - RX_PENDING_CHARGE


Column Name Type Null? Definition
ACTION_SEQUENCE DOUBLE N Identifies core action sequence of Pharmacy Pending Charge.
ADMIN_DT_TM DATETIME N Identifies administration date/time of Medication Administration event.
ADMIN_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
COMP_SEQUENCE DOUBLE N Identifies component sequence of Pharmacy Pending Charge.
DOSE DOUBLE N Identifies ingredient dose of Medication Administration event.
DOSE_UNIT_CD DOUBLE N Identifies ingredient dose unit of Medication Administration event.
EVENT_ID DOUBLE N Identifies Clinical Event related to Pharmacy Pending Charge.
INGRED_ACTION_SEQ DOUBLE N Identifies ingredient action sequence of Pharmacy Pending Charge.
ORDER_ID DOUBLE N Identifies Orders related to Pharmacy Pending Charge.
PRSNL_ID DOUBLE N Identifies administration personnel of Medication Administration event.
ROUTE_CD DOUBLE N Identifies route of Medication Administration event
RX_PENDING_CHARGE_ID DOUBLE N Unique field for Rx_pending_charge 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.
VALID_UNTIL_DT_TM DATETIME N Identifies when the Clinical Event is valid.



Relationship Detail - RX_PENDING_CHARGE


Child Column in RX_PENDING_CHARGE(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
ACTION_SEQUENCE ORDER_ACTION ACTION_SEQUENCE
ORDER_ID ORDER_ACTION ORDER_ID
PRSNL_ID PRSNL PERSON_ID


RX_PENDING_CHARGE_DELETED



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Pending Charge Deleted
Definition: Replica of rx_pending_charge table. It will hold the values deleted from rx_pending_charge.
Table Type: ACTIVITY





Column Detail - RX_PENDING_CHARGE_DELETED


Column Name Type Null? Definition
ACTION_SEQUENCE DOUBLE Y Identifies core action sequence of Pharmacy Pending Charge.
ADMIN_DT_TM DATETIME Y Identifies administration date/time of Medication Administration event.
ADMIN_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
COMP_SEQUENCE DOUBLE Y Identifies component sequence of Pharmacy Pending Charge.
DOSE DOUBLE Y Identifies ingredient dose of Medication Administration event.
DOSE_UNIT_CD DOUBLE Y Identifies ingredient dose unit of Medication Administration event.
EVENT_ID DOUBLE Y Identifies Clinical Event related to Pharmacy Pending Charge.
INGRED_ACTION_SEQ DOUBLE Y Identifies ingredient action sequence of Pharmacy Pending Charge.
ORDER_ID DOUBLE Y Identifies Orders related to Pharmacy Pending Charge.
PRSNL_ID DOUBLE Y Identifies administration personnel of Medication Administration event.
ROUTE_CD DOUBLE Y Identifies route of Medication Administration event
RX_PENDING_CHARGE_DELETED_ID DOUBLE N Unique generated number that identifies a single row on the RX_PENDING_CHARGE_DELETED table.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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.
VALID_UNTIL_DT_TM DATETIME Y Identifies when the Clinical Event is valid.



Relationship Detail - RX_PENDING_CHARGE_DELETED


Child Column in RX_PENDING_CHARGE_DELETED(FK) Parent Table Name Parent Column Name
Parents: ACTION_SEQUENCE ORDER_ACTION ACTION_SEQUENCE
ORDER_ID ORDER_ACTION ORDER_ID
PRSNL_ID PRSNL PERSON_ID


RX_PENDING_CREDIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Pending Credit
Definition: This table will queue up order information for orders that have been end-stated and need to be processed for potential system crediting. Once a row has been processed successfully, it will get deleted from the table.
Table Type: ACTIVITY





Column Detail - RX_PENDING_CREDIT


Column Name Type Null? Definition
ACTION_EFFECTIVE_DT_TM DATETIME Y Identifies the effective date and time associated with the end stated action. From ORDER_ACTION
ACTION_EFFECTIVE_DT_TM_TZ DOUBLE N Identifies the time zone associated with the action_effective_dt_tm. From ORDER_ACTION
ACTION_SEQUENCE DOUBLE N Identifies the action sequence associated with an end-stated action.
DISPENSE_CATEGORY_CD DOUBLE N Identifies the dispense category code associated with the end stated action. From ORDER_DETAIL
ORDER_ID DOUBLE N Identifies the order associated with an end-stated action.
PATIENT_FACILITY_CD DOUBLE N Identifies the facility code associated with the patient.From ENCOUNTER
PATIENT_NURSE_UNIT_CD DOUBLE N Identifies the nurse unit code associated with the patientFrom ENCOUNTER
RX_PENDING_CREDIT_ID DOUBLE N Unique, generated number that identifies a single row on the RX_PENDING_CREDIT table.
STATUS_FLAG DOUBLE N Indicates the status of each pending credit.
STATUS_REASON_TXT VARCHAR(100) Y Free text description of the reason for the current status.
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_PENDING_CREDIT


Child Column in RX_PENDING_CREDIT(FK) Parent Table Name Parent Column Name
Parents: PATIENT_FACILITY_CD LOCATION LOCATION_CD
PATIENT_NURSE_UNIT_CD LOCATION LOCATION_CD
ACTION_SEQUENCE ORDER_ACTION ACTION_SEQUENCE
ORDER_ID ORDER_ACTION ORDER_ID