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. |