TRN_VAL_CALEVW

(SQL View)
 Index Back

Training Calendar View

This view is used to retrive the Calandar based on the Budget Period and Business Unit.

SELECT DISTINCT G.CAL_ID ,F.DESCR FROM PS_GP_CAL_PRD F ,PS_GP_CALENDAR G WHERE G.CAL_PRD_ID=F.CAL_PRD_ID

  • Related Language Record: TRN_VCAL_LNGEVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description