RSF_TFP_VW

(SQL View)
 Index Back

All Timeframe Periods

A view of all Timeframe Periods

SELECT A.TIMEFRAME_PERIOD , A.PERIOD_TYPE , 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', 'S')

  • Related Language Record: RSF_TFP_LANG_VW

  • Parent record: RSF_TF_DEFN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TIMEFRAME_PERIOD Character(32) VARCHAR2(32) NOT NULL Time Frame
    2 PERIOD_TYPE Character(1) VARCHAR2(1) NOT NULL Quota Definition Period Type
    A=Annual
    B=Bi-Weekly
    D=Daily
    M=Monthly
    Q=Quarterly
    S=Semi-Annual
    W=Weekly
    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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    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