Oracle Fusion · Data dictionary
PAY_ASSIGNED_PAYROLLS_F
PayrollUsed in 0 subject areas77 reporting columnsBICC incremental-ready
Payroll (PAY).
Likely primary key: ASSIGNED_PAYROLL_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
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ASG_INFORMATION1 | ● | Asg information1. | |
| ASG_INFORMATION10 | ● | Asg information10. | |
| ASG_INFORMATION11 | ● | Asg information11. | |
| ASG_INFORMATION12 | ● | Asg information12. | |
| ASG_INFORMATION13 | ● | Asg information13. | |
| ASG_INFORMATION14 | ● | Asg information14. | |
| ASG_INFORMATION15 | ● | Asg information15. | |
| ASG_INFORMATION16 | ● | Asg information16. | |
| ASG_INFORMATION17 | ● | Asg information17. | |
| ASG_INFORMATION18 | ● | Asg information18. | |
| ASG_INFORMATION19 | ● | Asg information19. | |
| ASG_INFORMATION2 | ● | Asg information2. | |
| ASG_INFORMATION20 | ● | Asg information20. | |
| ASG_INFORMATION21 | ● | Asg information21. | |
| ASG_INFORMATION22 | ● | Asg information22. | |
| ASG_INFORMATION23 | ● | Asg information23. | |
| ASG_INFORMATION24 | ● | Asg information24. | |
| ASG_INFORMATION25 | ● | Asg information25. | |
| ASG_INFORMATION26 | ● | Asg information26. | |
| ASG_INFORMATION27 | ● | Asg information27. | |
| ASG_INFORMATION28 | ● | Asg information28. | |
| ASG_INFORMATION29 | ● | Asg information29. | |
| ASG_INFORMATION3 | ● | Asg information3. | |
| ASG_INFORMATION30 | ● | Asg information30. | |
| ASG_INFORMATION4 | ● | Asg information4. | |
| ASG_INFORMATION5 | ● | Asg information5. | |
| ASG_INFORMATION6 | ● | Asg information6. | |
| ASG_INFORMATION7 | ● | Asg information7. | |
| ASG_INFORMATION8 | ● | Asg information8. | |
| ASG_INFORMATION9 | ● | Asg information9. | |
| ASG_INFORMATION_DATE1 | ● | Asg information date1. | |
| ASG_INFORMATION_DATE10 | ● | Asg information date10. | |
| ASG_INFORMATION_DATE11 | ● | Asg information date11. | |
| ASG_INFORMATION_DATE12 | ● | Asg information date12. | |
| ASG_INFORMATION_DATE13 | ● | Asg information date13. | |
| ASG_INFORMATION_DATE14 | ● | Asg information date14. | |
| ASG_INFORMATION_DATE15 | ● | Asg information date15. | |
| ASG_INFORMATION_DATE2 | ● | Asg information date2. | |
| ASG_INFORMATION_DATE3 | ● | Asg information date3. | |
| ASG_INFORMATION_DATE4 | ● | Asg information date4. | |
| ASG_INFORMATION_DATE5 | ● | Asg information date5. | |
| ASG_INFORMATION_DATE6 | ● | Asg information date6. | |
| ASG_INFORMATION_DATE7 | ● | Asg information date7. | |
| ASG_INFORMATION_DATE8 | ● | Asg information date8. | |
| ASG_INFORMATION_DATE9 | ● | Asg information date9. | |
| ASG_INFORMATION_NUMBER1 | ● | Asg information number1. | |
| ASG_INFORMATION_NUMBER10 | ● | Asg information number10. | |
| ASG_INFORMATION_NUMBER11 | ● | Asg information number11. | |
| ASG_INFORMATION_NUMBER12 | ● | Asg information number12. | |
| ASG_INFORMATION_NUMBER13 | ● | Asg information number13. | |
| ASG_INFORMATION_NUMBER14 | ● | Asg information number14. | |
| ASG_INFORMATION_NUMBER15 | ● | Asg information number15. | |
| ASG_INFORMATION_NUMBER16 | ● | Asg information number16. | |
| ASG_INFORMATION_NUMBER17 | ● | Asg information number17. | |
| ASG_INFORMATION_NUMBER18 | ● | Asg information number18. | |
| ASG_INFORMATION_NUMBER19 | ● | Asg information number19. | |
| ASG_INFORMATION_NUMBER2 | ● | Asg information number2. | |
| ASG_INFORMATION_NUMBER20 | ● | Asg information number20. | |
| ASG_INFORMATION_NUMBER3 | ● | Asg information number3. | |
| ASG_INFORMATION_NUMBER4 | ● | Asg information number4. | |
| ASG_INFORMATION_NUMBER5 | ● | Asg information number5. | |
| ASG_INFORMATION_NUMBER6 | ● | Asg information number6. | |
| ASG_INFORMATION_NUMBER7 | ● | Asg information number7. | |
| ASG_INFORMATION_NUMBER8 | ● | Asg information number8. | |
| ASG_INFORMATION_NUMBER9 | ● | Asg information number9. | |
| ASG_INFORMATION_TYPE | ● | Type of asg information. | |
| ASSIGNED_PAYROLL_ID | PK? | ● | Identifier for the assigned payroll. |
| 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. | |
| PRIMARY_FLAG | ● | Indicator (Y/N) for the primary. |
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_ASSIGNED_PAYROLLS_F?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table