Search Results hr_document_extra_info_pk




Overview
Explore in AI Chat

Overview

HR_DOCUMENT_EXTRA_INFO is a Human Resources (PER) schema table in Oracle E-Business Suite, documented in ETRM as "Documents of Record Information." It stores supplementary, flexfield-driven detail about documents of record captured against a person or worker, such as visas, passports, licenses, certifications, and other statutory or internally tracked credentials. The table is distinct from the core documents-of-record table, which holds primary identifying attributes; HR_DOCUMENT_EXTRA_INFO provides the extensible attribute payload and related-object linkage that accompanies each document record.

In Data Vault modeling terms, the heuristic classification mined from the foreign-key structure is satellite-leaning. This suggests the table is best treated as a descriptive satellite whose grain is keyed by DOCUMENT_EXTRA_INFO_ID and which enriches a parent document or person hub. In Oracle EBS 12.1.1 and 12.2.2 the object is reported as VALID, residing in the HR schema, with 87 documented columns in the 12.2.2 physical schema.

Key Information Stored

The surrogate primary key is DOCUMENT_EXTRA_INFO_ID, enforced by the unique index/pk constraint HR_DOCUMENT_EXTRA_INFO_PK. It is the only documented unique index, and therefore the only business-key candidate formally recorded; no alternate unique key is present in the metadata.

Common Use Cases and Queries

The table supports compliance reporting, document expiry monitoring, and integration extracts. A typical expiry report joins to the document type definition and filters on DATE_TO:

  • Expiring documents: SELECT dei.person_id, dei.document_number, dei.date_to FROM hr.hr_document_extra_info dei WHERE dei.date_to BETWEEN SYSDATE AND SYSDATE + 90.
  • By document type: filter with dei.document_type_id = :p_type_id.
  • Flexfield reporting uses DEI_ATTRIBUTE_CATEGORY as the context discriminator, then selects only the DEI_ATTRIBUTEn columns relevant to that context, since the 30 attribute columns are context-dependent.
  • Purging or archiving can key off OBJECT_VERSION_NUMBER and the WHO columns to identify stale rows.

Related Objects

  • HR_DOCUMENT_EXTRA_INFO_PK — primary key constraint/index on DOCUMENT_EXTRA_INFO_ID.
  • Document type definition — referenced through DOCUMENT_TYPE_ID.
  • ASO_QUOTE_RELATED_OBJECTS — the documented foreign-table target associated with RELATED_OBJECT_ID.
  • Person / worker tables (PER_ALL_PEOPLE_F) — linked through PERSON_ID for worker-level reporting.
  • Core documents-of-record tables — the parent records this satellite describes.
  • HR document APIs (hr_document_api) — the supported programmatic interface for creating and maintaining document rows rather than direct DML.