Table Detail Report

ORDER_REVIEW_ATTRIBUTE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Review Attribute
Definition: Stores attributes associated with order reviews.
Table Type: ACTIVITY





Column Detail - ORDER_REVIEW_ATTRIBUTE


Column Name Type Null? Definition
ACTION_SEQUENCE DOUBLE Y The value to identifiy which action sequence created the row.
ATTRIBUTE_TYPE_FLAG DOUBLE Y The type to identifiy which attribute the row is for. 0 - Undefined, 1 - Pharmacy Verify Override Reason.
ATTRIBUTE_VALUE DOUBLE Y The numeric value of the attribute.
ATTRIBUTE_VALUE_TXT VARCHAR(250) Y The string value of the attribute.
ORDER_ID DOUBLE Y The ID of the associated order.
ORDER_REVIEW_ATTRIBUTE_ID DOUBLE N Unique generated number that identifies a single row on the ORDER_REVIEW_ATTRIBUTE table.;
REVIEW_SEQUENCE DOUBLE Y The value to identifiy which review sequence created the row.
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.



Relationship Detail - ORDER_REVIEW_ATTRIBUTE


Child Column in ORDER_REVIEW_ATTRIBUTE(FK) Parent Table Name Parent Column Name
Parents: ACTION_SEQUENCE ORDER_REVIEW ACTION_SEQUENCE
ORDER_ID ORDER_REVIEW ORDER_ID
REVIEW_SEQUENCE ORDER_REVIEW REVIEW_SEQUENCE


ORDER_REVIEW_DECISION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Review Decision
Definition: This table will store the history of decisions made to determine the need of an order review.
Table Type: ACTIVITY





Column Detail - ORDER_REVIEW_DECISION


Column Name Type Null? Definition
ACTION_SEQUENCE DOUBLE N The sequence of the order action which is associated to the order review decision. When paired with the order_id it points back to the row in the order_action table that this decision is associated with.
DECIDING_PRSNL_ID DOUBLE N When the source is User, this ID represents the personnel who made the review decision. When the source is System, this ID represents the personnel who directed the system to make the review decision. This field will be 0 when the system, by default, makes the review decision without a user directing it to do so.
DECISION_REASON_CD DOUBLE N The codified value representing reason of the decision. A reason may be associated to decision with a source of User; however, system determined decisions will not be accompanied with a reason (will be 0).
DECISION_SEQUENCE DOUBLE N The sequence of the review decision which represents the progression of decision made for a given order action. This value will always be unique for a given order_id, action_sequence, and review_type_flag.
DECISION_SOURCE_FLAG DOUBLE N The source of the decision. The source can either be the System (1) or by a User (2).
DECISION_VALUE_FLAG DOUBLE N The value of the decision. A decision value can either be Not Require Review (1) or Require Review (2).
ORDER_ID DOUBLE N The identifier of the order which is associated to the review decision.
ORDER_REVIEW_DECISION_ID DOUBLE N The primary key of this table. It is internally assigned by the system.
REVIEW_TYPE_FLAG DOUBLE N The type of review which the decision was made for. Currently, the only applicable type of review is Doctor Co-sign (2).
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 - ORDER_REVIEW_DECISION


