Table Detail Report

RX_MED_ORD_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Medical Order Detail
Definition: For an item, facility, age range combination, contains a row for each order entry detail that options are defined for.
Table Type: REFERENCE





Column Detail - RX_MED_ORD_DETAIL


Column Name Type Null? Definition
FACILITY_CD DOUBLE N The facility that options are defined for.
ITEM_ID DOUBLE N The item that options are provided for.
OE_FIELD_MEANING_ID DOUBLE N The order entry field that options are defined for.
RESTRICT_IND DOUBLE N Indicates if the value stored on the row is to be a restriction to the order entry application.
RX_AGE_RANGE_ID DOUBLE N The age range that options are being created for.
RX_MED_ORD_DETAIL_ID DOUBLE N Unique generated number that identifies a single row on the RX_MED_ORD_DETAIL table.
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_MED_ORD_DETAIL


Child Column in RX_MED_ORD_DETAIL(FK) Parent Table Name Parent Column Name
Parents: FACILITY_CD LOCATION LOCATION_CD
ITEM_ID MEDICATION_DEFINITION ITEM_ID
OE_FIELD_MEANING_ID OE_FIELD_MEANING OE_FIELD_MEANING_ID
RX_AGE_RANGE_ID RX_AGE_RANGE RX_AGE_RANGE_ID




Parent Column in RX_MED_ORD_DETAIL (PK) Child Table Name Child Column Name
Children: RX_MED_ORD_DETAIL_ID RX_MED_ORD_DETAIL_OPT RX_MED_ORD_DETAIL_ID


RX_MED_ORD_DETAIL_OPT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Medical Order Detail Option
Definition: Valid options for an order detail of an item at a facility for an age range.
Table Type: REFERENCE





Column Detail - RX_MED_ORD_DETAIL_OPT


Column Name Type Null? Definition
DEFAULT_IND DOUBLE N Indicates that this row is to be used for the default.
DISPLAY_SEQ DOUBLE N Order in which the detail options are to be displayed.
OPT_CD DOUBLE N If the option is from a code set, this field will be populated. For example, if the order entry field is Route, then this will contain a value from code set 4001.
OPT_NBR DOUBLE N This will be used for options that are numeric in nature.Example: Dose
OPT_TXT VARCHAR(100) N This will be used for options that are textual in nature.Example: Free-text Dose
RX_MED_ORD_DETAIL_ID DOUBLE N Refers to the field that this option is defined for.
RX_MED_ORD_DETAIL_OPT_ID DOUBLE N Unique generated number that identifies a single row on the RX_MED_ORD_DETAIL_OPT 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.



Relationship Detail - RX_MED_ORD_DETAIL_OPT


Child Column in RX_MED_ORD_DETAIL_OPT(FK) Parent Table Name Parent Column Name
Parents: RX_MED_ORD_DETAIL_ID RX_MED_ORD_DETAIL RX_MED_ORD_DETAIL_ID


RX_MED_REQUEST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Medication Request
Definition: Stores order request information (missing medication, scan failure, low quantity) for pharmacy to process
Table Type: ACTIVITY





Column Detail - RX_MED_REQUEST


Column Name Type Null? Definition
ORDER_ID DOUBLE N The order associated to the medication request
REQUEST_DT_TM DATETIME N The time the medication request was initiated
REQUEST_PRIORITY_CD DOUBLE N The priority of the medication request
REQUEST_PRSNL_ID DOUBLE N The personnel who requested the medication
REQUEST_REASON_CD DOUBLE N Describes why the medication request was initiated
REQUEST_REASON_LONG_TEXT_ID DOUBLE N Refers to an entry in long_text table which can additionally be provided by the user when a medication is request. Can be 0.0, if the user does not provide additional free text reason.
REQUEST_TZ DOUBLE N The time zone when the medication request was initiated
RX_ACTION_CD DOUBLE N Code to represent how the pharmacist acted on the med request (accept/decline/mark as duplicate)
RX_ACTION_DT_TM DATETIME N Date and time when a pharmacist acted on a medication request (accept/decline)
RX_ACTION_PRSNL_ID DOUBLE N Personnel ID of the user who acted on the medication request (accept/decline)
RX_ACTION_TZ DOUBLE N Time zone when a pharmacist acted on a medication request (accept/decline)
RX_MED_REQUEST_ID DOUBLE N Unique generated number that identifies a single row on the RX_MED_REQUEST table.
RX_REASON_CD DOUBLE N Codified reason select by the pharmacist after acting on a medication request (accept/decline)
RX_REASON_LONG_TEXT_ID DOUBLE N Free-text comment entered by the pharmacist after acting on a medication request (accept/decline)
RX_STATUS_CD DOUBLE N Code for the status the medication request is currently in
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_MED_REQUEST


