RF Non-Citizen Employees Tax Status Exception

Description

Purpose

The RF Non-Citizen Employees Tax Status Exception report is used to monitor and update exceptions in the residency status data used for tax purposes for non-U.S. citizens. This report includes eight sections:

Non-Citizen Employees Exceeding Treaty Limits with Incorrect Tax Coding
Non-Resident Alien Employees for Tax Purposes with Incorrect Tax Withholding Rules
Non-Citizen Employees Where Tax Form Residency Status Details are Inconsistent with Substantial Presence Test Entry
Non-Citizen/Permanent Resident with Null Residency Detail Exception Report
Non-Citizens Missing Certain Non-Citizen Residency SIT Information
Permanent Residents with Incorrect Tax Form Residency Details Status
US Citizens with Incorrect Tax Form Residency Details Status
Non-Citizen/Permanent Residents with India as Country of Citizenship

Frequency

The report should be run before each biweekly payroll run.

Responsibilities with Access

US HRMS Manager
HR PR Specialist
HRMS Administrator

Setting Report Parameters

The following table describes the required parameter to run the report:


Parameter	Description (click in the field to see the List of Values)
Required Parameters
Organization		Enter your operating location. For Example: 030 University at Buffalo

Understanding the Output

The following tables describe the output for each of the six sections of this report.

Non-Citizen Employees Exceeding Treaty Limits with Incorrect Tax Coding

Column Heading	Description of Column
Location	A three-digit code that identifies the specific Research Foundation operating location. In some cases the location code includes both the three-digit code and the short name of the location (abbreviated location name rather than the full name).
Last Name	The person's last name (i.e., surname, family name).
First Name	The person's first name.
Employee Number	The unique identification number assigned to each employee in Oracle.
Assignment Group	The assignment group describing the type of assignment the person has with the Research Foundation.
Country of Citizenship	The country of citizenship from the employee's Non-Citizen Visa and Residency special information type (SIT).
Visa Type	The Visa classification for non-U.S. citizen employees from the employee's Non-Citizen Visa and Residency special information type (SIT).
Tax Form - Res Details	An indicator of the residency status used for tax purposes for non-U.S. citizens. Nonresident alien (NRA) employees with a status of N in this field require special withholding calculations. Permanent residents are considered resident aliens for tax purposes and this field should have a value of R. Resident aliens that meet the substantial presence test (SPT) are considered resident aliens for tax purposes and this field should have a value of R. Students and business apprentices that are citizens of India are not subject to the special withholding calculations and this field should have a value of blank (null). Note: Nonresident alien status N indicator is the only status in which the special withholding calculations are applied.
Treaty Limit	Amount determined from the Non Citizen Reporting Special Information Type. The Value is either: The amount entered in the "Maximum Treaty Ben Amt" field or The calculated earnings amount paid using the "Date Treaty Benefits Begins" and "Date Treaty Benefits Ends" If data is not entered into the Non Citizen Reporting SIT, the report cannot evaluate for the exception.
YTD Earning	Year to Date total earnings for the employee.

Non-Resident Alien Employees for Tax Purposes with Incorrect Tax Withholding Rules

Column Heading	Description of Column
Location	A three-digit code that identifies the specific Research Foundation operating location. In some cases the location code includes both the three-digit code and the short name of the location (abbreviated location name rather than the full name).
Last Name	The person's last name (i.e., surname, family name).
First Name	The person's first name.
Employee Number	The unique identification number assigned to each employee in Oracle.
Assignment Group	The assignment group describing the type of assignment the person has with the Research Foundation.
Country of Citizenship	The country of citizenship from the employee's Non-Citizen Visa and Residency special information type (SIT).
Federal Filing Status	The "Filing Status" entered on the Federal Tax Rules form.
Federal Allowances	The "Allowances" entered on the Federal Tax Rules form.
State Filing Status	The "Filing Status" entered in the State Tax Rules form.
State Allowances	The "Allowances" entered on the State Tax Rules form.

Non-Citizen Employees Where Tax Form Residency Details are Inconsistent with Substantial Presence Test Entry

Column Heading	Description of Column
Location	A three-digit code that identifies the specific Research Foundation operating location. In some cases the location code includes both the three-digit code and the short name of the location (abbreviated location name rather than the full name).
Last Name	The person's last name (i.e., surname, family name).
First Name	The person's first name.
Employee Number	The unique identification number assigned to each employee in Oracle.
Assignment Group	The assignment group describing the type of assignment the person has with the Research Foundation.
Nationality	The person's citizenship status. For Example: US Citizen Permanent Resident Non-Citizen in US on VISA Non-Citizen not in US
Country of Citizenship	The country of citizenship from the employee's Non-Citizen Visa and Residency special information type (SIT).
Visa Type	The Visa classification for non-U.S. citizen employees from the employee's Non-Citizen Visa and Residency special information type (SIT).
Date First Entered US	The date the employee first entered the U.S. This information comes from the employee's Non-Citizen Visa and Residency special information type (SIT).
Res Alien for Tax Meets SPT	The resident alien determination for an employee who meets the substantial presence test (SPT). This information comes from the employee's Non-Citizen Visa and Residency special information type (SIT).
Tax Form - Res Details	An indicator of the residency status used for tax purposes for non-U.S. citizens. Nonresident alien (NRA) employees with a status of N in this field require special withholding calculations. Permanent residents are considered resident aliens for tax purposes and this field should have a value of R. Resident aliens that meet the substantial presence test (SPT) are considered resident aliens for tax purposes and this field should have a value of R. Students and business apprentices that are citizens of India are not subject to the special withholding calculations and this field should have a value of blank (null). Note: Nonresident alien status N indicator is the only status in which the special withholding calculations are applied.

Non-Citizen/Permanent Resident with Null Residency Detail Exception Report

Note: Non-citizens or permanent residents should have a value in the Residency Status field.

Column Heading	Description of Column
Location	A three-digit code that identifies the specific Research Foundation operating location. In some cases the location code includes both the three-digit code and the short name of the location (abbreviated location name rather than the full name).
Last Name	The person's last name (i.e., surname, family name).
First Name	The person's first name.
Employee Number	The unique identification number assigned to each employee in Oracle.
Assignment Group	The assignment group describing the type of assignment the person has with the Research Foundation.
Nationality	The person's citizenship status. For Example: US Citizen Permanent Resident Non-Citizen in US on VISA Non-Citizen not in US
Country of Citizenship	The country of citizenship from the employee's Non-Citizen Visa and Residency special information type (SIT).
Visa Type	The Visa classification for non-U.S. citizen employees from the employee's Non-Citizen Visa and Residency special information type (SIT).
Date First Entered US	The date the employee first entered the U.S. This information comes from the employee's Non-Citizen Visa and Residency special information type (SIT).
Res Alien for Tax Meets SPT	The resident alien determination for an employee who meets the substantial presence test (SPT). This information comes from the employee's Non-Citizen Visa and Residency special information type (SIT).

Non-Citizens Missing Certain Non-Citizen Residency SIT Information

Column Heading	Description of Column
Location	A three-digit code that identifies the specific Research Foundation operating location. In some cases the location code includes both the three-digit code and the short name of the location (abbreviated location name rather than the full name).
Last Name	The person's last name (i.e., surname, family name).
First Name	The person's first name.
Employee Number	The unique identification number assigned to each employee in Oracle.
Assignment Group	The assignment group describing the type of assignment the person has with the Research Foundation.
Nationality	The person's citizenship status. For Example: US Citizen Permanent Resident Non-Citizen in US on VISA Non-Citizen not in US
Country of Citizenship	The country of citizenship from the employee's Non-Citizen Visa and Residency special information type (SIT).
Visa Type	The Visa classification for non-U.S. citizen employees from the employee's Non-Citizen Visa and Residency special information type (SIT).
Date First Entered US	The date the employee first entered the U.S. This information comes from the employee's Non-Citizen Visa and Residency special information type (SIT).
Country of Residence	The country of residence from the employee's noncitizen Visa and Residency special information type (SIT).
Res Alien for Tax Meets SPT	The resident alien determination for an employee who meets the substantial presence test (SPT). This information comes from the employee's Non-Citizen Visa and Residency special information type (SIT).
Tax Form - Res Details	An indicator of the residency status used for tax purposes for non-U.S. citizens. Nonresident alien (NRA) employees with a status of N in this field require special withholding calculations. Permanent residents are considered resident aliens for tax purposes and this field should have a value of R. Resident aliens that meet the substantial presence test (SPT) are considered resident aliens for tax purposes and this field should have a value of R. Students and business apprentices that are citizens of India are not subject to the special withholding calculations and this field should have a value of blank (null). Note: Nonresident alien status N indicator is the only status in which the special withholding calculations are applied.

Permanent Residents with Incorrect Tax Residency Details Status

Column Heading	Description of Column
Location	A three-digit code that identifies the specific Research Foundation operating location. In some cases the location code includes both the three-digit code and the short name of the location (abbreviated location name rather than the full name).
Last Name	The person's last name (i.e., surname, family name).
First Name	The person's first name.
Employee Number	The unique identification number assigned to each employee in Oracle.
Assignment Group	The assignment group describing the type of assignment the person has with the Research Foundation.
Nationality	The person's citizenship status. For Example: US Citizen Permanent Resident Non-Citizen in US on VISA Non-Citizen not in US
Country of Citizenship	The country of citizenship from the employee's Non-Citizen Visa and Residency special information type (SIT).
Visa Type	The Visa classification for non-U.S. citizen employees from the employee's Non-Citizen Visa and Residency special information type (SIT).
Date First Entered US	The date the employee first entered the U.S. This information comes from the employee's Non-Citizen Visa and Residency special information type (SIT).
Res Alien for Tax Meets SPT	The resident alien determination for an employee who meets the substantial presence test (SPT). This information comes from the employee's Non-Citizen Visa and Residency special information type (SIT).
Tax Form - Res Details	An indicator of the residency status used for tax purposes for non-U.S. citizens. Nonresident alien (NRA) employees with a status of N in this field require special withholding calculations. Permanent residents are considered resident aliens for tax purposes and this field should have a value of R. Resident aliens that meet the substantial presence test (SPT) are considered resident aliens for tax purposes and this field should have a value of R. Students and business apprentices that are citizens of India are not subject to the special withholding calculations and this field should have a value of blank (null). Note: Nonresident alien status N indicator is the only status in which the special withholding calculations are applied.

U.S. Citizens with Incorrect Tax Form Residency Details Status

Column Heading	Description of Column
Location	A three-digit code that identifies the specific Research Foundation operating location. In some cases the location code includes both the three-digit code and the short name of the location (abbreviated location name rather than the full name).
Last Name	The person's last name (i.e., surname, family name).
First Name	The person's first name.
Employee Number	The unique identification number assigned to each employee in Oracle.
Nationality	The person's citizenship status. For Example: US Citizen Permanent Resident Non-Citizen in US on VISA Non-Citizen not in US
Country of Citizenship	The country of citizenship from the employee's Non-Citizen Visa and Residency special information type (SIT).
Visa Type	The Visa classification for non-U.S. citizen employees from the employee's Non-Citizen Visa and Residency special information type (SIT).
Date First Entered US	The date the employee first entered the U.S. This information comes from the employee's Non-Citizen Visa and Residency special information type (SIT).
Res Alien for Tax Meets SPT	The resident alien determination for an employee who meets the substantial presence test (SPT). This information comes from the employee's Non-Citizen Visa and Residency special information type (SIT).
Tax Form - Res Details	An indicator of the residency status used for tax purposes for non-U.S. citizens. Nonresident alien (NRA) employees with a status of N in this field require special withholding calculations. Permanent residents are considered resident aliens for tax purposes and this field should have a value of R. Resident aliens that meet the substantial presence test (SPT) are considered resident aliens for tax purposes and this field should have a value of R. Students and business apprentices that are citizens of India are not subject to the special withholding calculations and this field should have a value of blank (null). Note: Nonresident alien status N indicator is the only status in which the special withholding calculations are applied.

Non-Citizen/Permanent Residents with India as Country of Citizenship

Column Heading	Description of Column
Location	A three-digit code that identifies the specific Research Foundation operating location. In some cases the location code includes both the three-digit code and the short name of the location (abbreviated location name rather than the full name).
Last Name	The person's last name (i.e., surname, family name).
First Name	The person's first name.
Employee Number	The unique identification number assigned to each employee in Oracle.
Assignment Group	The assignment group describing the type of assignment the person has with the Research Foundation.
Nationality	The person's citizenship status. For Example: US Citizen Permanent Resident Non-Citizen in US on VISA Non-Citizen not in US
Country of Citizenship	The country of citizenship from the employee's Non-Citizen Visa and Residency special information type (SIT).
Visa Type	The Visa classification for non-U.S. citizen employees from the employee's Non-Citizen Visa and Residency special information type (SIT).
Date First Entered US	The date the employee first entered the U.S. This information comes from the employee's Non-Citizen Visa and Residency special information type (SIT).
Res Alien for Tax Meets SPT	The resident alien determination for an employee who meets the substantial presence test (SPT). This information comes from the employee's Non-Citizen Visa and Residency special information type (SIT).
Tax Form - Res Details	An indicator of the residency status used for tax purposes for non-U.S. citizens. Nonresident alien (NRA) employees with a status of N in this field require special withholding calculations. Permanent residents are considered resident aliens for tax purposes and this field should have a value of R. Resident aliens that meet the substantial presence test (SPT) are considered resident aliens for tax purposes and this field should have a value of R. Students and business apprentices that are citizens of India are not subject to the special withholding calculations and this field should have a value of blank (null). Note: Nonresident alien status N indicator is the only status in which the special withholding calculations are applied.

Helpful Tips

For complete details on running Oracle reports, refer to the Run a Report help topic.
The report is available in PDF and ASCII (TEXT) format. PDF is a formatted, printable version. ASCII can be easily pulled into a spreadsheet or word processor.
Once you select a format and run the report, you cannot change the output format. You will need to run the report again and select the desired output format on the Submit Request window.

Effective Date: 3/27/2008 2:34:17 PM