W_USER_UGRP_LIST |
Default Table Name | W_USER_UGRP_LIST |
Definition |
W_USER_UGRP_LIST Columns |
ColumnName | Domain | Datatype | NULL | Definition |
SEC_OBJ_ID![]() |
VARCHAR2(20) | NO | ||
NAME | VARCHAR2(60) | NO | ||
TYPE | VARCHAR2(1) | NO | ||
PHONE_ID | VARCHAR2(25) | YES | ||
PHONE_EXT_CD | VARCHAR2(6) | YES | ||
WEB_PASSWORD | VARCHAR2(120) | YES | ||
EMPL_ID | VARCHAR2(12) | YES | ||
CHG_PSWD_FL | VARCHAR2(1) | YES | ||
CHG_NAME_FL | VARCHAR2(1) | YES | ||
CHG_PHONE_FL | VARCHAR2(1) | YES | ||
DE_ACTIVATION_DT | DATE | YES | ||
LAST_PSWD_CHNG_DT | DATE | YES | ||
EMAIL_WF_ACTVTY_FL | VARCHAR2(1) | YES | ||
EMAIL_WF_MSG_FL | VARCHAR2(1) | YES | ||
EMAIL_NAME | VARCHAR2(60) | YES | ||
UNSUC_ATTEMPT_NO | NUMBER(5, 0) | YES | ||
DFLT_COMPANY_ID | VARCHAR2(10) | YES | ||
DYN_TBL_NO | NUMBER(10, 0) | YES | ||
PRINTER_NAME | VARCHAR2(50) | YES | ||
MEASURE_NO | NUMBER(5, 0) | YES | ||
PAGE_SIZE_CD | VARCHAR2(254) | YES | ||
PAGE_WIDTH_NO | NUMBER(10, 3) | YES | ||
PAGE_HEIGHT_NO | NUMBER(10, 3) | YES | ||
MARGIN_RIGHT_NO | NUMBER(10, 3) | YES | ||
MARGIN_LEFT_NO | NUMBER(10, 3) | YES | ||
MARGIN_TOP_NO | NUMBER(10, 3) | YES | ||
MARGIN_BOTTOM_NO | NUMBER(10, 3) | YES | ||
CHG_DFLT_COMP_FL | VARCHAR2(1) | YES | ||
CHG_MYMENU_FL | VARCHAR2(1) | YES | ||
LOCALE_ID | VARCHAR2(6) | YES | ||
TOOL_ROLE_ID | VARCHAR2(10) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
PRC_NOTIFY_FL | VARCHAR2(1) | NO | ||
CHG_PRC_NOTIFY_FL | VARCHAR2(1) | YES | ||
AUTH_METHOD | VARCHAR2(20) | YES | ||
LDAP_USER_ID | VARCHAR2(254) | YES | ||
WS_AUTH_FL | VARCHAR2(1) | YES | ||
ALLOW_PRINT_FL | VARCHAR2(1) | YES | ||
ALLOW_DOWNLOAD_FL | VARCHAR2(1) | YES | ||
ALLOW_ARCHIVE_FL | VARCHAR2(1) | YES | ||
ALLOW_PRINTFILE_FL | VARCHAR2(1) | YES | ||
ALLOW_EMAIL_FL | VARCHAR2(1) | YES | ||
DFLT_PRINT_FL | VARCHAR2(1) | YES | ||
DFLT_DOWNLOAD_FL | VARCHAR2(1) | YES | ||
DFLT_ARCHIVE_FL | VARCHAR2(1) | YES | ||
DFLT_PRINTFILE_FL | VARCHAR2(1) | YES | ||
DFLT_EMAIL_FL | VARCHAR2(1) | YES | ||
FORCE_PSWD_CHG_FL | VARCHAR2(1) | YES | ||
DFLT_LOCALPRINT_FL | VARCHAR2(1) | YES | ||
LAST_LOGIN_DT | DATE | YES | ||
SAVE_SCR_CONFIG_FL | VARCHAR2(1) | YES | ||
CHG_PROF_CONFIG_FL | VARCHAR2(1) | YES | ||
OVR_PRIORITY_FL | VARCHAR2(1) | YES | ||
AUTO_COMPLETE_FL | VARCHAR2(1) | YES | ||
AUTO_POSITION_FL | VARCHAR2(1) | YES | ||
CASE_SUBM_FL | VARCHAR2(1) | NO | ||
INT_CONSOLE_FL | VARCHAR2(1) | YES | ||
MFA_FL | VARCHAR2(1) | YES | ||
MFA_PIN | NUMBER(4, 0) | YES | ||
MFA_SECRET_CD | VARCHAR2(64) | YES | ||
MFA_EFFECT_DT | DATE | YES | ||
LDAP_GRP_FL | VARCHAR2(1) | YES | ||
DELEGATE_USER_ID | VARCHAR2(20) | YES | ||
DELEGATE_FROM_DT | DATE | YES | ||
DELEGATE_TO_DT | DATE | YES | ||
MFA_FIDO_FL | VARCHAR2(1) | YES | ||
MFA_FIDO_PSWD_FL | VARCHAR2(1) | YES | ||
SAML_FL | VARCHAR2(1) | YES | ||
HOME_SCREEN_APP_ID | VARCHAR2(30) | YES | ||
NOTIFICATION_METHOD | VARCHAR2(10) | NO | ||
NEW_UI_FL | VARCHAR2(1) | YES | ||
FIDO_FL | VARCHAR2(1) | YES | ||
TC_LOGIN_FL | VARCHAR2(1) | NO | ||
NAV_ENTRY_FL | VARCHAR2(1) | YES | ||
CHG_FIDO_FL | VARCHAR2(1) | NO | ||
OFFLINE_SECRET_CD | VARCHAR2(64) | YES | ||
ALLOW_VOICE_INTERFACE_FL | VARCHAR2(1) | NO | ||
MOBILE_CARRIER | VARCHAR2(10) | YES | ||
WS_AUTH_JWT_FL | VARCHAR2(1) | NO | ||
WS_AUTH_JWT_CERT | VARCHAR2(4000) | YES | ||
SAML_PROVIDER_ID | VARCHAR2(30) | YES |
W_USER_UGRP_LIST Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0012 | PrimaryKey | SEC_OBJ_ID |
W_USER_UGRP_LIST Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
W_ACTION_RIGHTS | Non-Identifying | One To Zero or More | F00007 | NO | NO | NO | |||
W_APP_RIGHTS | Non-Identifying | One To Zero or More | F00008 | NO | NO | NO | |||
W_LOC_USER_LINKS | Non-Identifying | One To Zero or More | F00011 | NO | NO | NO | |||
W_MENU_APP_RIGHTS | Non-Identifying | One To Zero or More | F00012 | NO | NO | NO | |||
W_MODULE_RIGHTS | Non-Identifying | One To Zero or More | F00013 | NO | NO | NO | |||
W_PRN_USER_LINKS | Non-Identifying | One To Zero or More | F00017 | NO | NO | NO | |||
W_RPT_ARCH_RIGHTS | Non-Identifying | One To Zero or More | F00018 | NO | NO | NO | |||
W_RPT_RIGHTS | Non-Identifying | One To Zero or More | F00020 | NO | NO | NO | |||
W_RS_RIGHTS | Non-Identifying | One To Zero or More | F00021 | NO | NO | NO | |||
W_USER_COMPANY | Non-Identifying | One To Zero or More | F00023 | NO | NO | NO | |||
W_USER_GRP_USERS | Non-Identifying | One To Zero or More | F00024 | NO | NO | NO | |||
W_USER_GRP_USERS | Non-Identifying | One To Zero or More | F00025 | NO | NO | NO | |||
W_USER_PSWD_HS | Non-Identifying | One To Zero or More | F00026 | NO | NO | NO | |||
W_USER_QUERY | Identifying | One To Zero or More | F00030 | NO | NO | NO | |||
W_USER_CONFIG | Identifying | One To Zero or More | F00046 | NO | NO | NO | |||
W_UI_PROF_USERS | Identifying | One To Zero or More | F00049 | NO | NO | NO | |||
MB_MBOARD_SUBSCR | Identifying | One To Zero or More | FK_MB_MBOARD_SUBSCR_US_IDX | NO | NO | NO | |||
MB_MBOARD_USER | Identifying | One To Zero or More | FK_MB_MBOARD_USER_SE_IDX | NO | NO | NO | |||
W_CAPABILITY_URL | Non-Identifying | One To Zero or More | FK_W_CAPABILITY_URL_US_IDX | NO | NO | NO | |||
W_MFA_FIDO_KEYS | Non-Identifying | One To Zero or More | FK_W_MFA_FIDO_KEYS_US_IDX | NO | NO | NO | |||
W_MFA_HS2 | Non-Identifying | One To Zero or More | FK_W_MFA_HS2_US_IDX | NO | NO | NO | |||
W_MFA_HS | Non-Identifying | One To Zero or More | FK_W_MFA_HS_US_IDX | NO | NO | NO | |||
W_NOTIFICATION_OVERRIDE | Identifying | One To Zero or More | FK_W_NOTIFICATION_OVRRD_SE_IDX | NO | NO | NO | |||
W_USER_FAVORITES | Non-Identifying | One To Zero or More | FK_W_USER_FAVORITES_USCOAP_IDX | NO | NO | NO | |||
WFA_ROLE_USER | Identifying | One To Zero or More | FK_WFA_ROLE_USER_US_IDX | NO | NO | NO |