BR_ADO_CATEGORY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Bedrock Advisor Orders Category |
Definition: | Stores the Category Names under which the Synonyms can be grouped. Category can come from Content/Read me or User Entered from Advisor Orders Wizard. |
Table Type: | REFERENCE |
Column Detail - BR_ADO_CATEGORY
Column Name | Type | Null? | Definition |
---|---|---|---|
BR_ADO_CATEGORY_ID | DOUBLE | N | Unique generated number that identifies a single row on the BR_ADO_CATEGORY table. |
CATEGORY_MEAN | VARCHAR(50) | Y | Uniquely identifies the Category that is being inserted from Readme/Content. |
CATEGORY_NAME | VARCHAR(100) | N | Name for the Category |
CATEGORY_NAME_KEY | VARCHAR(100) | N | The Key version of the Category |
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 - BR_ADO_CATEGORY
Parent Column in BR_ADO_CATEGORY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | BR_ADO_CATEGORY_ID | BR_ADO_DETAIL | BR_ADO_CATEGORY_ID |
BR_ADO_PROPOSED_DETAIL | BR_ADO_CATEGORY_ID |
BR_ADO_DETAIL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Bedrock Advisor Orders Detail |
Definition: | Stores the relations for Topic, Scenario, Facility and Category. |
Table Type: | REFERENCE |
Column Detail - BR_ADO_DETAIL
Column Name | Type | Null? | Definition |
---|---|---|---|
BR_ADO_CATEGORY_ID | DOUBLE | N | Identifies the Category, Foreign Key from BR_ADO_CATEGORY |
BR_ADO_DETAIL_ID | DOUBLE | N | Unique generated number that identifies a single row on the BR_ADO_DETAIL table. |
FACILITY_CD | DOUBLE | N | Facility to which Advisor Orders are being defined. |
NOTE_TXT | VARCHAR(255) | Y | Any required Notes at the Category Level. |
SCENARIO_CATEGORY_SEQ | DOUBLE | N | Sequence that categories per scenario are to be display in the Advisor frontend. |
SCENARIO_MEAN | VARCHAR(50) | N | Identifies the Scenario that this detail pertains to. |
SELECT_IND | DOUBLE | N | Determines if single or multiples choices can be made per category. 1-Single Select, 2-Multi Select |
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 - BR_ADO_DETAIL
Child Column in BR_ADO_DETAIL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BR_ADO_CATEGORY_ID | BR_ADO_CATEGORY | BR_ADO_CATEGORY_ID |
FACILITY_CD | LOCATION | LOCATION_CD |
Parent Column in BR_ADO_DETAIL (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | BR_ADO_DETAIL_ID | BR_ADO_OPTION | BR_ADO_DETAIL_ID |
BR_ADO_ORD_LIST | BR_ADO_DETAIL_ID |
BR_ADO_OPTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Bedrock Advisor Orders Option |
Definition: | Stores Option level information for a facility, topic, scenario and category |
Table Type: | REFERENCE |
Column Detail - BR_ADO_OPTION
Column Name | Type | Null? | Definition |
---|---|---|---|
BR_ADO_DETAIL_ID | DOUBLE | N | The detail this Option pertains to. Foreign Key to BR_ADO_DETAIL Table. |
BR_ADO_OPTION_ID | DOUBLE | N | Unique generated number that identifies a single row on the BR_ADO_OPTION table. |
NOTE_TXT | VARCHAR(255) | Y | Notes at Option Level |
OPTION_SEQ | DOUBLE | N | Sequence assigned to Options within a Category |
PRESELECT_IND | DOUBLE | N | Indicates if this Option is to be set as a default. 1-Yes, 0-No |
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 - BR_ADO_OPTION
Child Column in BR_ADO_OPTION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BR_ADO_DETAIL_ID | BR_ADO_DETAIL | BR_ADO_DETAIL_ID |
Parent Column in BR_ADO_OPTION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | BR_ADO_OPTION_ID | BR_ADO_ORD_LIST | BR_ADO_OPTION_ID |
BR_ADO_ORD_LIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Bedrock Advisor Orders Order Lists |
Definition: | Stores Synonyms and associated Sentences for Options under a Facility, Topic, Scenario and Category. |
Table Type: | REFERENCE |
Column Detail - BR_ADO_ORD_LIST
Column Name | Type | Null? | Definition |
---|---|---|---|
BR_ADO_DETAIL_ID | DOUBLE | N | The detail this Order List pertains to. Foreign Key to BR_ADO_DETAIL Table. |
BR_ADO_OPTION_ID | DOUBLE | N | Identifies Options. Foreign Key to BR_ADO_OPTION |
BR_ADO_ORD_LIST_ID | DOUBLE | N | Unique generated number that identifies a single row on the BR_ADO_ORD_LIST table. |
SENTENCE_ID | DOUBLE | N | Identifies Sentences for synonyms. |
SYNONYM_ID | DOUBLE | N | Identifies Synonyms under Options. |
SYNONYM_SEQ | DOUBLE | N | Value to sequence the synonyms configured to an option. |
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 - BR_ADO_ORD_LIST
Child Column in BR_ADO_ORD_LIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BR_ADO_DETAIL_ID | BR_ADO_DETAIL | BR_ADO_DETAIL_ID |
BR_ADO_OPTION_ID | BR_ADO_OPTION | BR_ADO_OPTION_ID | |
SYNONYM_ID | ORDER_CATALOG_SYNONYM | SYNONYM_ID |
BR_ADO_PROPOSED_DETAIL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Bedrock Advisor Order Proposed Detail |
Definition: | Stores Advisor Order Topics, Scenarios and category relations from Proposed Content. |
Table Type: | REFERENCE |
Column Detail - BR_ADO_PROPOSED_DETAIL
Column Name | Type | Null? | Definition |
---|---|---|---|
BR_ADO_CATEGORY_ID | DOUBLE | N | Identifies the Category, Foreign Key from BR_ADO_CATEGORY |
BR_ADO_PROPOSED_DETAIL_ID | DOUBLE | N | Unique generated number that identifies a single row on the BR_ADO_PROPOSED_DETAIL table. |
BR_ADO_TOPIC_SCENARIO_ID | DOUBLE | N | Identifies the Scenario, Foreign Key from BR_ADO_TOPIC_SCENARIO |
NOTE_TXT | VARCHAR(255) | Y | Any required Notes at the Category Level. |
SELECT_IND | DOUBLE | N | 1-Single Select, 2-Multi Select |
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 - BR_ADO_PROPOSED_DETAIL
Child Column in BR_ADO_PROPOSED_DETAIL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BR_ADO_CATEGORY_ID | BR_ADO_CATEGORY | BR_ADO_CATEGORY_ID |
BR_ADO_TOPIC_SCENARIO_ID | BR_ADO_TOPIC_SCENARIO | BR_ADO_TOPIC_SCENARIO_ID |
Parent Column in BR_ADO_PROPOSED_DETAIL (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | BR_ADO_PROPOSED_DETAIL_ID | BR_ADO_PROPOSED_OPTION | BR_ADO_PROPOSED_DETAIL_ID |