Oracle Fusion · Data dictionary
WLF_LEARNING_PLANS_F
SharedUsed in 0 subject areas81 reporting columnsBICC incremental-ready
Learning (WLF).
Likely primary key: LEARNING_PLAN_ID, EFFECTIVE_START_DATE (inferred from Oracle naming conventions — verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| EFFECTIVE_END_DATE | ● | End date of the effective-dated record. | |
| EFFECTIVE_START_DATE | PK? | ● | Start date of the effective-dated record. |
| ENTERPRISE_ID | ● | Identifier for the enterprise. | |
| 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. | |
| LEARNING_ITEM_ID | ● | Identifier for the learning item. | |
| LEARNING_PLAN_ID | PK? | ● | Identifier for the learning plan. |
| MONETARY_BUDGET | ● | Monetary budget. | |
| MONETARY_CURRENCY_CODE | ● | Currency code for the monetary. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| PLN_ATTRIBUTE1 | ● | Pln attribute1. | |
| PLN_ATTRIBUTE10 | ● | Pln attribute10. | |
| PLN_ATTRIBUTE11 | ● | Pln attribute11. | |
| PLN_ATTRIBUTE12 | ● | Pln attribute12. | |
| PLN_ATTRIBUTE13 | ● | Pln attribute13. | |
| PLN_ATTRIBUTE14 | ● | Pln attribute14. | |
| PLN_ATTRIBUTE15 | ● | Pln attribute15. | |
| PLN_ATTRIBUTE16 | ● | Pln attribute16. | |
| PLN_ATTRIBUTE17 | ● | Pln attribute17. | |
| PLN_ATTRIBUTE18 | ● | Pln attribute18. | |
| PLN_ATTRIBUTE19 | ● | Pln attribute19. | |
| PLN_ATTRIBUTE2 | ● | Pln attribute2. | |
| PLN_ATTRIBUTE20 | ● | Pln attribute20. | |
| PLN_ATTRIBUTE21 | ● | Pln attribute21. | |
| PLN_ATTRIBUTE22 | ● | Pln attribute22. | |
| PLN_ATTRIBUTE23 | ● | Pln attribute23. | |
| PLN_ATTRIBUTE24 | ● | Pln attribute24. | |
| PLN_ATTRIBUTE25 | ● | Pln attribute25. | |
| PLN_ATTRIBUTE26 | ● | Pln attribute26. | |
| PLN_ATTRIBUTE27 | ● | Pln attribute27. | |
| PLN_ATTRIBUTE28 | ● | Pln attribute28. | |
| PLN_ATTRIBUTE29 | ● | Pln attribute29. | |
| PLN_ATTRIBUTE3 | ● | Pln attribute3. | |
| PLN_ATTRIBUTE30 | ● | Pln attribute30. | |
| PLN_ATTRIBUTE4 | ● | Pln attribute4. | |
| PLN_ATTRIBUTE5 | ● | Pln attribute5. | |
| PLN_ATTRIBUTE6 | ● | Pln attribute6. | |
| PLN_ATTRIBUTE7 | ● | Pln attribute7. | |
| PLN_ATTRIBUTE8 | ● | Pln attribute8. | |
| PLN_ATTRIBUTE9 | ● | Pln attribute9. | |
| PLN_ATTRIBUTE_CATEGORY | ● | Pln attribute category. | |
| PLN_ATTRIBUTE_DATE1 | ● | Pln attribute date1. | |
| PLN_ATTRIBUTE_DATE10 | ● | Pln attribute date10. | |
| PLN_ATTRIBUTE_DATE11 | ● | Pln attribute date11. | |
| PLN_ATTRIBUTE_DATE12 | ● | Pln attribute date12. | |
| PLN_ATTRIBUTE_DATE13 | ● | Pln attribute date13. | |
| PLN_ATTRIBUTE_DATE14 | ● | Pln attribute date14. | |
| PLN_ATTRIBUTE_DATE15 | ● | Pln attribute date15. | |
| PLN_ATTRIBUTE_DATE2 | ● | Pln attribute date2. | |
| PLN_ATTRIBUTE_DATE3 | ● | Pln attribute date3. | |
| PLN_ATTRIBUTE_DATE4 | ● | Pln attribute date4. | |
| PLN_ATTRIBUTE_DATE5 | ● | Pln attribute date5. | |
| PLN_ATTRIBUTE_DATE6 | ● | Pln attribute date6. | |
| PLN_ATTRIBUTE_DATE7 | ● | Pln attribute date7. | |
| PLN_ATTRIBUTE_DATE8 | ● | Pln attribute date8. | |
| PLN_ATTRIBUTE_DATE9 | ● | Pln attribute date9. | |
| PLN_ATTRIBUTE_NUMBER1 | ● | Pln attribute number1. | |
| PLN_ATTRIBUTE_NUMBER10 | ● | Pln attribute number10. | |
| PLN_ATTRIBUTE_NUMBER11 | ● | Pln attribute number11. | |
| PLN_ATTRIBUTE_NUMBER12 | ● | Pln attribute number12. | |
| PLN_ATTRIBUTE_NUMBER13 | ● | Pln attribute number13. | |
| PLN_ATTRIBUTE_NUMBER14 | ● | Pln attribute number14. | |
| PLN_ATTRIBUTE_NUMBER15 | ● | Pln attribute number15. | |
| PLN_ATTRIBUTE_NUMBER16 | ● | Pln attribute number16. | |
| PLN_ATTRIBUTE_NUMBER17 | ● | Pln attribute number17. | |
| PLN_ATTRIBUTE_NUMBER18 | ● | Pln attribute number18. | |
| PLN_ATTRIBUTE_NUMBER19 | ● | Pln attribute number19. | |
| PLN_ATTRIBUTE_NUMBER2 | ● | Pln attribute number2. | |
| PLN_ATTRIBUTE_NUMBER20 | ● | Pln attribute number20. | |
| PLN_ATTRIBUTE_NUMBER3 | ● | Pln attribute number3. | |
| PLN_ATTRIBUTE_NUMBER4 | ● | Pln attribute number4. | |
| PLN_ATTRIBUTE_NUMBER5 | ● | Pln attribute number5. | |
| PLN_ATTRIBUTE_NUMBER6 | ● | Pln attribute number6. | |
| PLN_ATTRIBUTE_NUMBER7 | ● | Pln attribute number7. | |
| PLN_ATTRIBUTE_NUMBER8 | ● | Pln attribute number8. | |
| PLN_ATTRIBUTE_NUMBER9 | ● | Pln attribute number9. | |
| TIME_BUDGET | ● | Time budget. | |
| WAGE_RATE_FF | ● | Wage rate ff. |
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 WLF_LEARNING_PLANS_F?
We ship parameterized SQL, BICC config, and dbt models you own.