Child pages
  • Datatrieve Reports
Skip to end of metadata
Go to start of metadata

overview

Each Datatrieve procedure is designed to produce a report to assist you with USPS processing.

accessing the program

The program may be executed as follows.

In the menu system type:

Menu>USPS_DTR

At this point, select the desired Datatrieve option.

main menu

 

OECN USPS System Datatrieve Report Programs
1.    CALTYPE          Calendar Type and Description Listing
2.    CHKLEV           Current Leave Usage and Balance Report
3.    CHKSTRS          Check STRS Advance Totals
4.    MAXAMT           Maximum Amount Deduction Report
5.    OSDIRPT          OSDI Information Verification Reports
6.    PAYDSTLST        Payrol Distribution Listing
7.    PAYGRP           Pay Group Listing and Worksheet
8.    PGRPLEV          Current Leave Usage and Balance Report by Pay Group

OPTION>

 

caltype

Calendar Type and Description Listing

This procedure produces a single-spaced report
displaying the calendar type and its description.

Output file is CALTYPE.TXT


Reports

Date:  6/15/94             Calendar Type Listing                Page:    1
                        SAMPLE CITY SCHOOL DISTRICT            (CALTYPE)



         Calendar                  Calendar
           Type                   Description

           001     CERTIFIED
           002     NON-CERTIFIED
           003     ADMINISTRATION
           DEF     DEFAULT (BLANK)

 

chklev

Current Leave Usage and Balance Report

CHECK_LEAVE - prints current usage information and balances.
       The values on the report will be printed on the employee's
       next check stub.

Report Sort Options:
  N - Employee Name
  I - Employee ID

Enter Sort Option: N

Enter Subtotal by Name (Y,N): Y

Enter Continue (Y,N):

Processing...

Output file is CHKLEV.TXT


Reports

                                   Current Leave Usage and Balances                  15-Nov-2003
                                      Sample City School District                         Page 1

                                Sick                 Vacation                 Personal
    ID         Name             Usage   Balance        Usage     Balance       Usage    Balance

333333335 BASKET, MAY B         1.000    209.850       4.000      26.000       .000      3.000
333333343 BERRY, VERRY D         .250    137.000        .000       6.000       .000      2.500
333333333 DOE, JOHN J            .000    139.500       1.000      16.500       .000      3.000
555555555 DUST, BUNNY B          .000     38.500       1.000      29.000       .000       .000

Hourly GRAND Totals:             .000                   .000                   .000
Daily GRAND Totals:             1.250                  6.000                   .000


 

chkstrs

Check STRS Advance Totals

This procedure creates a report of employee STRS advance totals
for 450, 591 and 691 deduction records.

Report Sort Options:
  N - Employee Name Order
  S - Employee SSN Order

Enter Sort Option: S

Enter Continue (Y,N): Y

Working...

Your report is :  CHKSTR.TXT

Reports

                   STRS Actual Deduction Amounts             20-Jul-1992
                                                                  Page 1



                                    Deduction    STRS Advanced
    SSN                     Name      Code        Deductions


222-22-2222   SMITH, SANDRA A
                                       591              86.98
                                       591              86.98
                                       591              86.98

                        Total Advanced Amount          260.94

333-33-3333   JONES, JOHN J
                                       591              94.64
                                       591              94.64
                                       591              94.64

                        Total Advanced Amount          283.92

                                  Grand Total          544.86


Miscellaneous Notes

The information contained in this report can be used to determine how much retirement was actually deducted for each person while the district was in advance mode. The total advanced amount deducted for each employee can be compared to the STRSAD.TXT report generated at the end of June. Discrepancies between the two reports may assist you in resolving out of balance conditions.

maxamt

Maximum Amount Deduction Report

This procedure provides a report showing the 'Maximum Amount' flag for
a user-specified regular (6xx) deduction code.  The report is single-
spaced and may be sorted by SSN or Employee Name.

Enter Deduction Code for Report: 600

Report Sort Options:

  N - Alphabetic Order by Employee Name
  S - Social Security Number Order

Enter Sort Option: N

Output file is MAXAMT.TXT

Processing Completed!

Reports

Date:  2/04/93        Maximum Regular Deduction Report            Page:      1
                             Sample City School                   (MAXAMT)


                                             Has
                                           Maximum                    Calendar
                                           Amount        Maximum         YTD
