Business

User Tools

Site Tools

Trace: • Export by File ID - BUD7400 • Bank Reconciliation Questions & Answers • Actual Hours Worked and Actual Date Notes • Pre-Edit Payroll Data - HRS4600 • Run Payroll - HRS5000
general:actualhrsworked_and_date_notes

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
general:actualhrsworked_and_date_notes [2019/05/13 19:15] – emorenogeneral:actualhrsworked_and_date_notes [2020/05/14 18:38] (current) – emoreno
Line 3: Line 3:
 **During the payroll process**: **During the payroll process**:
    
-  * Select **Update Actual Hours From Payroll Processing** on the Human Resources > Tables > HR Options page to use actual hour data from the pay transmittals (during payroll processing) to update/insert records to the Actual Hours table for TRS processing.  This field is selected by default. | +  * Select the **Update Actual Hours From Payroll Processing** field on the Payroll > Tables > District HR Options page to use the actual hour data from the pay transmittals (during payroll processing) to update/insert records to the Actual Hours table that is used for TRS processing.    
-  * If a transmittal exists on the Maintenance > Hours/Pay Transmittals > Abs Ded tab with actual hours worked data, the value is multiplied by -1 prior to being added to the bhr_act_hrs_wrked table. +  * If a transmittal exists on the Payroll > Maintenance > Hours/Pay Transmittals > Abs Ded tab with actual hours worked data, the value is multiplied by -1 prior to being added to the Actual Hours Worked table. 
-  * If an employee has multiple transmittals with actual hours worked for the same actual date, and the sum of all actual hours worked equals zero, a record of zero hours is added to the bhr_act_hrs_wrked table. +  * If an employee has multiple transmittals with actual hours worked for the same actual date, and the sum of all actual hours worked equals zero, a record of zero-hours is added to the Actual Hours Worked table.  
-  * If a transmittal contains an actual date worked, but the actual hours worked value is zero, the record will not be added to the bhr_act_hrs_wrked table.+  * If a transmittal contains an actual date worked, but the actual hours worked value is zero, the record will not be added to the Actual Hours Worked table.
   * If a duplicate actual date worked exists for the same pay date, the actual hours worked will be summed by the date, and the TRS month will be replaced with the current TRS month for the pay date being processed.   * If a duplicate actual date worked exists for the same pay date, the actual hours worked will be summed by the date, and the TRS month will be replaced with the current TRS month for the pay date being processed.
   * If an employee was paid in the payroll run and has transmittals that will update a previously created actual date entry, the TRS month will be updated. If the employee was not paid during the payroll run, the TRS month will not be updated for a previously created actual date entry.   * If an employee was paid in the payroll run and has transmittals that will update a previously created actual date entry, the TRS month will be updated. If the employee was not paid during the payroll run, the TRS month will not be updated for a previously created actual date entry.
Line 12: Line 12:
   * If the actual date worked is blank, the pay period ending date from the employee’s pay date record is used.   * If the actual date worked is blank, the pay period ending date from the employee’s pay date record is used.
   * If the employee was paid during the payroll run and does not have any transmittals, the TRS month and actual date (if blank) will be updated.   * If the employee was paid during the payroll run and does not have any transmittals, the TRS month and actual date (if blank) will be updated.
-  * A failure message is generated if the actual hours worked summed value is less than -999.99 or exceeds 999.99.\\  \\  Pre-existing unprocessed transmittals (i.e., transmittals created prior to the Spring 2015 Release being loaded) should be reviewed thoroughly to ensure that the applicable values have matching signs (+/-).\\  \\  +  * A failure message is generated if the actual hours worked summed value is less than -999.99 or exceeds 999.99.\\  \\  
  
 **Prepost Reports**:\\  \\   **Prepost Reports**:\\  \\  
-  * The HRS2700 – Actual Hours Worked Report is included in the Pre-post and After-post report listing. +  * The HRS2700 – Actual Hours Worked Report is included in the Pre-Post and After-Post report listing. 
-    * The Pre-post report retrieves data from the bhr_hrly_data_xmital and bhr_suppl_xmital tables based on the pay date and selected employees. +    * The Pre-Post report retrieves data from the transmittal tables based on the pay date and selected employees. 
-    * The After-post report retrieves data from the bhr_act_hrs_wrked table based on the pay date and selected employees.+    * The After-Post report retrieves data from the Actual Hours Worked table based on the pay date and selected employees. 
 + 
 +<WRAP Box>**Note**: The Pre-Post and After-Post reports may contain different values if a record exists with the same pay date and actual date in the Actual Hours Worked table.
  
-<WRAP Box>**Notes**:\\  \\   
-  * The Pre-post and After-post reports may contain different values if a record exists with the same pay date and actual date in the bhr_act_hrs_wrked table. 
-  * Unordered List ItemEmployees who are not paid during the payroll run are excluded from the Pre-post and After-post reports 
  
 </WRAP> </WRAP>
 +
 +
  
  
general/actualhrsworked_and_date_notes.1557774938.txt.gz · Last modified: 2019/05/13 14:15 (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.