RSF_TF_RP_VW

(SQL View)
 Index Back

Timeframe Rollup Period

View which supports the rollup of quotas among varied periods.

SELECT P.TIMEFRAME_ID , P.PERIOD_ID , P.BEGIN_DT , P.END_DT , P.STATUS , P.DESCR FROM PS_RSF_PIPE_TF_VW P , PS_RSF_TF_DEFN T WHERE T.TIMEFRAME_ID = P.TIMEFRAME_ID AND T.PERIOD_TYPE <> P.PERIOD_TYPE AND T.PERIOD_TYPE <> ' '

  • Related Language Record: RSF_TF_RPL_VW

  • Parent record: RSF_TF_DEFN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TIMEFRAME_ID Character(15) VARCHAR2(15) NOT NULL Time Frame
    2 PERIOD_ROLLUP_ID Character(15) VARCHAR2(15) NOT NULL Quota Rollup Period
    3 BEGIN_DT Date(10) DATE NOT NULL Begin Date
    4 END_DT Date(10) DATE NOT NULL This field stores the end date values.
    5 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description