Search Results work_state_code




Overview
Explore in AI Chat

Overview

APPS.HR_ADP_WORKERS_COMP_V is a public Oracle E-Business Suite view owned by the APPS schema and registered in FND Design Data as PER.HR_ADP_WORKERS_COMP_V. It is classified as a public view intended for custom reporting and related data extraction requirements. In practice this view consolidates workers compensation attributes for employees, exposing the workers compensation code (WORKERS_COMP_CODE) alongside the employee's job, organization, assignment, and payroll context. The object is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2 metadata. Because it is a view rather than a table, it carries no storage of its own; all values are derived at query time from its underlying base objects, so results always reflect the current state of the source data. The view is typically leveraged when an organization needs to report or interface workers compensation classification data associated with ADP (Automatic Data Processing) payroll integration, mapping internal Oracle HR assignment records to ADP company codes, GRE (Government Reporting Entity) identifiers, and state-level workers compensation codes.

Underlying Base Objects

The view is defined over a documented set of base objects spanning HR and Payroll:

The inclusion of HR_SECURITY is significant: the view respects Oracle HR security profiles, so a query returns only the assignments and employees the querying responsibility is permitted to see.

Key Columns

Common Use Cases and Queries

Typical scenarios include validating workers compensation code assignment per employee, preparing ADP payroll extracts, and auditing state and job-to-code mappings. The GREATEST_LAST_UPDATE_DATE column supports delta-based reporting.

Retrieve workers compensation codes for a specific employee:

  • SELECT employee_number, job_name, workers_comp_code, work_state_code FROM apps.hr_adp_workers_comp_v WHERE employee_number = '10023';

List primary assignments by state:

  • SELECT employee_number, work_state_code, workers_comp_code, primary_flag FROM apps.hr_adp_workers_comp_v WHERE primary_flag = 'Y' ORDER BY work_state_code;

Incremental extraction using the change date:

  • SELECT person_id, assignment_id, workers_comp_code, work_state_code, greatest_last_update_date FROM apps.hr_adp_workers_comp_v WHERE greatest_last_update_date >= SYSDATE - 1;