Table Detail Report

OS_RBLD_ORD_SENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: OS_RBLD_ORD_SENT
Definition: OS_RBLD_ORD_SENT is used to store existing and rebuilt data from the ORDER_SENTENCE table.
Table Type: ACTIVITY





Column Detail - OS_RBLD_ORD_SENT


Column Name Type Null? Definition
COMMITTED_FLAG DOUBLE N Used to indicate the processing status of the rebuilt order sentence. 0 - Not processed, 1 - No update needed, 2 - Errors when updating, 3 - Committed, 4 - Errors on rollback, 5 - Rolled back.
EXTERNAL_IDENTIFIER_IND DOUBLE N Indicates the value for column EXTERNAL_IDENTIFIER on the order_sentence table was NULL. Null values do not come through the message buss. They get changed to a 0 or blank. Used when identifying the appropriate row to be removed when updating order sentence values.
NEW_DISCERN_AUTO_VERIFY_FLAG DOUBLE N Rebuilt discern_auto_verify_flag
NEW_EXTERNAL_IDENTIFIER VARCHAR(50) N Rebuilt external_identifier
NEW_IC_AUTO_VERIFY_FLAG DOUBLE N Rebuilt ic_auto_verify_flag
NEW_OE_FORMAT_ID DOUBLE N Rebuilt oe_format_id
NEW_ORDER_ENCNTR_GROUP_CD DOUBLE N Rebuilt order_encounter_group_cd
NEW_ORD_COMMENT_LONG_TEXT_ID DOUBLE N Rebuilt ord_comment_long_text_id
NEW_ORD_SENT_DISP_LINE VARCHAR(255) N Rebuilt ord_sent_disp_line
NEW_PARENT_ENTITY2_ID DOUBLE N Rebuilt parent_entity2_id
NEW_PARENT_ENTITY2_NAME VARCHAR(30) N Rebuilt parent_entity2_name
NEW_PARENT_ENTITY_ID DOUBLE N Rebuilt parent_entity_id
NEW_PARENT_ENTITY_NAME VARCHAR(30) N Rebuilt parent_entity_name
NEW_RX_TYPE_MEAN VARCHAR(12) N Rebuilt rx_type_mean
NEW_UPDT_APPLCTX DOUBLE N Rebuilt updt_applctx
NEW_UPDT_CNT DOUBLE N Rebuilt updt_cnt
NEW_UPDT_DT_TM DATETIME N Rebuilt updt_dt_tm
NEW_UPDT_ID DOUBLE N Rebuilt updt_id
NEW_UPDT_TASK DOUBLE N Rebuilt updt_task
NEW_USAGE_FLAG DOUBLE N Rebuilt usage_flag
OLD_DISCERN_AUTO_VERIFY_FLAG DOUBLE N Existing discern_auto_verify_flag value on the order_sentence table
OLD_EXTERNAL_IDENTIFIER VARCHAR(50) N Existing external_identifier value on the order_sentence table
OLD_IC_AUTO_VERIFY_FLAG DOUBLE N Existing ic_auto_verify_flag value on the order_sentence table
OLD_OE_FORMAT_ID DOUBLE N Existing oe_format_id value on the order_sentence table
OLD_ORDER_ENCNTR_GROUP_CD DOUBLE N Existing order_encntr_group_cd value on the order_sentence table
OLD_ORD_COMMENT_LONG_TEXT_ID DOUBLE N Existing ord_comment_long_text_id value on the order_sentence table
OLD_ORD_SENT_DISP_LINE VARCHAR(255) N Existing ord_sent_disp_line on the order_sentence table
OLD_PARENT_ENTITY2_ID DOUBLE N Existing parent_entity2_id value on the order_sentence table
OLD_PARENT_ENTITY2_NAME VARCHAR(30) N Existing parent_entity2_name value on the order_sentence table
OLD_PARENT_ENTITY_ID DOUBLE N Existing parent_entity_id value on the order_sentence table
OLD_PARENT_ENTITY_NAME VARCHAR(30) N Existing parent_entity_name value on the order_sentence table
OLD_RX_TYPE_MEAN VARCHAR(12) N Existing rx_type_mean value on the order_sentence table
OLD_UPDT_APPLCTX DOUBLE N Existing updt_applctx value on the order_sentence table
OLD_UPDT_CNT DOUBLE N Existing updt_cnt value on the order_sentence table
OLD_UPDT_DT_TM DATETIME N Existing updt_dt_tm value on the order_sentence table
OLD_UPDT_ID DOUBLE N Existing updt_id value on the order_sentence table
OLD_UPDT_TASK DOUBLE N Existing updt_task value on the order_sentence table
OLD_USAGE_FLAG DOUBLE N Existing usage_flag value on the order_sentence table
ORDER_SENTENCE_ID DOUBLE N The corresponding order_sentence_id on the order_sentence table.
ORD_SENT_DISP_LINE_IND DOUBLE N Indicates the value for column ORDER_SENTENCE_DISPLAY_LINE on the order_sentence table was NULL. Null values do not come through the message buss. They get changed to a 0 or blank. Used when identifying the appropriate row to be removed when updating order sentence values.
OS_RBLD_ORD_SENT_ID DOUBLE N Unique generated number that identifies a single row on the OS_RBLD_ORD_SENT table.
PARENT_ENTITY2_NAME_IND DOUBLE N Indicates the value for column PARENT_ENTITY2_NAME on the order_sentence table was NULL. Null values do not come through the message buss. They get changed to a 0 or blank. Used when identifying the appropriate row to be removed when updating order sentence values.
PARENT_SYNONYM_TEXT VARCHAR(100) N The synonym mnemonic of the order sentence.
PRSNL_ID DOUBLE N The prsnl_id of the person that executed the rebuild utility.
RUN_DT_TM DATETIME N The date/time the rebuild utility was run.
RX_TYPE_MEAN_IND DOUBLE N Indicates the value for column RX_TYPE_MEAN on the order_sentence table was NULL. Null values do not come through the message buss. They get changed to a 0 or blank. Used when identifying the appropriate row to be removed when updating order sentence values.
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 - OS_RBLD_ORD_SENT




