Oracle Fusion · Data dictionary
PER_TASKS_IN_CHECKLIST_B
HCMUsed in 0 subject areas136 reporting columnsBICC incremental-ready
Person / Worker (PER) — base table — language-neutral data (paired with _TL labels and the _VL view).
Primary key: not yet catalogued for PER_TASKS_IN_CHECKLIST_B — reference Oracle Tables & Views guide. · Incremental key: LAST_UPDATE_DATE
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTION_TYPE | ● | Type of action. | |
| ACTIVE_INACTIVE_FLAG | ● | Indicator (Y/N) for the active inactive. | |
| ALLOW_ALLC_TASK_CREATE | ● | Allow allc task create. | |
| ALLOW_ALLC_TASK_DELETE | ● | Allow allc task delete. | |
| ALLOW_ALLC_TASK_UPDATE | ● | Allow allc task update. | |
| AME_ATTRIBUTE_IDENTIFIER | ● | Ame attribute identifier. | |
| 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. | |
| CHECKLIST_ID | ● | Identifier for the checklist. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DOCUMENT_TYPE_ID | ● | Identifier for the document type. | |
| ELIGIBILITY_OBJECT_ID | ● | Identifier for the eligibility object. | |
| ELIGIBILITY_PROFILE_ID | ● | Identifier for the eligibility profile. | |
| ESIGN_TYPE | ● | Type of esign. | |
| EXPIRY_AFTER_DAYS | ● | Expiry after days. | |
| 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_DATE | INCR | ● | 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_TIME | ● | Meeting time. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| OWNER_RESP_TYPE | ● | Type of owner resp. | |
| QUESTIONNAIRE_ID | ● | Identifier for the questionnaire. | |
| REMINDER_RECURRENCE | ● | Reminder recurrence. | |
| REMINDER_RELATIVE_TO | ● | Reminder relative to. | |
| REPORT_PATH | ● | Report path. | |
| RESPONSIBILITY_TYPE | ● | Type of responsibility. | |
| SIGN_TEMPLATE | ● | Sign template. | |
| TARGET_DURATION | ● | Target duration. | |
| TARGET_DURATION_UOM | ● | Target duration unit of measure. | |
| TASK_ACTION_CODE | ● | Code identifying the task action. | |
| TASK_CATEGORY | ● | Task category. | |
| TASK_CONFIGURATION | ● | Task configuration. | |
| TASK_DELAY_DURATION | ● | Task delay duration. | |
| TASK_DELAY_DURATION_UOM | ● | Task delay duration unit of measure. | |
| TASK_IN_CHECKLIST_CODE | ● | Code identifying the task in checklist. | |
| TASK_IN_CHECKLIST_ID | ● | Identifier for the task in checklist. | |
| 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_TASKS_IN_CHECKLIST_B?
We ship parameterized SQL, BICC config, and dbt models you own.