Oracle Fusion · Data dictionary
PAY_PAYROLL_ACTIONS
PayrollUsed in 0 subject areas50 reporting columnsBICC incremental-ready
Payroll (PAY).
Likely primary key: PAYROLL_ACTION_ID (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): CONSOLIDATION_SET_ID → PAY_CONSOLIDATION_SETS · LEGISLATIVE_DATA_GROUP_ID → PER_LEGISLATIVE_DATA_GROUPS · PAY_REQUEST_ID → PAY_REQUESTS
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTION_PARAMETER_GROUP_ID | ● | Identifier for the action parameter group. | |
| ACTION_POPULATION_STATUS | ● | Status of the action population. | |
| ACTION_SEQUENCE | ● | Action sequence. | |
| ACTION_STATUS | ● | Status of the action. | |
| ACTION_TYPE | ● | Type of action. | |
| ASSIGNMENT_SET_ID | ● | Identifier for the assignment set. | |
| BATCH_PROCESS_MODE | ● | Batch process mode. | |
| BIP_JOB_ID | ● | Identifier for the bip job. | |
| CHEQUE_PROCEDURE | ● | Cheque procedure. | |
| CONSOLIDATION_SET_ID | ● | Identifier for the consolidation set. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CURRENT_CHUNK_NUMBER | ● | Current chunk number. | |
| CURRENT_TASK | ● | Current task. | |
| DATE_EARNED | ● | Date earned. | |
| DEDN_TIME_PERIOD_ID | ● | Identifier for the dedn time period. | |
| DISPLAY_RUN_NUMBER | ● | Display run number. | |
| EARN_TIME_PERIOD_ID | ● | Identifier for the earn time period. | |
| EFFECTIVE_DATE | ● | Effective date. | |
| EFT_EXPIRY_DATE | ● | Eft expiry date. | |
| EFT_FILE_REFERENCE | ● | Eft file reference. | |
| ELEMENT_SET_ID | ● | Identifier for the element set. | |
| END_CHEQUE_NUMBER | ● | End cheque number. | |
| END_DATE | ● | End date. | |
| ENTERPRISE_ID | ● | Identifier for the enterprise. | |
| FILE_NAME | ● | Name of the file. | |
| FUTURE_PROCESS_MODE | ● | Future process mode. | |
| INTERFACE_TYPE_ID | ● | Identifier for the interface type. | |
| 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. | |
| LEGISLATION_CODE | ● | Code identifying the legislation. | |
| LEGISLATIVE_DATA_GROUP_ID | ● | Identifier for the legislative data group. | |
| LEGISLATIVE_PARAMETERS | ● | Legislative parameters. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| ORG_PAYMENT_METHOD_ID | ● | Identifier for the organization payment method. | |
| OVERRIDING_DD_DATE | ● | Overriding dd date. | |
| PARENT_ORG_PAY_METHOD_ID | ● | Identifier for the parent organization pay method. | |
| PAYMENT_REASON | ● | Payment reason. | |
| PAYMENT_TYPE_ID | ● | Identifier for the payment type. | |
| PAYROLL_ACTION_ID | PK? | ● | Identifier for the payroll action. |
| PAYROLL_ID | ● | Identifier for the payroll. | |
| PAY_REQUEST_ID | ● | Identifier for the pay request. | |
| REPORT_CATEGORY_ID | ● | Identifier for the report category. | |
| REPORT_FORMAT_MAPPING_ID | ● | Identifier for the report format mapping. | |
| RETRO_DEFINITION_ID | ● | Identifier for the retro definition. | |
| RUN_TYPE_ID | ● | Identifier for the run type. | |
| START_CHEQUE_NUMBER | ● | Start cheque number. | |
| START_DATE | ● | Start date. | |
| TARGET_PAYROLL_ACTION_ID | ● | Identifier for the target payroll action. |
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_ACTIONS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table