Results for “pa_pay_proj_status_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_PAY_PROJ_STATUS_ALL is a transactional table in the Oracle Projects (PA) schema that stores the details of the payroll batch interfaced from Oracle Payroll into Oracle Projects. Within Oracle EBS 12.1.1 and 12.2.2, it serves as the staging and status-tracking vehicle for payroll costs that flow into project accounting, capturing, for each interface run, whether the payroll assignment's costs were successfully transferred and whether any project rollback was performed. The table is a critical control point for troubleshooting the Oracle Payroll-to-Projects cost interface, since the flags recorded here determine whether distributions are eligible for further processing or must be re-interfaced.

The heuristic Data Vault classification mined from its foreign key structure is standalone. Under this classification, the table does not naturally resolve into a hub, link, or satellite because its relationships are not part of a conformed, integrated key structure. From a modeling perspective, one may treat PA_PAY_PROJ_STATUS_ALL as a status/transaction satellite attached to the payroll interface process, keyed by the combination of interface run, person, and assignment rather than operating as an independent business entity.

Key Information Stored

The documented physical schema contains 12 columns. The most significant are:

• INTERFACE_RUN_ID — Identifier of the payroll cost interface run in which the assignment was processed; part of the business key unique index.
• PERSON_ID — The employee or person whose payroll costs are being interfaced; part of the business key.
• ASSIGNMENT_ID — The payroll assignment for which the process status is tracked; part of the business key.
• PAYROLL_STATUS_FLAG — Status indicator for the payroll side of the interface; typically reflects success or failure of the payroll batch processing.
• PROJECT_ROLLBACK_STATUS_IND — Indicates whether a project rollback occurred for the interfaced payroll cost, a key diagnostic field when costs must be reversed or re-processed.
• ASSIGNMENT_ACTION_ID — Foreign key to PAY_ASSIGNMENT_ACTIONS, linking the status record to the underlying payroll action.
• REQUEST_ID — Concurrent request that created or processed the record, valuable for tracing a specific run.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns capturing who created and last modified the row and when.

The unique index PA_PAY_PROJ_STATUS_U2 (INTERFACE_RUN_ID, PERSON_ID, ASSIGNMENT_ID) establishes the business-key candidate and enforces one status row per assignment per interface run.

Common Use Cases and Queries

Typical scenarios include identifying failed payroll cost transfers before period close, confirming that a payroll batch completed successfully, and auditing rollbacks for project payroll costs. A representative diagnostic query joins the table to PAY_ASSIGNMENT_ACTIONS and filters on status flags for a given run:

• SELECT p.INTERFACE_RUN_ID, p.PERSON_ID, p.ASSIGNMENT_ID, p.PAYROLL_STATUS_FLAG, p.PROJECT_ROLLBACK_STATUS_IND FROM PA.PA_PAY_PROJ_STATUS_ALL p WHERE p.INTERFACE_RUN_ID = :run_id ORDER BY p.PERSON_ID, p.ASSIGNMENT_ID;
• Join to payroll actions: SELECT p.*, a.* FROM PA.PA_PAY_PROJ_STATUS_ALL p, PAY.PAY_ASSIGNMENT_ACTIONS a WHERE p.ASSIGNMENT_ACTION_ID = a.ASSIGNMENT_ACTION_ID;
• Locate rollbacks: SELECT * FROM PA.PA_PAY_PROJ_STATUS_ALL WHERE PROJECT_ROLLBACK_STATUS_IND = 'Y';

These patterns support Payroll-to-Projects reconciliation reports and run-status dashboards used by payroll and project accountants.

Related Objects

• PAY_ASSIGNMENT_ACTIONS — Referenced via ASSIGNMENT_ACTION_ID; the primary foreign key linkage to the payroll action that generated the project cost.
• PA_PAY_PROJ_STATUS_ALL unique index PA_PAY_PROJ_STATUS_U2 — defines the business key and should be referenced when designing queries.
• Oracle Payroll cost interface concurrent programs — Create and populate this table through the payroll-to-Projects process, driving INTERFACE_RUN_ID.
• PA project cost distribution tables — Consume successful interface results for expenditure processing after status validation.
• PA interface run / batch tracking objects — Provide context for INTERFACE_RUN_ID values recorded here.

Together these objects form the boundary between payroll processing and project cost accounting, with PA_PAY_PROJ_STATUS_ALL acting as the authoritative status log of each interfaced payroll batch.