RSF_TF_DEFN

(SQL Table)
Index Back

Timeframe

View which supports the use of timeframes within pipeline.

  • Related Language Record: RSF_TF_DEFN_LNG
  • Parent Record Of RPM_TIMEFRAME_V RSFD_TIMEPRD_VW RSF_PIPE_TF_VW RSF_TFP_A_VW RSF_TFP_LANG_VW RSF_TFP_VW RSF_TF_PD_VW RSF_TF_PERD_LNG RSF_TF_PERIOD RSF_TF_ROLLUP RSF_TF_ROLL_VW RSF_TF_RPL_VW RSF_TF_RP_VW RSP_TFP_END_VW RSP_TFP_LANG_VW RSP_TFP_STRT_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TIMEFRAME_ID Character(15) VARCHAR2(15) NOT NULL Time Frame Group
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 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
    4 QUOTA_DETAIL Character(1) VARCHAR2(1) NOT NULL Quota Level
    D=Define Detailed Quotas
    N=No Quotas for this Time Frame
    T=Define Quotas By Time Frame

    Default Value: N

    5 QUOTA_DETAIL_BY Character(4) VARCHAR2(4) NOT NULL Define Detail Revenue Quota By
    IND=Industry
    PGRP=Product Group
    PRD=Product
    REGN=Region
    REVT=Revenue Type
    TERR=Territory
    UNIT=Business Unit
    6 ROLLUP_SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    7 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    8 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    9 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    10 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    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