RSP_TFP_STRT_VW

(SQL View)
 Index Back

All Timeframe Periods

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

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

  • Related Language Record: RSP_TFP_ST_L_VW

  • Parent record: RSF_TF_DEFN

    • # 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 START_TF_PERIOD Character(32) VARCHAR2(32) NOT NULL Start Time Frame
    3 START_DATE Date(10) DATE Start Date for Gen Standing PO
    4 END_DATE Date(10) DATE End date field to store an end date.
    5 TIMEFRAME_DESCR Character(30) VARCHAR2(30) NOT NULL Field used in identifying start and end time frames
    6 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive
    7 TIMEFRAME_ID Character(15) VARCHAR2(15) NOT NULL Time Frame
    8 PERIOD_ID Character(15) VARCHAR2(15) NOT NULL Period
    9 ROLLUP_SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number