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