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 |