GPAR_P_CALID_VW

(SQL View)
 Index Back

Calendar Id

Calendar Id

SELECT DISTINCT B.GP_PAYGROUP , B.CAL_ID , A.DESCR FROM PS_GP_CAL_RUN A , PS_GP_CAL_RUN_DTL B , PS_GPAR_TER_COMP C ,PS_GP_CALENDAR D , PS_GP_RUN_TYPE E WHERE A.RUN_FINALIZED_IND = 'N' AND A.CAL_RUN_ID = B.CAL_RUN_ID AND A.COUNTRY = 'ARG' AND B.CAL_RUN_ID = C.SRC_CAL_RUN_ID AND B.GP_PAYGROUP = C.GP_PAYGROUP AND D.CAL_ID = B.CAL_ID AND E.RUN_TYPE = D.RUN_TYPE AND E.CALC_TYPE <> 'A'

  • Parent record: GPAR_TER_COMP

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
    2 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description