GPGB_EE_P45_SR

(SQL View)
 Index Back

P45 Search View

P45 Search View

SELECT A.EMPLID ,A.EMPL_RCD ,A.CAL_RUN_ID ,A.CAL_ID ,A.GP_PAYGROUP ,A.RSLT_SEG_NUM ,B.PRD_END_DT ,C.NAME ,E.DESCR ,A.LEAVE_DT ,C.DT_OF_DEATH ,T.LEAVE_DT FROM PS_GPGB_EE_RSLT A , PS_GP_PYE_PRC_STAT B , PS_PERSONAL_DT_FST C , PS_JOB D , PS_JOBCODE_TBL E , PS_GPGB_EE_TAX T WHERE A.EMPLID= C.EMPLID AND A.EMPLID=B.EMPLID AND A.CAL_RUN_ID = B.CAL_RUN_ID AND A.EMPL_RCD=B.EMPL_RCD AND A.GP_PAYGROUP=B.GP_PAYGROUP AND A.CAL_ID=B.CAL_ID AND B.CALC_TYPE = 'P' AND B.SEL_ACTION <> 'L' AND B.PRD_TYPE = 'C' AND B.PRC_ORD_TS = ( SELECT MAX(X1.PRC_ORD_TS) FROM PS_GP_PYE_PRC_STAT X1 WHERE X1.EMPLID = B.EMPLID AND X1.CAL_RUN_ID = B.CAL_RUN_ID AND X1.EMPL_RCD = B.EMPL_RCD AND X1.GP_PAYGROUP = B.GP_PAYGROUP AND X1.CAL_ID = B.CAL_ID) AND D.SETID_JOBCODE=E.SETID AND A.EMPLID = D.EMPLID AND A.EMPL_RCD=D.EMPL_RCD AND ( D.EFFDT = ( SELECT MAX(D_ED.EFFDT) FROM PS_JOB D_ED WHERE D.EMPLID = D_ED.EMPLID AND D.EMPL_RCD = D_ED.EMPL_RCD AND D_ED.EFFDT <= B.PRD_END_DT ) AND D.EFFSEQ = ( SELECT MAX(D_ES.EFFSEQ) FROM PS_JOB D_ES WHERE D.EMPLID = D_ES.EMPLID AND D.EMPL_RCD = D_ES.EMPL_RCD AND D.EFFDT = D_ES.EFFDT) ) AND D.JOBCODE = E.JOBCODE AND E.EFFDT = ( SELECT MAX(E_ED.EFFDT) FROM PS_JOBCODE_TBL E_ED WHERE E.SETID = E_ED.SETID AND E.JOBCODE = E_ED.JOBCODE AND E_ED.EFFDT <= D.EFFDT AND E_ED.JOBCODE = E.JOBCODE) AND T.EMPLID = A.EMPLID AND T.EMPL_RCD = A.EMPL_RCD AND T.EFFDT = ( SELECT MAX(T2.EFFDT) FROM PS_GPGB_EE_TAX T2 WHERE T2.EMPLID = T.EMPLID AND T2.EMPL_RCD = T.EMPL_RCD AND T2.EFFDT <= B.PRD_END_DT) AND T.EFFSEQ = ( SELECT MAX(T3.EFFSEQ) FROM PS_GPGB_EE_TAX T3 WHERE T3.EMPLID = T.EMPLID AND T3.EMPL_RCD = T.EMPL_RCD AND T3.EFFDT = T.EFFDT) AND ((T.GPGB_P45_CAL_RUN = A.CAL_RUN_ID) OR (T.GPGB_P45_CAL_RUN = ' '))

  • Related Language Record: GPGB_EE_P45_LNG

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

    Prompt Table: GP_CAL_RUN4_VW

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

    Prompt Table: GP_CALENDAR9_VW

    5 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

    Prompt Table: GP_PYGRP5_VW

    6 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
    7 PRD_END_DT Date(10) DATE Pay Period End Date
    8 NAME Character(50) VARCHAR2(50) NOT NULL Name
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 LEAVE_DT Date(10) DATE Leave Date
    11 DT_OF_DEATH Date(10) DATE Date of Death
    12 GPGB_P45_EFFDT Date(10) DATE Field used to store P45 Effdt according to Job and Process Action Reason definition.