Business

User Tools

Site Tools

Trace: • Position Management • Install Salary/Tax Tables - HRS7000 • warehouse_requisition_details
payroll:utilities:installsalarytaxtables

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
payroll:utilities:installsalarytaxtables [2020/08/06 15:42] – emorenopayroll:utilities:installsalarytaxtables [2023/01/02 18:02] (current) – emoreno
Line 9: Line 9:
 You can choose between file types that are tab-delimited text (.txt) or database (.dbf). You can choose between file types that are tab-delimited text (.txt) or database (.dbf).
  
-**Note**: At the beginning of each calendar year, the TCC provides a flat text file containing the new calendar year tax tables. This file is accessible to the local ESC consultants via the FTP site. **It is recommended** that the LEA's use the provided file to import the tax data as the pay frequency is no longer being used for calendar years greater than 2019. Additionally, the import relieves the task of having to manually set up the tax table data on the Human Resources > Tables > Taxes/Deductions pages.+**Note**: At the beginning of each calendar year, the TCC provides a flat text file containing the new calendar year tax tables. This file is accessible to the local ESC consultants via the FTP site. **It is recommended** that LEAs use the provided file to import the tax data as the pay frequency is no longer being used for calendar years greater than 2019. Additionally, the import relieves the task of having to manually set up the tax table data on the Payroll > Tables > Taxes/Deductions pages. 
 + 
 +[[academy:business_payroll_updatetaxtableschecklist|Update Tax Tables]] 
  
 </WRAP> </WRAP>
Line 17: Line 20:
 ====Install a salary/tax table:==== ====Install a salary/tax table:====
  
-Under **Tables**, select the table for which you want to import data:+VCV Under **Tables**, select the table for which you want to import data:
   * **State Salary**   * **State Salary**
   * **Job Code**   * **Job Code**
Line 25: Line 28:
  
  
-Under **Current-Next Year**, select either **Current Year** or **Next Year**. These options are only available when the **State Salary** or **Job Code** table is selected.+VCV Under **Current-Next Year**, select one of the following.  
 + 
 +<div indent>These options are only available when the **State Salary** or **Job Code** table is selected. 
 +</div> 
 + 
 +  * **Current Year**  
 +  * **Next Year** 
  
-Under **Process Specifications**:+VCV Under **Process Specifications**:
  
 ^School or Calendar Year|Type the year in the YYYY format. If **State Salary** or **Job Code** is selected under **Tables**, the school year cannot be edited. The year field type changes between **School Year** and **Calendar Year** depending on the table selected.| ^School or Calendar Year|Type the year in the YYYY format. If **State Salary** or **Job Code** is selected under **Tables**, the school year cannot be edited. The year field type changes between **School Year** and **Calendar Year** depending on the table selected.|
  
-If the **Import Path** is **None**, click **Browse**.+VCV If the **Import Path** is **None**, click **Browse**.
  
   * Click **Choose File** and type the drive and folder name from where you want to install a salary/tax table.   * Click **Choose File** and type the drive and folder name from where you want to install a salary/tax table.
-  * Click **Submit** to accept the import file name and return to the Import Salary/Tax Tables page. Otherwise, click **Cancel** to close the dialog box without processing.+  * Click **Submit** to accept the import file name and return to the Import Salary/Tax Tables page.  
 +  * Click **Cancel** to close the dialog box without processing.
  
  
-Click **Execute**. A data preview window displays the name of the table being updated (e.g., Data Preview - Fed. Income Tax Table). +VCV Click **Execute** to execute the process. A data preview window displays the name of the table being updated (e.g., Data Preview - Fed. Income Tax Table). 
-  * If records exist for a table, the system displays the following message: ”Do you wish to replace existing records?” Click **Yes** to delete the existing records for the school/tax year and import the data into the Human Resources current year or next year tables. Otherwise, click **No** to cancel the import process.+  * If records exist for a table, the system displays the following message: ”Do you wish to replace existing records?” Click **Yes** to delete the existing records for the school/tax year and import the data into the Payroll current year or next year tables. Otherwise, click **No** to cancel the import process.
   * If records exist for the salary table, the system deletes the existing records for the current year or next year (as specified) when the user chooses to replace existing records.   * If records exist for the salary table, the system deletes the existing records for the current year or next year (as specified) when the user chooses to replace existing records.
   * If the job table already has data, it cannot be deleted or replaced. The job table can only be loaded from an empty job table.   * If the job table already has data, it cannot be deleted or replaced. The job table can only be loaded from an empty job table.
payroll/utilities/installsalarytaxtables.1596728520.txt.gz · Last modified: 2020/08/06 10:42 (external edit)

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.