GPGB_EEMVW_LNG

(SQL View)
 Index Back

Payslip EE Message - SS

GPGB - Message table for UKSelf Service Payslip purposes.

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.LANGUAGE_CD ,B.DESCRLONG FROM PS_GP_PYE_SEG_STAT A , PS_GPGB_EEMDTL_LNG B WHERE a.EMPLID=B.EMPLID AND A.EMPL_RCD=B.EMPL_RCD 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    11 DESCRLONG Long Character CLOB Long Description