Table slot9.WORLD.TSTA.RESTRICTION_LISTS
A TABLE THAT REPRESENTS A LIST OF USERS LINKED TO ORGANIZAITONAL OBJECTS THAT SPECIFIES THAT THEY ARE EITHER INCLUDED AS THE USER WHO CAN GAIN VIEW OR UPDATE ACCESS TO THAT OBJECT OR THEY ARE INCLUDED AS USER WHO ARE DENIED ACCESS TO THE OBJECT FOR ANY REASON
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
RESTRICTION_ID number 38 A unique identifier for each item in the RESTRICTION_LIST table, PK
INCLUDE_EXCLUDE varchar2 1 Indicator as to how the restriction applies, 0 = User is allowed access to the organizational object(s) referenced, 1 = User is denied access to the organizational object(s).
POD_ID number 38  √  null
PSEUDO_ORG_DESCRIPTORS.POD_ID ORGSTRRL_ORGSTRPOD_FK R
Foreign key to the PSEUDO_ORG_DESCRIPTOR table, points to the organizational object to which the restriction applies.
ASSIGNMENT_ORG_ID number 38  √  null
ASSIGNMENT_ORGS.ASSIGNMENT_ORG_ID ORGSTRRL_ORGSTRAO_FK R
Foreign key to the ASSIGNMENT_ORG table, points to the organizational object to which the restriction applies.
LOGIN_ID varchar2 30  √  null
IJIS_USER_PROFILES.LOGIN_ID ORGSTRRL_IUP_FK R
Foreign key to the IJIS_USER_PROFILES table, points to the User Identity to whom the restriction is directed.
AFFILIATE_CODE varchar2 30  √  null
AFFILIATE_CODES.AFFILIATE_CODE ORGSTRRL_ORGSTRAC_FK R
Foreign key to the AFFILATE_CODES table, points to the affliated object to which the restriction applies.
CREATOR_ID varchar2 100  √  null USER ID for the initial record creation.
CREATOR_DATE date 7  √  null Date record was created.
UPDATOR_ID varchar2 100  √  null USER ID for the last record update.
UPDATOR_DATE date 7  √  null Date record was last updated.

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"INCLUDE_EXCLUDE" IS NOT NULL ORGSTRRL_INC_EXC_NN
"RESTRICTION_ID" IS NOT NULL ORGSTRRL_RESTRICTION_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
RESTRICTION_ID Primary key Asc ORGSTRRL_PK
LOGIN_ID Performance Asc ORGSTRRL_IUP_FK_I
AFFILIATE_CODE Performance Asc ORGSTRRL_ORGSTRAC_FK_I
ASSIGNMENT_ORG_ID Performance Asc ORGSTRRL_ORGSTRAO_FK_I
POD_ID Performance Asc ORGSTRRL_ORGSTRPOD_FK_I

Close relationships  within of separation: