RSF_TFP_A_VW

(SQL View)
 Index Back

Active Timeframe Periods

A view of all Active 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 , A.SYNCID , A.SYNCDTTM FROM PS_RSF_TF_PERIOD A WHERE A.STATUS = 'A' AND 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
    10 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    11 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time