RSF_QUP_N_VW

(SQL View)
 Index Back

Unit Quota-New

A view of all Unit Quota for new periods

SELECT A.PERSON_ID , B.TIMEFRAME_ID , B.PERIOD_ID , 0 FROM PS_RSF_SUSER A , PS_RSF_PIPE_TF_VW B , PS_RSF_TF_DEFN C WHERE B.STATUS = 'A' AND C.TIMEFRAME_ID = B.TIMEFRAME_ID AND C.PERIOD_TYPE = B.PERIOD_TYPE AND NOT EXISTS ( SELECT 'X' FROM PS_RSF_QUP D WHERE D.PERSON_ID = A.PERSON_ID AND D.TIMEFRAME_ID = B.TIMEFRAME_ID AND D.PERIOD_ID = B.PERIOD_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 QUOTA_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quota