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 |