Skip to content

SAIF.Services.Appworx database tables

This page catalogs database tables accessed by this library. The SAIF.Services.Appworx .NET code touches zero tables directly — all table access is procedure-side, performed inside the Oracle stored procedure submit_appworx_job that this library calls.

Table catalog

Table Database Schema/Link CRUD Purpose Primary business object
JOB_QUEUE Oracle [unqualified]** (resolves to WCIS_DBA as procedure owner**) C Queues the Appworx batch job request row read by the scheduler clsRequestAppworxJob (indirect — via submit_appworx_job)
DUAL Oracle SYS (Oracle pseudo-table) R Sequence fetch (SO_MAX_JOBID.NEXTVAL) used to generate the job identifier clsRequestAppworxJob (indirect — via submit_appworx_job)

JOB_QUEUE

Field Value
Database Oracle
Schema/Link [unqualified]** — the procedure references the table unqualified; it resolves to WCIS_DBA as the procedure owner**
Purpose Holds queued Appworx scheduler job requests; this is the row the Appworx scheduler polls and executes
Access pattern Stored procedure only — via submit_appworx_job
CRUD operations Create (Insert only)
Key columns used MODULE, REQUESTOR, MASTER_JOB_NUMBER, JOBID, ARG_1 … ARG_20 (24 columns)
Sequence SO_MAX_JOBID
Related tables None — no joins or foreign-key-style predicates
Business objects clsRequestAppworxJob (indirect; no BOF business object participates)

Operations referencing this table

Business rules referencing this table

SQL referencing this table

DUAL

Field Value
Database Oracle
Schema/Link SYS (Oracle pseudo-table)
Purpose Used to fetch SO_MAX_JOBID.NEXTVAL for the job identifier assigned to the queued row
Access pattern Stored procedure only — via submit_appworx_job
CRUD operations Read (sequence fetch only)
Key columns used (none — SO_MAX_JOBID.NEXTVAL pseudo-column only)
Sequence SO_MAX_JOBID
Related tables None
Business objects clsRequestAppworxJob (indirect)

Operations referencing this table

SQL referencing this table

Table relationship diagram

No cross-table relationships were identified in this library's SQL. JOB_QUEUE.JOBID is populated from the SO_MAX_JOBID sequence (a generator, not a parent table), and MASTER_JOB_NUMBER is a hard-coded -1 rather than a reference to a parent job row.

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

  • SAIF.Services.Appworx/clsRequestAppworxJob.vb