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:
|
| 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.