Parent Column in OS_RBLD_ORD_SENT (PK) Child Table Name Child Column Name
Children: OS_RBLD_ORD_SENT_ID OS_RBLD_MSG OS_RBLD_ORD_SENT_ID
OS_RBLD_ORD_SENT_DET OS_RBLD_ORD_SENT_ID


OS_RBLD_ORD_SENT_DET



Column Section Relationship Section Top of Page


Table-level Detail

Description: OS_RBLD_ORD_SENT_DET
Definition: OS_RBLD_ORD_SENT_DET is used to store existing and rebuilt data from the order_sentence_detail table
Table Type: ACTIVITY





Column Detail - OS_RBLD_ORD_SENT_DET


Column Name Type Null? Definition
DEFAULT_PARENT_ENTITY_ID_IND DOUBLE N Indicates the value for column DEFAULT_PARENT_ENTITY_ID on the order_sentence_det table was NULL. Null values do not come through the message buss. They get changed to a 0 or blank. Used when identifying the appropriate row to be removed when updating order sentence values.
DEFAULT_PARENT_ENTITY_NAME_IND DOUBLE N Indicates the value for column DEFAULT_PARENT_ENTITY_NAME on the order_sentence_det table was NULL. Null values do not come through the message buss. They get changed to a 0 or blank. Used when identifying the appropriate row to be removed when updating order sentence values.
DELETE_OLD_IND DOUBLE N Indicator used to flag deletion on old_ columns
DETAIL_SEQUENCE DOUBLE N Rebuild utility internal detail sequence number
FIELD_TYPE_FLAG_IND DOUBLE N Indicates the value for column FIELD_TYPE_FLAG on the order_sentence_det table was NULL. Null values do not come through the message buss. They get changed to a 0 or blank. Used when identifying the appropriate row to be removed when updating order sentence values.
INSERT_NEW_IND DOUBLE N Indicator used to flag insertion on new_ columns
NEW_DEFAULT_PARENT_ENTITY_ID DOUBLE N Rebuilt default_parent_entity_id
NEW_DEFAULT_PARENT_ENTITY_NAME VARCHAR(32) N Rebuilt default_parent_entity_name
NEW_FIELD_TYPE_FLAG DOUBLE N Rebuilt field_type_flag
NEW_OE_FIELD_DISPLAY_VALUE VARCHAR(255) N Rebuilt oe_field_display_value
NEW_OE_FIELD_ID DOUBLE N Rebuilt oe_field_id
NEW_OE_FIELD_MEANING_ID DOUBLE N Rebuilt oe_field_meaning_id
NEW_OE_FIELD_VALUE DOUBLE N Rebuilt oe_field_value
NEW_SEQUENCE DOUBLE N Rebuilt new_sequence
NEW_UPDT_APPLCTX DOUBLE N Rebuilt updt_applctx
NEW_UPDT_CNT DOUBLE N Rebuilt updt_cnt
NEW_UPDT_DT_TM DATETIME N Rebuilt updt_dt_tm
NEW_UPDT_ID DOUBLE N Rebuilt updt_id
NEW_UPDT_TASK DOUBLE N Rebuilt updt_task
OE_FIELD_DISPLAY_VALUE_IND DOUBLE N Indicates the value for column OE_FIELD_DISPLAY_VALUE on the order_sentence_det table was NULL. Null values do not come through the message buss. They get changed to a 0 or blank. Used when identifying the appropriate row to be removed when updating order sentence values.
OE_FIELD_VALUE_IND DOUBLE N Indicates the value for column OE_FIELD_VALUE on the order_sentence_det table was NULL. Null values do not come through the message buss. They get changed to a 0 or blank. Used when identifying the appropriate row to be removed when updating order sentence values.
OLD_DEFAULT_PARENT_ENTITY_ID DOUBLE N Existing default_parent_entity_id value on the order_sentence_detail table
OLD_DEFAULT_PARENT_ENTITY_NAME VARCHAR(32) N Existing default_parent_entity_name value on the order_sentence_detail table
OLD_FIELD_TYPE_FLAG DOUBLE N Existing field_type_flag value on the order_sentence_detail table
OLD_OE_FIELD_DISPLAY_VALUE VARCHAR(255) N Existing oe_field_display_value on the order_sentence_detail table
OLD_OE_FIELD_ID DOUBLE N Existing oe_field_id value on the order_sentence_detail table
OLD_OE_FIELD_MEANING_ID DOUBLE N Existing oe_field_meaning_id value on the order_sentence_detail table
OLD_OE_FIELD_VALUE DOUBLE N Existing oe_field_value on the order_sentence_detail table
OLD_SEQUENCE DOUBLE N Existing sequence value on the order_sentence_detail table
OLD_UPDT_APPLCTX DOUBLE N Existing updt_applctx value on the order_sentence_detail table
OLD_UPDT_CNT DOUBLE N Existing updt_cnt value on the order_sentence_detail table
OLD_UPDT_DT_TM DATETIME N Existing updt_dt_tm value on the order_sentence_detail table
OLD_UPDT_ID DOUBLE N Existing updt_id value on the order_sentence_detail table
OLD_UPDT_TASK DOUBLE N Existing updt_task value on the order_sentence_detail table
OS_RBLD_ORD_SENT_DET_ID DOUBLE N Unique generated number that identifies a single row on the OS_RBLD_ORD_SENT_DET table.
OS_RBLD_ORD_SENT_ID DOUBLE N The identifier of the rebuilt order sentence this detail record belongs to.
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 - OS_RBLD_ORD_SENT_DET


