Results for “fit_exemptions”

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

Overview

The APPS.HR_CERIDIAN_RESIDENT_TAX_V view is a payroll interface object within the Oracle E-Business Suite Human Resources (PER) module. It is documented in ETRM 12.2.2 as a VALID view owned by the APPS schema, and its Product/Module classification places it squarely within Oracle HRMS rather than Payroll proper. Its purpose is to expose resident tax-related employee data in the flat, denormalized shape required by the Ceridian Source 100 payroll interface, a third-party payroll bureau integration typically used by North American (predominantly US) organizations that outsource payroll processing.

The view condenses tax withholding attributes drawn from federal, state, and local employee tax rule records into a single row per person, formatted according to Ceridian Source 100 layout expectations. Its name and structure confirm it supplies the "resident tax" segment of that interface feed, complementing other HR_CERIDIAN* views that handle employer, deduction, and earnings segments. Because it is consistently exposed across both 12.1.1 and 12.2.2, it remains a stable integration surface for customers running the Ceridian interface on either release. The user's search term fica_futa_exempt corresponds directly to the package function HR_CERIDIAN.FICA_FUTA_EXEMPT invoked in the view's select list, which is the specific mechanism the view uses to derive FICA and FUTA exemption indicators.

Underlying Base Objects

ETRM documents the view as referencing a combination of packages, views, synonyms, and base tables:

• HR_CERIDIAN (PACKAGE) — supplies the FICA_FUTA_EXEMPT function that consolidates Medicare, Social Security, and FUTA exemption flags into a single Ceridian-facing value.
• HR_GENERAL and HR_SECURITY (PACKAGES) — provide general HR utilities and row-level security enforcement respectively.
• HR_ORGANIZATION_UNITS (VIEW) and HR_SOFT_CODING_KEYFLEX (SYNONYM) — supply organization naming and key flexfield context.
• PAY_US_EMP_FED_TAX_RULES_F, PAY_US_EMP_STATE_TAX_RULES_F, PAY_US_EMP_CITY_TAX_RULES_F (SYNONYMS) — the core tax rule tables from which FIT, SIT, and LIT exemption, withholding allowance, override amount/rate, and additional tax values are drawn.
• PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_ADDRESSES, PER_PERIODS_OF_SERVICE (SYNONYMS) — person, assignment, address, and service history sources.
• PAY_US_CITY_NAMES, PAY_US_COUNTIES, PAY_US_STATES (SYNONYMS) — geographic reference data used to resolve jurisdiction and location names.

The view joins these objects to produce one consolidated resident tax record per employee, with GREATEST(NVL(...,TO_DATE('01-01-1900')), ...) expressions used to derive last-update tracking columns across the person, address, and assignment sources.

Key Columns

• EMPLOYEE_NUMBER, LAST_NAME, FIRST_NAME, MIDDLE_NAMES — employee identity attributes from PER_ALL_PEOPLE_F.
• Filing Status — a DECODE translating numeric filing status codes ('01','02','03','04') into Ceridian single/married indicators ('S','M').
• FICA_FUTA_EXEMPT — the derived value returned by HR_CERIDIAN.FICA_FUTA_EXEMPT(PFT.MEDICARE_TAX_EXEMPT, PFT.SS_TAX_EXEMPT, PFT.FUTA_TAX_EXEMPT). This is the column the searcher's term references.
• FIT_EXEMPT, WITHHOLDING_ALLOWANCES, FIT_OVERRIDE_*, FIT_ADDITIONAL_TAX — federal income tax attributes, with override amount/rate and additional tax concatenated into a single formatted string using '%' and '$' markers.
• SIT_EXEMPT, LIT_EXEMPT and their override/additional tax columns — the analogous state and local income tax attributes.
• JURISDICTION_CODE (from LIT), CITY_NAME (x2 from CN, CN2), ADD_INFORMATION17/REGION_2 — geographic and jurisdiction identifiers.
• BUSINESS_GROUP_ID, PERSON_ID — key identifiers used by the payroll interface to correlate records.

Common Use Cases and Queries

This view is primarily consumed by the Ceridian Source 100 extraction process rather than by end-user reporting. Typical scenarios include auditing which employees are flagged exempt from FICA/FUTA, validating withholding allowance counts before a payroll transmit, and reconciling override amounts between Oracle Payroll and the Ceridian file.

A representative query isolating FICA/FUTA exemption for a business group:

SELECT EMPLOYEE_NUMBER, LAST_NAME, FIRST_NAME, FICA_FUTA_EXEMPT, FIT_EXEMPT, SIT_EXEMPT, LIT_EXEMPT FROM APPS.HR_CERIDIAN_RESIDENT_TAX_V WHERE BUSINESS_GROUP_ID = :p_bg_id;

To review employees with federal overrides or additional withholding:

SELECT EMPLOYEE_NUMBER, FIT_EXEMPT, WITHHOLDING_ALLOWANCES FROM APPS.HR_CERIDIAN_RESIDENT_TAX_V WHERE FIT_EXEMPT = 'N' AND WITHHOLDING_ALLOWANCES > 0;

Because the view enforces HR security via underlying packages, queries should be executed with an APPS-enabled responsibility or through the seeded extraction responsibility to avoid security predicate failures.