Oracle Fusion · Data dictionary
PAY_PAY_RELATIONSHIPS_F
PayrollUsed in 0 subject areas76 reporting columnsBICC incremental-ready
Payroll (PAY).
Likely primary key: PAYROLL_RELATIONSHIP_ID, EFFECTIVE_START_DATE (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): ELEMENT_CRITERIA_ID → PAY_ELEMENT_CRITERIA · PAYROLL_RELATIONSHIP_ID → PAY_REL_GROUPS_DN
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. |
| ELEMENT_CRITERIA_ID | ● | Identifier for the element criteria. | |
| 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. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| PAYROLL_RELATIONSHIP_ID | PK? | ● | Identifier for the payroll relationship. |
| REL_INFORMATION1 | ● | Rel information1. | |
| REL_INFORMATION10 | ● | Rel information10. | |
| REL_INFORMATION11 | ● | Rel information11. | |
| REL_INFORMATION12 | ● | Rel information12. | |
| REL_INFORMATION13 | ● | Rel information13. | |
| REL_INFORMATION14 | ● | Rel information14. | |
| REL_INFORMATION15 | ● | Rel information15. | |
| REL_INFORMATION16 | ● | Rel information16. | |
| REL_INFORMATION17 | ● | Rel information17. | |
| REL_INFORMATION18 | ● | Rel information18. | |
| REL_INFORMATION19 | ● | Rel information19. | |
| REL_INFORMATION2 | ● | Rel information2. | |
| REL_INFORMATION20 | ● | Rel information20. | |
| REL_INFORMATION21 | ● | Rel information21. | |
| REL_INFORMATION22 | ● | Rel information22. | |
| REL_INFORMATION23 | ● | Rel information23. | |
| REL_INFORMATION24 | ● | Rel information24. | |
| REL_INFORMATION25 | ● | Rel information25. | |
| REL_INFORMATION26 | ● | Rel information26. | |
| REL_INFORMATION27 | ● | Rel information27. | |
| REL_INFORMATION28 | ● | Rel information28. | |
| REL_INFORMATION29 | ● | Rel information29. | |
| REL_INFORMATION3 | ● | Rel information3. | |
| REL_INFORMATION30 | ● | Rel information30. | |
| REL_INFORMATION4 | ● | Rel information4. | |
| REL_INFORMATION5 | ● | Rel information5. | |
| REL_INFORMATION6 | ● | Rel information6. | |
| REL_INFORMATION7 | ● | Rel information7. | |
| REL_INFORMATION8 | ● | Rel information8. | |
| REL_INFORMATION9 | ● | Rel information9. | |
| REL_INFORMATION_DATE1 | ● | Rel information date1. | |
| REL_INFORMATION_DATE10 | ● | Rel information date10. | |
| REL_INFORMATION_DATE11 | ● | Rel information date11. | |
| REL_INFORMATION_DATE12 | ● | Rel information date12. | |
| REL_INFORMATION_DATE13 | ● | Rel information date13. | |
| REL_INFORMATION_DATE14 | ● | Rel information date14. | |
| REL_INFORMATION_DATE15 | ● | Rel information date15. | |
| REL_INFORMATION_DATE2 | ● | Rel information date2. | |
| REL_INFORMATION_DATE3 | ● | Rel information date3. | |
| REL_INFORMATION_DATE4 | ● | Rel information date4. | |
| REL_INFORMATION_DATE5 | ● | Rel information date5. | |
| REL_INFORMATION_DATE6 | ● | Rel information date6. | |
| REL_INFORMATION_DATE7 | ● | Rel information date7. | |
| REL_INFORMATION_DATE8 | ● | Rel information date8. | |
| REL_INFORMATION_DATE9 | ● | Rel information date9. | |
| REL_INFORMATION_NUMBER1 | ● | Rel information number1. | |
| REL_INFORMATION_NUMBER10 | ● | Rel information number10. | |
| REL_INFORMATION_NUMBER11 | ● | Rel information number11. | |
| REL_INFORMATION_NUMBER12 | ● | Rel information number12. | |
| REL_INFORMATION_NUMBER13 | ● | Rel information number13. | |
| REL_INFORMATION_NUMBER14 | ● | Rel information number14. | |
| REL_INFORMATION_NUMBER15 | ● | Rel information number15. | |
| REL_INFORMATION_NUMBER16 | ● | Rel information number16. | |
| REL_INFORMATION_NUMBER17 | ● | Rel information number17. | |
| REL_INFORMATION_NUMBER18 | ● | Rel information number18. | |
| REL_INFORMATION_NUMBER19 | ● | Rel information number19. | |
| REL_INFORMATION_NUMBER2 | ● | Rel information number2. | |
| REL_INFORMATION_NUMBER20 | ● | Rel information number20. | |
| REL_INFORMATION_NUMBER3 | ● | Rel information number3. | |
| REL_INFORMATION_NUMBER4 | ● | Rel information number4. | |
| REL_INFORMATION_NUMBER5 | ● | Rel information number5. | |
| REL_INFORMATION_NUMBER6 | ● | Rel information number6. | |
| REL_INFORMATION_NUMBER7 | ● | Rel information number7. | |
| REL_INFORMATION_NUMBER8 | ● | Rel information number8. | |
| REL_INFORMATION_NUMBER9 | ● | Rel information number9. | |
| REL_INFORMATION_TYPE | ● | Type of rel information. |
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 PAY_PAY_RELATIONSHIPS_F?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table