Table Detail Report

BR_ADO_PROPOSED_OPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Advisor Orders Proposed Option
Definition: Stores Advisor Orders Proposed Options for Topic, Scenario and Category.
Table Type: REFERENCE





Column Detail - BR_ADO_PROPOSED_OPTION


Column Name Type Null? Definition
BR_ADO_PROPOSED_DETAIL_ID DOUBLE N The Detail that this option pertains to. Foreign Key to BR_ADO_PROP_DETAIL Table.
BR_ADO_PROPOSED_OPTION_ID DOUBLE N Unique generated number that identifies a single row on the BR_ADO_PROPOSED_OPTION table.
NOTE_TXT VARCHAR(255) Y Notes at Option Level
OPTION_MEAN VARCHAR(50) N Uniquely identifies the option from Readme/Content
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_PROPOSED_OPTION


Child Column in BR_ADO_PROPOSED_OPTION(FK) Parent Table Name Parent Column Name
Parents: BR_ADO_PROPOSED_DETAIL_ID BR_ADO_PROPOSED_DETAIL BR_ADO_PROPOSED_DETAIL_ID




Parent Column in BR_ADO_PROPOSED_OPTION (PK) Child Table Name Child Column Name
Children: BR_ADO_PROPOSED_OPTION_ID BR_ADO_PROPOSED_ORD_LIST BR_ADO_PROPOSED_OPTION_ID


BR_ADO_PROPOSED_ORD_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Advisor Orders Proposed Order Lists
Definition: Stores Proposed Synonyms and associated Sentence for Proposed Options under Topic, Scenario and Category.
Table Type: REFERENCE





Column Detail - BR_ADO_PROPOSED_ORD_LIST


Column Name Type Null? Definition
BR_ADO_PROPOSED_OPTION_ID DOUBLE N Identifies the Option this order list pertains to. Foreign Key to BR_ADO_PROPOSED_OPTION
BR_ADO_PROPOSED_ORD_LIST_ID DOUBLE N Unique generated number that identifies a single row on the BR_ADO_PROPOSED_ORD_LIST table.
PROPOSED_SENTENCE_TXT VARCHAR(255) Y Contains Proposed Sentence Information
SYNONYM_NAME VARCHAR(100) N Identifies Synonyms under Options.
SYNONYM_SEQ DOUBLE N Value to sequence the synonyms configured to an option.
SYNONYM_UNIQUE_IDENT VARCHAR(255) N identifies Synonym. Can contain CKI or Concept CKI of the Synonym
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_ORD_LIST


Child Column in BR_ADO_PROPOSED_ORD_LIST(FK) Parent Table Name Parent Column Name
Parents: BR_ADO_PROPOSED_OPTION_ID BR_ADO_PROPOSED_OPTION BR_ADO_PROPOSED_OPTION_ID


BR_ADO_TOPIC



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Advisor Orders Topic
Definition: Stores Advisor Orders Topics from the Content.
Table Type: REFERENCE





Column Detail - BR_ADO_TOPIC


Column Name Type Null? Definition
BR_ADO_TOPIC_ID DOUBLE N Unique generated number that identifies a single row on the BR_ADO_TOPIC table.
TOPIC_DISPLAY VARCHAR(100) N Display Value for the Topic.
TOPIC_MEAN VARCHAR(50) N Uniquely identifies the Topics that are being inserted from Readme/Content
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_TOPIC




Parent Column in BR_ADO_TOPIC (PK) Child Table Name Child Column Name
Children: BR_ADO_TOPIC_ID BR_ADO_TOPIC_SCENARIO BR_ADO_TOPIC_ID


BR_ADO_TOPIC_SCENARIO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Advisor Orders Topic Scenario
Definition: Stores Scenarios and their relation with Topics
Table Type: REFERENCE





Column Detail - BR_ADO_TOPIC_SCENARIO


Column Name Type Null? Definition
BR_ADO_TOPIC_ID DOUBLE N Topic ID of the Topic that this Scenario is related to.
BR_ADO_TOPIC_SCENARIO_ID DOUBLE N Unique generated number that identifies a single row on the BR_ADO_TOPIC_SCENARIO table.
SCENARIO_DISPLAY VARCHAR(255) N Display Value for the Scenario.
SCENARIO_MEAN VARCHAR(50) N Uniquely identifies the Scenario rows that are being inserted from Readme/Content
SCENARIO_SECTION_NAME VARCHAR(50) N Provides a mechanism grouping scenarios for a topic.
SCENARIO_SEQ DOUBLE N Sequence of the Scenario within a Topic
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_TOPIC_SCENARIO


Child Column in BR_ADO_TOPIC_SCENARIO(FK) Parent Table Name Parent Column Name
Parents: BR_ADO_TOPIC_ID BR_ADO_TOPIC BR_ADO_TOPIC_ID




Parent Column in BR_ADO_TOPIC_SCENARIO (PK) Child Table Name Child Column Name
Children: BR_ADO_TOPIC_SCENARIO_ID BR_ADO_PROPOSED_DETAIL BR_ADO_TOPIC_SCENARIO_ID


BR_ALIAS_POOL_INFO



Column Section Top of Page


Table-level Detail

Description: BEDROCK ALIAS POOL INFO
Definition: Alias pool data
Table Type: REFERENCE





Column Detail - BR_ALIAS_POOL_INFO


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ALIAS_POOL_CD DOUBLE N alias pool code set
ALIAS_POOL_TYPE_CD DOUBLE N Stores the code value for the type of the alias pool
ALPHA_CHAR_IND DOUBLE Y Defines whether alpha characters are allowed in the aliases in this pool
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
FORMAT_IND DOUBLE Y Defined whether the aliases in this pool are subject to a format mask
FSI_ID DOUBLE N The id for the row on the BR_FSI table related to this alias pool
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.