Define the State Tax Jurisdiction Through Element Entry
For this example, you're defining the Payroll Waterfront Tax employer liability for the following jurisdictions.
-
New Jersey at 2 percent gross wages
-
New York at 1.85 percent gross wages
Because this tax has multiple jurisdictions, you don't predefine the states or deduction percentages on the fast formula. Instead, you identify both on the employee's element entry.
This involves the following high-level steps.
-
Define and configure the elements.
-
Configure the fast formulas.
-
Configure balances.
-
Create element entries.
-
Validate tax calculations.
-
Extract the payroll data.
Define and Configure the Elements
To define your element for this employer state localized tax:
-
Define the state tax element, Payroll Waterfront Employer Tax.
-
Configure the element's input values.
-
Configure the state tax results element, Payroll Waterfront Employer Tax Results.
Defining the State Tax Element
To define the base element:
-
Start the Elements task.
-
Create an Employer Taxes element with these settings.
Field
What you enter
Legislative Data Group
Your US legislative data group
Name
Payroll Waterfront Employer Tax
Primary Classification
Employer Taxes
Secondary Classification
Leave blank
Employment Level
Payroll relationship level
Calculation Rule
Percentage
-
Enter the other required fields as needed, and submit.
Configuring the Element Input Values
After you define the element, you define an input value that identifies the jurisdiction to be at the state level.
-
On the Element Summary page, click Input Values.
-
Click Actions and then Create Input Values.
-
In Create Input Value, set these values.
Field name
What you enter
Name
State
Displayed
Selected
Allow User Entry
Selected
Create a Database Item
Selected
Unit of Measure
Integer
Display Sequence
1
-
In Default Entry Values and Validation, set this value.
Field name
What you enter
Reference
State
-
Click Save.
-
Review all other input values.
Make sure none of them use a display sequence of 1. If they do, renumber them appropriately.
Don't create element eligibility until after you have configured the input values.
-
Create the element eligibility.
Configuring the State Tax Results Element
When you defined the Payroll Waterfront Employer Tax element, the template automatically created a results element, Payroll Waterfront Employer Tax Results. Make the following configuration changes to this element.
-
Using the Elements task, search for and open for editing the Payroll Waterfront Employer Tax Results element.
-
Set the priority to 6255. This ensures the payroll process:
-
Runs the results element after the base element
-
Makes the results element available for selection when setting the formula results (see the next section)
-
-
Create a State input value with the same settings as the base element.
-
Review all other input values.
Make sure none of them use a display sequence of 1. If they do, renumber them appropriately.
-
Create a Gross Earnings input value with the following values.
Field name
What you enter
Displayed
Selected
Allow User Entry
Selected
Create Database Item
Selected
Unit of Measure
Money
Configure the Fast Formulas
When you define the Payroll Waterfront Employer Tax base element, the template creates these fast formulas.
-
Payroll Waterfront Employer Tax_CHG_DEDN
-
Payroll Waterfront Employer Tax_CHG_DEDN_CALCULATOR
Edit these fast formulas to identify the jurisdiction is at the state level.
-
Use the Fast Formula task to modify the Payroll Waterfront Employer Tax_CHG_DEDN formula to pass the jurisdiction input value to the calculator formula.
Edit this formula to make these changes.
-
Locate the
INPUTS are Amount
section, and add a,State(number)
entry after it. -
Locate the
call_formula( 'GLB_DEDN_CHG_BASE'
section, and insert this immediately before it.ee_id2 = ee_id ||'State' IF (WSA_EXISTS(ee_id2,'TEXT_TEXT')) THEN ( ee_array = WSA_GET(ee_id2, EMPTY_TEXT_TEXT) ) ELSE ( dummy = PAY_INTERNAL_LOG_WRITE('[PAYROLL_WATERFRONT_EMPLOYER_TAX_CHG_DEDN] - ARRAY NOT FOUND : ' || ee_id2)) IF (State WAS NOT DEFAULTED) THEN ( ee_array['State'] = to_char(State) dummy = PAY_INTERNAL_LOG_WRITE('[PAYROLL_WATERFRONT_EMPLOYER_TAX_CHG_DEDN] - 999 : ' || to_char(State)) wsa_set(ee_id2, ee_array))
-
Locate the
IF error_mesg
section, and modify it to include a state reference.Return error_mesg, state
-
Submit and compile the formula.
-
-
Modify the Payroll Waterfront Employer Tax_CHG_DEDN_CALCULATOR formula to pass the jurisdiction input values.
Edit this formula to make these changes.
-
At the end of the declaration section, add this line.
Default for PAYROLL_WATERFRONT_EMPLOYER_TAX_STATE_REL_ENTRY_VALUE is 31
-
After the
INPUTS
section, add this line.State = PAYROLL_WATERFRONT_EMPLOYER_TAX_STATE_REL_ENTRY_VALUE
-
Search for the
call_formula( 'GLB_DEDN_CHG_CALC'
section. Locate these lines at the end of thecall_formula
section.stop_entry )
After these lines, insert this.
ee_id2 = ee_id||'State' IF (WSA_EXISTS(ee_id2,'TEXT_TEXT')) THEN ( ee_array = WSA_GET(ee_id2, EMPTY_TEXT_TEXT) dummy = PAY_INTERNAL_LOG_WRITE('[PAYROLL_WATERFRONT_EMPLOYER_TAX_CHG_DEDN_CALCULATOR] 999 = '|| ee_id2) IF ee_array.EXISTS('State') THEN ( state = to_number(ee_array['State'] ) dummy = PAY_INTERNAL_LOG_WRITE('[PAYROLL_WATERFRONT_EMPLOYER_TAX_CHG_DEDN_CALCULATOR] = '|| to_char(state)) ) )
-
Search for the
RETURN
statements that includededn_amt
, and add these lines at the end of each.eligible_compensation, state
-
Submit and compile the formula.
-
-
Return to the Elements task.
-
Make these changes to the Payroll Waterfront Employer Tax Calculator element.
-
Select Status Processing Rules, and select the current rule.
-
Create a formula result rule to pass ELIGIBLE_COMPENSATION as an indirect result. Pass this result to the Gross Earnings input value of the Payroll Waterfront Employer Tax Results element.
-
Create a formula result rule to pass STATE as an indirect result to the State input value of the Payroll Waterfront Employer Tax Results element.
-
Configure the Balances
After you configure the fast formulas, you define the balances necessary for this tax.
-
Define the state tax balances.
-
Implement the balances at the enterprise level.
Defining the State Tax Balances
Define and configure the required balances.
-
Use the Balance Definitions task to define a Reduced Subject Wages balance.
Field name
What you enter
Name
Payroll Waterfront Employer Tax Reduced Subject Wages
Balance Category
Employer Tax Wages
Unit of Measure
Money
Balance Dimensions
Because this is a state-level tax, search for and add the following.
-
Relationship Tax Unit,State Run
-
Relationship Tax Unit,State Year to Date
-
Relationship Tax Unit, Area1 Payslip
-
Relationship Tax Unit,State Quarter to Date
Balance Feeds by Element
Payroll Waterfront Employer Tax Results
Input Value
Gross Earnings
-
-
Define a Taxable Wages balance.
Field name
What you enter
Name
Payroll Waterfront Employer Tax Taxable Wages
Balance Category
Employer Tax Wages
Unit of Measure
Money
Balance Dimensions
Because this is a state-level tax, search for and add the following.
-
Relationship Tax Unit,State Run
-
Relationship Tax Unit,State Year to Date
-
Relationship Tax Unit, Area1 Payslip
-
Relationship Tax Unit,State Quarter to Date
Balance Feeds by Element
Payroll Waterfront Employer Tax Results
Input Value
Gross Earnings
-
-
Define a Gross Wages balance.
Field
What you enter
Name
Payroll Waterfront Employer Tax Gross Wages
Balance Category
Employer Tax Wages
Unit of Measure
Money
Balance Dimensions
Because this is a state-level tax, search for and add the following.
-
Relationship Tax Unit,State Run
-
Relationship Tax Unit,State Year to Date
-
Relationship Tax Unit, Area1 Payslip
-
Relationship Tax Unit,State Quarter to Date
Balance Feeds by Element
Payroll Waterfront Employer Tax Results
Input Value
Gross Earnings
-
-
Configure the predefined Payroll Waterfront Employer Tax Eligible Comp balance.
Make these changes.
-
Add these balance classifications as feeds.
-
Regular
-
Supplemental Earnings
-
Imputed Earnings
-
-
Add these balance dimensions.
-
Relationship Tax Unit,State Run
-
Relationship Tax Unit,State Year to Date
-
Relationship Tax Unit, Area1 Payslip
-
Relationship Tax Unit,State Quarter to Date
-
-
-
Add the same balance dimensions to the predefined Payroll Waterfront Employer Tax balance.
Implementing the Balances at the Enterprise Level
Perform these steps to implement the balances you configured in the previous section. This makes them available for payroll archival and reporting.
-
Start the Enterprise HCM Information task.
-
Add a row to the US Balance Definition table, and enter these values.
Field name
What you enter
Legislative Data Group
Your US legislative data group
Archive Level
State
Category
Reduced Subject Wages
Balance Name
Payroll Waterfront Employer Tax Reduced Subject Wages
Tax Code
PAYTAX_ER
Type
Balance
Report Usage
Periodic and Quarterly
-
Add a row to the US Balance Definition table, and enter these values.
Field name
What you enter
Legislative Data Group
Your US legislative data group
Archive Level
State
Category
Taxable Wages
Balance Name
Payroll Waterfront Employer Tax Taxable Wages
Tax Code
PAYTAX_ER
Type
Balance
Report Usage
Periodic and Quarterly
-
Add a row to the US Balance Definition table, and enter these values.
Field
What you enter
Legislative Data Group
Your US legislative data group
Archive Level
State
Category
Withheld or Liability
Balance Name
Payroll Waterfront Employer Tax
Tax Code
PAYTAX_ER
Type
Balance
Report Usage
Periodic and Quarterly
-
Add a row to the US Balance Definition table, and enter these values.
Field
What you enter
Legislative Data Group
Your US legislative data group
Archive Level
State
Category
Total Wage or Gross
Balance Name
Payroll Waterfront Employer Tax Gross Wages
Tax Code
PAYTAX_ER
Type
Balance
Report Usage
Periodic and Quarterly
Note: As this tax applies to multiple states, you enter the new element on your employee with an appropriate State input value for each. This ensures the tax filing processes prefix the tax code with the state codes. For example, NJPAYTAX1_ER and NYPAYTAX1_ER.
Create Element Entries
After you configure the required balances, use the Element Entries task to create element entries for each employee subject to this tax.
-
Start the Element Entries task for the selected employee.
-
Select the effective date for your new entry.
-
Click Create.
-
Select the Payroll Waterfront Employer Tax element.
-
Click Continue.
-
Select either New Jersey or New York as the state, whichever is appropriate for the employee.
-
In Percentage, enter
2.0
for New Jersey employees or1.85
for New York employees. -
Click Submit.
Validate Tax Calculations
Use these steps to validate your new Payroll Waterfront Tax for New Jersey and New York.
-
Run your payroll.
-
Upon completion, check the Statement of Earnings run results.
For further info, see How to View the Statement of Earnings for the US in the Help Center.
-
Verify the tax was calculated correctly and the State and Gross Earnings input values were correctly populated.
Extract the Payroll Data
For complete info about third-party tax reporting, refer to the US Third-Party Tax Filing Interface technical brief.
To extract the state tax data in preparation for submitting to a third-party tax filing agent.
-
Run prepayments.
For further info, see Calculate and Validate Payroll Payment Distributions for the US in the Help Center.
-
Run the periodic archive.
For further info, see Archive Periodic Payroll Results for the US in the Help Center.
-
Run the Third-Party Periodic Tax Filing Extract.
For further info, see Oracle Cloud Human Capital Management for United States: Third-Party Tax Filing Interface (1594079.1) on My Oracle Support.
-
Check the output file.
Verify the following.
-
Correct TAX CODE appears in the file
-
All four balances you defined were passed on one record for tax code NJPAYTAX1_ER
-
All four balances you defined were passed on one record for tax code NYPAYTAX1_ER
-
-
Run the Third-Party Quarterly Tax Filing Extract process to verify your state tax data.