Table Detail Report

RX_AUTO_VERIFY_ING_AUDIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmarcy auto verify ingredient audit table
Definition: The table is used to log order ingredient information relevant to auto verification decision.
Table Type: ACTIVITY





Column Detail - RX_AUTO_VERIFY_ING_AUDIT


Column Name Type Null? Definition
ORDER_SENTENCE_ID DOUBLE N ID of the order sentence that matches order detail information on the ingredient.
RX_AUTO_VERIFY_AUDIT_ID DOUBLE N Rx auto verification audit ID to which this record is associated.
RX_AUTO_VERIFY_ING_AUDIT_ID DOUBLE N Unique identifier for rx auto verification audit at ingredient level.
SYNONYM_ID DOUBLE N Order catalog synonym id to which the ingredient is associated.
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_AUTO_VERIFY_ING_AUDIT


Child Column in RX_AUTO_VERIFY_ING_AUDIT(FK) Parent Table Name Parent Column Name
Parents: SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
ORDER_SENTENCE_ID ORDER_SENTENCE ORDER_SENTENCE_ID
RX_AUTO_VERIFY_AUDIT_ID RX_AUTO_VERIFY_AUDIT RX_AUTO_VERIFY_AUDIT_ID


RX_COA_TRANS_AUDIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Charge on Administration Transaction Audit
Definition: Audits the COA transactions without logging the servers for improved troubleshooting.
Table Type: ACTIVITY





Column Detail - RX_COA_TRANS_AUDIT


Column Name Type Null? Definition
AUDIT_TXT LONGTEXT Y Stores audit text information captured by charge/credit workflows;
CREATE_DT_TM DATETIME Y Contains the date and time this record was created.
EVENT_ID DOUBLE Y Identifies the Clinical Event related to COA transactions audited.
ORDER_ID DOUBLE Y Identifies Orders related to COA transactions audited.
RX_COA_TRANS_AUDIT_ID DOUBLE N Unique generated number that identifies a single row on the RX_COA_TRANS_AUDIT table.
SCRIPT_NAME VARCHAR(32) Y Stores the script name through which transaction occurs;
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 - RX_COA_TRANS_AUDIT


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


RX_CURVE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rx Curve
Definition: Stores properties of calcium phosphate curves.
Table Type: REFERENCE





Column Detail - RX_CURVE


Column Name Type Null? Definition
AMINO_ACID_CONC_PCT DOUBLE N The concentration of amino acid associated to the solubility curve, expressed as a percentage of weight to volume.
CALCIUM_UNIT_CD DOUBLE N Code value for the unit of measure used to express the curve's calcium values.
CURVE_CD DOUBLE N Code value for the curve.
CYSTEINE_IND DOUBLE N Indication that the curve is defined for user with orders that have cysteine.
DEXTROSE_CONC_PCT DOUBLE N The concentration of dextrose associated to the solubility curve, expressed as a percentage of weight to volume.
PHOSPHATE_UNIT_CD DOUBLE N Code value for the unit of measure used to express the curve's phosphate values.
RX_CURVE_ID DOUBLE N Unique, generated primary key for the RX_CURVE 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_CURVE




Parent Column in RX_CURVE (PK) Child Table Name Child Column Name
Children: RX_CURVE_ID RX_CURVE_MBR RX_CURVE_ID


RX_CURVE_MBR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rx Curve Member
Definition: Stores properties of calcium phosphate curves.
Table Type: REFERENCE





Column Detail - RX_CURVE_MBR


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.
CALCIUM_CONC_VALUE DOUBLE N The concentration of calcium stored in mmol/L units.
CURVE_MBR_SEQ_NBR DOUBLE N The order the points on the curve are to be connected.
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.
PHOSPHATE_CONC_VALUE DOUBLE N Phosphate concentration value stored in mmol/L units.
PREV_RX_CURVE_MBR_ID DOUBLE N The id to the member record before the record was changed. If 0, this is the original unchanged record
RX_CURVE_ID DOUBLE N Unique identifier of the curve.
RX_CURVE_MBR_ID DOUBLE N Unique, generated primary key for the RX_CURVE_MBR 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_CURVE_MBR


Child Column in RX_CURVE_MBR(FK) Parent Table Name Parent Column Name
Parents: RX_CURVE_ID RX_CURVE RX_CURVE_ID
PREV_RX_CURVE_MBR_ID RX_CURVE_MBR RX_CURVE_MBR_ID




Parent Column in RX_CURVE_MBR (PK) Child Table Name Child Column Name
Children: RX_CURVE_MBR_ID RX_CURVE_MBR PREV_RX_CURVE_MBR_ID


RX_DISPENSE_ORDERS_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Dispense Orders Relation
Definition: Associate instances of child Orders to the Dispense.
Table Type: ACTIVITY





Column Detail - RX_DISPENSE_ORDERS_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.
DISPENSE_HX_ID DOUBLE N Identifier to reference the related Dispense event.
ORDER_ID DOUBLE N Identifier that points to the related child orders on the ORDERS table.
RX_DISPENSE_ORDERS_RELTN_ID DOUBLE N Unique Identifier for rows on the 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_DISPENSE_ORDERS_RELTN


Child Column in RX_DISPENSE_ORDERS_RELTN(FK) Parent Table Name Parent Column Name
Parents: DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
ORDER_ID ORDERS ORDER_ID