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 |