SPF_RBFTR_R_VW

(SQL View)
 Index Back

Req Line Resource BidFactor Vw

Requisition Line Resource -based Bid Factor View

SELECT A.SETID , A.SP_ATTR , 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 , B.PRICE_FLG , B.IDEAL_REQD FROM PS_SPF_BDFTR_MAP A , PS_BID_FACTOR_HDR B WHERE B.EFFDT = ( SELECT MAX (C.EFFDT) FROM PS_BID_FACTOR_HDR C WHERE C.SETID = A.SETID AND C.BID_FACTOR_CD = A.BID_FACTOR_CD AND C.EFFDT <= %CurrentDateIn /* AND C.EFF_STATUS = 'A'*/) AND A.SETID = B.SETID AND A.BID_FACTOR_CD = B.BID_FACTOR_CD AND A.RESOURCE_FLG = 'Y' AND B.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 SP_ATTR Character(4) VARCHAR2(4) NOT NULL Services Procurement Attribute
AD01=Adhoc 1
AD02=Adhoc 2
AD03=Adhoc 3
AD04=Adhoc 4
AD05=Adhoc 5
AMNT=Amount
CMPT=Competency
CNDT=Candidate
EXPR=Experience
INTR=Inteview
NDDT=End Dt
RATE=Rate
RSTM=Res Time
STDT=Start Dt
TCMT=Tele Comut
TRVL=Travel
XPNS=Expenses
3 BID_FACTOR_CD Character(18) VARCHAR2(18) NOT NULL Bid Factor Code
4 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
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 COMMENTS_2000 Long Character CLOB Comment Text
7 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
8 MIN_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Minimum Quantity
9 MAX_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Maximum Quantity
10 MIN_DT Date(10) DATE Minimum Date
11 MAX_DT Date(10) DATE Max Date
12 IDEAL_TXT Character(254) VARCHAR2(254) NOT NULL Ideal Text
13 IDEAL_YN Character(1) VARCHAR2(1) NOT NULL Ideal Yes/No
14 WEIGHTING Signed Number(10,5) DECIMAL(8,5) NOT NULL Used for applying a weighting to totals. e.g. Limit Utilisation totals
15 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required Flag
N=No
Y=Yes

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N