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

PER_PERSON_NAMES_F_V

HCMUsed in 169 subject areas124 reporting columnsBICC incremental-ready

Person / Worker (PER) — denormalized view.

Primary key: PERSON_ID, EFFECTIVE_START_DATE, NAME_TYPE · Incremental key: LAST_UPDATE_DATE

Columns

ColumnKeyIn reportsDescription (inferred)
ATTRIBUTE1●Descriptive flexfield segment.
ATTRIBUTE10●Descriptive flexfield segment.
ATTRIBUTE11●Descriptive flexfield segment.
ATTRIBUTE12●Descriptive flexfield segment.
ATTRIBUTE13●Descriptive flexfield segment.
ATTRIBUTE14●Descriptive flexfield segment.
ATTRIBUTE15●Descriptive flexfield segment.
ATTRIBUTE16●Descriptive flexfield segment.
ATTRIBUTE17●Descriptive flexfield segment.
ATTRIBUTE18●Descriptive flexfield segment.
ATTRIBUTE19●Descriptive flexfield segment.
ATTRIBUTE2●Descriptive flexfield segment.
ATTRIBUTE20●Descriptive flexfield segment.
ATTRIBUTE21●Descriptive flexfield segment.
ATTRIBUTE22●Descriptive flexfield segment.
ATTRIBUTE23●Descriptive flexfield segment.
ATTRIBUTE24●Descriptive flexfield segment.
ATTRIBUTE25●Descriptive flexfield segment.
ATTRIBUTE26●Descriptive flexfield segment.
ATTRIBUTE27●Descriptive flexfield segment.
ATTRIBUTE28●Descriptive flexfield segment.
ATTRIBUTE29●Descriptive flexfield segment.
ATTRIBUTE3●Descriptive flexfield segment.
ATTRIBUTE30●Descriptive flexfield segment.
ATTRIBUTE4●Descriptive flexfield segment.
ATTRIBUTE5●Descriptive flexfield segment.
ATTRIBUTE6●Descriptive flexfield segment.
ATTRIBUTE7●Descriptive flexfield segment.
ATTRIBUTE8●Descriptive flexfield segment.
ATTRIBUTE9●Descriptive flexfield segment.
ATTRIBUTE_CATEGORY●Descriptive flexfield context (structure definition).
ATTRIBUTE_DATE1●Descriptive flexfield segment.
ATTRIBUTE_DATE10●Descriptive flexfield segment.
ATTRIBUTE_DATE11●Descriptive flexfield segment.
ATTRIBUTE_DATE12●Descriptive flexfield segment.
ATTRIBUTE_DATE13●Descriptive flexfield segment.
ATTRIBUTE_DATE14●Descriptive flexfield segment.
ATTRIBUTE_DATE15●Descriptive flexfield segment.
ATTRIBUTE_DATE2●Descriptive flexfield segment.
ATTRIBUTE_DATE3●Descriptive flexfield segment.
ATTRIBUTE_DATE4●Descriptive flexfield segment.
ATTRIBUTE_DATE5●Descriptive flexfield segment.
ATTRIBUTE_DATE6●Descriptive flexfield segment.
ATTRIBUTE_DATE7●Descriptive flexfield segment.
ATTRIBUTE_DATE8●Descriptive flexfield segment.
ATTRIBUTE_DATE9●Descriptive flexfield segment.
ATTRIBUTE_NUMBER1●Descriptive flexfield segment.
ATTRIBUTE_NUMBER10●Descriptive flexfield segment.
ATTRIBUTE_NUMBER11●Descriptive flexfield segment.
ATTRIBUTE_NUMBER12●Descriptive flexfield segment.
ATTRIBUTE_NUMBER13●Descriptive flexfield segment.
ATTRIBUTE_NUMBER14●Descriptive flexfield segment.
ATTRIBUTE_NUMBER15●Descriptive flexfield segment.
ATTRIBUTE_NUMBER16●Descriptive flexfield segment.
ATTRIBUTE_NUMBER17●Descriptive flexfield segment.
ATTRIBUTE_NUMBER18●Descriptive flexfield segment.
ATTRIBUTE_NUMBER19●Descriptive flexfield segment.
ATTRIBUTE_NUMBER2●Descriptive flexfield segment.
ATTRIBUTE_NUMBER20●Descriptive flexfield segment.
ATTRIBUTE_NUMBER3●Descriptive flexfield segment.
ATTRIBUTE_NUMBER4●Descriptive flexfield segment.
ATTRIBUTE_NUMBER5●Descriptive flexfield segment.
ATTRIBUTE_NUMBER6●Descriptive flexfield segment.
ATTRIBUTE_NUMBER7●Descriptive flexfield segment.
ATTRIBUTE_NUMBER8●Descriptive flexfield segment.
ATTRIBUTE_NUMBER9●Descriptive flexfield segment.
BUSINESS_GROUP_ID●Identifier for the business group.
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
DISPLAY_NAME●Name of the display.
EFFECTIVE_END_DATE●End date of the effective-dated record.
EFFECTIVE_START_DATEPK●Start date of the effective-dated record.
FIRST_NAME●Name of the first.
FULL_NAME●Name of the full.
HONORS●Honors.
KNOWN_AS●Known as.
LAST_NAME●Name of the last.
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.
LEGISLATION_CODE●Code identifying the legislation.
LIST_NAME●Name of the list.
MIDDLE_NAMES●Middle names.
MILITARY_RANK●Military rank.
NAME_TYPEPK●Type of name.
NAM_INFORMATION1●Nam information1.
NAM_INFORMATION10●Nam information10.
NAM_INFORMATION11●Nam information11.
NAM_INFORMATION12●Nam information12.
NAM_INFORMATION13●Nam information13.
NAM_INFORMATION14●Nam information14.
NAM_INFORMATION15●Nam information15.
NAM_INFORMATION16●Nam information16.
NAM_INFORMATION17●Nam information17.
NAM_INFORMATION18●Nam information18.
NAM_INFORMATION19●Nam information19.
NAM_INFORMATION2●Nam information2.
NAM_INFORMATION20●Nam information20.
NAM_INFORMATION21●Nam information21.
NAM_INFORMATION22●Nam information22.
NAM_INFORMATION23●Nam information23.
NAM_INFORMATION24●Nam information24.
NAM_INFORMATION25●Nam information25.
NAM_INFORMATION26●Nam information26.
NAM_INFORMATION27●Nam information27.
NAM_INFORMATION28●Nam information28.
NAM_INFORMATION29●Nam information29.
NAM_INFORMATION3●Nam information3.
NAM_INFORMATION30●Nam information30.
NAM_INFORMATION4●Nam information4.
NAM_INFORMATION5●Nam information5.
NAM_INFORMATION6●Nam information6.
NAM_INFORMATION7●Nam information7.
NAM_INFORMATION8●Nam information8.
NAM_INFORMATION9●Nam information9.
NAM_INFORMATION_CATEGORY●Nam information category.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
ORDER_NAME●Name of the order.
PERSON_IDPK●Identifier for the person.
PERSON_NAME_ID●Identifier for the person name.
PREVIOUS_LAST_NAME●Name of the previous last.
PRE_NAME_ADJUNCT●Pre name adjunct.
SUFFIX●Suffix.
TITLE●Title.

2 reports read from this table

Change a column here and these are the reports that move with it — the blast radius for any change to PER_PERSON_NAMES_F_V.

Where this surfaces in OTBI

The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.

Need the extract + dbt staging for PER_PERSON_NAMES_F_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us