RSF_PLQU_Q_VW

(SQL View)
 Index Back

Unit Quota - Quota Period

View underlying calculation for sales ser quotas.

SELECT '1' , M.PERSON_ID_MANAGER , Q.PERSON_ID , Q.TIMEFRAME_ID , Q.PERIOD_ID , SU.UNIT_QUOTA_TYPE , Q.PERIOD_ID , P.ROLLUP_SEQNUM , P.BEGIN_DT , P.END_DT , Q.UNIT_OF_MEASURE , Q.QUOTA_QTY , Q.SETID , Q.PRODUCT_ID FROM PS_RSF_ACC_MGR_VW M , PS_RSF_QUT T , PS_RSF_QUP Q , PS_RSF_PIPE_TF_VW P , PS_RSF_SUSER SU WHERE M.PERSON_ID = SU.PERSON_ID AND M.PERSON_ID = Q.PERSON_ID AND T.PERSON_ID = Q.PERSON_ID AND T.TIMEFRAME_ID = Q.TIMEFRAME_ID AND P.TIMEFRAME_ID = Q.TIMEFRAME_ID AND P.PERIOD_ID = Q.PERIOD_ID AND P.ROLLUP_SEQNUM = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PL_DATATYPE Character(1) VARCHAR2(1) NOT NULL Pipeline Data Type
1=Quota
2=Actual
3=Leak
2 PERSON_ID_MANAGER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
3 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

Prompt Table: RSF_SUSER

4 TIMEFRAME_ID Character(15) VARCHAR2(15) NOT NULL Time Frame

Prompt Table: RSF_TF_DEFN

5 PERIOD_ID Character(15) VARCHAR2(15) NOT NULL Period

Prompt Table: RSF_TF_PERIOD

6 REV_QUOTA_TYPE Character(1) VARCHAR2(1) NOT NULL Revenue Quota Type
M=Manager Quota
R=Rollup Quota
7 PERIOD_ROLLUP_ID Character(15) VARCHAR2(15) NOT NULL Quota Rollup Period
8 ROLLUP_SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
9 BEGIN_DT Date(10) DATE Begin Date
10 END_DT Date(10) DATE This field stores the end date values.
11 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
CS=Case
EA=Each
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
12 UNIT_COUNT Signed Number(21,4) DECIMAL(19,4) NOT NULL Unit Count
13 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
14 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID