Report Manager

Printing, storing and distributing large amounts of information every day is a time intensive and costly activity. Report Manager enables you to organize, store, execute, access PL/PDF reports in the Oracle database.

Repository tables

 

Column name

Description

Domain

Definition tables: Describes the main properties of reports definitions (prefix of tables: DEF)

GROUP: Report group definitions
ID	Unique Identifier	ID
NAME	Name of group	NAME
DESCRIPTION	Description	DESCRIPTION

RGROUP: Join table between GROUP and REP
GROUP_ID	GROUP Identifier	ID
REP_ID	REP Identifier	ID

REP: Definitions of reports
ID	Unique Identifier	ID
CODE	Code of report for user identification	CODE
NAME	Name of group	NAME
DESCRIPTION	Description	DESCRIPTION
PLSQLCODE	PL/SQL procedure name	PLSQL
CREATED_DATE	Date of creation	DATE
CREATED_BY	ID of Creator User	ID

PAR: Logical parameters of reports
ID	Parameter Identifier	ID
REP_ID	REP Identifier	ID
CODE	Parameter name in PL/SQL procedure	CODE
ORDER_NUM	Sorting number for appearance on Parameter Form	ORDER_NUM
OPTIONAL	Optional or required parameter	LOGICAL
VISIBLE	Parameter is visible on Parameter Form or not	LOGICAL
DATA_TYPE	Data type of parameter	DATA_TYPE
MAX_LENGTH	Variable-length character string maximum length or number data precision.	DATA_LENGTH
DEC_PLACES	If data type is number then scale of parameter.	NUM_DEC_PLACES
DEFAULT_VALUE	Default value of parameter	PARAMETER_VALUE
LOV_ID	List of values Identifier	ID
FORMAT_MASK	Format string of  parameter on Parameter Form	DATA_MASK
PICT_LENGTH	Item length on Parameter Form	PICT_LENGTH
PROMPT	Prompt on Parameter Form	PROMPT
DESCRIPTION	Description	DESCRIPTION

LOV: List of values
ID	Unique Identifier	ID
LOV_QUERY	Name of group	QUERY
TITLE	Title of LOV	PROMPT
RETURN_COLUMN	Column name wich column serves value of row	CODE
VISIBLE_COLUMN	Column name wich column appearences in LOV	CODE
VISIBLE_TITLE	Title of visible column	PROMPT

Execution tables: Stores the instaces of reports (prefix of tables: RUN)

RINST: Report instances
ID	Unique Identifier	ID
REP_ID	Report ID	ID
USER_ID	Executor User ID	ID
RUN_STATUS	Status of report instance	RUN_STATUS
RUN_START	Start date of the execution of the report	DATE
RUN_END	End date of the execution of the report	DATE
MESSAGE	Messages	MESSAGE
REP_DATA	PDF file	BLOB
REQ_ID	Request ID	ID

PINST: Parameter instance
RINST_ID	Report instance ID	ID
PAR_ID	Parameter ID	ID
ACT_VALUE	Parameter value	PARAMETER_VALUE

Job tables: Automatic report creations (prefix of tables: JOB)

REQ: Request definitions
ID	Unique Identifier	ID
NAME	Name of group	NAME
DESCRIPTION	Description	DESCRIPTION
REP_ID	Report ID	ID
FREQUENCY	Frequency of running	JOB_FREQUENCY
FIRST_RUNNING	First requested date of execution	DATE
LAST_RUNNING	Last date of execution	DATE
CREATED_BY	Creator of request	ID
CREATED_DATE	Date of creation	DATE

PVAL: Parameter values
REQ_ID	Request ID	ID
PAR_ID	Parameter ID	ID
PAR_EXP	SQL expression creating the parameter value	SQL_EXPRESSION

View tables: Logging entries of view/open the reports (prefix of tables: VIEW)

