GB_VAL_EFFDT_VW

(SQL View)
 Index Back

GB Records with EFFDT view

This view allows to know the records having an EFFDT used in Group Build

SELECT X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'GB_VALUE_DT_EFFDT' AND %EffdtCheck(PSXLATITEM, X, %CurrentDateIn) AND X.EFF_STATUS = 'A'

  • Related Language Record: GB_VAL_EFFDT_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name