Oracle Fusion · Data dictionary
PAY_PAYROLL_REL_ACTIONS
PayrollUsed in 0 subject areas14 reporting columns
Payroll (PAY).
Likely primary key: PAYROLL_REL_ACTION_ID (inferred from Oracle naming conventions — verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTION_SEQUENCE | ● | Action sequence. | |
| ACTION_STATUS | ● | Status of the action. | |
| CHUNK_NUMBER | ● | Chunk number. | |
| END_DATE | ● | End date. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| PAYROLL_ACTION_ID | ● | Identifier for the payroll action. | |
| PAYROLL_RELATIONSHIP_ID | ● | Identifier for the payroll relationship. | |
| PAYROLL_REL_ACTION_ID | PK? | ● | Identifier for the payroll rel action. |
| PRE_PAYMENT_ID | ● | Identifier for the pre payment. | |
| RETRO_COMPONENT_ID | ● | Identifier for the retro component. | |
| RUN_TYPE_ID | ● | Identifier for the run type. | |
| SERIAL_NUMBER | ● | Serial number. | |
| SOURCE_ACTION_ID | ● | Identifier for the source action. | |
| START_DATE | ● | Start date. |
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_PAYROLL_REL_ACTIONS?
We ship parameterized SQL, BICC config, and dbt models you own.