RSF_PIPE_TF_VW

(SQL View)
 Index Back

Period

View on timeframes used in piepline.

SELECT TIMEFRAME_ID , PERIOD_ID , RSF_PERIOD_USE , PERIOD_TYPE , BEGIN_DT , END_DT , PERIOD_ROLLUP_ID , ROLLUP_SEQNUM , STATUS , DESCR , TIMEFRAME_PERIOD , %subrec(RB_AUDIT_SBR, A) FROM PS_RSF_TF_PERIOD A WHERE RSF_PERIOD_USE IN ('A', 'P', 'S')

  • Related Language Record: RSF_PIPE_TF_LNG

  • 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_ID Character(15) VARCHAR2(15) NOT NULL Period
    3 RSF_PERIOD_USE Character(1) VARCHAR2(1) NOT NULL Field used in identifying period usage
    A=All
    D=Planning & Portfolio
    P=Pipeline Only
    S=Forecast & Pipeline
    U=Survey

    Default Value: P

    4 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
    5 BEGIN_DT Date(10) DATE NOT NULL Begin Date
    6 END_DT Date(10) DATE NOT NULL This field stores the end date values.
    7 PERIOD_ROLLUP_ID Character(15) VARCHAR2(15) NOT NULL Quota Rollup Period

    Prompt Table: RSF_TF_RP_VW

    8 ROLLUP_SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    9 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 TIMEFRAME_PERIOD Character(32) VARCHAR2(32) NOT NULL Time Frame
    12 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    13 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    14 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    15 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    16 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.
    17 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time