Search Results ny_1f_record

Overview

APPS.PER_NEW_HIRE_PKG is a PL/SQL package in Oracle E-Business Suite, declared with AUTHID CURRENT_USER, that supports the generation of U.S. state and federal new-hire reporting records from Oracle Human Resources (HR) and Oracle Payroll data. New-hire reporting is a statutory requirement in the United States: employers must report newly hired or rehired employees to state agencies, typically within a short window after the hire date. Rather than forcing each jurisdiction's format into a separate reporting tool, PER_NEW_HIRE_PKG centralizes the encoding of employee, address, assignment, and payroll attributes into the fixed-position and delimited record layouts required by individual states and by federal Forms W-4 and equivalent tax forms.

The package is classified as OTHER in the ETRM metadata rather than as a public API, indicating that it is intended primarily for internal consumption by Oracle HRMS concurrent programs and reports rather than for direct customer invocation. Its header comment records a legacy constraint: because Reports' conversion function was defective, the package returns converted characters, and the calling environment's NLS_CHARACTERSET must match the database character set. Concurrent Manager satisfies this condition automatically, so the constraint is transparent to normal operation.

Key Procedures and Functions

The package exposes 58 documented procedures and functions. Most are record-formatting functions named after the jurisdiction they serve, each returning a VARCHAR2 string representing one formatted report record. Notable members include:

• CHAR_SET_INIT — initializes the character-set context used by the record-building functions, ensuring correct character conversion for downstream Reports processing.
• CA_E4_RECORD, CA_W4_RECORD, CA_T4_RECORD — build California Employer's Report (E4), federal/state withholding (W4), and related California tax records from identification, address, and hire-date attributes.
• NY_1A_RECORD, NY_1E_RECORD, NY_1H_RECORD, NY_1T_RECORD, NY_1F_RECORD — construct the New York State new-hire submission record segments (1A, 1E, 1H, 1T, 1F), which together form the state's required new-hire file.
• AL_NEW_HIRE_RECORD, FL_NEW_HIRE_RECORD, IL_NEW_HIRE_RECORD, TX_NEW_HIRE_RECORD, SC_NEW_HIRE_RECORD, MI_NEW_HIRE_RECORD, OH_NEW_HIRE_RECORD, PA_NEW_HIRE_RECORD — jurisdiction-specific new-hire records for Alabama, Florida, Illinois, Texas, South Carolina, Michigan, Ohio, and Pennsylvania.
• TX_T4_RECORD — Texas T4 record layout.
• SC_HEADER_RECORD, OH_HEADER_RECORD — header records that precede the detail lines in the South Carolina and Ohio new-hire files. These functions are directly relevant to the search term sc_header_record, which is the South Carolina file header constructor invoked before SC_NEW_HIRE_RECORD detail lines are written.

Tables Accessed

The package reads the core HRMS person, assignment, and address entities to populate new-hire records, including PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_ADDRESSES, PER_JOBS, PER_PAY_BASES, PER_TIME_PERIOD_TYPES, and the payroll element entry tables PAY_ELEMENT_ENTRIES_F and PAY_ELEMENT_ENTRY_VALUES_F. HR_SOFT_CODING_KEYFLEX supplies key flexfield segment values used in record encoding. The documented table list indicates read-only access for reporting purposes; the package's role is to format records, not to persist new-hire submissions.

Usage Notes

PER_NEW_HIRE_PKG is typically invoked from the Oracle HRMS new-hire reporting concurrent programs and associated Reports templates. Because the record functions return complete formatted strings, callers — usually the reporting program's PL/SQL wrapper — pass the retrieved person, address, assignment, and tax attributes for each employee and concatenate the returned values into a submission file. Two other packages reference PER_NEW_HIRE_PKG, confirming its role as a shared formatting layer rather than a standalone deliverable. Customizations should call the package through the same concurrent-request path Oracle supplies, honoring the NLS_CHARACTERSET requirement described in the package header, since direct invocation from a session with a mismatched character set can corrupt converted output.