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

PER_COL_AGREEMENTS_F

HCMUsed in 0 subject areas154 reporting columnsBICC incremental-ready

Person / Worker (PER).

Primary key: not yet catalogued for PER_COL_AGREEMENTS_F, reference Oracle Tables & Views guide. · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): LEGAL_ENTITY_ID → XLE_ENTITY_PROFILES

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.
BARGAINING_UNIT_CODE●Code identifying the bargaining unit.
BUSINESS_GROUP_ID●Identifier for the business group.
CAG_INFORMATION1●Cag information1.
CAG_INFORMATION10●Cag information10.
CAG_INFORMATION11●Cag information11.
CAG_INFORMATION12●Cag information12.
CAG_INFORMATION13●Cag information13.
CAG_INFORMATION14●Cag information14.
CAG_INFORMATION15●Cag information15.
CAG_INFORMATION16●Cag information16.
CAG_INFORMATION17●Cag information17.
CAG_INFORMATION18●Cag information18.
CAG_INFORMATION19●Cag information19.
CAG_INFORMATION2●Cag information2.
CAG_INFORMATION20●Cag information20.
CAG_INFORMATION21●Cag information21.
CAG_INFORMATION22●Cag information22.
CAG_INFORMATION23●Cag information23.
CAG_INFORMATION24●Cag information24.
CAG_INFORMATION25●Cag information25.
CAG_INFORMATION26●Cag information26.
CAG_INFORMATION27●Cag information27.
CAG_INFORMATION28●Cag information28.
CAG_INFORMATION29●Cag information29.
CAG_INFORMATION3●Cag information3.
CAG_INFORMATION30●Cag information30.
CAG_INFORMATION4●Cag information4.
CAG_INFORMATION5●Cag information5.
CAG_INFORMATION6●Cag information6.
CAG_INFORMATION7●Cag information7.
CAG_INFORMATION8●Cag information8.
CAG_INFORMATION9●Cag information9.
CAG_INFORMATION_CATEGORY●Cag information category.
CAG_INFORMATION_DATE1●Cag information date1.
CAG_INFORMATION_DATE10●Cag information date10.
CAG_INFORMATION_DATE11●Cag information date11.
CAG_INFORMATION_DATE12●Cag information date12.
CAG_INFORMATION_DATE13●Cag information date13.
CAG_INFORMATION_DATE14●Cag information date14.
CAG_INFORMATION_DATE15●Cag information date15.
CAG_INFORMATION_DATE2●Cag information date2.
CAG_INFORMATION_DATE3●Cag information date3.
CAG_INFORMATION_DATE4●Cag information date4.
CAG_INFORMATION_DATE5●Cag information date5.
CAG_INFORMATION_DATE6●Cag information date6.
CAG_INFORMATION_DATE7●Cag information date7.
CAG_INFORMATION_DATE8●Cag information date8.
CAG_INFORMATION_DATE9●Cag information date9.
CAG_INFORMATION_NUMBER1●Cag information number1.
CAG_INFORMATION_NUMBER10●Cag information number10.
CAG_INFORMATION_NUMBER11●Cag information number11.
CAG_INFORMATION_NUMBER12●Cag information number12.
CAG_INFORMATION_NUMBER13●Cag information number13.
CAG_INFORMATION_NUMBER14●Cag information number14.
CAG_INFORMATION_NUMBER15●Cag information number15.
CAG_INFORMATION_NUMBER16●Cag information number16.
CAG_INFORMATION_NUMBER17●Cag information number17.
CAG_INFORMATION_NUMBER18●Cag information number18.
CAG_INFORMATION_NUMBER19●Cag information number19.
CAG_INFORMATION_NUMBER2●Cag information number2.
CAG_INFORMATION_NUMBER20●Cag information number20.
CAG_INFORMATION_NUMBER3●Cag information number3.
CAG_INFORMATION_NUMBER4●Cag information number4.
CAG_INFORMATION_NUMBER5●Cag information number5.
CAG_INFORMATION_NUMBER6●Cag information number6.
CAG_INFORMATION_NUMBER7●Cag information number7.
CAG_INFORMATION_NUMBER8●Cag information number8.
CAG_INFORMATION_NUMBER9●Cag information number9.
COLLECTIVE_AGREEMENT_ID●Identifier for the collective agreement.
COMMENTS●Comments.
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
DESCRIPTION●Description.
EFFECTIVE_END_DATE●End date of the effective-dated record.
EFFECTIVE_START_DATE●Start date of the effective-dated record.
EMPLOYEE_ORG_CONTACT●Employee organization contact.
EMPLOYEE_ORG_NAME●Name of the employee organization.
EMPLOYER_ORG_CONTACT●Employer organization contact.
EMPLOYER_ORG_NAME●Name of the employer organization.
IDENTIFICATION_CODE●Code identifying the identification.
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.
LEGAL_ENTITY_ID●Identifier of the legal entity.
LEGISLATION_CODE●Code identifying the legislation.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
STATUS●Status.
UNION_ID●Identifier for the union.

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 PER_COL_AGREEMENTS_F?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
The report that lies quietly · Approval history vanishes · What the extract does not carry