Table Detail Report

BR_BP_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock BP Activity
Definition: Bedrock BP Activity table
Table Type: REFERENCE





Column Detail - BR_BP_ACTIVITY


Column Name Type Null? Definition
ACTIVITY_MEAN VARCHAR(100) Y Unique meaning for the activity
BR_BP_ACTIVITY_ID DOUBLE N Unique ID
BR_LONG_TEXT_ID DOUBLE N ID of long description for the activity group
DESCRIPTION VARCHAR(100) Y Description of the activity
DISPLAY VARCHAR(100) Y Display for the activity
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.
VERSION_NBR DOUBLE Y Indicates the version of the task



Relationship Detail - BR_BP_ACTIVITY


Child Column in BR_BP_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: BR_LONG_TEXT_ID BR_LONG_TEXT LONG_TEXT_ID


BR_BP_ACT_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock BP Act Group
Definition: Stores default activity groups built by bedrock
Table Type: REFERENCE





Column Detail - BR_BP_ACT_GROUP


Column Name Type Null? Definition
ACT_GROUP_MEAN VARCHAR(100) Y Unique meaning for the activity group
BLUEPRINT_IND DOUBLE Y Indicates blueprint or not
BR_BP_ACT_GROUP_ID DOUBLE N Unique ID
BR_LONG_TEXT_ID DOUBLE N ID of long description for the activity group
CAT_DISP VARCHAR(100) Y Solution display
CAT_MEAN VARCHAR(200) Y Solution meaning
CREATE_DT_TM DATETIME Y Date and time the blueprint was created
CREATE_PRSNL_ID DOUBLE N ID of the person who created the blueprint
DESCRIPTION VARCHAR(100) Y Description of the activity group
DISPLAY VARCHAR(100) Y Display for the activity group
DISPLAY_KEY_CAP VARCHAR(100) Y Display for the activity group, stored as all caps
TYPE_FLAG DOUBLE Y Indicates how a blueprints tasks are to be completed
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.
VERSION_NBR DOUBLE Y Indicates the version of the activity group



Relationship Detail - BR_BP_ACT_GROUP


Child Column in BR_BP_ACT_GROUP(FK) Parent Table Name Parent Column Name
Parents: BR_LONG_TEXT_ID BR_LONG_TEXT LONG_TEXT_ID




Parent Column in BR_BP_ACT_GROUP (PK) Child Table Name Child Column Name
Children: BR_BP_ACT_GROUP_ID BR_BP_ACT_GROUP_R BR_BP_ACT_GROUP_ID


BR_BP_ACT_GROUP_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock BP Activity Group Relationship
Definition: Stores relationship between activity groups and activity groups/activities.
Table Type: REFERENCE





Column Detail - BR_BP_ACT_GROUP_R


Column Name Type Null? Definition
ACTIVITY_STATUS DOUBLE Y Status of the activity
BR_BP_ACT_GROUP_ID DOUBLE N ID of the activity group
BR_BP_ACT_GROUP_R_ID DOUBLE N Unique ID
CHILD_ENTITY_ID DOUBLE N Id of the child entity
CHILD_ENTITY_NAME VARCHAR(100) Y Identifies where the child entity comes from
DISPLAY_SEQ DOUBLE Y Determines the sequence of tasks
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_BP_ACT_GROUP_R


Child Column in BR_BP_ACT_GROUP_R(FK) Parent Table Name Parent Column Name
Parents: BR_BP_ACT_GROUP_ID BR_BP_ACT_GROUP BR_BP_ACT_GROUP_ID


BR_BP_ACT_LONG_DESC



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock BP Activity long description
Definition: Stores right side links for activity groups and activities
Table Type: REFERENCE





Column Detail - BR_BP_ACT_LONG_DESC


Column Name Type Null? Definition
ACTIVITY_MEAN VARCHAR(100) Y Unique meaning for the activity
ACT_GROUP_MEAN VARCHAR(100) Y Unique meaning for the activity group
BR_BP_ACT_LONG_DESC_ID DOUBLE N Stores right side links for activity groups and activities
BR_LONG_TEXT_ID DOUBLE N ID of long description for the activity group
CAT_MEAN VARCHAR(100) Y Solution meaning
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_BP_ACT_LONG_DESC


Child Column in BR_BP_ACT_LONG_DESC(FK) Parent Table Name Parent Column Name
Parents: BR_LONG_TEXT_ID BR_LONG_TEXT LONG_TEXT_ID


BR_BP_RSLINK



Column Section Top of Page


Table-level Detail

Description: Bedrock BP Rslink
Definition: Stores right side links for activity groups and activities
Table Type: REFERENCE





Column Detail - BR_BP_RSLINK


Column Name Type Null? Definition
BEDROCK_ENTITY_MEAN VARCHAR(100) Y Identifier for the parent
BEDROCK_ENTITY_NAME VARCHAR(100) Y Identifies what table the parent came from
BR_BP_RSLINK_ID DOUBLE N Unique ID
RSLINK_TEXT VARCHAR(200) Y Text for right side link
RSLINK_URL VARCHAR(500) Y URL for right side link to follow
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.