RSP_TFP_EN_L_VW

(SQL View)
 Index Back

Prompt View for Strategic Plan

This view is used within Strategic Planning component to create new Template and Plan.

SELECT A.PERIOD_TYPE , A.TIMEFRAME_PERIOD , B.LANGUAGE_CD , B.DESCR , A.TIMEFRAME_ID , A.PERIOD_ID FROM PS_RSF_TF_PERIOD A , PS_RSF_TF_PERD_LNG B WHERE A.RSF_PERIOD_USE IN ('A', 'D') AND A.END_DT >= %CurrentDateIn AND A.TIMEFRAME_ID = B.TIMEFRAME_ID AND A.PERIOD_ID = B.PERIOD_ID

  • Related Language Record for RSP_TFP_END_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PERIOD_TYPE Character(1) VARCHAR2(1) NOT NULL Frequency
    A=Annual
    B=Bi-Weekly
    D=Daily
    M=Monthly
    Q=Quarterly
    S=Semi-Annual
    W=Weekly
    2 END_TF_PERIOD Character(32) VARCHAR2(32) NOT NULL End Time Frame
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 TIMEFRAME_DESCR Character(30) VARCHAR2(30) NOT NULL Field used in identifying start and end time frames
    5 TIMEFRAME_ID Character(15) VARCHAR2(15) NOT NULL Time Frame
    6 PERIOD_ID Character(15) VARCHAR2(15) NOT NULL Period