Table slot9.WORLD.TSTA.EJS_REPORTS
This table is an administrative table that is configured under Administration Reports
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
REPORT_ID number 4
EJS_REPORT_PARAMETERS.REPORT_ID ERP_ER_FK R
REPORT_SECTION_CODES.ER_REPORT_ID REP_SEC_CD_ER_FK R
This is a sequence to uniquely identify the report.
REPORT_NAME varchar2 50 This is the name of the report and may be used as the label of th
FILE_NAME varchar2 50 This is the name of the file which will be executed.
DESCRIPTION varchar2 255  √  null This is a description of the report.
LANDSCAPE varchar2 1 The default for this field is portrait. If checked it will be lan
COMMAND_LINE varchar2 50  √  null This field is used for certain types of reports.
DIRECTORY varchar2 50  √  null This is the directory where the file is located.
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
IS_NAME varchar2 30
INSTALL_SUBSYSTEMS.NAME ER_IS_FK R
IS_INSTALL_APPLICATION varchar2 15
INSTALL_SUBSYSTEMS.INSTALL_APPLICATION ER_IS_FK R
Name of Application
RC_CODE varchar2 30
EJS_CODES.CODE ER_RC_CODE_EJS_CODE_FK R
This is a type of file code. ex- rep, fmx etc.
PRINT_ONLY_FLAG varchar2 1  √  'N' Yes, No, or Unkown Fields
MUGSHOT_USED varchar2 1  √  'N' Yes, No, or Unkown Fields
OLE_FLAG varchar2 1  √  'N' Yes, No, or Unkown Fields
GROUP_CODE varchar2 30  √  null
EJS_CODES.CODE ER_GROUP_CODE_EJS_CODE_FK R
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE ER_AGNCY_CD_FK R
Agency involved
PARAMETER_METHOD varchar2 1  √  'N'
GROUP_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ER_GROUP_CODE_EJS_CODE_FK R
RC_CODE_TYPE varchar2 30  √  'REPORT_CODES'
EJS_CODES.CODE_TYPE ER_RC_CODE_EJS_CODE_FK R
REC_ID number 0  √  null
CALLING_SCREEN varchar2 255  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
LANDSCAPE IN ('Y', 'N') CK_ER_LANDSCAPE
OLE_FLAG IN ('Y', 'N') CK_ER_OLE_FLAG
PRINT_ONLY_FLAG IN ('Y', 'N') CK_ER_PRINT_ONLY_FLAG
"FILE_NAME" IS NOT NULL ER_FILE_NAME_NN
"IS_INSTALL_APPLICATION" IS NOT NULL ER_IS_INSTALL_APPLICATION_NN
"IS_NAME" IS NOT NULL ER_IS_NAME_NN
"LANDSCAPE" IS NOT NULL ER_LANDSCAPE_NN
"RC_CODE" IS NOT NULL ER_RC_CODE_NN
"REPORT_ID" IS NOT NULL ER_REPORT_ID_NN
"REPORT_NAME" IS NOT NULL ER_REPORT_NAME_NN

Indexes:
Column(s) Type Sort Constraint Name
REPORT_ID Primary key Asc ER_PK
AGENCY_CODE Performance Asc ER_AGNCY_CD_FK_I
GROUP_CODE Performance Asc ER_DGC_FK_I
GROUP_CODE_TYPE + GROUP_CODE Performance Asc/Asc ER_GROUP_CODE_EJS_CODE_I
IS_NAME + IS_INSTALL_APPLICATION Performance Asc/Asc ER_IS_FK_I
RC_CODE_TYPE + RC_CODE Performance Asc/Asc ER_RC_CODE_EJS_CODE_I
RC_CODE Performance Asc ER_RC_FK_I

Close relationships  within of separation: