Table Detail Report
BR_PW_COMP_PLACEHLDR
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Bedrock Pathway Component Placeholder |
Definition: | Defines a placeholder for a pathway component. A placeholder can be linked to a pathway component so that it can later be replaced with a different pathway component. |
Table Type: | REFERENCE |
Column Detail - BR_PW_COMP_PLACEHLDR
Column Name | Type | Null? | Definition |
---|---|---|---|
BR_PW_COMP_PLACEHLDR_ID | DOUBLE | N | Unique generated number that identifies a single row on the BR_PW_COMP_PLACEHLDR table. |
COMP_TYPE_FLAG | DOUBLE | N | Component type flag that represents the intended use of the placeholder. |
PLACEHLDR_NAME | VARCHAR(100) | N | Name of placeholder. |
PLACEHLDR_NAME_KEY | VARCHAR(100) | N | Name of placeholder in all uppercase. |
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_PW_COMP_PLACEHLDR
Parent Column in BR_PW_COMP_PLACEHLDR (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | BR_PW_COMP_PLACEHLDR_ID | BR_PW_COMP_PLACEHLDR_R | BR_PW_COMP_PLACEHLDR_ID |
BR_PW_COMP_PLACEHLDR_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Bedrock Pathway Component Placeholder Relation |
Definition: | Relates a placeholder to a pathway component so that the pathway component can be identified as a placeholder. |
Table Type: | REFERENCE |
Column Detail - BR_PW_COMP_PLACEHLDR_R
Column Name | Type | Null? | Definition |
---|---|---|---|
BR_PW_COMP_PLACEHLDR_ID | DOUBLE | N | The header row for the Placeholder. |
BR_PW_COMP_PLACEHLDR_R_ID | DOUBLE | N | Unique generated number that identifies a single row on the BR_PW_COMP_PLACEHLDR_R table. |
INCLUDE_IND | DOUBLE | N | Indicator that controls if the placeholder will be included in the pathway by default. |
PATHWAY_UUID | VARCHAR(255) | N | The pathway_comp unique universal identifier. This will relate to the component in any current and future versions of the powerplan in PATHWAY_COMP. |
REQUIRED_IND | DOUBLE | N | Indicator that defines the placeholder as being required. |
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_PW_COMP_PLACEHLDR_R
Child Column in BR_PW_COMP_PLACEHLDR_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BR_PW_COMP_PLACEHLDR_ID | BR_PW_COMP_PLACEHLDR | BR_PW_COMP_PLACEHLDR_ID |
BR_REC
Column Section | Top of Page |
Table-level Detail
Description: | BR_RECOMMENDATION |
Definition: | Stores Bedrock recommendations |
Table Type: | REFERENCE |
Column Detail - BR_REC
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. |
BEDROCK_IND | DOUBLE | Y | recommendation run by bedrock or not. |
CATEGORY_MEAN | VARCHAR(50) | Y | Meaning for the category each recommendation should appear under |
CLIENT_VIEW_IND | DOUBLE | Y | recommendation is turned on or off for the client |
CODE_LVL_TXT_ID | DOUBLE | N | ID for the text stored on br_long_text |
CURR_OVERRIDE_NOTE | DOUBLE | Y | Stores the note ID from the br_name_value table |
DESIGN_DECISION_TXT_ID | DOUBLE | N | ID for the text stored on br_long_text |
DETAIL_PROGRAM_NAME | VARCHAR(50) | Y | Name of the program that is run to return the recommendation details |
HIGH_IMPACT_IND | DOUBLE | N | Indicates if the recommendation is high impact or not. A value of 1 indicates a high impact recommendation. |
LONG_DESC | VARCHAR(256) | Y | Long description of the recommendation |
OVERRIDE_DT_TM | DATETIME | Y | Date/time recommendation was overridden |
OVERRIDE_IND | DOUBLE | Y | recommendation has been overridden or not |
OVERRIDE_MEAN | VARCHAR(50) | Y | Stores the override meaning |
OVERRIDE_PRSNL_ID | DOUBLE | N | Personnel id of the person who overrode the recommendation |
PROGRAM_NAME | VARCHAR(50) | Y | Name of the program that is run to check the recommendation |
RATIONALE_TXT_ID | DOUBLE | N | ID for the text stored on br_long_text |
RECOMMENDATION_TXT_ID | DOUBLE | N | ID for the text stored on br_long_text |
REC_ID | DOUBLE | N | Unique ID for the table |
REC_MEAN | VARCHAR(50) | Y | Unique meaning given to a recommendation |
RELEASE_DATE_TXT | VARCHAR(50) | N | Stores the date of the release in which the recommendation was released, ex. "June 2010" |
RELEASE_NBR_TXT | VARCHAR(50) | N | Stores the number of the release in which the recommendation was released, ex. "Administration.25" |
RESOLUTION_TXT_ID | DOUBLE | N | ID for the text stored on br_long_text |
SEQUENCE | DOUBLE | Y | Display sequence |
SHORT_DESC | VARCHAR(100) | Y | Short description of the recommendation |
SPEC_CONS_TXT_ID | DOUBLE | N | ID from the long_text table where the special considerations text is stored |
SUBCATEGORY_MEAN | VARCHAR(50) | Y | Meaning for the subcategory each recommendation should appear under |
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. |
BR_REC_HISTORY
Column Section | Top of Page |
Table-level Detail
Description: | Bedrock Recommendation History |
Definition: | Stores history data from bedrock recommendations. |
Table Type: | REFERENCE |
Column Detail - BR_REC_HISTORY
Column Name | Type | Null? | Definition |
---|---|---|---|
REC_HISTORY_ID | DOUBLE | N | Unique ID from bedrock_seq |
REC_ID | DOUBLE | N | recommendation id from br_recommendation. |
RUN_DT_TM | DATETIME | Y | Date/Time the instance of the recommendation was run. |
RUN_PRSNL_ID | DOUBLE | N | ID of the user who ran the recommendation. |
RUN_STATUS_FLAG | DOUBLE | N | Status of the recommendations data when it was run. |
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. |
BR_REC_R
Column Section | Top of Page |
Table-level Detail
Description: | Bedrock Recommendation Relationship |
Definition: | Stores relationship between a recommendation and the solutions/interest areas it is associated to |
Table Type: | REFERENCE |
Column Detail - BR_REC_R
Column Name | Type | Null? | Definition |
---|---|---|---|
REC_ID | DOUBLE | N | recommendation id from br_recommendation. |
REC_R_ID | DOUBLE | N | recommendation id from br_recommendation_r. |
SOLUTION_MEAN | VARCHAR(50) | Y | Meaning of the solution |
TOPIC_MEAN | VARCHAR(50) | Y | Meaning of the interest area. |
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. |