Search Results worksite_number

Overview

APPS.HR_CERIDIAN_500_ASSIGNMENT_V is a public Oracle EBS view owned by the APPS schema and registered under FND Design Data as PER.HR_CERIDIAN_500_ASSIGNMENT_V. Its status is VALID. The view is designed to return information about employee assignments in a format suitable for Ceridian payroll interfaces and related reporting. The view is documented as a public view which may be useful for custom reporting or other data requirements, meaning Oracle does not necessarily guarantee its structure across releases, but it remains available for read-only consumption by custom reports, extracts, and payroll integration routines.

Functionally, the view flattens assignment, element entry, payroll, and worksite attributes into a single row per assignment, exposing both native Oracle HRMS identifiers (ASSIGNMENT_ID, PERSON_ID, BUSINESS_GROUP_ID, PAYROLL_ID) and Ceridian-specific codes such as EMP_CODE, HOLIDAY_CODE, VACATION_CODE, SICK_CODE, RATE_CODE, WORKERS_COMP_CODE, and PAY_FREQUENCY. It is therefore best understood as a reporting and outbound-interface artifact rather than a transactional view. Because it combines HR assignment data with payroll element entries, it is commonly consumed by Ceridian 500-format extract processes and by downstream reporting that needs a single, Ceridian-oriented projection of an assignment.

Underlying Base Objects

The view is defined over a substantial set of HRMS and payroll base objects. The principal HRMS sources are PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F, PER_PERIODS_OF_SERVICE, PER_PAY_BASES, PER_PAY_PROPOSALS, PER_ASSIGNMENT_STATUS_TYPES, PER_ASS_STATUS_TYPE_AMENDS, and PER_TIME_PERIOD_TYPES. Payroll-related sources include PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_LINKS_X, PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F, PAY_PAYROLLS_F, PAY_JOB_WC_CODE_USAGES, and HR_SOFT_CODING_KEYFLEX. Location and organization context is drawn from HR_LOCATIONS_ALL and HR_ORGANIZATION_UNITS.

Security and logic are supplied by packaged PL/SQL: HR_CERIDIAN, HR_GENERAL, HR_PAY_INTERFACE_PKG, and HR_SECURITY. The HR_SECURITY dependency is significant because it indicates the view respects HRMS security profiles, so results are filtered according to the accessing user's security profile. The Ceridian-specific columns (employee, holiday, vacation, and sick codes) originate from the Ceridian employee codes element, whose effective dates are exposed through POL_EFFECTIVE_START_DATE and POL_EFFECTIVE_END_DATE. The view therefore joins assignment records to element entries and element entry values to retrieve those coded values.

Key Columns

The view exposes identifying columns including EMPLOYEE_NUMBER, ASSIGNMENT_NUMBER, ASSIGNMENT_ID, PERSON_ID, BUSINESS_GROUP_ID, and PAYROLL_ID. PRIMARY_FLAG (Y/N) identifies the primary assignment, and SOCIAL_SECURITY_NUMBER provides the national identifier. Payroll and rate attributes include RATE_CODE, BASE_RATE, HOURLY_RATE, ANNUAL_SALARY, PAY_FREQUENCY, PAYROLL_STATUS, STANDARD_HOURS, and SHIFT. Ceridian code columns include EMP_CODE, HOLIDAY_CODE, VACATION_CODE, SICK_CODE, and WORKERS_COMP_CODE. COMPANY carries the GRE name. PREVIOUS_SALARY_CHANGE_DATE and LAST_UPDATE_DATE support change tracking.

Notably, both WORKSITE_NUMBER and WORKSITE_STATE_CODE are datatype CHAR and are documented as Not currently used. This is directly relevant to a search for "worksite_state_code": although the column exists in the view definition for interface compatibility, it is not populated with meaningful data in the current release, and it should not be relied upon for worksite state reporting. Worksite state information, when required, must be sourced from the assignment's location record (HR_LOCATIONS_ALL) rather than from this view.

Common Use Cases and Queries

Typical uses include Ceridian 500 extract generation, payroll reconciliation, and ad hoc HR reporting that requires Ceridian codes alongside assignment and salary attributes. Because the view honors HRMS security, it is safe to query from a custom report without bypassing security profiles.

• List assignments with Ceridian codes for a business group:
  SELECT employee_number, assignment_number, primary_flag, emp_code, holiday_code, vacation_code, sick_code FROM apps.hr_ceridian_500_assignment_v WHERE business_group_id = :p_bg_id;
• Retrieve active salary and pay frequency data:
  SELECT assignment_id, person_id, rate_code, base_rate, hourly_rate, annual_salary, pay_frequency, payroll_status FROM apps.hr_ceridian_500_assignment_v WHERE payroll_status IS NOT NULL;
• Identify primary assignments for interface output:
  SELECT employee_number, assignment_number, social_security_number, worksite_state_code FROM apps.hr_ceridian_500_assignment_v WHERE primary_flag = 'Y'; — note that WORKSITE_STATE_CODE returns no meaningful value.
• Track recent salary changes:
  SELECT assignment_id, previous_salary_change_date FROM apps.hr_ceridian_500_assignment_v WHERE previous_salary_change_date > :p_since_date;

When worksite state is genuinely required, join the assignment to HR_LOCATIONS_ALL via the assignment's location_id in PER_ALL_ASSIGNMENTS_F rather than depending on WORKSITE_STATE_CODE.