Oracle Fusion · Data dictionary
WLF_RESOURCES_B
SharedUsed in 0 subject areas76 reporting columns
Learning (WLF), base table, language-neutral data (paired with _TL labels and the _VL view).
Likely primary key: RESOURCE_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Joins (inferred from key columns): SOURCE_ID → HRT_SOURCES_B
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ADDRESS_ID | ● | Identifier for the address. | |
| ATTRIBUTION_ID | ● | Identifier for the attribution. | |
| ATTRIBUTION_TYPE | ● | Type of attribution. | |
| CAPACITY | ● | Capacity. | |
| CONTACT_ID | ● | Identifier for the contact. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| ENTERPRISE_ID | ● | Identifier for the enterprise. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | 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. | |
| LOCATION_ID | ● | Identifier for the location. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| RESOURCE_ID | PK? | ● | Identifier for the resource. |
| RESOURCE_NUMBER | ● | Resource number. | |
| RESOURCE_TYPE | ● | Type of resource. | |
| RS_ATTRIBUTE1 | ● | Rs attribute1. | |
| RS_ATTRIBUTE10 | ● | Rs attribute10. | |
| RS_ATTRIBUTE11 | ● | Rs attribute11. | |
| RS_ATTRIBUTE12 | ● | Rs attribute12. | |
| RS_ATTRIBUTE13 | ● | Rs attribute13. | |
| RS_ATTRIBUTE14 | ● | Rs attribute14. | |
| RS_ATTRIBUTE15 | ● | Rs attribute15. | |
| RS_ATTRIBUTE16 | ● | Rs attribute16. | |
| RS_ATTRIBUTE17 | ● | Rs attribute17. | |
| RS_ATTRIBUTE18 | ● | Rs attribute18. | |
| RS_ATTRIBUTE19 | ● | Rs attribute19. | |
| RS_ATTRIBUTE2 | ● | Rs attribute2. | |
| RS_ATTRIBUTE20 | ● | Rs attribute20. | |
| RS_ATTRIBUTE3 | ● | Rs attribute3. | |
| RS_ATTRIBUTE4 | ● | Rs attribute4. | |
| RS_ATTRIBUTE5 | ● | Rs attribute5. | |
| RS_ATTRIBUTE6 | ● | Rs attribute6. | |
| RS_ATTRIBUTE7 | ● | Rs attribute7. | |
| RS_ATTRIBUTE8 | ● | Rs attribute8. | |
| RS_ATTRIBUTE9 | ● | Rs attribute9. | |
| RS_ATTRIBUTE_CATEGORY | ● | Rs attribute category. | |
| RS_ATTRIBUTE_DATE1 | ● | Rs attribute date1. | |
| RS_ATTRIBUTE_DATE10 | ● | Rs attribute date10. | |
| RS_ATTRIBUTE_DATE11 | ● | Rs attribute date11. | |
| RS_ATTRIBUTE_DATE12 | ● | Rs attribute date12. | |
| RS_ATTRIBUTE_DATE13 | ● | Rs attribute date13. | |
| RS_ATTRIBUTE_DATE14 | ● | Rs attribute date14. | |
| RS_ATTRIBUTE_DATE15 | ● | Rs attribute date15. | |
| RS_ATTRIBUTE_DATE2 | ● | Rs attribute date2. | |
| RS_ATTRIBUTE_DATE3 | ● | Rs attribute date3. | |
| RS_ATTRIBUTE_DATE4 | ● | Rs attribute date4. | |
| RS_ATTRIBUTE_DATE5 | ● | Rs attribute date5. | |
| RS_ATTRIBUTE_DATE6 | ● | Rs attribute date6. | |
| RS_ATTRIBUTE_DATE7 | ● | Rs attribute date7. | |
| RS_ATTRIBUTE_DATE8 | ● | Rs attribute date8. | |
| RS_ATTRIBUTE_DATE9 | ● | Rs attribute date9. | |
| RS_ATTRIBUTE_NUMBER1 | ● | Rs attribute number1. | |
| RS_ATTRIBUTE_NUMBER10 | ● | Rs attribute number10. | |
| RS_ATTRIBUTE_NUMBER11 | ● | Rs attribute number11. | |
| RS_ATTRIBUTE_NUMBER12 | ● | Rs attribute number12. | |
| RS_ATTRIBUTE_NUMBER13 | ● | Rs attribute number13. | |
| RS_ATTRIBUTE_NUMBER14 | ● | Rs attribute number14. | |
| RS_ATTRIBUTE_NUMBER15 | ● | Rs attribute number15. | |
| RS_ATTRIBUTE_NUMBER16 | ● | Rs attribute number16. | |
| RS_ATTRIBUTE_NUMBER17 | ● | Rs attribute number17. | |
| RS_ATTRIBUTE_NUMBER18 | ● | Rs attribute number18. | |
| RS_ATTRIBUTE_NUMBER19 | ● | Rs attribute number19. | |
| RS_ATTRIBUTE_NUMBER2 | ● | Rs attribute number2. | |
| RS_ATTRIBUTE_NUMBER20 | ● | Rs attribute number20. | |
| RS_ATTRIBUTE_NUMBER3 | ● | Rs attribute number3. | |
| RS_ATTRIBUTE_NUMBER4 | ● | Rs attribute number4. | |
| RS_ATTRIBUTE_NUMBER5 | ● | Rs attribute number5. | |
| RS_ATTRIBUTE_NUMBER6 | ● | Rs attribute number6. | |
| RS_ATTRIBUTE_NUMBER7 | ● | Rs attribute number7. | |
| RS_ATTRIBUTE_NUMBER8 | ● | Rs attribute number8. | |
| RS_ATTRIBUTE_NUMBER9 | ● | Rs attribute number9. | |
| SOURCE_ID | ● | Identifier for the source. | |
| SOURCE_TYPE | ● | Type of source. | |
| STATUS | ● | Status. | |
| TRAINING_VENDOR_RES_ID | ● | Identifier for the training vendor res. |
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_RESOURCES_B?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table