Search Results hr_document_types




Overview
Explore in AI Chat

Overview

HR.HR_DOCUMENT_TYPES is a Human Resources (PER) setup table that defines the document types available for Documents of Record in Oracle EBS 12.1.1 and 12.2.2. Each row represents a configurable document category that can be attached to a person, assignment, or HR record — for example identification papers, visas, passports, contracts, or certifications — together with the rules that govern how those documents are captured and validated. Because the table sits at the intersection of HR security, authorization requirements, and legislative compliance, it is typically treated as reference or control data rather than transactional data.

The ETRM metadata classifies this object as standalone in the heuristic Data Vault model. In practice, this suggests modeling HR_DOCUMENT_TYPES as a hub or reference table keyed on DOCUMENT_TYPE_ID, with no direct parent dependency inside the documented relationship graph. Any dependents are captured through the foreign keys listed below.

Key Information Stored

Common Use Cases and Queries

HR administrators query this table to enumerate available document types when configuring Documents of Record, and reporting teams join it to person-level document instances to analyze compliance. A typical lookup for active document types by legislation is:

  • SELECT document_type_id, category_code, sub_category_code FROM hr.hr_document_types WHERE active_inactive_flag = 'Y' AND legislation_code = :legislation;
  • Resolving a seeded type: SELECT * FROM hr.hr_document_types WHERE system_document_type = :system_document_type;
  • Expiry monitoring: use WARNING_PERIOD against the corresponding person document dates to flag renewals.

Because the table is small and largely static, it is commonly used as a validation set for flexfields, self-service page configurations, and extracts to downstream systems.

Related Objects

  • MTL_MWB_GTMP — references HR_DOCUMENT_TYPES.DOCUMENT_TYPE_ID; relevant to mobile/wireless gateway staging.
  • ZX_PTNR_NEG_TAX_LINE_GT — references HR_DOCUMENT_TYPE_ID in partner negotiation tax line processing.
  • HR_DOCUMENT_TYPES_PK — primary key index on DOCUMENT_TYPE_ID, ZD_EDITION_NAME.
  • HR_DOCUMENT_TYPES_U1 — unique business-key index on SYSTEM_DOCUMENT_TYPE, ZD_EDITION_NAME.
  • PER_DOCUMENTS_OF_RECORD — the transactional table holding person-level document instances keyed to these types.
  • HR_LOOKUPS — often joined for CATEGORY_CODE and SUB_CATEGORY_CODE validation.