ReportCaster stores distribution and scheduling information in WebFOCUS Repository tables. At installation, an SQL-based repository is created in a selected location.
The following is a list of WebFOCUS Repository tables that store ReportCaster information, their contents, and primary keys.
|
Table |
Contains |
Primary Keys |
|---|---|---|
|
BOTACCES |
Access List names. One record per Access List and 1:m with BOTLIST. |
Access ID. |
|
BOTADDR |
Properties of each Distribution List. For example, its name and whether it is a public or private list. One record per list and 1:m with BOTDEST. |
AddressBook ID. |
|
BOTCAT |
Library catalog table. Includes one record for each report in the Report Library. If the schedule is burst, each bursted report is a record. |
Report group ID. |
|
BOTCDATE |
Information about the custom run intervals of schedules. |
CDate ID. |
|
BOTDEST |
Recipients and destinations within a Distribution List. One record per destination. |
Distribution List name and a counter from 1 to n for each member of a particular Distribution List. |
|
BOTDIST |
Distribution information. |
Distribution ID. |
|
BOTSIT |
Recurrence information. |
Interval ID. |
|
BOTLDATA |
Report stored in the Report Library, in BLOB format. |
Report ID and a counter from 1 to n for each report stored in the Library. |
|
BOTLIB |
Version and expiration information. One record for each report in the Report Library. |
Report group ID, and version. |
|
BOTLIST |
User IDs and burst values within each Access List. One record per destination. |
Access List name and a counter from 1 to n for each member of a particular Access List. |
|
BOTLOG |
General log information, such as the start time and end time for each executed job. One record per job run and a 1:m with BOTLOG2. |
Process number that is generated when a job is run. |
|
BOTLOG2 |
Detailed log records for all jobs that have run. One record per job message. |
Process number and a counter that runs from 1 to n for each detail log record for a particular process number. |
|
BOTPACK |
Packet ID that uniquely identifies each schedule. |
Packet ID. |
|
BOTPARMS |
Parameter names and values for each Task. One record per parameter per Task. |
Schedule ID, Task ID, parameter name, and a counter from 1 to n for each parameter in a Task. |
|
BOTSBDS |
Schedule Blackout Dates table. Contains global and group schedule blackout dates and descriptions. |
ID. |
|
BOTSCHED |
Timing, frequency, and connection information about a particular schedule. Distribution methods (for example, email or FTP), along with supporting information, such as Reply Address and location of recipient. Distribution List (if any). One record per schedule. |
Schedule ID. |
|
BOTSCIT |
Information about the custom run intervals of schedules. |
|
|
BOTSTATE |
Failover and Workload Distribution information. |
|
|
BOTTASK |
Individual Task information. Includes the name of the Task, the Execution ID for the Task, and the WebFOCUS Reporting Server name. For WebFOCUS reports, BOTTASK also lists the full path in the WebFOCUS Repository. There is a BOTTASK record for each Task in a schedule. Since there can be multiple Tasks in a schedule, there is a 1:m relationship with BOTSCHED. |
Task ID, Packet ID. |
|
BOTTSKEX |
ReportCaster user ID. Execution ID and password. Contains execution type (for example, WebFOCUS Server Procedure). Depending on execution type, contains server name (for WebFOCUS Server Procedures and Managed Reporting reports), application name (for files), or server name and port (for URLs, FTP files, and mainframe output). One record per Task. |
ReportCaster User ID, Execution ID, server name, server type. |
|
BOTWATCH |
Library Watch List information. |
|