LOG: Log entries
ID	Unique Identifier	ID
RINST_ID	Report instance ID	ID
USER_ID	User ID of the user viewing the report	ID
OPENING_DATE	Date the report was opened/viewed	DATE

Role tables: User permissions for reports (prefix of tables: ROLE)

USER: User definitions
ID	Unique Identifier	ID
NAME	Name of user	PERSON_NAME
EMAIL	E-mail address for distribution	EMAIL_ADDRESS
ORACLE_USER	Oracle database user name	ORACLE_USER_NAME
CREATED_BY	Creator user ID	ID
CREATED_DATE	Date of creation	DATE

ROLE: Role group definitions
ID	Unique Identifier	ID
NAME	Name of group	NAME
DESCRIPTION	Description	DESCRIPTION

USERR: User roles
ROLE_ID	Role ID	ID
USER_ID	User ID	ID
CREATED_BY	Creator user ID	ID
CREATED_DATE	Date of creation	DATE

RUNR: Run permissions
ROLE_ID	Role ID	ID
REP_ID	Report ID	ID
CREATED_BY	Creator user ID	ID
CREATED_DATE	Date of creation	DATE

VIEWR: View permissons
ROLE_ID	Role ID	ID
REP_ID	Report ID	ID
CREATED_BY	Creator user ID	ID
CREATED_DATE	Date of creation	DATE

Distribution tables: E-mail distribution of generated reports (prefix of tables: DIST)

DDEF: Distribution definitions
ID	Unique Identifier	ID
NAME	Name of group	NAME
DESCRIPTION	Description	DESCRIPTION
REQ_ID	Job request ID to define Report for distribution	ID
USER_ID	User ID to define target of distribution	ID

DACT: Distribution actions
ID	Unique Identifier	ID
DDEF_ID	Distribution definition ID	ID
DDATE	Date of  distribution action	DATE

Domain name	Data type	Description
ID	NUMBER	Identifier
NAME	VARCHAR2(50)	Name
DESCRIPTION	VARCHAR2(255)	Description
CODE	VARCHAR2(10)	Code
PLSQL	VARCHAR2(100)	PL/SQL package, function, procedure name
ORDER_NUM	NUMBER(2,0)	Arragement order
LOGICAL	VARCHAR2(1)	Logical type Allowable values: 'Y': Yes 'N': No
DATA_TYPE	VARCHAR2(1)	Available data types Allowable values: 'V': Varchar2 'N': Number 'D': Date
DATA_LENGTH	NUMBER(5,0)	Variable-length character string maximum length or number data precision.
NUM_DEC_PLACES	NUMBER(5,0)	If data type is number then scale of  data.
PARAMETER_VALUE	VARCHAR2(255)	Value of  parameter
DATA_MASK	VARCHAR2(20)	Format mask of the data
PICT_LENGTH	NUMBER(5,0)	Item length on a form
PROMPT	VARCHAR2(50)	Item prompt text on a form
QUERY	VARCHAR2(2000)	SQL SELECT text
RUN_STATUS	VARCHAR2(1)	Allowable values: 'N': Not started 'R': Run 'F': Finished 'E': Error
MESSAGE	VARCHAR2(255)	Message text
JOB_FREQUENCY	VARCHAR2(1)	Allowable values: 'D': Day 'W': Week 'M': Month 'Y': Year
SQL_EXPRESSION	VARCHAR2(255)	SQL expression
PERSON_NAME	VARCHAR2(100)	Name of a person (last and first)
EMAIL_ADDRESS	VARCHAR2(100)	E-mail address
ORACLE_USER_NAME	VARCHAR2(30)	Oracle database user identifier

Domains

Required User Interfaces

Administrator

• Report Group maintenance
• LOV maintenance
• Report and Parameter maintenance
• Job maintenance
• Role maintenance

User maintenance

• Permission maintenance
• Distribution maintenance
• End User
• Execute report
• Select a report for viewing
• You can create these interfaces rapidly with HTML DB and MOD_PLSQL.