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

PER_PERSON_NAMES_F

HCMUsed in 0 subject areas160 reporting columnsBICC incremental-ready

Person / Worker (PER).

Likely primary key: PERSON_NAME_ID, EFFECTIVE_START_DATE (inferred from Oracle naming conventions — verify against Tables & Views) · 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.
CHAR_SET_CONTEXT●Char set context.
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_TYPE●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.
NAM_INFORMATION_DATE1●Nam information date1.
NAM_INFORMATION_DATE10●Nam information date10.
NAM_INFORMATION_DATE11●Nam information date11.
NAM_INFORMATION_DATE12●Nam information date12.
NAM_INFORMATION_DATE13●Nam information date13.
NAM_INFORMATION_DATE14●Nam information date14.
NAM_INFORMATION_DATE15●Nam information date15.
NAM_INFORMATION_DATE2●Nam information date2.
NAM_INFORMATION_DATE3●Nam information date3.
NAM_INFORMATION_DATE4●Nam information date4.
NAM_INFORMATION_DATE5●Nam information date5.
NAM_INFORMATION_DATE6●Nam information date6.
NAM_INFORMATION_DATE7●Nam information date7.
NAM_INFORMATION_DATE8●Nam information date8.
NAM_INFORMATION_DATE9●Nam information date9.
NAM_INFORMATION_NUMBER1●Nam information number1.
NAM_INFORMATION_NUMBER10●Nam information number10.
NAM_INFORMATION_NUMBER11●Nam information number11.
NAM_INFORMATION_NUMBER12●Nam information number12.
NAM_INFORMATION_NUMBER13●Nam information number13.
NAM_INFORMATION_NUMBER14●Nam information number14.
NAM_INFORMATION_NUMBER15●Nam information number15.
NAM_INFORMATION_NUMBER16●Nam information number16.
NAM_INFORMATION_NUMBER17●Nam information number17.
NAM_INFORMATION_NUMBER18●Nam information number18.
NAM_INFORMATION_NUMBER19●Nam information number19.
NAM_INFORMATION_NUMBER2●Nam information number2.
NAM_INFORMATION_NUMBER20●Nam information number20.
NAM_INFORMATION_NUMBER3●Nam information number3.
NAM_INFORMATION_NUMBER4●Nam information number4.
NAM_INFORMATION_NUMBER5●Nam information number5.
NAM_INFORMATION_NUMBER6●Nam information number6.
NAM_INFORMATION_NUMBER7●Nam information number7.
NAM_INFORMATION_NUMBER8●Nam information number8.
NAM_INFORMATION_NUMBER9●Nam information number9.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
ORDER_NAME●Name of the order.
PERSON_ID●Identifier for the person.
PERSON_NAME_IDPK?●Identifier for the person name.
PREVIOUS_LAST_NAME●Name of the previous last.
PRE_NAME_ADJUNCT●Pre name adjunct.
SUFFIX●Suffix.
TITLE●Title.

3 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.

Subject areas

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