RSF_TF_DEFN_QVW

(SQL View)
 Index Back

Quota Timeframes


SELECT TIMEFRAME_ID , DESCR , PERIOD_TYPE , QUOTA_DETAIL , QUOTA_DETAIL_BY , ROLLUP_SEQNUM FROM PS_RSF_TF_DEFN WHERE QUOTA_DETAIL IN ('T','D')

  • Related Language Record: RSF_TF_DEFN_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TIMEFRAME_ID Character(15) VARCHAR2(15) NOT NULL Time Frame
    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