RSF_TF_PD_PL_VW

(SQL View)
 Index Back

Period - Pipeline Prompt View

View which supports the pipeline prompts

SELECT TIMEFRAME_ID , PERIOD_ID , DESCR , BEGIN_DT , END_DT , PERIOD_ROLLUP_ID FROM PS_RSF_PIPE_TF_VW P WHERE (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: RSF_TF_PD_PL_LN

  • Parent Record Of RSF_TF_PD_PL_LN

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 BEGIN_DT Date(10) DATE Begin Date
    5 END_DT Date(10) DATE This field stores the end date values.
    6 PERIOD_ROLLUP_ID Character(15) VARCHAR2(15) NOT NULL Quota Rollup Period