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 |