| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
AUC_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Event ID
Default Value: NEXT
|
| 3 |
AUC_ROUND |
Number(5,0) |
INTEGER NOT NULL |
Event Round
Default Value: 1
|
| 4 |
AUC_VERSION |
Number(5,0) |
INTEGER NOT NULL |
Event Version
Default Value: 1
|
| 5 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
Default Value: 1
|
| 6 |
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
Default Value: O
|
| 7 |
AUC_DTTM_FINISH |
DateTime(26) |
TIMESTAMP |
Date Time Finish
|
| 8 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 9 |
REASON_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Reason Type
|
| 10 |
REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Reason Code
Prompt Table:
%EDITTABLE
|
| 11 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 12 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 13 |
EMAIL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
When the email flag is checked, the user will notified a specific user regarding an activity.
N=No
Y=Yes
|
| 14 |
ACTION_DTTM |
DateTime(26) |
TIMESTAMP |
Override Date Time
|