INFUSION_BILL_RPT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Infusion Billing Report
Definition: To store the report information for Infusion Billing of an patient encounter.
Table Type: ACTIVITY





Column Detail - INFUSION_BILL_RPT


Column Name Type Null? Definition
ENCNTR_ID DOUBLE Y Identifies the encounter for the billig report
END_DT_TM DATETIME Y The date and time the medication administration ended.;
INFUSION_BILL_RPT_ID DOUBLE N THE PRIMARY KEY
PERFORMED_DT_TM DATETIME Y Date and time the action was performed for the billing report
PERFORMED_PRSNL_ID DOUBLE Y the personnel performing the encounter process
START_DT_TM DATETIME Y the date and time the medication administration was started.;
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 The valid date and time of a Infusion Billing Report.;



Relationship Detail - INFUSION_BILL_RPT


Child Column in INFUSION_BILL_RPT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERFORMED_PRSNL_ID PRSNL PERSON_ID




Parent Column in INFUSION_BILL_RPT (PK) Child Table Name Child Column Name
Children: INFUSION_BILL_RPT_ID INFUSION_BILL_RPT_ADMIN INFUSION_BILL_RPT_ID


INFUSION_BILL_RPT_ADMIN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Infusion Billing Report Admin
Definition: To store the admin information for Infusion Billing of an patient encounter
Table Type: ACTIVITY





Column Detail - INFUSION_BILL_RPT_ADMIN


Column Name Type Null? Definition
ADMIN_BLOB LONGBLOB Y A BLOB field containig JSON formatted data related to the infusion encounter
ADMIN_END_DT_TM DATETIME Y the date and time the medication administration ended.;
ADMIN_IDENT VARCHAR(40) Y the identifier for this administration
ADMIN_START_DT_TM DATETIME Y The medication administration was started.;
DISPLAY_TXT VARCHAR(255) Y Administration display line.;
DURATION_DISPLAY_TXT VARCHAR(255) Y Total duration display of the administration in character form
DURATION_NBR DOUBLE Y Total duration value of the administration.;
IMMUNIZATION_IND DOUBLE N The indicator used to determine if the order is an immunization.;
INFUSED_VOLUME DOUBLE Y The total volume of the administration across qualifying volume based ingredients
INFUSION_BILL_RPT_ADMIN_ID DOUBLE N PRIMARY KEY
INFUSION_BILL_RPT_ID DOUBLE Y Infusion Billing Report Identifer
JSON_VRSN_TXT VARCHAR(20) Y Stores the version of Json that is used in the BLOB column.
NEEDS_REVIEW_IND DOUBLE N Indicates if the administration needs to be reviewed.
ORDER_ID DOUBLE Y Orders identifier;
PAUSE_TIME_DISPLAY_TXT VARCHAR(255) Y Total paused time display associated with the administration.;
PAUSE_TIME_NBR DOUBLE Y Total paused time value associated with the administration.;
ROUTE_CD DOUBLE Y The route associated with the administration.;
SITE_CD DOUBLE Y The initial site documented on an administration.
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.
VISIT_TYPE_DISPLAY_TXT VARCHAR(255) Y The Visit type for the administration occurred within.;



Relationship Detail - INFUSION_BILL_RPT_ADMIN


Child Column in INFUSION_BILL_RPT_ADMIN(FK) Parent Table Name Parent Column Name
Parents: INFUSION_BILL_RPT_ID INFUSION_BILL_RPT INFUSION_BILL_RPT_ID
ORDER_ID ORDERS ORDER_ID




Parent Column in INFUSION_BILL_RPT_ADMIN (PK) Child Table Name Child Column Name
Children: INFUSION_BILL_RPT_ADMIN_ID INFUSION_BILL_RPT_SITE_CHG INFUSION_BILL_RPT_ADMIN_ID


INFUSION_BILL_RPT_SITE_CHG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Infusion Billing Report Site Change
Definition: To store the report site change information for Infusion Billing of an patient encounter
Table Type: ACTIVITY





Column Detail - INFUSION_BILL_RPT_SITE_CHG


Column Name Type Null? Definition
INFUSION_BILL_RPT_ADMIN_ID DOUBLE Y Infusion Billing Report admin identifier
INFUSION_BILL_RPT_SITE_CHG_ID DOUBLE N PRIMARY KEY
SITE_CHANGE_CD DOUBLE Y codeset that represents this site in the system.;
SITE_CHANGE_PERFORMED_DT_TM DATETIME Y The date and time the site was documented.;
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 - INFUSION_BILL_RPT_SITE_CHG


Child Column in INFUSION_BILL_RPT_SITE_CHG(FK) Parent Table Name Parent Column Name
Parents: INFUSION_BILL_RPT_ADMIN_ID INFUSION_BILL_RPT_ADMIN INFUSION_BILL_RPT_ADMIN_ID


MED_ADMIN_EXT_MAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Medication Administration External Identifiers
Definition: This table is the external mapping of medication record identifiers.
Table Type: ACTIVITY





Column Detail - MED_ADMIN_EXT_MAP


Column Name Type Null? Definition
EXT_MAP_PRSNL_ID DOUBLE N EXTERNAL MAPPING PRSNL ID
INTERNAL_IDENT DOUBLE N Unique generated number that identifies the parent entity within medication administration records.
MED_ADMIN_EXT_MAP_ID DOUBLE N PRIMARY KEY
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 - MED_ADMIN_EXT_MAP


Child Column in MED_ADMIN_EXT_MAP(FK) Parent Table Name Parent Column Name
Parents: EXT_MAP_PRSNL_ID PRSNL PERSON_ID


MED_ADMIN_INGREDIENT_META



Column Section Relationship Section Top of Page


Table-level Detail

Description: Medication Administration Ingredient Metadata
Definition: Table containing medication ingredient metadata related to medication administration records.
Table Type: ACTIVITY





Column Detail - MED_ADMIN_INGREDIENT_META


Column Name Type Null? Definition
ADMIN_BLOB LONGBLOB Y A BLOB containing the JSON representation of medication administration records.
BLOB_DEF_VERSION DOUBLE N Version of the data definition contained in the ADMINS_BLOB.
ENCNTR_ID DOUBLE N Unique generated number that identifies a single row on the ENCOUNTER table.
INGREDIENT_REF_ID DOUBLE N Unique generated number that identifies a single row on the ORDER_CATALOG table.
MED_ADMIN_INGREDIENT_META_ID DOUBLE N PRIMARY KEY
PERSON_ID DOUBLE N Unique generated number that identifies a single row on the PERSON 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 - MED_ADMIN_INGREDIENT_META


Child Column in MED_ADMIN_INGREDIENT_META(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
INGREDIENT_REF_ID ORDER_CATALOG CATALOG_CD
PERSON_ID PERSON PERSON_ID