SP_RBFTR_ACT_VW

(SQL View)
 Index Back

Req Line Activity BidFactor Vw

Requisition Line Activity Bid Factor View

SELECT A.SETID , D.PROJ_ROLE , A.ACTIVITY_ID , A.BID_FACTOR_CD , B.BID_FACTOR_TYPE , B.DESCR , B.COMMENTS_2000 , B.UNIT_OF_MEASURE , B.MIN_QTY , B.MAX_QTY , B.MIN_DT , B.MAX_DT , B.IDEAL_TXT , B.IDEAL_YN , B.WEIGHTING , B.REQUIRED_FLAG , B.AUC_MULTI_SEL_FLG , A.PRICE_FLG , B.IDEAL_REQD , A.QTY_FLG FROM PS_SP_BDFTR_BY_ACT A , PS_BID_FACTOR_HDR B , PS_SPB_SRC_ACT D , PS_SET_CNTRL_GROUP SC , PS_SET_CNTRL_GROUP SV WHERE A.BID_FACTOR_CD = B.BID_FACTOR_CD AND A.ACTIVITY_ID = D.ACTIVITY_ID AND SC.SETCNTRLVALUE = A.SETID AND SC.REC_GROUP_ID = 'PC_18' AND SC.SETID = D.SETID AND SV.SETCNTRLVALUE = A.SETID AND SV.REC_GROUP_ID = 'AUC_01' AND SV.SETID = B.SETID AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX (C.EFFDT) FROM PS_BID_FACTOR_HDR C WHERE C.SETID = B.SETID AND C.BID_FACTOR_CD = B.BID_FACTOR_CD AND C.EFFDT <= %CurrentDateIn AND C.EFF_STATUS = 'A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

Prompt Table: SPB_PJROLE_D_VW

3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: SPB_SRC_ACT
Set Control Field: SETID

4 BID_FACTOR_CD Character(18) VARCHAR2(18) NOT NULL Bid Factor Code
5 BID_FACTOR_TYPE Character(1) VARCHAR2(1) NOT NULL Bid Factor Type for the Auction Services product. Will be used to describe units of measurements for the different BID_FACTOR_CD's.
A=Attachment
C=Monetary
D=Date
L=List
N=Numeric
S=Separator
T=Text
Y=Yes/No
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 COMMENTS_2000 Long Character CLOB Comment Text
8 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
9 MIN_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Minimum Quantity
10 MAX_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Maximum Quantity
11 MIN_DT Date(10) DATE Minimum Date
12 MAX_DT Date(10) DATE Max Date
13 IDEAL_TXT Character(254) VARCHAR2(254) NOT NULL Ideal Text
14 IDEAL_YN Character(1) VARCHAR2(1) NOT NULL Ideal Yes/No
15 WEIGHTING Signed Number(10,5) DECIMAL(8,5) NOT NULL Used for applying a weighting to totals. e.g. Limit Utilisation totals
16 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required Flag
N=No
Y=Yes

Y/N Table Edit

Default Value: Y

17 AUC_MULTI_SEL_FLG Character(1) VARCHAR2(1) NOT NULL Allow Multiple Selections

Y/N Table Edit

Default Value: N

18 PRICE_FLG Character(1) VARCHAR2(1) NOT NULL Price Flag
N=No
Y=Yes

Y/N Table Edit

Default Value: N

19 IDEAL_REQD Character(1) VARCHAR2(1) NOT NULL Mandatory Response

Y/N Table Edit

Default Value: N

20 QTY_FLG Character(1) VARCHAR2(1) NOT NULL Quantity Bid factor Flag

Y/N Table Edit

Default Value: N