Child Column in ORDER_REVIEW_DECISION(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
DECIDING_PRSNL_ID PRSNL PERSON_ID


ORDER_RX_SCRATCHPAD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Prescription Scratchpad
Definition: Contains prescription scratchpad orders.
Table Type: ACTIVITY





Column Detail - ORDER_RX_SCRATCHPAD


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.
CATALOG_CD DOUBLE N The coded value for the order catalog for this order.
COMMENT_LONG_TEXT_ID DOUBLE N Relates this record to a specific long_text record . It is a foreign key reference to the primary key of the long_text table.
DISPENSE_AS_WRITTEN_IND DOUBLE N Indicates if the prescription scratchpad order should be dispensed as written.
DISPENSE_QUANTITY DOUBLE N The dispense quantity of the prescription scratchpad order.
DISPENSE_QUANTITY_UNIT_CD DOUBLE N The dispense quantity unit code value of the prescription scratchpad order.
DOCUMENTED_IND DOUBLE N Indicates if the prescription scratchpad order is documented.
DOSE DOUBLE N The dose of the prescription scratchpad order.
DOSE_UNIT_CD DOUBLE N The dose unit code value of the prescription scratchpad order.
DURATION DOUBLE N The duration of the prescription scratchpad order.
DURATION_UNIT_CD DOUBLE N The duration unit code value of the prescription scratchpad order.
FREETEXT_DOSE VARCHAR(1024) Y The free text dose of the prescription scratchpad order.
FREQUENCY_CD DOUBLE N The frequency code value of the prescription scratchpad order.
INCLUDE_DEA_NUMBER_IND DOUBLE N Indicates if the prescription scratchpad order should include the DEA number.
NO_REQUIRED_DETAILS_IND DOUBLE N Indicates if the prescription scratchpad order does not need required details validated.
NUMBER_OF_REFILLS DOUBLE N The number of refills for the prescription scratchpad order.
ORDERED_AS_MNEMONIC VARCHAR(1024) Y The mnemonic of the prescription scratchpad order.
ORDER_ENTRY_PRSNL_ID DOUBLE N The value of the unique, internally system assigned primary identifier of the prsnl table.
ORDER_ID DOUBLE N The value of the unique, internally system assigned primary identifier of the orders table.
ORDER_RX_SCRATCHPAD_ID DOUBLE N table key The value of the unique, internally system assigned primary identifier of the order_rx_scratchpad table.
PERSON_ID DOUBLE N Person whom the order is placed for.
PRN_IND DOUBLE N Indicates if the prescription scratchpad order is PRN.
PRN_INSTRUCTIONS VARCHAR(1024) Y The PRN instructions of the prescription scratchpad order.
RENEWED_FROM_ORDER_ID DOUBLE N The order_id the prescription scratchpad order is being renewed from.
REQUISITION_ROUTING_CD DOUBLE N The requisition routing code value of the prescription scratchpad order.
RESPONSIBLE_PROVIDER_ID DOUBLE N The value of the unique, internally system assigned primary identifier of the prsnl table.
ROUTE_OF_ADMINISTRATION_CD DOUBLE N The route of administration of the prescription scratchpad order.
ROUTING_PHARMACY_IDENTIFIER VARCHAR(100) Y The unique identifier supplied from other external database - pharmacy's alphanumeric NCPDP ID.
ROUTING_TYPE_FLAG DOUBLE Y Obsolete - no longer used. The routing type of the prescription scratchpad order.
SAMPLE_QUANTITY DOUBLE N The sample quantity of the prescription scratchpad order.
SAMPLE_QUANTITY_UNIT_CD DOUBLE N The sample quantity unit code value of the prescription scratchpad order.
SPECIAL_INSTRUCTIONS VARCHAR(1024) Y The special instructions of the prescription scratchpad order.
START_DT_TM DATETIME Y The start date/time of the prescription scratchpad order
STOP_DT_TM DATETIME Y The stop date/time of the prescription scratchpad order.
STOP_TYPE_CD DOUBLE N The stop type code value of the prescription scratchpad order.
SUPERVISING_PROVIDER_ID DOUBLE N In addition to order entry personnel and order provider, the system could capture a supervising provider. For example, when mid level providers (nurse practitioners) place orders, they're required to enter a supervising provider.
SYNONYM_ID DOUBLE N The value of the unique, internally system assigned primary identifier of the order_catalog_synonym 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 - ORDER_RX_SCRATCHPAD


Child Column in ORDER_RX_SCRATCHPAD(FK) Parent Table Name Parent Column Name
Parents: COMMENT_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
RENEWED_FROM_ORDER_ID ORDERS ORDER_ID
CATALOG_CD ORDER_CATALOG CATALOG_CD
SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
PERSON_ID PERSON PERSON_ID
ORDER_ENTRY_PRSNL_ID PRSNL PERSON_ID
RESPONSIBLE_PROVIDER_ID PRSNL PERSON_ID
SUPERVISING_PROVIDER_ID PRSNL PERSON_ID


ORDER_RX_VERIFY_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Rx Verify Information
Definition: Stores information about pharmacy verification for orders.
Table Type: ACTIVITY





Column Detail - ORDER_RX_VERIFY_INFO


Column Name Type Null? Definition
CLINICAL_REVIEW_COMPLETED_CNT DOUBLE Y The number of clinical reviews a pharmacist has completed for the order.
CLINICAL_REVIEW_REQD_PREF_CD DOUBLE Y The preference code defining the multiple pharmacy verification behavior currently assigned to the order.
CLINICAL_REVIEW_REQUIRED_CNT DOUBLE Y The number of clinical reviews required by a pharmacist for the order to be considered fully verified.
LATEST_ORIGINATING_ACTION_SEQ DOUBLE Y The latest action sequence on an order from which an rx verify group originated.
ORDER_ID DOUBLE N The ID of the associated order.
ORDER_RX_VERIFY_INFO_ID DOUBLE N Unique generated number that identifies a single row on the ORDER_RX_VERIFY_INFO 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 - ORDER_RX_VERIFY_INFO


Child Column in ORDER_RX_VERIFY_INFO(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID


ORDER_SCHEDULE_EXCEPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Schedule Exception
Definition: This table will contain exceptions to the order schedule. For example, when a user moves or skips an administration, it will be recorded on this table)
Table Type: ACTIVITY





Column Detail - ORDER_SCHEDULE_EXCEPTION


Column Name Type Null? Definition
INACTIVE_ORDER_ACTION_SEQUENCE DOUBLE N The action sequence on the order_action table when this exception was inactivated.
NEW_INSTANCE_DT_TM DATETIME Y The new scheduled administration date/time created by the schedule exception . This field will be blank if an administration has been skipped.
NEW_INSTANCE_TZ DOUBLE Y Time zone of the new scheduled administration date/time created by the schedule exception.
ORDER_ACTION_SEQUENCE DOUBLE N Action_sequence on the order_action table that the schedule exception is affecting.
ORDER_ID DOUBLE N The order to which the schedule exception is associated.
ORDER_SCHEDULE_EXCEPTION_ID DOUBLE N The primary key for this order schedule exception table.
ORIG_INSTANCE_DT_TM DATETIME Y The original scheduled administration date/time of the instance to which the exception is associated.
ORIG_INSTANCE_TZ DOUBLE Y Time zone of the original scheduled administration date/time of the instance to which the exception is associated.
SCHEDULE_EXCEPTION_TYPE_CD DOUBLE N The type of schedule exception.
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 - ORDER_SCHEDULE_EXCEPTION


Child Column in ORDER_SCHEDULE_EXCEPTION(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID