Table slot9.WORLD.TSTA.MASTER_REPORTS
This table defines the master reports that can be generated fro the Forms and Reports module 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
MASTER_REPORT_ID number 0
AUDIT_REPORTS.MASTER_REPORT_ID AUDREP_MREP_FK R
MASTER_REPORT_REFERENCES.MASTER_REPORT_ID MRREF_MREP_FK R
REPORT_AGENCIES.MASTER_REPORT_ID REPAG_MREP_FK C
REPORT_OUTPUT_TYPES.MASTER_REPORT_ID ROT_MREP_FK C
REPORT_PARAMETER_GROUPS.MASTER_REPORT_ID RPG_MREP_FK C
REPORT_ROLE_SECURITY.MASTER_REPORT_ID RRSEC_MREP_FK C
REPORT_SCREEN_REPORTS.MASTER_REPORT_ID RSREP_MREP_FK R
SCREEN_TYPE_RPT_INCLUDES.MASTER_REPORT_ID STRI_MREP_FK R
SCREEN_TYPE_SCREEN_RPTS.MASTER_REPORT_ID STSR_MREP_FK R
SCREEN_TYPE_SCREENS.REPORT_ID USRSCRN_STS_MREP_FK R
USER_SCREEN_TYPES.DEFAULT_REPORT_ID USRSCRN_TYP_MREP_FK R
REPORT_NAME varchar2 100  √  null
DESCRIPTION varchar2 4000  √  null
CUSTOM_TYPE varchar2 1  √  'N'
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null
USE_ASYNC_GEN char 1  √  'Y'
EXTERNAL_ID varchar2 50  √  null
CATEGORY_ID number 0  √  null
REPORT_CATEGORIES.CATEGORY_ID MREP_CATEGORY_ID_FK R
JS_URI varchar2 500  √  null
REPORT_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE MREP_EJS_CD_REPTYP_FK R
REPORT_TYPE_CODE_TYPE varchar2 30  √  'REPORT_TYPE_CODES'
EJS_CODES.CODE_TYPE MREP_EJS_CD_REPTYP_FK R
DISABLE_STAMP_FLAG varchar2 1  √  'N' If set to Y, header and footer stamps will not be added to the PDF output

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
USE_ASYNC_GEN IN ( 'Y','N') CK_MR_USE_ASYNCH_GEN
CUSTOM_TYPE IN ( 'Y','N') CK_MREP_CUSTOM_TYPE
DISABLE_STAMP_FLAG IN ( 'Y','N') CK_MREP_DISABLE_STMP
"MASTER_REPORT_ID" IS NOT NULL MREP_MASTER_REPORT_ID_NN

Indexes:
Column(s) Type Sort Constraint Name Anomalies
MASTER_REPORT_ID Primary key Asc MREP_PK  
CATEGORY_ID Performance Asc MR_CAT_ID_FK_I  
REPORT_TYPE_CODE_TYPE + REPORT_TYPE_CODE Performance Asc/Asc MREP_EJS_CD_REPTYP_FK_I  
EXTERNAL_ID Must be unique Asc MREP_EXTERNAL_ID_UK This unique column is also nullable

Close relationships  within of separation: