Results for “user_display_name”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
EDR_PSIG_PRINT_HISTORY is an E-Records (EDR) module table in the Oracle E-Business Suite EDR schema. Its documented purpose is to maintain the print history for an e-record, providing an auditable record of every print event associated with a controlled electronic document. In regulated environments such as pharmaceutical manufacturing, clinical operations, and quality management, this table underpins print-reproduction accountability for validated records managed through Oracle E-Records. The object is reported with status VALID in both Oracle EBS 12.1.1 and 12.2.2, and is documented with 13 columns in the ETRM 12.2.2 physical schema.
The heuristic Data Vault classification mined from the foreign-key structure is standalone. This suggests a modeling treatment in which the table is not a pure hub, link, or satellite, but carries its own composite identity and a small number of descriptive attributes. Its grain is one row per print event per document, keyed by document identifier and print sequence.
Key Information Stored
The primary key, EDR_PSIG_PRINT_HISTORY_PK, is defined on the composite of DOCUMENT_ID and PRINT_COUNT. Because this unique index functions as the business key, DOCUMENT_ID identifies the e-record being printed and PRINT_COUNT provides the monotonic sequence of print attempts for that record.
- DOCUMENT_ID – Identifier of the e-record for which print history is retained; part of the composite primary key.
- PRINT_COUNT – Sequential print number for the document; part of the composite primary key and the business-key candidate.
- PRINT_DOCUMENT_ID – Identifier of the rendered or generated print document associated with the event.
- PRINT_REQUESTED_BY – The user who initiated the print request.
- PRINT_REQUESTED_DATE – Timestamp of the print request, supporting chronological audit.
- ORIG_SYSTEM and ORIG_SYSTEM_ID – Source system reference; ORIG_SYSTEM_ID resolves to HZ_ORIG_SYSTEMS_B, linking the record to the originating application or registry.
- USER_DISPLAY_NAME – Display name captured at print time, useful for reporting where the numeric user reference is insufficient.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard EBS WHO-column audit attributes tracking row creation and modification.
Common Use Cases and Queries
Typical usage centers on print audit and reconciliation. Quality and compliance teams verify that every controlled record was printed only by authorized personnel, and that reprints are justified. A representative query counts prints per document:
SELECT document_id, COUNT(*) print_events FROM edr.edr_psig_print_history GROUP BY document_id HAVING COUNT(*) > 1;
A second pattern lists the print trail for a specific e-record, including the requester and timestamp:
SELECT print_count, print_requested_by, print_requested_date, user_display_name FROM edr.edr_psig_print_history WHERE document_id = :document_id ORDER BY print_count;
Management reporting may join ORIG_SYSTEM_ID to HZ_ORIG_SYSTEMS_B to attribute print activity by source system, while the WHO columns support change-monitoring extracts for audit trails.
Related Objects
- HZ_ORIG_SYSTEMS_B – Referenced by ORIG_SYSTEM_ID to resolve the originating system registration.
- EDR_PSIG_PRINT_HISTORY_PK – Composite unique index serving as the primary key and business-key candidate.
- EDR e-record document tables keyed by DOCUMENT_ID, which supply the parent record context for each print row.
- Standard EBS audit or WHO-column reports that consume CREATED_BY, LAST_UPDATED_BY, and their date counterparts.
Because the documented foreign-key footprint is limited to HZ_ORIG_SYSTEMS_B, dependencies outside the EDR schema should be validated against the actual database before extending any integration.
-
Maintain print history for a e-record
-
Maintain print history for a e-record
-
Electronic signature document details
-
Electronic signature document details
-
VIEW: EDR.EDR_PSIG_DETAILS# 12.2.2
-
VIEW: EDR.EDR_PSIG_DETAILS# 12.2.2
-
TABLE: EDR.EDR_PSIG_DETAILS 12.1.1
-
TABLE: EDR.EDR_PSIG_DETAILS 12.2.2
-
APPS.EDR_PSIG SQL Statements 12.1.1
-
APPS.EDR_PSIG SQL Statements 12.2.2
-
PACKAGE: APPS.AZW_ARCHIVE 12.1.1
-
PACKAGE: APPS.AZW_ARCHIVE 12.2.2
-
PACKAGE: APPS.PER_PQH_SHR 12.1.1
-
PACKAGE BODY: APPS.EDR_PSIG 12.2.2
-
PACKAGE BODY: APPS.EDR_PSIG 12.1.1
-
PACKAGE: APPS.EDR_PSIG 12.1.1