| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
SP_REQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Service Request ID
|
| 3 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 4 |
BID_FACTOR_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
Bid Factor Number
|
| 5 |
BID_FACTOR_CD |
Character(18) |
VARCHAR2(18) NOT NULL |
Bid Factor Code
Prompt Table:
SPF_BDFTR_PT_VW
|
| 6 |
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
|
| 7 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 8 |
COMMENTS_2000 |
Long Character |
CLOB NOT NULL |
Comment Text
|
| 9 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table:
UNITS_TBL
|
| 10 |
MIN_QTY |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Minimum Quantity
|
| 11 |
MAX_QTY |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Maximum Quantity
|
| 12 |
MIN_DT |
Date(10) |
DATE |
Minimum Date
|
| 13 |
MAX_DT |
Date(10) |
DATE |
Max Date
|
| 14 |
IDEAL_TXT |
Character(254) |
VARCHAR2(254) NOT NULL |
Ideal Text
|
| 15 |
IDEAL_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
Ideal Yes/No
|
| 16 |
WEIGHTING |
Signed Number(10,5) |
DECIMAL(8,5) NOT NULL |
Used for applying a weighting to totals.
e.g. Limit Utilisation totals
|
| 17 |
AUC_BF_DISPLAY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Bid factor
Y/N Table Edit
Default Value: Y
|
| 18 |
SP_BIDFCTR_R_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Bid Factor Required Flag
Y/N Table Edit
Default Value: N
|
| 19 |
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
|
| 20 |
REQUIRED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Required Flag
N=No
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 21 |
SP_BF_ORIGIN_FLG |
Character(3) |
VARCHAR2(3) NOT NULL |
Bid Factor Origin flag
ACT=BF by Activity
CAT=BF By Category
SER=BF by Service
STD=Standard Predefined
Default Value: STD
|
| 22 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
SPB_SRC_ACT
Set Control Field: SETID
|
| 23 |
PROJ_ROLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Role
Prompt Table:
SPB_PJROLE_D_VW
|
| 24 |
CATEGORY_CD |
Character(18) |
VARCHAR2(18) NOT NULL |
Category Code
Prompt Table:
SPB_CATEG_CD_VW
Set Control Field: SETID
|
| 25 |
AUC_MULTI_SEL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Multiple Selections
Y/N Table Edit
Default Value: N
|
| 26 |
QTY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Quantity Bid factor Flag
|
| 27 |
PRICE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Price Flag
N=No
Y=Yes
|
| 28 |
CHNG_ORD_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Change Order Sequence Number
|