Miscellaneous attributes
These are attributes that are related to security such as users and roles.
| Attribute name | Source column | Source table |
|---|---|---|
| Workbrain Group ID | WBG_ID | WORKBRAIN_GROUP |
| Workbrain Parent ID | WBP_ID | WORKBRAIN_GROUP |
| Workbrain Group Name | WBG_NAME | WORKBRAIN_GROUP |
| Workbrain Group Description | WBG_DESC | WORKBRAIN_GROUP |
| Workbrain Group Lockdown | WBG_LOCKDOWN | WORKBRAIN_GROUP |
| Workbrain Group Flag1 | WBG_FLAG1 | WORKBRAIN_GROUP |
| Workbrain Group Flag2 | WBG_FLAG2 | WORKBRAIN_GROUP |
| Workbrain Group Flag3 | WBG_FLAG3 | WORKBRAIN_GROUP |
| Workbrain Group Flag4 | WBG_FLAG4 | WORKBRAIN_GROUP |
| Workbrain Group Flag5 | WBG_FLAG5 | WORKBRAIN_GROUP |
| Workbrain Group DefPerm | WBG_DEF_PERM | WORKBRAIN_GROUP |
| Workbrain Group Can Proxy | WBG_CAN_PROXY | WORKBRAIN_GROUP |
| Workbrain Group DefStartPage | WBG_DEF_START_PAGE | WORKBRAIN_GROUP |
| Workbrain Group WbiAdmin | WBG_WBI_ADMIN | WORKBRAIN_GROUP |
| Workbrain Group WbiRole | WBG_WBI_ROLE | WORKBRAIN_GROUP |
| Workbrain Group UTC Insert Date | WBG_UTC_INSERT_DATE | WORKBRAIN_GROUP |
| Workbrain Group UTC Update Date | WBG_UTC_UPDATE_DATE | WORKBRAIN_GROUP |
| Workbrain Group InforRole | WBG_INFOR_ROLE | WORKBRAIN_GROUP |
| Deleted | deleted* | WORKBRAIN_GROUP |
| Variation | variation* | WORKBRAIN_GROUP |
| Data Lake Time Stamp | lastModified* | WORKBRAIN_GROUP |
| Workbrain Role ID | WBROLE_ID | WORKBRAIN_ROLE |
| Workbrain Role Name | WBROLE_NAME | WORKBRAIN_ROLE |
| Workbrain Role Description | WBROLE_DESC | WORKBRAIN_ROLE |
| Workbrain Role Virtual | WBROLE_VIRTUAL | WORKBRAIN_ROLE |
| Workbrain Role Supervisor | WBROLE_SUPERVISOR | WORKBRAIN_ROLE |
| Workbrain Role Approver | WBROLE_APPROVER | WORKBRAIN_ROLE |
| Workbrain Role UTC Insert Date | WBROLE_UTC_INSERT_DATE | WORKBRAIN_ROLE |
| Workbrain Role UTC Update Date | WBROLE_UTC_UPDATE_DATE | WORKBRAIN_ROLE |
| Deleted | deleted* | WORKBRAIN_ROLE |
| Variation | variation* | WORKBRAIN_ROLE |
| Data Lake Time Stamp | lastModified* | WORKBRAIN_ROLE |
| Workbrain User ID | WBU_ID | WORKBRAIN_USER |
| Workbrain User IP Address | WBU_IP | WORKBRAIN_USER |
| Employee ID | EMP_ID | WORKBRAIN_USER |
| wblId | WBL_ID | WORKBRAIN_USER |
| Workbrain Group ID | WBG_ID | WORKBRAIN_USER |
| wbllId | WBLL_ID | WORKBRAIN_USER |
| Workbrain User Name | WBU_NAME | WORKBRAIN_USER |
| Workbrain User Password | WBU_PASSWORD | WORKBRAIN_USER |
| Workbrain User Password Changed Date | WBU_PWD_CHANGED_DATE | WORKBRAIN_USER |
| Workbrain User Active | WBU_ACTIVE | WORKBRAIN_USER |
| Workbrain User Bad Login Count | WBU_BAD_LOGIN_COUNT | WORKBRAIN_USER |
| Workbrain User Email | WBU_EMAIL | WORKBRAIN_USER |
| Workbrain User External Validation | WBU_EXTERNAL_VALIDATION | WORKBRAIN_USER |
| Workbrain User Flag1 | WBU_FLAG1 | WORKBRAIN_USER |
| Workbrain User Flag2 | WBU_FLAG2 | WORKBRAIN_USER |
| Workbrain User Flag3 | WBU_FLAG3 | WORKBRAIN_USER |
| Workbrain User Flag4 | WBU_FLAG4 | WORKBRAIN_USER |
| Workbrain User Flag5 | WBU_FLAG5 | WORKBRAIN_USER |
| Workbrain User Flag6 | WBU_FLAG6 | WORKBRAIN_USER |
| Workbrain User Flag7 | WBU_FLAG7 | WORKBRAIN_USER |
| Workbrain User Flag8 | WBU_FLAG8 | WORKBRAIN_USER |
| Workbrain User Flag9 | WBU_FLAG9 | WORKBRAIN_USER |
| Workbrain User Flag10 | WBU_FLAG10 | WORKBRAIN_USER |
| Workbrain User Badge Number | WBU_BADGE_NUMBER | WORKBRAIN_USER |
| Workbrain User CanseeSelf | WBU_CANSEE_SELF | WORKBRAIN_USER |
| Workbrain User Udf1 | WBU_UDF1 | WORKBRAIN_USER |
| Workbrain User Udf2 | WBU_UDF2 | WORKBRAIN_USER |
| Workbrain User Udf3 | WBU_UDF3 | WORKBRAIN_USER |
| Workbrain User Udf4 | WBU_UDF4 | WORKBRAIN_USER |
| Workbrain User Udf5 | WBU_UDF5 | WORKBRAIN_USER |
| Workbrain User Can Proxy | WBU_CAN_PROXY | WORKBRAIN_USER |
| Workbrain User Is Power | WBU_IS_POWER | WORKBRAIN_USER |
| Workbrain User Password History | WBU_PWD_HISTORY | WORKBRAIN_USER |
| Workbrain User Identity2 | WBU_IDENTITY2 | WORKBRAIN_USER |
| Workbrain User UTC Insert Date | WBU_UTC_INSERT_DATE | WORKBRAIN_USER |
| Workbrain User UTC Update Date | WBU_UTC_UPDATE_DATE | WORKBRAIN_USER |
| Deleted | deleted* | WORKBRAIN_USER |
| Variation | variation* | WORKBRAIN_USER |
| Data Lake Time Stamp | lastModified* | WORKBRAIN_USER |
| Workbrain User Team ID | WBUT_ID | WORKBRAIN_USER_TEAM |
| Workbrain Team ID | WBT_ID | WORKBRAIN_USER_TEAM |
| Workbrain User ID | WBU_ID | WORKBRAIN_USER_TEAM |
| Workbrain Role ID | WBROLE_ID | WORKBRAIN_USER_TEAM |
| Employee ID | EMP_ID | WORKBRAIN_USER_TEAM |
| Workbrain User Team Start Date | WBUT_START_DATE | WORKBRAIN_USER_TEAM |
| Workbrain User Team End Date | WBUT_END_DATE | WORKBRAIN_USER_TEAM |
| Workbrain User Team Flag1 | WBUT_FLAG1 | WORKBRAIN_USER_TEAM |
| Workbrain User Team Flag2 | WBUT_FLAG2 | WORKBRAIN_USER_TEAM |
| Workbrain User Team Flag3 | WBUT_FLAG3 | WORKBRAIN_USER_TEAM |
| Workbrain User Team Flag4 | WBUT_FLAG4 | WORKBRAIN_USER_TEAM |
| Workbrain User Team Flag5 | WBUT_FLAG5 | WORKBRAIN_USER_TEAM |
| Workbrain User Team Udf1 | WBUT_UDF1 | WORKBRAIN_USER_TEAM |
| Workbrain User Team Udf2 | WBUT_UDF2 | WORKBRAIN_USER_TEAM |
| Workbrain User Team Udf3 | WBUT_UDF3 | WORKBRAIN_USER_TEAM |
| Workbrain User Team Udf4 | WBUT_UDF4 | WORKBRAIN_USER_TEAM |
| Workbrain User Team Udf5 | WBUT_UDF5 | WORKBRAIN_USER_TEAM |
| Workbrain User Team Approver | WBUT_APPROVER | WORKBRAIN_USER_TEAM |
| Workbrain User Team UTC Insert Date | WBUT_UTC_INSERT_DATE | WORKBRAIN_USER_TEAM |
| Workbrain User Team UTC Update Date | WBUT_UTC_UPDATE_DATE | WORKBRAIN_USER_TEAM |
| Deleted | deleted* | WORKBRAIN_USER_TEAM |
| Variation | variation* | WORKBRAIN_USER_TEAM |
| Data Lake Time Stamp | lastModified* | WORKBRAIN_USER_TEAM |
Note: * - source columns are from Data Lake