| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 USERID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID
|
| 2 |
PAGE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Page Name
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_AUC_BU_NONVW
|
| 4 |
AUC_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Event ID
|
| 5 |
AUC_FORMAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Event Format
F=Sell
I=RFI
R=Buy
S=Service
|
| 6 |
AUC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Event Type
E=Auction
S=RFx
|
| 7 |
AUC_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Event Status
A=Awarded
C=Collaborating Event
D=Collaborating Bid Analysis
E=Evaluating
F=RFI Reviewed
I=Pending RFI Review
N=Not Awarded
O=Open
P=Posted
Q=Paused
R=Pending Scheduled Review
S=Pending Post Approval
T=Pending Award
U=Pending Award Approval
W=Post to Third Party Failed
X=Cancelled
Z=Inactive Version
|
| 8 |
AUC_FROM_START_DT |
Date(10) |
DATE |
From Start Date
|
| 9 |
AUC_TO_START_DT |
Date(10) |
DATE |
To Start Date
|
| 10 |
AUC_FROM_END_DT |
Date(10) |
DATE |
From End Date
|
| 11 |
AUC_TO_END_DT |
Date(10) |
DATE |
To End Date
|
| 12 |
AUC_SORT_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort By field used for Manage Events Page.
A=Event Format
B=Event ID
C=Event Type
D=Event Status
E=Business Unit
F=End Date
Default Value: F
|
| 13 |
SORT_ORDER |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Order
A=Ascending
D=Descending
Default Value: A
|
| 14 |
AUC_MY_EVENTS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Only show Events I created
Y/N Table Edit
|