Code/SSN                                    [Y\N]       Deduction     Deduction

  600       CREDIT UNION

222-22-2222 APPLE, ALICE                      Y           200.00          30.00
333-33-3333 BANANA, BOB                       N              .00         130.00
444-44-4444 GRAPE, GEORGE                     Y           500.00          50.00
555-55-5555 PRUNE, PAUL                       N              .00          50.00


    Grand Total ===>                                         .00         260.00



 

osdirpt

OSDI Information Verification Reports

OSDIRPT - Ohio School District Income Tax Verification Report

This procedure produces a single-spaced report displaying employee
records that have no OSDI district code in BIOSCN; employees that
are believed to be missing a required OSDI deduction record; or all
employees on file.

Notes: This report displays data for all employee record status codes
       to help insure that an inactive record isn't activated and a
       needed OSDI tax not withheld.  This report _cannot_ determine
       the OSDI deduction code status if the employee record in BIOSCN
       does not contain a valid OSDI district code.

Report Selection Options:

  A - All Employees Regardless of OSDI Status
  M - Employees With Missing Required OSDI Deduction Record
  N - Employees With No OSDI District Code in BIOSCN

Enter Selection Option: N

Report Sort Options:

  C - City/OSDI District Code (BIOSCN)/Employee Name
  N - Employee Name
  O - OSDI District Code (BIOSCN)/Employee Name
  S - Employee Social Security Number

Enter Sort Option: N

Output file is OSDIRPT.TXT

Processing Completed!

Reports

Option A - All Employees Regardless of OSDI Status

Date:  1/05/93    All Employees Regardless of OSDI Status         Page: 1
                        Sample City School District               (OSDIRPT)


                                                     OSDI
                                                     Dist    OSDI  OSDI
                                                     Code    Ded   Ded
    SSN#     Employee Name         City/State      (BIOSCN)  Code Exists

333-33-3335 BASKET, MAY L          TEST OH                  Unknwn N/A+
333-33-3343 BERRY, VERY D          TEST OH                  Unknwn N/A+
333-33-3345 BOGGS, WADE A          FENWAY OH                Unknwn N/A
111-11-1123 BOULTON, MICHAEL       TEST OH                  Unknwn N/A
111-11-1121 BOX, MAIL              TEST OH                  Unknwn N/A
111-11-1129 CARPENTER, IMA A       SAMPLE OH                Unknwn N/A+
333-33-3340 CLARK, ROY P           SAMPLE OH                Unknwn N/A
222-22-2226 CUTTER, WOOD S         SAMPLE OH         3501   804    YES+
111-11-1125 DRIVE, TEST A          TEST OH           3503   NotReq N/A+


+  Indicates calendar YTD earnings detected for employee.


Option M - Employees With Missing Required OSDI Deduction Record

Date:  1/05/93    Employees Missing Needed OSDI Deduction         Page: 1
                        Sample City School District             (OSDIRPT)

                                                     OSDI
                                                     Dist    OSDI  OSDI
                                                     Code    Ded   Ded
    SSN#     Employee Name       City/State        (BIOSCN)  Code Exists
333-33-3335 BASKET, MAY L          TEST OH           3501   806    NO+
333-33-3343 BERRY, VERY D          TEST OH           3501   806    NO+
333-33-3345 BOGGS, WADE A          FENWAY OH         3501   806    NO+


+  Indicates calendar YTD earnings detected for employee.


Option N - Employees With No OSDI District Code in BIOSCN

Date:  1/05/93    Employees W/No OSDI Dist. Code (BIOSCN)         Page: 1
                        Sample City School District             (OSDIRPT)


                                                     OSDI
                                                     Dist    OSDI  OSDI
                                                     Code    Ded   Ded
    SSN#     Employee Name      City/State         (BIOSCN)  Code Exists

333-33-3335 BASKET, MAY L           TEST OH                  Unknwn N/A+
333-33-3343 BERRY, VERY D           TEST OH                  Unknwn N/A+
333-33-3345 BOGGS, WADE A           FENWAY OH                Unknwn N/A
111-11-1123 BOULTON, MICHAEL        TEST OH                  Unknwn N/A
111-11-1121 BOX, MAIL               TEST OH                  Unknwn N/A
111-11-1129 CARPENTER, IMA A        SAMPLE OH                Unknwn N/A+
333-33-3340 CLARK, ROY P            SAMPLE OH                Unknwn N/A
222-22-2231 DUCK, DONALD A          MINNEY OH                Unknwn N/A+

