RSF_QUP_E_VW

(SQL View)
Index Back

Unit Quota-Existing

A view of all Unit Quota for existing periods

SELECT A.PERSON_ID , A.TIMEFRAME_ID , A.PERIOD_ID , A.SETID , A.PRODUCT_ID , A.UNIT_OF_MEASURE , A.QUOTA_QTY FROM PS_RSF_QUP A , PS_RSF_PIPE_TF_VW B , PS_RSF_TF_DEFN C WHERE B.TIMEFRAME_ID = A.TIMEFRAME_ID AND B.PERIOD_ID = A.PERIOD_ID AND B.STATUS = 'A' AND C.TIMEFRAME_ID = B.TIMEFRAME_ID AND C.PERIOD_TYPE = B.PERIOD_TYPE

# 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 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
5 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
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 QUOTA_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quota