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