RSF_PLQU_R3_VW(SQL View) |
Index Back |
|---|---|
Unit Quota - Rollup Lvl 3View underlying calculation for sales user quotas. |
| SELECT '1' , M.PERSON_ID_MANAGER , Q.PERSON_ID , Q.TIMEFRAME_ID , R2.PERIOD_ROLLUP_ID , SU.UNIT_QUOTA_TYPE , R3.PERIOD_ROLLUP_ID , R3.ROLLUP_SEQNUM , R3.BEGIN_DT , R3.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_TF_ROLL_VW R1 , PS_RSF_TF_ROLL_VW R2 , PS_RSF_TF_ROLL_VW R3 , PS_RSF_SUSER SU WHERE M.PERSON_ID = SU.PERSON_ID AND M.PERSON_ID = Q.PERSON_ID AND T.TIMEFRAME_ID = Q.TIMEFRAME_ID AND T.PERSON_ID = Q.PERSON_ID AND P.TIMEFRAME_ID = Q.TIMEFRAME_ID AND P.PERIOD_ID = Q.PERIOD_ID AND P.TIMEFRAME_ID = R1.TIMEFRAME_ID AND P.PERIOD_ID = R1.PERIOD_ID AND R2.TIMEFRAME_ID = R1.TIMEFRAME_ID AND R2.PERIOD_ID = R1.PERIOD_ROLLUP_ID AND R3.TIMEFRAME_ID = R2.TIMEFRAME_ID AND R3.PERIOD_ID = R2.PERIOD_ROLLUP_ID AND R3.ROLLUP_SEQNUM = 3 |
| # | 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 |