RPM_TIMEFRAME_V

(SQL View)
 Index Back

Active Timeframe Periods

Record to store active timeframe periods.

SELECT A.TIMEFRAME_PERIOD , A.PERIOD_TYPE , A.BEGIN_DT , A.END_DT , A.DESCR , A.DESCRSHORT , 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', 'D')

  • Related Language Record: RPM_TIME_FR_LNG

  • 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 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive
    8 TIMEFRAME_ID Character(15) VARCHAR2(15) NOT NULL Time Frame
    9 PERIOD_ID Character(15) VARCHAR2(15) NOT NULL Period
    10 ROLLUP_SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    11 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.
    12 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time