RSF_PLPU_RL2_VW

(SQL View)
Index Back

Prod Units:Rollup 2 - Leaks

View underlying pipeline calculations for salesuser leaks.

SELECT '3' , M.PERSON_ID_MANAGER , M.PERSON_ID , R2.TIMEFRAME_ID , R2.PERIOD_ROLLUP_ID , R1.PERIOD_ROLLUP_ID , R2.ROLLUP_SEQNUM , R2.BEGIN_DT , R2.END_DT , O.OPPORTUNITY_ID , O.OPPORTUNITY_STATUS , O.EST_CLOSE_DT , P.UNIT_OF_MEASURE , P.QTY , O.PROD_SETID , P.PRODUCT_ID FROM PS_RSF_OPP_PRODUCT P , PS_RSF_PIPE_TF_VW TP , PS_RSF_TF_ROLL_VW R1 , PS_RSF_TF_ROLL_VW R2 , PS_RSF_ACC_MGR_VW M , PS_RSF_OPPORTUNITY O WHERE O.EST_CLOSE_DT >= TP.BEGIN_DT AND O.EST_CLOSE_DT <= TP.END_DT AND O.OPPORTUNITY_ID = P.OPPORTUNITY_ID AND O.PERSON_ID = M.PERSON_ID AND O.OPPORTUNITY_STATUS = '1' AND R2.ROLLUP_SEQNUM = 2 AND TP.TIMEFRAME_ID = R1.TIMEFRAME_ID AND TP.PERIOD_ID = R1.PERIOD_ID AND R2.TIMEFRAME_ID = R1.TIMEFRAME_ID AND R2.PERIOD_ID = R1.PERIOD_ROLLUP_ID

# 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
4 TIMEFRAME_ID Character(15) VARCHAR2(15) NOT NULL Time Frame
5 PERIOD_ROLLUP_ID Character(15) VARCHAR2(15) NOT NULL Quota Rollup Period
6 PERIOD_ID Character(15) VARCHAR2(15) NOT NULL Period
7 ROLLUP_SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
8 BEGIN_DT Date(10) DATE Begin Date
9 END_DT Date(10) DATE This field stores the end date values.
10 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID
11 OPPORTUNITY_STATUS Character(1) VARCHAR2(1) NOT NULL Opportunity Status. The values are XLat Values
0=Open
1=Closed - Lost
2=Closed - Won
3=Inactive
12 EST_CLOSE_DT Date(10) DATE Estimated Close Date of an Opportunity
13 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
14 UNIT_COUNT Signed Number(21,4) DECIMAL(19,4) NOT NULL Unit Count
15 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
16 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID