Table slot9.WORLD.TSTA.USER_SCREENS
This table defines custom forms to be used in 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
SCREEN_ID number 38
MAP_USER_SCREENS.SCREEN_ID MUS_USRSCRN_FK R
SCREEN_TYPE_SCREENS.SCREEN_ID USRSCRN_STS_USRSCRN_FK R
USER_FIELD_GROUPS.SCREEN_ID USRSCRN_FG_USRSCRN_FK R
USER_FIELDS.SCREEN_ID USRSCRN_F_USRSCRN_FK R
USER_FIELDS.SUB_SCREEN_ID USRSCRN_F_USRSCRN2_FK R
USER_SCREEN_ADMINS.SCREEN_ID USRSCRAD_USRSCRN_FK C
USER_SCREEN_AGENCIES.SCREEN_ID USRSCA_USRSCRN_FK C
USER_SCREEN_INSTANCES.SCREEN_ID USRSCRN_INST_USRSCRN_FK R
USER_SCREEN_ROLES.SCREEN_ID USRSCRN_ROL_USRSCRN_FK R
USER_SCREEN_USER_PRIVS.SCREEN_ID USRSCRPR_USRSCRN_FK C
USI_SEARCH_VW.SCREEN_ID Implied Constraint R
TITLE varchar2 255  √  null
DESCRIPTION varchar2 1000  √  null
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE USRSCRN_AGNCY_CD_FK R
Agency involved
JS_VALIDATION clob 4000  √  null
PUBLISHED_FLAG varchar2 1  √  'N'
CATEGORY_CODE varchar2 30  √  null
EJS_CODES.CODE USRSCRN_EC_CAT_FK R
CATEGORY_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE USRSCRN_EC_CAT_FK R
OFFICER_REQ_CODE varchar2 30
EJS_CODES.CODE USRSCRN_EC_OFFICER_FK R
OFFICER_REQ_CODE_TYPE varchar2 30
EJS_CODES.CODE_TYPE USRSCRN_EC_OFFICER_FK R
CREATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null
PRINT_HEADER varchar2 4000  √  null
JS_INIT clob 4000  √  null
DEFAULT_SECURITY_LEVEL number 38  √  null
INCIDENT_SECURITY_LEVEL_CODES.INC_SEC_LEVEL_CODE USRSCRN_INC_SEC_LVL_FK R
Default Security Level for Non-Inline Forms
ROUTE_TEMPLATE_ID number 38  √  null
ROUTE_TEMPLATES.TEMPLATE_ID USRSCRN_ROUTEM_FK R
REVIEW_REQ_FLAG varchar2 1  √  'N'
RESTRICT_EDIT varchar2 1  √  'N'
FORM_NUMBER varchar2 30  √  null
ACTIVE_STATUS_CODE varchar2 30
EJS_CODES.CODE USRSCRN_EC_ACTIVE_STAT_FK R
ACTIVE_STATUS_CODE_TYPE varchar2 30
EJS_CODES.CODE_TYPE USRSCRN_EC_ACTIVE_STAT_FK R
REPORT_FORMAT_CODE varchar2 30  √  null
REPORT_FORMAT_CODE_TYPE varchar2 30  √  null
NEXT_NUMBER number 0  √  null
FORMAT_TYPE varchar2 20  √  null
EFFECTIVE_DATE date 7  √  null
END_DATE date 7  √  null
CREATE_INCIDENT_FLAG varchar2 1  √  'N'

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
PUBLISHED_FLAG IN ('Y', 'N') CK_USRSCRN_PUBLISHED_FLAG
RESTRICT_EDIT IN ('Y', 'N') CK_USRSCRN_RESTR_EDIT
REVIEW_REQ_FLAG IN ('Y', 'N') CK_USRSCRN_RV_REQ_FLAG
"ACTIVE_STATUS_CODE" IS NOT NULL USRSCRN_ACTIVESTATCD_NN
"ACTIVE_STATUS_CODE_TYPE" IS NOT NULL USRSCRN_ACTIVESTCDT_NN
"OFFICER_REQ_CODE" IS NOT NULL USRSCRN_OFF_REQ_CD_NN
"OFFICER_REQ_CODE_TYPE" IS NOT NULL USRSCRN_OFF_REQ_CDTYP_NN
"SCREEN_ID" IS NOT NULL USRSCRN_SCREEN_ID_NN

Indexes:
Column(s) Type Sort Constraint Name Anomalies
SCREEN_ID Primary key Asc USRSCRN_PK  
AGENCY_CODE Performance Asc USRSCRN_AGNCY_CD_FK_I  
ACTIVE_STATUS_CODE_TYPE + ACTIVE_STATUS_CODE Performance Asc/Asc USRSCRN_EC_ACTIVE_STAT_FK_I  
CATEGORY_CODE_TYPE + CATEGORY_CODE Performance Asc/Asc USRSCRN_EC_CAT_FK_I  
OFFICER_REQ_CODE_TYPE + OFFICER_REQ_CODE Performance Asc/Asc USRSCRN_EC_OFFICER_FK_I  
FORM_NUMBER Must be unique Asc USRSCRN_FRM_NUM_UK This unique column is also nullable
DEFAULT_SECURITY_LEVEL Performance Asc USRSCRN_INC_SEC_LVL_FK_I  
ROUTE_TEMPLATE_ID Performance Asc USRSCRN_ROUTEM_FK_I  

Close relationships  within of separation: