GPDE_DV_TRID_VW

(SQL View)
 Index Back

Deuev Trigger Run Ids

Deuev Run Ids for which triggers have been generated.

SELECT DISTINCT A.CAL_RUN_ID , B.DESCR FROM PS_GPDE_DV_RID_ST A , PS_GP_CAL_RUN B WHERE (A.GPDE_DV_DAY_IND = 'Y' OR A.GPDE_DV_MON_IND = 'Y' OR A.GPDE_DV_YEAR_IND = 'Y' OR A.GPDE_DV_START_IND = 'Y' OR A.GPDE_DV_END_IND = 'Y' OR A.GPDE_DV_CUR_IND= 'Y') AND B.CAL_RUN_ID = A.CAL_RUN_ID

  • Related Language Record: GPDE_DV_TRD_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description