GPBR_P_CALID_VW

(SQL View)
 Index Back

Calendar Id

Calendars of Brazil unfinalized

SELECT DISTINCT c.src_cal_run_id ,B.GP_PAYGROUP ,B.CAL_ID ,A.DESCR FROM PS_GP_CAL_RUN A , PS_GP_CAL_RUN_DTL B , PS_GPBR_TER_COMP C , PS_GP_CALENDAR D , PS_GP_RUN_TYPE R WHERE A.RUN_FINALIZED_IND='N' AND A.CAL_RUN_ID=B.CAL_RUN_ID AND A.COUNTRY='BRA' AND b.cal_run_id=c.src_cal_run_id AND B.GP_PAYGROUP=C.GP_PAYGROUP AND B.GP_PAYGROUP=D.GP_PAYGROUP AND D.CAL_ID = B.CAL_ID AND R.RUN_TYPE = D.RUN_TYPE AND R.CALC_TYPE = 'P'

  • Parent record: GPBR_TER_COMP

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