GPBR_P_CALID_VW

(SQL View)
Index Back

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_GPBR_TER_COMP C 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

  • Parent record: GPBR_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