Child Column in OS_RBLD_ORD_SENT_DET(FK) Parent Table Name Parent Column Name
Parents: OS_RBLD_ORD_SENT_ID OS_RBLD_ORD_SENT OS_RBLD_ORD_SENT_ID




Parent Column in OS_RBLD_ORD_SENT_DET (PK) Child Table Name Child Column Name
Children: OS_RBLD_ORD_SENT_DET_ID OS_RBLD_MSG OS_RBLD_ORD_SENT_DET_ID


PW_DEF_DOSE_CALC_METHOD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pathway Default Dose Calculator Method
Definition: Table used to store the default weight adjustment and CRCL method of a Plan component.
Table Type: REFERENCE





Column Detail - PW_DEF_DOSE_CALC_METHOD


Column Name Type Null? Definition
FACILITY_CD DOUBLE N Stores the facility code of the facility for which default method is configured.
METHOD_CD DOUBLE N Stores the code value of the default method selected.
METHOD_MEAN VARCHAR(100) N The CDF_MEANING of the method from code set 4016.
PATHWAY_COMP_ID DOUBLE N Identifies the pathway component. Foreign Key from PATHWAY_COMP table.
PW_DEF_DOSE_CALC_METHOD_ID DOUBLE N Unique generated number that identifies a single row on the PW_DEF_DOSE_CALC_METHOD 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 - PW_DEF_DOSE_CALC_METHOD


