PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 05/17/2017 2:55 PM by  Kristie Starzyk
Table for PR51 Data
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Kristie Starzyk
HRIS Coordinator
Rush-Copley Medical Center
Advanced Member
(81 points)
Advanced Member
Posts:33


Send Message:

--
05/17/2017 2:33 PM

    I'm trying to run a report in my report writing tool for Worker's Comp Wage Statements, and I need data off of the paychecks on PR51.  Does anyone know what table that data sits on?  I've been trying to find it all morning. I can find the deductions from the checks, but I'm having a hard time finding the income/pay codes.

    Thank you in advance!

    Margie Gyurisin
    Private
    Private
    Veteran Member
    (1275 points)
    Veteran Member
    Posts:473


    Send Message:

    --
    05/17/2017 2:40 PM
    Off the top of my head, I would say EMPLOYEE, PRTIME and PAYDEDUCTN.
    Margie Gyurisin
    Private
    Private
    Veteran Member
    (1275 points)
    Veteran Member
    Posts:473


    Send Message:

    --
    05/17/2017 2:42 PM
    To get all descriptors, etc. You will need some additional tables. Technical Text lists these tables -
    DEDCODE -
    EMPLOYEE -
    HRSECLEV -
    PAYDEDUCTN -
    PAYMASTR -
    PAYSUMGRP -
    PRCHECK -
    PRSYSTEM -
    PRTIME -
    Kristie Starzyk
    HRIS Coordinator
    Rush-Copley Medical Center
    Advanced Member
    (81 points)
    Advanced Member
    Posts:33


    Send Message:

    --
    05/17/2017 2:55 PM
    Thank you so much, Margie!! PRTIME and PAYSUMGRP were my missing pieces!

    You are the best!
    You are not authorized to post a reply.