+  Indicates calendar YTD earnings detected for employee.

Miscellaneous Notes

This report shows those employee records that have no OSDI district code in BIOSCN; a report of those employee records that are believed to be missing a required OSDI deduction code; or a report of all employees on file with the status of various OSDI indicators.

The report always reports employee records of all status codes (as opposed to looking at "Active" employees only). This is done to help insure that an inactive or terminated job is not inadvertantly activated and a needed OSDI tax not withheld.

This report cannot determine the need/validity of OSDI records if the OSDI district code has not been completed in BIOSCN. It is recommended that the user first utilize the program to determine those records missing this data (report selection option "N"). Then, using BIOSCN (from within USPSCN), complete this missing data and then utilize OSDIRPT again using option "M" to select missing required information. Report option "A" can be used to get a status report of all employees on file.

Any employee that has the word "NO" in the column "OSDI Ded Exists" (the right-most column on the report) should be examined carefully. In this case the report has determined that an OSDI record is necessary, but does not exist. If this column contains "YES" an appropriate OSDI record was found, whereas "N/A" indicates that an OSDI record is not applicable based on the information found.

Because of the importance of properly withholding tax information, it is recommended that users run this report periodically to insure proper setup of these tax deduction records.

paydstlst

Payroll Distribution Listing

PAYDSTLST - Payroll Distribution Listing

This procedure generates a payroll distribution register permitting
a means of verification of payroll check and/or direct deposit notice
distribution.  This procedure should be run immediately following
CHKPRT in order to achieve the desired results.  Several sort options
are provided. Page breaks are automatically determined by the sort
option chosen.

Report Selection Options:

  B - (Both) Check & Direct Deposit Employees
  C - Check Employees Only
  D - Direct Deposit Employees Only

Enter Selection Option: C

Report Sort Options:

  B - Building/Employee Name Order
  D - Building/Department/Name Order
  N - Alphabetic Order by Employee Name
  E - Employee Id Order

Enter Sort Option: B

Output file is PAYDSTLST.TXT

Processing Completed!

Reports

Date:  2/03/93     Employee Payroll Distribution Report           Page:      1
                        Sample City School District               (PAYDSTLST)


   EMPID          Employee Name              Employee Signature


Building: 1

  DUCK00001      DUCK, DONALD J             ______________________________

  HOME00001      HOMECKY, BECKY B           ______________________________

  SMIT00001      SMITH, JOE J               ______________________________

  TEST00001      TEST, TEST9 L              ______________________________

  TRAC00001      TRACY, DICK S              ______________________________

  TUCK00001      TUCKER, TONYA E            ______________________________


 

paygrp

Pay Group Listing and Worksheet

Generating Pay Group Listing/Worksheet


Output file is PAYGRP.TXT

Reports

                         Pay Group Listing/Worksheet              2-Mar-1994
                                                                  Page 1
                          Sample City School District

     Pay Group                    Description                  Calendar Type

        1              ADMINISTRATORS                              001
        2              CERT. EMPLOYEES                             002
        3              9 MO. NON-CERT.                             ___
        4              10 MO. NON-CERT                             ___
        5              12 MO. NON-CERT                             ___
        6              NON-UN NON-CERT                             ___
        7              CERTIFIED SUBS                              ___
        8              NON-CERT SUBS                               ___
        9              SUPPLEMENTAL                                ___


 

pgrplev

Current Leave Usage and Balance Report by Pay Group

PGRP_CHECK_LEAVE - Prints current Leave usage information and balances.
       The report will be sorted and subtotaled on pay group.
       The values on this report will be printed on the employee's
       next check stub.

Enter Continue (Y,N): Y

Processing...

Output file is PGRPLEV.TXT


Reports

                               Current Leave Usage and Balances by Pay Group

                                      Sample City Schools
                          Pay   Sick                   Vacation                 Personal
  ID          Name        Grp   Usage  Balance          Usage    Balance        Usage    Balance

555555555   Doe, John J   AD    1.000    336.500          .000      .000         .000    2.000

Hourly Subtotals:                .000                     .000                   .000
Daily Subtotals:                1.000                     .000                   .000

Hourly GRAND Totals:             .000                     .000                   .000
Daily GRAND Totals:             1.000                     .000                   .000


  • No labels