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.