Analytics Catalog/Data dictionary/HR_DOCUMENTS_OF_RECORD
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

HR_DOCUMENTS_OF_RECORD

HCMUsed in 0 subject areas192 reporting columnsBICC incremental-ready

HR / Workforce (HR).

Likely primary key: DOCUMENTS_OF_RECORD_ID (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE

Columns

ColumnKeyIn reportsDescription (inferred)
ASSIGNMENT_ID●Identifier for the assignment.
COMMENTS●Comments.
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
CREATION_SOURCE●Creation source.
DATE_FROM●Date from.
DATE_TO●Date to.
DEI_ATTRIBUTE1●Dei attribute1.
DEI_ATTRIBUTE10●Dei attribute10.
DEI_ATTRIBUTE11●Dei attribute11.
DEI_ATTRIBUTE12●Dei attribute12.
DEI_ATTRIBUTE13●Dei attribute13.
DEI_ATTRIBUTE14●Dei attribute14.
DEI_ATTRIBUTE15●Dei attribute15.
DEI_ATTRIBUTE16●Dei attribute16.
DEI_ATTRIBUTE17●Dei attribute17.
DEI_ATTRIBUTE18●Dei attribute18.
DEI_ATTRIBUTE19●Dei attribute19.
DEI_ATTRIBUTE2●Dei attribute2.
DEI_ATTRIBUTE20●Dei attribute20.
DEI_ATTRIBUTE21●Dei attribute21.
DEI_ATTRIBUTE22●Dei attribute22.
DEI_ATTRIBUTE23●Dei attribute23.
DEI_ATTRIBUTE24●Dei attribute24.
DEI_ATTRIBUTE25●Dei attribute25.
DEI_ATTRIBUTE26●Dei attribute26.
DEI_ATTRIBUTE27●Dei attribute27.
DEI_ATTRIBUTE28●Dei attribute28.
DEI_ATTRIBUTE29●Dei attribute29.
DEI_ATTRIBUTE3●Dei attribute3.
DEI_ATTRIBUTE30●Dei attribute30.
DEI_ATTRIBUTE31●Dei attribute31.
DEI_ATTRIBUTE32●Dei attribute32.
DEI_ATTRIBUTE33●Dei attribute33.
DEI_ATTRIBUTE34●Dei attribute34.
DEI_ATTRIBUTE35●Dei attribute35.
DEI_ATTRIBUTE36●Dei attribute36.
DEI_ATTRIBUTE37●Dei attribute37.
DEI_ATTRIBUTE38●Dei attribute38.
DEI_ATTRIBUTE39●Dei attribute39.
DEI_ATTRIBUTE4●Dei attribute4.
DEI_ATTRIBUTE40●Dei attribute40.
DEI_ATTRIBUTE5●Dei attribute5.
DEI_ATTRIBUTE6●Dei attribute6.
DEI_ATTRIBUTE7●Dei attribute7.
DEI_ATTRIBUTE8●Dei attribute8.
DEI_ATTRIBUTE9●Dei attribute9.
DEI_ATTRIBUTE_CATEGORY●Dei attribute category.
DEI_ATTRIBUTE_DATE1●Dei attribute date1.
DEI_ATTRIBUTE_DATE10●Dei attribute date10.
DEI_ATTRIBUTE_DATE11●Dei attribute date11.
DEI_ATTRIBUTE_DATE12●Dei attribute date12.
DEI_ATTRIBUTE_DATE13●Dei attribute date13.
DEI_ATTRIBUTE_DATE14●Dei attribute date14.
DEI_ATTRIBUTE_DATE15●Dei attribute date15.
DEI_ATTRIBUTE_DATE2●Dei attribute date2.
DEI_ATTRIBUTE_DATE3●Dei attribute date3.
DEI_ATTRIBUTE_DATE4●Dei attribute date4.
DEI_ATTRIBUTE_DATE5●Dei attribute date5.
DEI_ATTRIBUTE_DATE6●Dei attribute date6.
DEI_ATTRIBUTE_DATE7●Dei attribute date7.
DEI_ATTRIBUTE_DATE8●Dei attribute date8.
DEI_ATTRIBUTE_DATE9●Dei attribute date9.
DEI_ATTRIBUTE_NUMBER1●Dei attribute number1.
DEI_ATTRIBUTE_NUMBER10●Dei attribute number10.
DEI_ATTRIBUTE_NUMBER11●Dei attribute number11.
DEI_ATTRIBUTE_NUMBER12●Dei attribute number12.
DEI_ATTRIBUTE_NUMBER13●Dei attribute number13.
DEI_ATTRIBUTE_NUMBER14●Dei attribute number14.
DEI_ATTRIBUTE_NUMBER15●Dei attribute number15.
DEI_ATTRIBUTE_NUMBER16●Dei attribute number16.
DEI_ATTRIBUTE_NUMBER17●Dei attribute number17.
DEI_ATTRIBUTE_NUMBER18●Dei attribute number18.
DEI_ATTRIBUTE_NUMBER19●Dei attribute number19.
DEI_ATTRIBUTE_NUMBER2●Dei attribute number2.
DEI_ATTRIBUTE_NUMBER20●Dei attribute number20.
DEI_ATTRIBUTE_NUMBER3●Dei attribute number3.
DEI_ATTRIBUTE_NUMBER4●Dei attribute number4.
DEI_ATTRIBUTE_NUMBER5●Dei attribute number5.
DEI_ATTRIBUTE_NUMBER6●Dei attribute number6.
DEI_ATTRIBUTE_NUMBER7●Dei attribute number7.
DEI_ATTRIBUTE_NUMBER8●Dei attribute number8.
DEI_ATTRIBUTE_NUMBER9●Dei attribute number9.
DEI_ATTRIBUTE_TIMESTAMP1●Dei attribute timestamp1.
DEI_ATTRIBUTE_TIMESTAMP2●Dei attribute timestamp2.
DEI_ATTRIBUTE_TIMESTAMP3●Dei attribute timestamp3.
DEI_ATTRIBUTE_TIMESTAMP4●Dei attribute timestamp4.
DEI_ATTRIBUTE_TIMESTAMP5●Dei attribute timestamp5.
DEI_INFORMATION1●Dei information1.
DEI_INFORMATION10●Dei information10.
DEI_INFORMATION11●Dei information11.
DEI_INFORMATION12●Dei information12.
DEI_INFORMATION13●Dei information13.
DEI_INFORMATION14●Dei information14.
DEI_INFORMATION15●Dei information15.
DEI_INFORMATION16●Dei information16.
DEI_INFORMATION17●Dei information17.
DEI_INFORMATION18●Dei information18.
DEI_INFORMATION19●Dei information19.
DEI_INFORMATION2●Dei information2.
DEI_INFORMATION20●Dei information20.
DEI_INFORMATION21●Dei information21.
DEI_INFORMATION22●Dei information22.
DEI_INFORMATION23●Dei information23.
DEI_INFORMATION24●Dei information24.
DEI_INFORMATION25●Dei information25.
DEI_INFORMATION26●Dei information26.
DEI_INFORMATION27●Dei information27.
DEI_INFORMATION28●Dei information28.
DEI_INFORMATION29●Dei information29.
DEI_INFORMATION3●Dei information3.
DEI_INFORMATION30●Dei information30.
DEI_INFORMATION31●Dei information31.
DEI_INFORMATION32●Dei information32.
DEI_INFORMATION33●Dei information33.
DEI_INFORMATION34●Dei information34.
DEI_INFORMATION35●Dei information35.
DEI_INFORMATION36●Dei information36.
DEI_INFORMATION37●Dei information37.
DEI_INFORMATION38●Dei information38.
DEI_INFORMATION39●Dei information39.
DEI_INFORMATION4●Dei information4.
DEI_INFORMATION40●Dei information40.
DEI_INFORMATION5●Dei information5.
DEI_INFORMATION6●Dei information6.
DEI_INFORMATION7●Dei information7.
DEI_INFORMATION8●Dei information8.
DEI_INFORMATION9●Dei information9.
DEI_INFORMATION_CATEGORY●Dei information category.
DEI_INFORMATION_DATE1●Dei information date1.
DEI_INFORMATION_DATE10●Dei information date10.
DEI_INFORMATION_DATE11●Dei information date11.
DEI_INFORMATION_DATE12●Dei information date12.
DEI_INFORMATION_DATE13●Dei information date13.
DEI_INFORMATION_DATE14●Dei information date14.
DEI_INFORMATION_DATE15●Dei information date15.
DEI_INFORMATION_DATE2●Dei information date2.
DEI_INFORMATION_DATE3●Dei information date3.
DEI_INFORMATION_DATE4●Dei information date4.
DEI_INFORMATION_DATE5●Dei information date5.
DEI_INFORMATION_DATE6●Dei information date6.
DEI_INFORMATION_DATE7●Dei information date7.
DEI_INFORMATION_DATE8●Dei information date8.
DEI_INFORMATION_DATE9●Dei information date9.
DEI_INFORMATION_NUMBER1●Dei information number1.
DEI_INFORMATION_NUMBER10●Dei information number10.
DEI_INFORMATION_NUMBER11●Dei information number11.
DEI_INFORMATION_NUMBER12●Dei information number12.
DEI_INFORMATION_NUMBER13●Dei information number13.
DEI_INFORMATION_NUMBER14●Dei information number14.
DEI_INFORMATION_NUMBER15●Dei information number15.
DEI_INFORMATION_NUMBER16●Dei information number16.
DEI_INFORMATION_NUMBER17●Dei information number17.
DEI_INFORMATION_NUMBER18●Dei information number18.
DEI_INFORMATION_NUMBER19●Dei information number19.
DEI_INFORMATION_NUMBER2●Dei information number2.
DEI_INFORMATION_NUMBER20●Dei information number20.
DEI_INFORMATION_NUMBER3●Dei information number3.
DEI_INFORMATION_NUMBER4●Dei information number4.
DEI_INFORMATION_NUMBER5●Dei information number5.
DEI_INFORMATION_NUMBER6●Dei information number6.
DEI_INFORMATION_NUMBER7●Dei information number7.
DEI_INFORMATION_NUMBER8●Dei information number8.
DEI_INFORMATION_NUMBER9●Dei information number9.
DEI_INFORMATION_TIMESTAMP1●Dei information timestamp1.
DEI_INFORMATION_TIMESTAMP2●Dei information timestamp2.
DEI_INFORMATION_TIMESTAMP3●Dei information timestamp3.
DEI_INFORMATION_TIMESTAMP4●Dei information timestamp4.
DEI_INFORMATION_TIMESTAMP5●Dei information timestamp5.
DOCUMENTS_OF_RECORD_IDPK?●Identifier for the documents of record.
DOCUMENT_CODE●Code identifying the document.
DOCUMENT_NAME●Name of the document.
DOCUMENT_NUMBER●Document number.
DOCUMENT_TYPE_ID●Identifier for the document type.
ENTERPRISE_ID●Identifier for the enterprise.
ISSUED_DATE●Issued date.
ISSUING_AUTHORITY●Issuing authority.
ISSUING_COUNTRY●Issuing country.
ISSUING_LOCATION●Issuing location.
LAST_UPDATED_BY●User who last updated the row.
LAST_UPDATE_DATEINCR●Date and time the row was last updated (the incremental-extract key).
LAST_UPDATE_LOGIN●Session login of the user who last updated the row.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
PERSON_ID●Identifier for the person.
PUBLISH●Publish.
PUBLISH_DATE●Publish date.
RELATED_OBJECT_ID●Identifier for the related object.
RELATED_OBJECT_ID_COL●Related object id col.
RELATED_OBJECT_NAME●Name of the related object.
STATUS●Status.
VERIFIED_BY●Verified by.
VERIFIED_DATE●Verified date.

Used by reports

No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.

Subject areas

Need the extract + dbt staging for HR_DOCUMENTS_OF_RECORD?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
What the extract does not carry · The export ceiling · The extraction pattern