GPGB_PGRP_M_VW

(SQL View)
 Index Back

Payslip EE Msg / Paygroup - SS

GPGB - Message table for UKSelf Service Payslip purposes. Per Paygroup.

SELECT A.emplid , a.cal_run_id , a.empl_rcd , a.gp_paygroup , a.cal_id , a.rslt_seg_num , B.GPGB_PSLIP_ID , B.effdt ,B.INSTANCE ,B.GPGB_PSLIP_MESS FROM PS_GP_PYE_SEG_STAT A , PS_GPGB_PGRP_M_DTL B WHERE a.GP_PAYGROUP=B.GP_PAYGROUP AND B.EFFDT >= A.SEG_BGN_DT AND B.EFFDT <= A.SEG_END_DT

  • Parent record: GPGB_PGRP_MESS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
    3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

    Prompt Table: GP_PYGRP

    5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id

    Prompt Table: GP_CALENDAR

    6 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
    7 GPGB_PSLIP_ID Character(6) VARCHAR2(6) NOT NULL Payslip ID

    Prompt Table: GPGB_PSLIP_HDR

    8 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    9 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
    10 GPGB_PSLIP_MESS Character(254) VARCHAR2(254) NOT NULL New field created by Jo Maye 27/7/2001 for Oracle Payslip fix (JMAYE)