CAPPS Reports
HR/Payroll
Or click on the headings below to open a topic individually.
Commitment Accounting [+]
| Report Title | Process Name | Navigation | Description |
|---|---|---|---|
| TX Predistribution Audit Report | TXPCA010 | Payroll for North America>Payroll Distribution>Commitment Accounting USA>TX Predistrib Audit Report | Identifies potential errors that may occur during the Actuals Distribution process. Allows budget/position control staff the ability to identify the errors and modify configurations or budgets within the HCM Tx Baseline CAPPS in order to successfully process payroll. |
| TX Pyrl Actuals by Project Id | ASPY3046 | Payroll for North America>Payroll Distribution>Commitment Accounting USA>TX Pyrl Actuals by ProjectID | Provides summary payroll expenditure information by Project ID for a specific payroll document being processed in order to aid budget and cash management staff in validating funds availability. |
| TX Pyrl Actuals Class Summary | HSAS3002 | Payroll for North America>Payroll Distribution>Commitment Accounting USA>TX Pyrl Actuals Class Summary | Provides summary payroll expenditure information by class (PCA) for a specific payroll document being processed in order to aid budget and cash management staff in validating funds availability. |
| TX Pyrl Actuals Fund Summary | HSAS3001 | Payroll for North America>Payroll Distribution>Commitment Accounting USA>TX Pyrl Actuals Fund Summary | Provides summary payroll expenditure information by fund for a specific payroll document being processed in order to aid budget and cash management staff in validating funds availability. |
| TX Pyrl by Approp/PCA | HSPY0001 | Payroll for North America>Payroll Distribution>Commitment Accounting USA>TX Payroll by Approp/PCA | Provides summary payroll expenditure information by Appropriation/PCA for a specific payroll document being processed in order to aid budget and cash management staff in validating funds availability. |
Human Resources [+]
| Report Title | Process Name | Navigation | Description |
|---|---|---|---|
| Active Employee Report | TXACTEMP | Workforce Administration > CAPPS Reports > Active Employee Report | This report displays each employee's primary assignment personnel and payroll information such as address, salary and employment data. |
| Active Position Report | TXACTPOS | Organizational Development> Position Management> CAPPS Reports> Active Position Report | This is an adhoc report that provides a listing of active positions as of the date indicated for the agency on the run control. Active positions include positions in the Approved status and provides certain information about both vacant and filled positions with limited incumbent (the person filling the position) details. The report excludes contingent workers. |
| Audit – Position Exceptions | HSAS0206 | Organizational Development> Position Management> CAPPS Reports> Audit – Position Exceptions | The Audit – Position Exceptions is an adhoc report that should be run to ensure that Job and Position data match. The report will identify conditions where position and job data are out of sync. Non pay impacting changes to position data will not update job data if the position and job data are out of sync with one another. |
| Employees on LOA | TX_EMPL_LOA | Workforce Administration> CAPPS Reports> Employees on LOA | This report provides a list of employees who are on a Leave of Absence (per their Job Data) as of the date indicated in the run control prompt. |
| ERS/CAPPS Insurance Reconciliation Report | TXERS100 | CAPPS Interfaces> Benefits> Reports> ERS/CAPPS Insurance Recon | The ERS/CAPPS Insurance Reconciliation is an adhoc report that uses the ERS monthly snapshot file to identify discrepancies between ERS (the Benefits Administrator) and CAPPS (the HR/Payroll system). The report must be used as a reconciliation tool to care for discrepancies to benefit elections and/or deductions to ensure CAPPS is appropriately deducting employee benefits and that the employee has paid for those benefits. This report has multiple ways it compares ERS to CAPPS and includes great detail. |
| FMLA/Parental Leave History Report | TX_RC_FMLRPT | Benefits> Track FMLA> Track FMLA> FMLA/Parental Leave History Report | The track FMLA or Parental History report can be run adhoc for all employees or an individual employee to help reconcile leave recorded on the time sheet and Leave of Absence hours recorded in the FMLA Activity page for the event. The run control is used to specify whether to run FMLA or Parental History. |
| FTE Information Report | TXFTERPT | Workforce Administration> CAPPS Reports> FTE Information Report | This adhoc report is designed as a tool to assist agencies in satisfying the State Auditor's Office (SAO) FTE state employee quarterly reporting requirements. The report produces values based on agency data entry, payroll processing, and position control procedures. Therefore, agencies should verify the correctness of their data before using the figures for SAO reporting requirements. This report is a snapshot of information as of the last day of the fiscal quarter. All payment information with payment dates within the quarter and all assignment information as of the last day of the quarter are included. |
| HIR/REH Report (Hire/Rehire) | ASHR1051 | CAPPS Interfaces> Benefits> Reports> Benefits HIR/REH Report | An adhoc report showing Hires and Rehires for the Agency. The report can be used to open an event in ERS OnLine for the employee to enroll in their benefits. If no hires and/or rehires were added for the date or date range requested, the report will indicate that no data exists. Note: The report should be run timely to ensure the employee is promptly enrolled in benefits. For a large agency, this might be needed daily. For a smaller agency, the report can be run for the day the employee(s) were onboarded into CAPPS. |
| List – Employee Comp Changes | HSAS0405 | Workforce Administration > CAPPS Reports > List – Employee Comp Changes | This report displays all employees who have had any salary impacting actions during a specified date range. |
| Mgmt/Staff Ratio Report | TXMSRRPT | Workforce Administration> CAPPS Reports> Mgmt/Staff Ratio Report | This report displays information required by the State Auditor's Office (SAO) regarding the management to staff ratios based on FTE's in addition to employee count. This report can be used as a tool and agencies should verify the correctness of the data before submitting figures for SAO reporting requirements. |
| New Hires and Transfers Report | TX_NEW_HIRES | Workforce Administration> CAPPS Reports> New Hire and Transfers Report | This adhoc report displays the latest new hire record on employees that might have terminated and been rehired. If the newly hired employee terminates within the time period requested the termination date should be displayed on the report. |
| Notification of Termination (Letter) | TXTRMLTR | Workforce Administration> CAPPS Reports> Notification of Termination | The Notification of Termination report is an adhoc report that generates a letter notifying the Courts or Obligees (e.g. IRS, TGSLC, etc.) of the termination of an employee with an active garnishment for Child Support, Administrative Wage Garnishment (AWG), Student Loan, Tax Levy, Bankruptcy and Spousal Maintenance. |
| Notification of Termination (Report) | TXTRMRPT | Workforce Administration> CAPPS Reports> Notification of Termination | The notification of termination report is an adhoc report that can be run to identify employees that were terminated with an active garnishment. The report displays by garnishment ID type (i.e. CHI), provides the employee name, SSN and term date along with a total number of employees for each garnishment ID type. This is different from the Notification of Termination letter, because it is not intended to be distributed outside of the agency and can be used as a report to ensure all relevant agencies have been notified. |
| Pay Impacting Forms for MON | ASPY1022 | CAPPS Interfaces>Benefits>Reports>Pay impacting forms for MON | The Pay Impacting Forms for MON is an adhoc report that can be used to make benefit adjustments for late hires. The employees identified are current pay period hires where payroll has processed without their deductions. After verification the form can be printed and given to the payroll administrator to make the appropriate additional deduction on the employee's next paycheck. |
| Personnel Changes Report | TX_PERS_CHG | Workforce Administration > CAPPS Reports > Personnel Changes Report | This report displays all employees who have had any of the following reason codes: 001-003, 008-009, 020-031, A23, 034, and 040-049. |
| Staffing Forecast Report | TX_STAFFING & TX_STSUMM | Workforce Administration > CAPPS Reports > Staffing Forecast Report | This report displays your agency's filled, vacant, and closed positions for the requested fiscal year. The budget information includes budgeted annual salary, expenditures-to-date, projected expenditures, and projected lapse. The report lists the position records assigned to each organization code, followed by activity, program, and division totals. Agency totals are also provided. |
| TX FMLA ER Insurance Rpt | TXPYFMLA | Benefits> Track FMLA> Track FMLA> TX FMLA ER Insurance Rpt | FMLA ER Insurance Report is an adhoc report that can be used to assist in reconciling if an adjustment is needed to care for the health insurance state match for an employee on Family Medical Leave. |
| Benefit Contribution Report | TXBEN003 | Root > CAPPS Interfaces > Benefits > Reports > Benefits Contribution Report | The As of Date" will determine the month |
| FMLA Event Status Report | TX_FMLA_EVNT | Benefits > Track FMLA (Family Medical Lv) > FMLA Event Status Report | Displays FMLA events |
| MSS Merit Approval Status | TX_MERIT_RPT | Workforce Administration > CAPPS Reports > MSS Merit Approval Status | Review the status of regular and one-time merits submitted through manager self service full (MSSF). |
| Active Staff in Multiple Agencies | TX_DUAL_EMP | Workforce Administration > CAPPS Reports > Active Staff in Multi Agencies | Identify staff employed at multiple agencies in CAPPS. This BI Report will not replace the statewide State Employees Employed by More than One State Agency. This report will provide a list of all active dually employed staff based on a "pay end date." Any employees active at any time during the month for the agency where an active row is found at another agency or another active employee record at the same agency) should be displayed. |
| Active Position – EE Details | TX_POS_INFO | Organizational Development > Position Management > Position Reports > Active Position – EE Details | This Report lists Active Positions with Employee Details. It includes vacant positions and the 3 Reporting Indicator fields and monthly budge amount. It also will show if a position is Hazardous Duty. |
| Position Funding Report | TX_POS_FUND | Payroll for North America > Payroll Distribution > Commitment Accounting USA > TX Position Funding Report | Provides funding information for either all active positions as of a specific Fiscal Year, or all vacant positions as of a specific date within an Agency. The report includes data from positions including "reports_to", jobcode, working titles, salary grade, Position Indicators and Commitment Accounting (budget/funding) data. |
| Total Compensation Report | TX_TOT_COMP | Workforce Administration > CAPPS Reports > Total Compensation Report | Create a report for employees to show the total cost of their employment (including employer paid benefits and taxes). The Excel format creates a spreadsheet for agencies that prefer to create their own Total Compensation Statements for their employees |
| Direct/Indirect Reports | TX_PSNRPT | Workforce Administration > CAPPS Reports > Direct/Indirect Reports | This report will provide all Direct and Indirect Reports, starting with either the Manager's Position, or the Manager's ID. A "Starting Position" is required. For large organizations, you may limit the "levels" of direct/indirect reports returned by specifying the number of levels desired. |
| Employee Biosketch Report | TXBIOSKETCH | Workforce Administration > CAPPS Reports > Employee Biosketch Report | This report provides Employee biographical information and includes employee's degrees, certification/license, spoken languages, awards/assignments/accreditations, firearm qualifications, and disciplinary actions. This is a confidential report and use must be in compliance with the Public Information Act (Texas Government Code Chapter 552) |
Payroll [+]
| Report Title | Process Name | Navigation | Description |
|---|---|---|---|
| Deduction Register | PAY001 | Payroll for North America>Payroll Processing USA>Pay Period Reports>Deduction Registry | Lists the amount of money deducted from each employee's paycheck for general deductions, garnishments, and benefits as of the end of a pay period |
| Deductions Not Taken Report | TXPAY008 | Payroll for North America>Payroll Processing USA>Pay Period Reports>Deductions Not Taken | Produces a report of employee deductions that were not taken for the pay period. Also shows the deductions and amounts that went into arrears. |
| Employees Not Processed Report | PAY010 | Payroll for North America>Payroll Processing USA>Produce Payroll>Employees Not Processed Report | Produces a report of employee deductions that were not taken for the pay period. For each employee, this report lists: – Pay group – Deduction name and code – Amount omitted – Reason Not Taken |
| Federal Liability by State | TAX014 | Payroll for North America>Pay Period Tax Reports USA>Federal Liability by State | Produces a report of federal withholding and liability (ER and EE FICA plus withholding) for each state. |
| Multiple Worksite | TXTAX004 | Payroll for North America > U.S. Quarterly Processing > Quarterly Reports > Multiple Worksite | This report displays TWC gross wages by county for each month in the quarter and is used by agencies to prepare TWC Quarterly Reports. |
| Other Earnings Register | TXPAY006 | Payroll for North America>Payroll Processing USA>Pay Period Reports>Other Earnings Register | Produces a report of detailed entitlements. Report includes each Other Earnings type on a separate page and totals, sorted by hours and amounts. Under each earnings type, the report lists the names and ID numbers of employees in employee ID order. It includes amounts and hours for the current pay period and sorted by MTD, QTD, and YTD totals. The report includes a grand total of hours and amounts for the following: All earnings types for the pay group -Pay period -Company |
| Payroll Error Messages | PAY011 | Payroll for North America > Payroll Processing USA > Review Processing Messages > Payroll Error Message Report | Provides a list of the system error messages (with message ID number and description) generated during payroll processes. Can be viewed online. |
| Payroll Register Report | TXPAY002 | Payroll for North America>Payroll Processing USA>Pay Period Reports>Payroll Register | This report provides employee-level payment detail. The report is sorted by department ID and provides department subtotals as well as a grand total for all paychecks. |
| Payroll Summary Report | PAY018 | Payroll for North America>Payroll Processing USA>Pay Period Reports>Payroll Summary | Produces a summary of U.S. paycheck detail by Run ID. It includes amounts, earnings, employee deductions, employer contributions, employee and employer taxes. |
| Precalculation Audit Report | PAY035 | Payroll for North America>Payroll Processing USA>Produce Payroll>Precalculation Audit Report | The Precalculation Audit Report is a report that you should run before the pay calculation to identify records that could cause errors during pay calculation. It checks employee data for valid company, tax location code, state tax data, unemployment insurance jurisdiction, and so on. |
| PreConfirm Audit Report | PAY036 | Payroll for North America>Payroll Processing USA>Produce Payroll>PreConfirm Audit Report | Provides a detailed listing (by pay group, pay end date, and employee ID) of information that might cause problems during the Pay Confirmation process. It checks for potential duplicate keys, no active job record found, prior unconfirmed payroll runs, and outstanding off-cycle checks. This report is usually run before confirm. Also as a troubleshooting tool, it can be run after confirm to help identify errors. |
| PreSheet Audit Report | PAY034 | Payroll for North America>Payroll Processing USA>Create and Load PaySheets>PreSheet Audit Report | Provides a detailed error listing of set up data (employee, benefit, deductions) that can cause errors in the Create Paysheet process |
| Tax Deposit Summary | TXTX10FD | Payroll for North America>Pay Period Tax Reports USA>TX Federal Tax Summary | Produces a summary report of period-to-date income tax withheld, FICA, and unemployment taxes at the federal level |
| Tax Deposit Summary | TAX001 | Payroll for North America>Pay Period Tax Reports USA>Tax Deposit Summary | Produces pay period details of federal, state, and local taxes that are withheld from employees, and liabilities incurred for employer-paid taxes. |
| TWC Quarterly Report – Wages by Employee | TXTAX015 | Payroll for North America>U.S. Quarterly Processing>State Quarterly Wage Reporting>Create Quarterly Wage File SD-WY | Creates a file for states that must submit quarterly state wage listings on electronic/magnetic media. |
| TWC Quarterly Report – Wages by Employee | TXTAX015 | Payroll for North America>U.S. Quarterly Processing>State Quarterly Wage Reporting>Create Quarterly Wage File SD-WY | Creates a file for states that must submit quarterly state wage listings on electronic/magnetic media |
| TX 941 Quarterly Fed Tax | TXTAX941 | Payroll for North America>U.S. Quarterly Processing>Quarterly Reports>TX 941 Quarterly Fed Tax | Displays all net pay and vendor information relating to the current payroll. This includes fund numbers, appropriation years, PCA/Index codes, object codes, and amounts. |
| TX Deceased Employee Tax Rpt | TXDECTAX | Payroll for North America>U.S. Annual Processing>TX Deceased Employee Tax Rpt | Lists employees with earnings paid where Job Status equals 'D' (deceased). List gross and taxable details from the tax balance tables. |
| TX EE/ER Tax Difference | TX_TXTDIFFAE | Payroll for North America > Payroll Processing USA > Pay Period Reports > TX EE/ER Tax Difference | This report accounts for payments where employer OASDI/Medicare taxable gross/tax amounts are different from the employee OASDI/Medicare taxable gross/tax amounts. |
| TX Employee Count | TXTX04ST | Payroll for North America>U.S. Quarterly Processing>Quarterly Reports>TX Employee Count | Produces a report of employment count totals, sorted by gender, as of the 12th of each month in the quarter. |
| TX Employees Not Paid | TXNOTPD | Payroll for North America > Payroll Processing USA > Pay Period Reports > TX Employees Not Paid | This report displays all employees that have not been paid during the pay period. |
| TX Error Listing | TXTAX900 | Payroll for North America>U.S. Annual Processing>Audit and Error Reports>TX Error Listing | Error Listing report of errors that will impact year-end processing (employees who have negative tax balances or reportable wage amounts that would cause overflow in fields when the system writes W-2 data to magnetic media. It also checks for other error conditions. |
| TX Fed Tax Summary – Detail | TXTAX007 | Payroll for North America>U.S. Quarterly Processing>Quarterly Reports>TX Fed Tax Summary – Detail | Produces a report by employee, quarter-to-date (QTD), federal withholding, Federal Insurance Contributions Act (FICA), and unemployment taxes. It lists employees by social security number (SSN) and name, and it provides page and company totals. |
| TX Local Tax Deposit | TAX009 | Payroll for North America>Pay Period Tax Reports USA>Local Tax Deposit | Provides a tax summary report of local taxes withheld. This pay period report lists total taxes withheld for residents and nonresidents separately for each locality. It lists the number of employees in each category and counts only once those employees who receive more than one check. |
| TX Local Tax Summary | TXTX02LC | Payroll for North America>U.S. Quarterly Processing>Quarterly Reports>TX Local Tax Summary | Produces a summary report of employee QTD local wages and withholding. This report lists employees by SSN and name. |
| TX Monthly Longevity Report | TX_MTLY_LNG | Payroll for North America > Payroll Processing USA > Pay Period Reports > TX Monthly Longevity Report | This report displays the new longevity pay rates for employees when the rate will change in the next period. |
| TX Negative Tax Balance | TXQTRNEG | Payroll for North America > Payroll Processing USA > Pay Period Reports > TX Negative Tax Balance | This report allows agencies to identify out of balance conditions prior to confirmation. Early detection of negative tax balances provides agencies the ability to identify, research and make any adjustments necessary to ensure accurate 941, W-2, and SUI taxable wage reporting and employee/employer FICA tax withholdings. |
| TX Payroll CY Audit Report | TXAUDLIM | Payroll for North America>Payroll Processing USA>Pay Period Reports>TX Payroll CY Audit Report | Reports employees for a specified pay period that meet or exceed defined exception limits (defined on CAPPS Constants Table) for gross amount, deduction amount, net amount and tax amounts. This report also monitors BRP and Deferred Comp YTD maximums. |
| TX PaySheet Manager Audit | TXPMRAUD | Payroll for North America>Payroll Processing USA>Update PaySheets>TX PaySheet Manager Audit | Lists employees that were identified by the PaySheet Manager Process that are in need of research due to no time loading for them. Fields are Employee Name, EmplID, Page #, Line # and off cycle. |
| TX Position Payment Posting | TX_POS_PMT | Payroll for North America > Payroll Processing USA > Pay Period Reports > TX Position Payment Posting | This report displays all earnings related to a position for the payroll period processed. |
| TX Predistribution Audit Report | TXPCA010 | Payroll for North America>Payroll Distribution>Commitment Accounting USA>TX Predistrib Audit Report | Identifies potential errors that may occur during the Actuals Distribution process. Allows budget/position control staff the ability to identify the errors and modify configurations or budgets within the HCM Tx Baseline CAPPS in order to successfully process payroll. |
| TX Pyrl Actuals by Project Id | ASPY3046 | Payroll for North America>Payroll Distribution>Commitment Accounting USA>TX Pyrl Actuals by ProjectID | Provides summary payroll expenditure information by Project ID for a specific payroll document being processed in order to aid budget and cash management staff in validating funds availability. |
| TX Pyrl Actuals Class Summary | HSAS3002 | Payroll for North America>Payroll Distribution>Commitment Accounting USA>TX Pyrl Actuals Class Summary | Provides summary payroll expenditure information by class (PCA) for a specific payroll document being processed in order to aid budget and cash management staff in validating funds availability. |
| TX Pyrl Actuals Fund Summary | HSAS3001 | Payroll for North America>Payroll Distribution>Commitment Accounting USA>TX Pyrl Actuals Fund Summary | Provides summary payroll expenditure information by fund for a specific payroll document being processed in order to aid budget and cash management staff in validating funds availability. |
| TX Pyrl by Approp/PCA | HSPY0001 | Payroll for North America>Payroll Distribution>Commitment Accounting USA>TX Payroll by Approp/PCA | Provides summary payroll expenditure information by Appropriation/PCA for a specific payroll document being processed in order to aid budget and cash management staff in validating funds availability. |
| TX SPRS Audit Rpt | TXSPRAUD | Payroll for North America>Payroll Distribution>TX SPRS Audit Rpt | Provides an analysis of a payroll as if it were sent to SPRS for processing. It lists any potential errors that would not pass SPRS processing. |
| TX State Matching Contribution | TX_MTCH_CTB | Payroll for North America > Payroll Processing USA > Pay Period Reports > TX State Matching Contribution | This report displays the state matching contributions deposited to different funds by labor code. It is used to document billings to outside entities for costs associated with state employee services, such as state matching taxes, state paid insurance, and state matching retirement. |
| TX State Tax Summary | TXTX10ST | Payroll for North America>Pay Period Tax Reports USA>TX State Tax Summary | Produces a summary report of period-to-date income tax withheld, disability, and unemployment taxes at the state and local levels. |
| TX State Tax Summary – Detail | TXTAX008 | Payroll for North America>U.S. Quarterly Processing>Quarterly Reports>TX State Tax Summary – Detail | Produces a summary report of employee QTD state withholding, disability, and unemployment taxes. It lists employees by SSN and name, and it provides page and company totals. |
| TX State Unemployment Tax | TXTAX017 | Payroll for North America>U.S. Quarterly Processing>Quarterly Reports>TX State Unemployment Tax | Produces a report to verify that the appropriate employer unemployment tax for the quarter being reported has been calculated and posted to employees' Tax Balance records. |
| TX Tax Balance Audit | TXTAX015 | Payroll for North America>U.S. Quarterly Processing>Quarterly Reports>TX Tax Balance Audit | Produces a report that compares the employee QTD tax balance with the sum of Tax Detail records from each payroll run for each tax class and tax jurisdiction, making it possible to verify that system computations are correct for these balances. |
| Tx Tax Balance Audit | TXTAX015 | Payroll for North America>U.S. Quarterly Processing>Quarterly Reports>TX Tax Balance Audit | Produces pay period details of federal, state, and local taxes that are withheld from employees, and liabilities incurred for employer paid taxes. |
| TX Taxable Gross Audit | TXTXGAUD | Payroll for North America>Pay Period Tax Reports USA>TX Taxable Gross Audit | Reports payments containing a calculated taxable gross (FIT/OASDI/HI) that exceeds the sum of the taxable gross components on the payment. |
| TX Vendor Remittance | TXVNDRMT | Payroll for North America>Payroll Processing USA>Pay Period Reports>TX Vendor Remittance | Provides a listing of Deductions and Garnishments by SetID/Business Unit/Deduction for a particular on or off-cycle payroll. |
| TX W-4 Exemptions | TXTAX100 | Payroll for North America>U.S. Annual Processing>Year-End/New Year Preparation>TX W-4 Exemptions Report | Produces a listing of all employees whose Tax Data records indicate that they are exempt from federal income tax withholding. |
| TX Warrant Register | TXPAY004 | Payroll for North America>Payroll Processing USA>Pay Period Reports>TX Warrant Register | Displays PeopleSoft Check Number, Check Amount (optional upon user request), Employee Name, EmplID, SPRS Payment Number, and Mail Drop. It sorts and totals by Company, Business Unit, Location, and Department. |
| Position Funding Report | TX_POS_FUND | Payroll for North America > Payroll Distribution > Commitment Accounting USA > TX Position Funding Report | Provides funding information for either all active positions as of a specific Fiscal Year, or all vacant positions as of a specific date within an Agency |
| Direct Deposit Audit Report | TX_DIR_DEP | Payroll for North America > Payroll Processing USA > Pay Period Reports > Direct Deposit Audit Report | This report lists the direct deposit changes for the corresponding agency employees with the following run control capability: 1. Company 2. Updated by drop down (Example 'NOC Process' or 'Employee Self Service' or 'Online User' or 'System') 3. Begin date and End Date The Audit report is an outcome of the CAPPS NOC Process which makes updates to the employee direct deposit data based on receiving the NOC Information through Bank Returns file. |
| Payroll Reimbursement | TX_PY_RIMB | Payroll for North America > Payroll Processing USA > Pay Period Reports > TXPayroll Reimbursement Rpt | Lists employee level and state matching contributions at the fund level (funding vs. state), as well as roll up costs by other funding elements (program code, earmark, etc.). |
Time and Labor [+]
| Report Title | Process Name | Navigation | Description |
|---|---|---|---|
| Comp Time Expiration Report | HTL00018 | Time and Labor > Texas Reports > Comp Time Expiration Report | HTL00018 – Comp Time Expiration Report. Shows expiring time for an employee within a selected 3 month period. |
| Comp Time/Overtime Earned Rpt | TXTL1028 | Time and Labor > Texas Reports > CompTime/Overtime Earned Rpt | CompTime/Overtime Earned Rpt displays employees who have earned Comptime or Overtime within the start and end dates entered. A separate report must be run for Comptime or Overtime. |
| Comp Time/Overtime Threshld Rpt | ASTL0015 | Manager Self Service > Time Management > Texas Reports > Comp Time/Overtime Threshld Rpt | The Compensatory Time/Overtime Threshold Report displays employees who have a balance over a user specified threshold for a selected leave type of Compensatory Time or Overtime. Only one report can be run at a time. |
| Comptime/Overtime Earned Rpt | TXTL028A | Manager Self Service > Time Management > Texas Reports > Comptime/Overtime Earned Rpt | Comptime/Overtime Earned Rpt displays employees who have earned Comptime or Overtime within the start and end dates entered. A separate report must be run for Comptime or Overtime. |
| CompTime/Overtime Threshld Rpt | HTL00015 | Time and Labor > Texas Reports > CompTime/Overtime Threshld Rpt | The Compensatory Time/Overtime Threshold Report displays employees who have a balance over a user specified threshold for a selected leave type of Compensatory Time or Overtime. Only one report can be run at a time. |
| Employee Monthly T&L Rpt | HTL00001 | Time and Labor > Texas Reports > Employee Monthly T&L Rpt | This report displays Leave activity for the current month, monthly Leave accruals and fiscal year-to-date balances. It also shows expiring time, time to be converted, and provides a breakdown by day including Labor Account codes (if LAC selected), and provides a certification page that can be printed out (if Attestment is selected). Run by individual employee. |
| Employee Monthly Time & Leave | ASTL1004 | Manager Self Service > Time Management > Texas Reports > Employee Monthly Time & Leave | The Employee Monthly Time and Leave Report can only be run for your direct reports. It provides a monthly summary of leave hours taken, leave balances, expiring leave balances and forecasts Vacation Leave converting to Sick Leave at the end of the Fiscal Year. |
| Employees Without Accruals Rpt | HTL00019 | Time and Labor > Texas Reports > Employees Without Accruals Rpt | Use this report to identify employee who did not earn accruals. |
| Employees Without Accruals Rpt | ASTL1001 | Manager Self Service > Time Management > Texas Reports > Employees Without Accruals Rpt | The Employees Without Accruals Report is used to identify employees who did not earn accruals. This report can be run for employees that report directly to you. |
| Full Month of LWOP Time Rpt | ASTL1016 | Time and Labor > Texas Reports > Employees Without Accruals Rpt | The Full Month of Leave Without Pay report shows employees who have the entire month of scheduled hours reported as LWOP. This is useful for FMLA/Benefits Reporting to help determine if an employee is eligible for the state contribution and to verify if the State Effective Service Date has been updated based on the LWOP month. |
| Leave Liability Report | ETL00022 | Time and Labor > Texas Reports > Leave Liability Report | This report provides expendable trust funds/long term debt information needed by agencies for the Annual Financial Report. The report provides the details needed to support the agency balances during an audit. Every employee who has had a balance of compensatory time, overtime, or vacation leave during the requested fiscal year will be included. The report shows balance information at the beginning of the fiscal year, and the current balance will be displayed along with basic personnel information (assignment, longevity, salary, etc.). For each balance, the monetary value is also listed. |
| Military Leave FFYE Report | TXTLMLRP | Time and Labor > Texas Reports > Military Leave FFYE Report | Use this report to display, by employee, military hours lost from one Federal Fiscal Year to the next Federal Fiscal Year. |
| Optional Holiday Owed Report | TXTL0025 | Time and Labor > Texas Reports > Optional Holiday Owed Report | The Optional Holiday Owed Report provides a way to view balance activity for the Optional Holiday Time Reporting Codes (OPHCT and REGOH) over a specified period of time. This should be run prior to the last skeleton crew holiday of the fiscal year so that the agency can notify employee's with a negative balance. Identifies employees who have taken off for an Optional Holiday and need to work on a Skeleton Crew Holiday. |
| Optional Holiday Owed Report | TXTL025A | Manager Self Service > Time Management > Texas Reports > Optional Holiday Owed Report | The Optional Holiday Owed Report provides a way to view balance activity for the Optional Holiday Time Reporting Codes (OPHCT and REGOH) over a specified period of time. Use to identify employees who have taken off for an Optional Holiday and need to work on a Skeleton Crew Holiday. |
| Positive Time Rptrs Without Hrs | ETL00012 | Time and Labor > Texas Reports > Positive Time Rptrs Without Hrs | The Positive Time Reporters Without Hours Report displays Hourly employees reporters that have not reported hours for a specified start and end date. |
| Positive Time Rptrs Without Hrs | ASTL0003 | Manager Self Service > Time Management > Texas Reports > Positive Time Rptrs Without Hrs | The Positive Time Reporters Without Hours Report identifies hourly employees who have not reported hours for a specified start and end date entered by the manager. |
| Sched Hrs Not Equal to Std Hrs | HTL00007 | Time and Labor > Texas Reports > Sched Hrs Not Equal to Std Hrs | This identifies employees with a schedule with total hours that do not equal their authorized hours in Job Data. There are many edits in the system to prevent this, so it should not be a regular occurring issue. |
| Sick Leave Pool/Extended Sick | TXTL0024 | Time and Labor > Texas Reports > Sick Leave Pool/Extended Sick | This report provides utilization by employee for Donated (SCKPD), Reclaimed (SCKPX), Awarded (SCKPA), Taken (SCKPT), and Returned (SCKPR) Sick Leave Pool. The sick leave pool balance is also available on an online CAPPS web page. |
| Time Certification Report | HTL00032 | Time and Labor > Texas Reports > Time Certification Report | The Time Certification Report is used to provide a monthly summary of the time certification details for employees required to certify their time. It identifies whether or not their time has been certified, by whom, and the date of certification. |
| Time Certification Report | HTL00031 | Manager Self Service > Time Management > Texas Reports > Time Certification Report | The Time Certification Report is used to provide a monthly summary of the time certification details for employees who report to you. |
| TRCs by Date Report | TXTL024A | Manager Self Service > Time Management > Texas Reports > TRCs by Date Report | The Time Reporting Codes by Date Report provides a way to view balance activity for various Time Reporting Codes used by a manager's direct reports over a specified period of time. |
| Employee Leave Balances by Agency | TXTLELBAR | Time and Labor > Texas Reports > Employee Lv Balances by Agency | The Employee Lv Balances by Agency report displays all leave balances for all employees (specified on the run control) as of the date specified on the run control. |
| FYE Leave Conversion Report | TXTLALCR | Time and Labor > Texas Reports > FYE Leave Conversion Report | The FYE Leave Conversion Report provides company information on employees that had excess Annual Leave time rolled over into Sick Leave time at the end of the fiscal year. |
| Comp Time Expire (LEG Only) | TXTLCTEL | Time and Labor > Texas Reports > FYE Leave Conversion Report | Legislative Agency Comp Time Lost Report for Legislative agencies. This report should be run after the FYE Annual Leave Conversion process has been run. |
| Leave Balance Detail Report | TXTLCLBDR | Time and Labor > Texas Reports > Leave Balance Detail Report | The Leave Balance Detail Report displays leave activity by employee or group of employees for a specified comp time plan (leave type) within the specified period (Start Date/End Date) entered on the run control. |
| Leave Balance Detail Report | TXTLCLBDR | Manager Self Service > Time Management > Texas Reports > Leave Balance Detail Report | The Leave Balance Detail Report displays leave activity by employee or group of employees for a specified comp time plan (leave type) within the specified period (Start Date/End Date) entered on the run control. |
| Legislative Leave Pool | TXTLLLPRPT | Time and Labor > Texas Reports > Legislative Leave Pool | The Legislative Leave Pool report displays information/activity for the time period specified for all employees (specified on the run control). Requires Legislative Authority to use this pool. |
| Low Leave Balance by Agency | TXTLLLBAR | Time and Labor > Texas Reports > Low Leave Balance by Agency | The Low Leave Balance by Agency report displays employees with a summary of total leave balances less than or equal to the specified amount on the first tab (Emp Leave Balance Summary). It also displays the detail balance information by employee on the second tab (Emp Leave Balances by Plan). |
| Projected Annual Leave Report | TX_PRJLVBAL | Time and Labor > Texas Reports > Projected Annual Leave | The Projected Annual Leave Report provides a projection for employees annual leave that will be converted to sick leave at fiscal year end. |
| TL Federal Funding Report | TX_TL_FEDFND | Time and Labor > Texas Reports > TL Federal Funding Report | The TL Federal Funding Report creates 2 spreadsheets TX_TL_LAC_HR.xlsx and TX_TL_TOT_HR.xlsx and may also generate corresponding flat files if the SU checks the Generate Flat File checkbox. The reports can be used to help redistribute labor costs. TX_TL_TOT_HR is a summary that contains all employees in the Group ID. TX_TL_LAC_HR contains detail daily time information for employees in the Group ID who have reported any time to a LAC. For each employee meeting the criteria for the TX_TL_LAC_HR report, the entire months worth of hours is reported. |
| Time Needs Approval Status Report | TXTLTMAP | Manager Self Service > Time Management > Texas Reports > Time Needs Approval Status | The Time Needs Approval Status report provides a list of employees who have time that needs to be approved. |
| Time Needs Approval Status Rpt | TXTLNASR | Time and Labor > Texas Reports > Time Needs Approval Status Rpt | The Time Needs Approval Status report provides a list of employees who have time that needs to be approved. |