Search Results format_sqwl_rs_record




Overview
Explore in AI Chat

Overview

APPS.PAY_US_MMRF_SQWL_FORMAT_RECORD is a PL/SQL package body within the Oracle E-Business Suite (EBS) Payroll module, specifically supporting United States legislative reporting requirements. Its stated purpose is to format records that support the generation of SQWL (State Quarterly Wage Listing) magnetic tape output for US legislative reporting. The package produces fixed-position and, in some cases, CSV-style formatted records that are written to magnetic media or files for submission to state agencies. The header identifies the source file as pyussqfr.pkb, with the most recent revision dated 25-Feb-2013 (version 120.21.12020000.19). The package is referenced by pay_us_reporting_utils_pkg, indicating it operates as a subordinate formatting layer within a broader US statutory reporting utility framework. The current API classification is OTHER, and the package is owned by APPS.

Key Procedures and Functions

The package body documents ten procedures and functions, each responsible for assembling a specific SQWL record type:

  • SET_REQ_FIELD_LENGTH — Establishes or adjusts the required field length for formatted output, ensuring positional alignment of the generated records.
  • FORMAT_SQWL_CONTACT_PRSN_INFO — Formats contact person information included within the SQWL reporting output.
  • FORMAT_SQWL_RA_RECORD — Constructs the RA (report/header-level) SQWL record.
  • FORMAT_SQWL_RE_RECORD — Builds the RE record. Revision history notes a 2013 change to display "X" for the LA_SQWL Location Address when it is blank.
  • FORMAT_SQWL_RS_RECORD — Produces the RS (report summary/state) record. This procedure has the most documented change history, including CSV reformatting for New Mexico (NM), removal of extra spacing so that the NM RS record yields 512 characters with the 512th character being the End of Line / Carriage Return, Minnesota (MN) Employer Unit Number repositioning to positions 256–259, correct display of r_input_25 when special characters are present, correct NM Income Tax Withheld values in CSV format, and negative-value checks on r_input_20, r_input_27, and r_input_2.
  • FORMAT_SQWL_RT_RECORD — Constructs the RT record type for SQWL output.
  • FORMAT_SQWL_RSSUMM_RECORD — Formats the RS summary record, aggregating totals for the state submission.
  • FORMAT_SQWL_RST_RECORD — Builds the RST (total) record.
  • FORMAT_SQWL_RU_RECORD — Constructs the RU record type.
  • FORMAT_SQWL_RF_RECORD — Produces the RF (final) record closing the SQWL submission.

Tables Accessed

The documented table reference for this package, resolved via APPS synonyms, is PAY_US_FEDERAL_TAX_INFO_F. This table supplies US federal tax information (such as Employer Identification Number and related tax registration data) required to populate header and identifier fields across the SQWL record types. No other tables are documented in the ETRM metadata.

Usage Notes

The package is not intended for direct invocation. It is referenced by pay_us_reporting_utils_pkg, which orchestrates SQWL generation, and by one additional package. Typical invocation occurs through the US statutory reporting concurrent programs that produce SQWL magnetic tape or file output. Because state specifications change frequently, the extensive revision history — particularly for FORMAT_SQWL_RS_RECORD — reflects ongoing compliance adjustments for individual states (NM, MN, LA). Any customization should account for the positional sensitivity of these record formats.