RSF_QUP_RD_VW

(SQL View)
 Index Back

Rollup Detail Summary

A pipeline view supporting Rollup Detail Summary

SELECT P.PERSON_ID , T1.TIMEFRAME_ID , T1.PERIOD_ID , T1.BEGIN_DT , T1.END_DT , P.UNIT_OF_MEASURE , P.SETID , P.PRODUCT_ID , SUM(P.QUOTA_QTY) FROM PS_RSF_PIPE_TF_VW T1 , PS_RSF_PIPE_TF_VW T2 , PS_RSF_QUP P , PS_RSF_QUT T WHERE T1.TIMEFRAME_ID = T2.TIMEFRAME_ID AND T1.PERIOD_ID = T2.PERIOD_ROLLUP_ID AND P.TIMEFRAME_ID = T2.TIMEFRAME_ID AND P.PERIOD_ID = T2.PERIOD_ID AND P.TIMEFRAME_ID = T.TIMEFRAME_ID AND P.PERSON_ID = T.PERSON_ID GROUP BY P.PERSON_ID , T1.TIMEFRAME_ID , T1.PERIOD_ID , T1.BEGIN_DT , T1.END_DT , P.UNIT_OF_MEASURE , P.SETID , P.PRODUCT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

Prompt Table: RSF_SUSER

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

Prompt Table: RSF_TF_DEFN

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

Prompt Table: RSF_TF_PERIOD

4 BEGIN_DT Date(10) DATE Begin Date
5 END_DT Date(10) DATE This field stores the end date values.
6 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
7 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
8 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
9 TOTAL_QUOTA_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quota