Table slot9.WORLD.TSTA.ROLE_SECURITIES
This table defines the valid roles that can be assigned to a user created by administrators of the application
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ROLE_NAME varchar2 30
AGENCY_ROLE_JS_USERS.ROLE_NAME AR_JS_RS_FK R
AUDIT_SEARCHES.ROLE_CODE AUDSRCH_RS_FK R
DV_ROLE_RESTRICTIONS.ROLE_CODE DVROLE_RS_FK R
EJS_ROLE_PERM_CATS.ROLE_NAME ERP_CAT_RS_FK R
EJS_ROLE_PERMISSION_VW.ROLE_NAME Implied Constraint R
EMP_INFO_TYPE_CODE_ROLES.ROLE_CODE EITCROLE_RS_FK R
EXT_SEARCH_ROLES.ROLE_NAME EXSR_RS_FK C
IJIS_USER_PROFILE_ROLES.ROLE_NAME IUPR_RS_FK R
INC_REVIEW_ROUTE_INSTANCES.ROLE_CODE INCRVWRTINST_RS_FK R
INC_REVIEW_ROUTE_LEVELS.ROLE_CODE INCRVWRTLVL_RS_FK R
NARRATIVE_SEARCH_ACCESS.ROLE_NAME NSA_RS_FK C
NOTIFICATION_AUDITS.ROLE_CODE NOTIFAUD_RS_FK R
NOTIFICATION_DTL_ROLES.ROLE_NAME NTDTLRL_RS_FK R
NOTIFY_ROLES.ROLE_NAME NR_RS_FK R
REPORT_ROLE_SECURITY.ROLE_NAME RRSEC_RS_FK R
ROLE_SECUR_PERMISSIONS.ROLE_NAME RSP_ROLE_NAME_RS_ROLE_NAME_FK R
ROLE_SECURITIES.MAPPED_ROLE_NAME RS_RS_MPED_ROLE_FK R
ROUTE_ACT_INST_USR_ROLES.ROLE_NAME RTEATRO_RS_FK R
ROUTE_ACTION_INST_ROLES.ROLE_NAME RTINSTRO_RS_FK R
ROUTE_ACTION_ROLES.ROLE_NAME RTEAR_RS_FK R
ROUTE_INSTANCE_ROLES.ROLE_NAME RTINSTRL_RS_FK R
USER_SCREEN_ROLES.ROLE_NAME USRSCRN_ROL_RS_FK R
Database Role
ROLE_DESC varchar2 255  √  null
ROLE_ACCESS_LEVEL number 0  √  null
REC_ID number 0  √  null
SYSTEM_ROLE varchar2 1  √  'Y'
DBA_ACCESS_ONLY varchar2 1  √  'N' Y/N Flag determines if only DBAs have access to modify the role
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE RS_AGNCY_CD_FK R
If set, the role becomes organization specific to the specified agency code
MAPPED_ROLE_NAME varchar2 30  √  null
ROLE_SECURITIES.ROLE_NAME RS_RS_MPED_ROLE_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
DBA_ACCESS_ONLY IN ('N', 'Y') CK_RS_DBA_ACCESS_ONLY
SYSTEM_ROLE IN ( 'Y','N') CK_RS_SYSTEM_ROLE
"ROLE_NAME" IS NOT NULL RS_ROLE_NAME_NN

Indexes:
Column(s) Type Sort Constraint Name
ROLE_NAME Primary key Asc RS_PK
AGENCY_CODE Performance Asc RS_AGNCY_CD_FK_I
MAPPED_ROLE_NAME Performance Asc RS_RS_MPED_ROLE_FK_I

Close relationships  within of separation: