Topics Map > DOCUMENT TYPE > User Procedure
Topics Map > FUNCTIONAL AREA > Payroll (PY)
PY – Foreign Nationals Inbound File Page
The Foreign Nationals Inbound File page displays all the foreign nationals processed by the Glacier demographics and tax interface processes for the most recent run of a specified Pay Run ID. The page displays all information from Glacier Files 3 and 14 that are used to update employee HRS records for accurate taxation. Use this page, or the accompanying PS Query UW_PY_FN_INBOUND_QRY, to view what information was used by the interface jobs to update the employee’s Job Data, visa, substantial presence, and tax settings.
- The information shown on the Foreign Nationals Inbound File page is cleansed information as compared to the raw data found in Glacier. The interface processing executes many updates to the raw Glacier data found on Files 3 and 14 in order to tax employees appropriately on the payroll, and the updated information is what is shown on the page as well as in the PS Query UW_PY_FN_INBOUND_QRY.
- The Foreign Nationals Inbound File page is accessible with the following security role: UW_UNV_PY_TAX_VIEW (PY Tax View).
1. Navigate to: Payroll for North America > Payroll Processing USA > UW Glacier Interfaces > Foreign Nationals Inbound File
2. On the Foreign Nationals Inbound File page, enter the Pay Run ID for which you wish to view employee information.
3. The relevant File 14 and File 3 information used by the Glacier demographics and tax interface jobs for the specified Pay Run ID will appear. This page is best used if you are looking to verify how individual employees were treated by the interface processes on a certain payroll.
4. Since this page will show all the employees evaluated by the interface on that Pay Run ID, you can search for individual employees by clicking the “Find” link at the top of the page. A new window will pop up where you can type the information you’re searching by, such as Empl ID, First Name or Last Name.
5. Note that this page is very wide and only some of the columns are visible. Use the scroll bar at the bottom of the page to horizontally scroll to the additional columns.
6. As mentioned above, the raw Glacier data from Files 3 and 14 goes through an update process as part of the interface. Employee information that is shown on the Foreign Nationals Inbound File page may not exactly match what is shown in Glacier. The most commonly changed values are Residency Status and Tax File Status. This is done to most appropriately tax the individual based on the information he/she has provided in Glacier. The most common updates the interface will make to Glacier data are based on the following criteria:
- If the foreign national is not a permanent resident and the Tax File Status is Complete, but the Exit Date is less than the pay period begin date for the Pay Run ID, OR the Immigration Expiration Date is less than the pay period begin date for the Pay Run ID, the Tax File Status will be listed as Waiting.
- If the foreign national is not a permanent resident and the Individual Record Status is Terminated and the Tax File Status is Complete, the Tax File Status will be listed as Waiting.
- If the foreign national’s Residency Status is permanent resident or resident alien, and the Tax File Status is not Complete, the Residency Status will be listed as Non-Resident Alien.
- If the foreign national’s Residency Status is resident alien, and the Current Immigration Status is not permanent resident, and the Exit Date is less than 1/31/current year or the Immigration Expiration Date is less than 1/31/current year, then the Residency Status will be listed as non-resident alien.
7. Since the data shown on the main Foreign Nationals Inbound File Page may not exactly match what is in Glacier, you can click on the “View Original” link on the employee’s row to see what values came from Glacier and if the interface process updated anything.
8. If the employee does not have a “View Original” link on his/her line, this means he/she was not on File 14 from Glacier. The employee was added to the updated file by the interface process because he/she has an active job or relationship not listed in Glacier. Employees can also be added during the 2nd run of the interface processes if they have an inactive job but an open payline in HRS for the Pay Run ID specified. These scenarios are added to the file because these employees also need to be taxed appropriately.
Viewing Foreign National Inbound File Data through PS Query:
1. The PS Query UW_PY_FN_INBOUND_QRY can also be run to view the adjusted file information used by the tax interface processes for a specified Pay Run ID. This query returns the same values as seen on the main Foreign Nationals Inbound File page, but is advantageous to run when you want to view multiple employees by Dept ID.
2. Navigate to: Reporting Tools > Query > Query Viewer and enter the name of the query in the search field.
3. When you run the query either to Excel or HTML, you will be prompted to enter in some criteria. These criteria are required:
- Business Unit – Enter or use the lookup icon to choose the institution for which you want to return results.
- Dept ID – Enter the Dept ID for which you want to return results. You can enter a wild card to return results for an entire institution or division. For example, enter A% to return results for all UW-Madison employees, or A48% to return results only for that UW-Madison division.
- Pay Run ID – Enter or use the lookup icon to choose the Pay Run ID for which you want to return results.
- Note: Query results will be based on your row level security in HRS. The query will only return results for employees you have security to view.
- PY - Glacier Account Requirements for Foreign Nationals on UW Payroll
- [Link for document 17409 is unavailable at this time.]