AUC_HDR_VW (SQL View)	Index Back
Event Header View View for Event Header

AUC_HDR_VW

(SQL View)

Event Header View

View for Event Header

SELECT A.BUSINESS_UNIT ,A.AUC_ID ,A.AUC_ROUND ,A.AUC_VERSION ,A.AUC_STATUS ,A.AUC_FORMAT ,A.AUC_TYPE ,A.AUC_NAME ,A.AUC_DTTM_START ,A.AUC_DTTM_FINISH ,A.ORIGIN ,A.OPRID_ENTERED_BY ,A.CURRENCY_CD ,A.RT_TYPE ,A.DESCRLONG FROM PS_AUC_HDR A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_PM_NONVW

2 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID

3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round

4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version

5 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

6 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
F=Sell
I=RFI
R=Buy
S=Service

7 AUC_TYPE Character(1) VARCHAR2(1) NOT NULL Event Type
E=Auction
S=RFx

8 AUC_NAME Character(50) VARCHAR2(50) NOT NULL Event Name

9 AUC_DTTM_START DateTime(26) TIMESTAMP Date Time Start

10 AUC_DTTM_FINISH DateTime(26) TIMESTAMP Date Time Finish

11 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

12 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes

13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: BUS_UNIT_TBL_A1.CURRENCY_CD
Prompt Table: CURRENCY_CD_TBL

14 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

15 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PM_NONVW
2	AUC_ID	Character(10)	VARCHAR2(10) NOT NULL	Event ID
3	AUC_ROUND	Number(5,0)	INTEGER NOT NULL	Event Round
4	AUC_VERSION	Number(5,0)	INTEGER NOT NULL	Event Version
5	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
6	AUC_FORMAT	Character(1)	VARCHAR2(1) NOT NULL	Event Format F=Sell I=RFI R=Buy S=Service
7	AUC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Event Type E=Auction S=RFx
8	AUC_NAME	Character(50)	VARCHAR2(50) NOT NULL	Event Name
9	AUC_DTTM_START	DateTime(26)	TIMESTAMP	Date Time Start
10	AUC_DTTM_FINISH	DateTime(26)	TIMESTAMP	Date Time Finish
11	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin
12	OPRID_ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
13	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BUS_UNIT_TBL_A1.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
14	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
15	DESCRLONG	Long Character	CLOB	Long Description