Stores print-control batch headers: directory, duplex mode, processed date, IDM path, XML file name, and MD5 hash for a set of documents queued for print processing.
None live in this library — XPrintControlSeqNum must be supplied by the caller; DIRECTORY_NAME_NEXTVAL in dead CreateSQL (SQL-003) is a CodeGen2 template artifact, not a real Oracle sequence.*
Related tables
XDOCUMENT (one-to-many via XPRINT_CONTROL_SEQ_NUM)
Stores individual print job documents linked to a print-control batch. Contains routing metadata (bin type, sort values), document type, email/fax routing, and print group text for sequencing and grouping.
Access pattern
Direct SQL via IBusinessCriteria
CRUD operations
Create (Insert), Read (Select), Delete — no live Update
XDeferred_SEQ — generated procedurally via IDataPortalInfo.GetNextSeqNum("XDeferred_SEQ") in clsXDeferredPrint.Create(). COPIES_COUNT_NEXTVAL in dead CreateSQL properties (SQL-001, SQL-002) is a CodeGen2 template artifact.*
Oracle's single-row pseudo-table, referenced by the three dead CreateSQL sequence-select properties (SQL-001, SQL-002, SQL-003) as CodeGen2 template artifacts. Not used by any live code path in this library.
Access pattern
Referenced in dead/unwired Criteria.CreateSQL properties only
The following diagram shows verifiable relationships between the primary tables used by this library.
erDiagram
XPRINT_CONTROL ||--o{ XDOCUMENT : "XPRINT_CONTROL_SEQ_NUM (one-to-many)*"
XPRINTER ||--o{ XPRINTER_BIN : "PRINTER_ID (one-to-many)"
XPRINTER_BIN }o--o{ XDOCUMENT : "XBIN_TYPE_CODE + PRINTER_ID (routing join)"
XPRINT_CONTROL {
NUMBER XPRINT_CONTROL_SEQ_NUM PK
VARCHAR2 DIRECTORY_NAME
VARCHAR2 DUPLEX_CODE
DATE PROCESSED_DATE
DATE CREATE_DATE
VARCHAR2 IDM_PATH_NAME
VARCHAR2 XML_FILE_NAME
VARCHAR2 MD5_HASH_VALUE
}
XDOCUMENT {
NUMBER XDOCUMENT_SEQ_NUM PK
NUMBER XPRINT_CONTROL_SEQ_NUM FK
VARCHAR2 XBIN_TYPE_CODE
NUMBER COPIES_COUNT
VARCHAR2 FILE_NAME
VARCHAR2 PRINT_GROUP_TEXT
VARCHAR2 DUPLEX_CODE
}
XPRINTER {
VARCHAR2 PRINTER_ID PK
VARCHAR2 NETWORK_NAME
}
XPRINTER_BIN {
VARCHAR2 PRINTER_ID FK
VARCHAR2 XBIN_TYPE_CODE
NUMBER BIN_NUM
}
XDEFERRED_PRINT {
NUMBER XDEFERRED_SEQ_NUM PK
VARCHAR2 DOCUMENT_DESCR
VARCHAR2 DUPLEX_CODE
DATE PRINTED_DATE
DATE CREATE_DATE
NUMBER COPIES_COUNT
NCLOB XML_VALUE_TEXT
}
Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.