Child Column in RX_MED_REQUEST(FK) Parent Table Name Parent Column Name
Parents: REQUEST_REASON_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
RX_REASON_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
ORDER_ID ORDERS ORDER_ID
REQUEST_PRSNL_ID PRSNL PERSON_ID
RX_ACTION_PRSNL_ID PRSNL PERSON_ID


RX_METHOD



Column Section Relationship Section Top of Page


Table-level Detail

Description: PharmNet Method
Definition: Header table for methods of calculating demographic values. Examples: Body Surface Area, Creatinine Clearance, Adjusted/Ideal body Weight
Table Type: REFERENCE





Column Detail - RX_METHOD


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.
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.
LONG_TEXT_ID DOUBLE N User-entered data. Example s: the name of the Study that came up with the method, explanation of the calculation.
METHOD_CD DOUBLE N The Code value will contain the method name and description as well as a CDF_MEANING identifying its type i.e. BSA.
RX_METHOD_ID DOUBLE N Unique generated number that identifies a single row on the rx_method table.
RX_METHOD_P_ID DOUBLE N Used for grouping of versions of RX_METHODs.
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


Child Column in RX_METHOD(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
RX_METHOD_P_ID RX_METHOD RX_METHOD_ID




Parent Column in RX_METHOD (PK) Child Table Name Child Column Name
Children: RX_METHOD_ID RX_FORMULA RX_METHOD_ID
RX_METHOD RX_METHOD_P_ID
RX_METHOD_FAC_RELTN RX_METHOD_ID
RX_METHOD_RANGE RX_METHOD_ID
RX_METHOD_RELTN CHILD_METHOD_ID
RX_METHOD_RELTN PARENT_METHOD_ID


RX_METHOD_FAC_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: PharmNet Facility Method Relation
Definition: Relates the Methods to the facilities they can be used at.
Table Type: REFERENCE





Column Detail - RX_METHOD_FAC_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.
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.
FACILITY_CD DOUBLE N The facility the method is used at.
METHOD_MEANING VARCHAR(12) N CDF meaning for the Method related to this facility. Denormalized data used to speed access to all methods of a certain type for a facility.
METHOD_SEQ DOUBLE N Sequences methods with a facility. A user can establish a precedence of what methods should be evaluated first when attempting to perform a calculation.
RX_METHOD_FAC_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the RX_METHOD_FAC_RELTN table.
RX_METHOD_FAC_RELTN_P_ID DOUBLE N Used for grouping versions of Method Facility Relations.
RX_METHOD_ID DOUBLE N The method this facility is related to.
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_FAC_RELTN


Child Column in RX_METHOD_FAC_RELTN(FK) Parent Table Name Parent Column Name
Parents: RX_METHOD_ID RX_METHOD RX_METHOD_ID
RX_METHOD_FAC_RELTN_P_ID RX_METHOD_FAC_RELTN RX_METHOD_FAC_RELTN_ID




Parent Column in RX_METHOD_FAC_RELTN (PK) Child Table Name Child Column Name
Children: RX_METHOD_FAC_RELTN_ID RX_METHOD_FAC_RELTN RX_METHOD_FAC_RELTN_P_ID