TRN_VAL_CAL_VW

(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 D.BUDGET_PERIOD ,D.BUSINESS_UNIT ,A.CAL_ID ,F.DESCR FROM PS_TRN_SCUT_STATUS A ,PS_CRSE_SESS_DATES B , PS_BUDGET_PERIOD C ,PS_BUDGET_BUS_UNIT D ,PS_TRAINING E ,PS_GP_CAL_PRD F ,PS_GP_CALENDAR G WHERE A.COURSE=B.COURSE AND A.SESSION_NBR=B.SESSION_NBR AND A.CUT_SESSION_NBR=B.CUT_SESSION_NBR AND B.SESSN_START_DT >=C.EFFDT AND B.SESSN_END_DT <=C.THRU_DATE AND C.BUDGET_PERIOD=D.BUDGET_PERIOD AND A.EMPLID=E.EMPLID AND A.COURSE_START_DT=E.COURSE_START_DT AND A.COURSE=E.COURSE AND A.SESSION_NBR=E.SESSION_NBR AND A.COURSE_TITLE=E.COURSE_TITLE AND D.BUSINESS_UNIT=E.BUSINESS_UNIT AND A.CAL_ID=G.CAL_ID AND G.CAL_PRD_ID=F.CAL_PRD_ID AND A.CAL_ID <>' '

  • Related Language Record: TRN_VCAL_LNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUDGET_PERIOD Character(10) VARCHAR2(10) NOT NULL Budget Period
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description