RSF_TF_PD_PL_LN

(SQL View)
 Index Back

Period - Pipeline Prompt View

Language view for RSF_TF_PD_PL_VW description.

SELECT P.TIMEFRAME_ID , P.PERIOD_ID , L.LANGUAGE_CD , L.DESCR , P.PERIOD_ROLLUP_ID FROM PS_RSF_PIPE_TF_VW P , PS_RSF_TF_PERD_LNG L WHERE P.TIMEFRAME_ID = L.TIMEFRAME_ID AND P.PERIOD_ID = L.PERIOD_ID AND ((P.PERIOD_TYPE IN ( SELECT PERIOD_TYPE FROM PS_RSF_TF_DEFN T WHERE T.TIMEFRAME_ID = P.TIMEFRAME_ID)) OR (P.PERIOD_ID IN ( SELECT P2.PERIOD_ROLLUP_ID FROM PS_RSF_PIPE_TF_VW P2 WHERE P2.TIMEFRAME_ID = P.TIMEFRAME_ID)))

  • Related Language Record for RSF_TF_PD_PL_VW

  • Parent record: RSF_TF_PD_PL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TIMEFRAME_ID Character(15) VARCHAR2(15) NOT NULL Time Frame
    2 PERIOD_ID Character(15) VARCHAR2(15) NOT NULL Period
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 PERIOD_ROLLUP_ID Character(15) VARCHAR2(15) NOT NULL Quota Rollup Period