UPG_RBFTR_TAO (SQL Table)	Index Back
Upgrade Bid Factor Temp Table Requisition Line Bid Factor Temp Table for Upgrade - This Temp Table is based on the SPF_RBFTR_TAO

UPG_RBFTR_TAO

(SQL Table)

Upgrade Bid Factor Temp Table

Requisition Line Bid Factor Temp Table for Upgrade - This Temp Table is based on the SPF_RBFTR_TAO

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

3 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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	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
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