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

PER_ALLOCATED_TASKS

HCMUsed in 0 subject areas173 reporting columnsBICC incremental-ready

Person / Worker (PER).

Likely primary key: ALLOCATED_TASK_ID (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): ALLOCATED_CHECKLIST_ID → PER_ALLOCATED_CHECKLISTS · QUESTIONNAIRE_ID → HRQ_QUESTIONNAIRES_B

Columns

ColumnKeyIn reportsDescription (inferred)
ABS_ALLOCATED_CHECKLIST_ID●Identifier for the abs allocated checklist.
ACTION_TYPE●Type of action.
ACTUAL_END_DATE●Actual end date.
ACTUAL_START_DATE●Actual start date.
ALLOCATED_CHECKLIST_ID●Identifier for the allocated checklist.
ALLOCATED_TASK_IDPK?●Identifier for the allocated task.
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.
COMPLETED_BY●Completed by.
COMPLETION_DATE●Completion date.
CONTACT_DETAILS●Contact details.
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
DEFAULT_PERF_RESP_TYPE●Type of default perf resp.
DEF_ALLOCATION_DATE●Def allocation date.
DEPENDENT_ON_TASKS●Dependent on tasks.
DETAIL_ALLOC_CHECKLIST_ID●Identifier for the detail alloc checklist.
DETAIL_CHECKLIST_ID●Identifier for the detail checklist.
DOCUMENT_ENTITY_ID●Identifier for the document entity.
DOCUMENT_TYPE_ID●Identifier for the document type.
ENTERPRISE_ID●Identifier for the enterprise.
ESIGN_TYPE●Type of esign.
EXPIRY_DAYS●Expiry days.
FLEX_CONTEXT_CODE●Code identifying the flex context.
GENERATE_ATOM_FEED●Generate atom feed.
INFORMATION1●Information1.
INFORMATION10●Information10.
INFORMATION11●Information11.
INFORMATION12●Information12.
INFORMATION13●Information13.
INFORMATION14●Information14.
INFORMATION15●Information15.
INFORMATION16●Information16.
INFORMATION17●Information17.
INFORMATION18●Information18.
INFORMATION19●Information19.
INFORMATION2●Information2.
INFORMATION20●Information20.
INFORMATION21●Information21.
INFORMATION22●Information22.
INFORMATION23●Information23.
INFORMATION24●Information24.
INFORMATION25●Information25.
INFORMATION26●Information26.
INFORMATION27●Information27.
INFORMATION28●Information28.
INFORMATION29●Information29.
INFORMATION3●Information3.
INFORMATION30●Information30.
INFORMATION4●Information4.
INFORMATION5●Information5.
INFORMATION6●Information6.
INFORMATION7●Information7.
INFORMATION8●Information8.
INFORMATION9●Information9.
INFORMATION_CATEGORY●Information category.
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.
MANDATORY_FLAG●Indicator (Y/N) for the mandatory.
MEETING_OFFSET●Meeting offset.
MEETING_TIME●Meeting time.
NEXT_REMINDER_DATE●Next reminder date.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
OWNER_RESP_TYPE●Type of owner resp.
OWNER_RESP_TYPE_USERS●Owner resp type users.
PERFORMER_ORIG_SYSTEM●Performer orig system.
PERFORMER_ORIG_SYS_ID●Identifier for the performer orig sys.
PROCESSING_MODE●Processing mode.
QUESTIONNAIRE_ID●Identifier for the questionnaire.
REASSIGNED_BY●Reassigned by.
REASSIGNED_DATE●Reassigned date.
REMINDER_COUNT●Reminder count.
REMINDER_DURATION●Reminder duration.
REMINDER_RECURRENCE●Reminder recurrence.
REMINDER_RELATIVE_TO●Reminder relative to.
REMINDER_TEMPLATE_ID●Identifier for the reminder template.
REOPENED_BY●Reopened by.
REOPEN_DATE●Reopen date.
REPORT_PATH●Report path.
RESPONSIBILITY_TYPE●Type of responsibility.
RESPONSIBILITY_TYPE_GUID●Responsibility type guid.
RESP_PERFORMER_AVAILABILITY●Resp performer availability.
SIGNER_EMAIL●Signer email.
SIGNER_NAME●Name of the signer.
SIGN_DATE●Sign date.
SIGN_DOCUMENT●Sign document.
SIGN_TEMPLATE●Sign template.
STATUS●Status.
TARGET_DURATION●Target duration.
TARGET_DURATION_UOM●Target duration unit of measure.
TARGET_END_DATE●Target end date.
TARGET_START_DATE●Target start date.
TASK_ACTION_CODE●Code identifying the task action.
TASK_ACTION_ID●Identifier for the task action.
TASK_COMMENTS●Task comments.
TASK_CONFIGURATION●Task configuration.
TASK_DELAY_DURATION●Task delay duration.
TASK_DELAY_DURATION_UOM●Task delay duration unit of measure.
TASK_FEATURE1●Task feature1.
TASK_INITIATOR●Task initiator.
TASK_INITIATOR_PERSON_ID●Identifier for the task initiator person.
TASK_IN_CHECKLIST_ID●Identifier for the task in checklist.
TASK_OWNERS●Task owners.
TASK_OWNER_PERSON_ID●Identifier for the task owner person.
TASK_OWNER_USERNAME●Task owner username.
TASK_PERCENTAGE_COMPLETE●Task percentage complete.
TASK_PERFORMERS●Task performers.
TASK_SEQUENCE●Task sequence.

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_ALLOCATED_TASKS?
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