Child Column in PW_DEF_DOSE_CALC_METHOD(FK) Parent Table Name Parent Column Name
Parents: PATHWAY_COMP_ID PATHWAY_COMP PATHWAY_COMP_ID


RENEW_NOTIFICATION_PERIOD



Column Section Top of Page


Table-level Detail

Description: Renew Notification Period
Definition: Renew Notification Period
Table Type: REFERENCE





Column Detail - RENEW_NOTIFICATION_PERIOD


Column Name Type Null? Definition
NOTIFICATION_PERIOD DOUBLE Y NOTIFICATION_PERIOD
RENEW_NOTIFICATION_PERIOD_ID DOUBLE N RENEW_NOTIFICATION_PERIOD
STOP_DURATION DOUBLE N STOP_DURATION
STOP_DURATION_UNIT_CD DOUBLE N STOP_DURATION_UNIT_CD
STOP_TYPE_CD DOUBLE N STOP_TYPE_CD
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.


THERAPEUTIC_CAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Therapautic Category
Definition: Stores therapeutic category reference content across multiple vocabularies. A therapeutic category is a categorization of further sub therapeutic categories and/or drugs that pertain to a particiular therapy.
Table Type: REFERENCE





Column Detail - THERAPEUTIC_CAT


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.
EXTERNAL_IDENT VARCHAR(255) N External identifier defined by source creating a therapeutic category. This value uniquely identifies a record when compared against the source. It will allow us to create a 'key' to identify rows outside the current domain. In our current scenario, the external_ident is composed on SNOMED CT concept values.
SOURCE_VOCABULARY_CD DOUBLE N The source vocabulary from which the therapeutic category originated from.
SYNONYM_ID DOUBLE N If this therapeutic category also represents a synonym, this will be the id of the synonym. As an example, therapeutic categories in SNOMED can represent synonyms which are also drugs. This column will allow the identification of those folders which are also drugs themselves.
THERAPEUTIC_CAT_ID DOUBLE N The primary key for the Therapeutic_Cat table
THERAPEUTIC_CAT_NAME VARCHAR(255) N The name of the therapeutic category.
THERAPEUTIC_CAT_NAME_KEY VARCHAR(255) N The name of the therapeutic category converted to upper case and stripped of all non-alpha characters.
THERAPEUTIC_CAT_NAME_KEY_A_NLS VARCHAR(1020) Y THERAPEUTIC_CAT_NAME_KEY_A_NLS column
THERAPEUTIC_CAT_NAME_KEY_NLS VARCHAR(512) N The i18n name of the therapeutic category converted to upper case and stripped of all non-alpha characters.
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 - THERAPEUTIC_CAT




Parent Column in THERAPEUTIC_CAT (PK) Child Table Name Child Column Name
Children: THERAPEUTIC_CAT_ID THERAPEUTIC_CAT_ITEM SUB_THERAPEUTIC_CAT_ID
THERAPEUTIC_CAT_ITEM THERAPEUTIC_CAT_ID