AUC_HDR_EB_VW

(SQL View)

SELECT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.AUC_FORMAT , A.AUC_TYPE , A.AUC_NAME , A.AUC_STATUS , A.DESCRLONG , A.TIMEZONE , A.AUC_DTTM_PREVIEW , A.AUC_DTTM_START , A.AUC_DTTM_FINISH , A.PYMNT_TERMS_CD , A.CURRENCY_CD , A.ORIGIN , A.TAX_EXEMPT , A.TAX_EXEMPT_ID , A.BILL_LOCATION , A.PAYMENT_METHOD , A.REQUESTOR_ID , A.BUYER_ID , A.AUC_EXTENSION_FLAG , A.AUC_EXTENSION_LAST , A.AUC_EXTENSION_TYPE , A.AUC_EXTENSION_QTY , A.AUC_EXTENSION_LEN , A.EXTENSION_LEN_TYPE , A.AUC_EXTENDED_DTTM , A.AUC_EXTENDED_QTY , A.AUC_ORIGINAL_ENDDT , A.BLIND_FLG , A.AUC_ALL_LINES_FLG , A.MULTIPLE_BIDS_FLG , A.OPRID_ENTERED_BY , A.OPRID_MODIFIED_BY , A.AUC_TMPLTE_FLG , A.AUC_TMPLTE_ID , A.AUC_TMPLTE_DESCR , A.RATE_DATE , A.RT_TYPE , A.NAME1 , A.PHONE , A.EMAILID , A.AUC_MULTI_CUR_FLG , A.AUC_DISP_WEIGHTING , A.AUC_START_PRC_RL , A.AUC_PRELIM_BID , A.AUC_EDIT_RESP , A.AUC_SCORE_RFI , A.CATEGORY_ID , A.BID_CNTR_BINDING , A.AUC_COLLAB_STATUS , A.AUC_COLLAB_SEQNUM , A.AUC_COLLAB_DUEDT , A.AUC_COLLAB_OPRID , A.AUC_COLLAB_CKOUT , A.AUC_AWD_COL_STATUS , A.AUC_AWD_COL_DUEDT , A.AUC_AWD_COL_SHWBID , A.AUC_DISP_SCORE_DEF , A.WEIGHTING , A.AUC_SCORE_FCTR , A.AUC_SD_ID FROM PS_AUC_HDR A WHERE A.AUC_ROUND = ( SELECT MAX(AUC_ROUND) FROM PS_AUC_HDR WHERE BUSINESS_UNIT = A.BUSINESS_UNIT AND AUC_ID = A.AUC_ID) AND A.AUC_VERSION = %Coalesce(( SELECT MAX(AUC_VERSION) FROM PS_AUC_HDR WHERE BUSINESS_UNIT = A.BUSINESS_UNIT AND AUC_ID = A.AUC_ID AND AUC_ROUND = A.AUC_ROUND AND AUC_STATUS <> 'Z' AND AUC_STATUS <> 'X') , ( SELECT MAX(AUC_VERSION) FROM PS_AUC_HDR WHERE BUSINESS_UNIT = A.BUSINESS_UNIT AND AUC_ID = A.AUC_ID AND AUC_ROUND = A.AUC_ROUND)) AND A.BUSINESS_UNIT <> ' ' AND A.AUC_FORMAT <> 'S' AND A.AUC_STATUS <> 'E' AND A.AUC_TMPLTE_FLG <> 'Y'

# 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 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_NAME Character(50) VARCHAR2(50) NOT NULL Event Name

8 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

9 DESCRLONG Long Character CLOB Long Description

10 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
Prompt Table: PSTIMEZONE

11 AUC_DTTM_PREVIEW DateTime(26) TIMESTAMP Date Time Preview

12 AUC_DTTM_START DateTime(26) TIMESTAMP NOT NULL Date Time Start

13 AUC_DTTM_FINISH DateTime(26) TIMESTAMP NOT NULL Date Time Finish

14 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
Prompt Table: PYMT_TR_EFF_VW

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

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

17 TAX_EXEMPT Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag
Y/N Table Edit
Default Value: BUS_UNIT_TBL_A1.TAX_EXEMPT

18 TAX_EXEMPT_ID Character(30) VARCHAR2(30) NOT NULL Tax Exempt ID
Default Value: BUS_UNIT_TBL_A1.TAX_EXEMPT_ID

19 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location
Default Value: BUS_UNIT_TBL_A1.BILL_LOCATION
Prompt Table: LOCATION_TBL

20 PAYMENT_METHOD Character(3) VARCHAR2(3) NOT NULL Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH
CC=Credit Card
CHK=Check
CSH=Cash
DD=Direct Debit
DR=Draft
EC=Electronic Check
EFT=Electronic Fund Transfer
GE=Giro - EFT
PL=PayPal
WIR=Wire Report

21 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
Prompt Table: RQSTR_ACTIVE_VW

22 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
Prompt Table: BUYER_ACTIVE_VW

23 AUC_EXTENSION_FLAG Character(1) VARCHAR2(1) NOT NULL Allow Extension
Y/N Table Edit
Default Value: N

24 AUC_EXTENSION_LAST Number(10,0) DECIMAL(10) NOT NULL Last Bid

25 AUC_EXTENSION_TYPE Character(1) VARCHAR2(1) NOT NULL Extension Type
D=Days
H=Hours
M=Minutes

26 AUC_EXTENSION_QTY Number(10,0) DECIMAL(10) NOT NULL Number of extensions

27 AUC_EXTENSION_LEN Number(10,0) DECIMAL(10) NOT NULL Length of Extension

28 EXTENSION_LEN_TYPE Character(1) VARCHAR2(1) NOT NULL Extension Length Type
D=Days
H=Hours
M=Minutes

29 AUC_EXTENDED_DTTM DateTime(26) TIMESTAMP Date Time extension

30 AUC_EXTENDED_QTY Number(3,0) SMALLINT NOT NULL Number of Times Extended

31 AUC_ORIGINAL_ENDDT DateTime(26) TIMESTAMP Original End Date

32 BLIND_FLG Character(1) VARCHAR2(1) NOT NULL Sealed Event
Y/N Table Edit
Default Value: N

33 AUC_ALL_LINES_FLG Character(1) VARCHAR2(1) NOT NULL Bid Required on all lines
Y/N Table Edit
Default Value: N

34 MULTIPLE_BIDS_FLG Character(1) VARCHAR2(1) NOT NULL Multiple Bids Allowed
N=Not Allowed
Y=Allowed
Y/N Table Edit
Default Value: Y

35 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

36 OPRID_MODIFIED_BY Character(30) VARCHAR2(30) NOT NULL Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.

37 AUC_TMPLTE_FLG Character(1) VARCHAR2(1) NOT NULL Auction Template
Y/N Table Edit
Default Value: N

38 AUC_TMPLTE_ID Character(10) VARCHAR2(10) NOT NULL Template ID

39 AUC_TMPLTE_DESCR Character(25) VARCHAR2(25) NOT NULL Template Description

40 RATE_DATE Date(10) DATE Exchange Rate Date

41 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.
Default Value: BUS_UNIT_TBL_A1.RT_TYPE
Prompt Table: RT_TYPE_TBL

42 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

43 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone

44 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address

45 AUC_MULTI_CUR_FLG Character(1) VARCHAR2(1) NOT NULL Allow MultiCurrency Events
N=No
Y=Yes
Default Value: N

46 AUC_DISP_WEIGHTING Character(1) VARCHAR2(1) NOT NULL Display Weights
Y/N Table Edit
Default Value: Y

47 AUC_START_PRC_RL Character(1) VARCHAR2(1) NOT NULL Start Price
D=Display - Not Required to Beat
N=Do Not Display
Y=Display and Also Must Beat

48 AUC_PRELIM_BID Character(1) VARCHAR2(1) NOT NULL Allow Preliminary Bids
Y/N Table Edit
Default Value: N

49 AUC_EDIT_RESP Character(1) VARCHAR2(1) NOT NULL Edit Posted Response
Y/N Table Edit
Default Value: N

50 AUC_SCORE_RFI Character(1) VARCHAR2(1) NOT NULL Score RFI Event
Y/N Table Edit
Default Value: N

51 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID

52 BID_CNTR_BINDING Character(1) VARCHAR2(1) NOT NULL Counter Offer Binding
Y/N Table Edit
Default Value: N

53 AUC_COLLAB_STATUS Character(1) VARCHAR2(1) NOT NULL Collaboration Status
A=Available
C=Checked Out
N=No Collaboration
X=Collaboration Cancelled
Default Value: N

54 AUC_COLLAB_SEQNUM Number(3,0) SMALLINT NOT NULL Collaboration Sequence number
Default Value: 0

55 AUC_COLLAB_DUEDT DateTime(26) TIMESTAMP Collaboration Due Date

56 AUC_COLLAB_OPRID Character(30) VARCHAR2(30) NOT NULL Collaborator OPRID

57 AUC_COLLAB_CKOUT DateTime(26) TIMESTAMP Check out date

58 AUC_AWD_COL_STATUS Character(1) VARCHAR2(1) NOT NULL Collaboration Status
A=Available
C=Completed
N=No Collaboration
O=Checked Out
Default Value: N

59 AUC_AWD_COL_DUEDT DateTime(26) TIMESTAMP Collaboration Due Date

60 AUC_AWD_COL_SHWBID Character(1) VARCHAR2(1) NOT NULL Award Collaboration Show Bid
Y/N Table Edit
Default Value: N

61 AUC_DISP_SCORE_DEF Character(1) VARCHAR2(1) NOT NULL Display Scoring Algorithm
Y/N Table Edit

62 WEIGHTING Signed Number(10,5) DECIMAL(8,5) NOT NULL Used for applying a weighting to totals. e.g. Limit Utilisation totals

63 AUC_SCORE_FCTR Character(1) VARCHAR2(1) NOT NULL Score Factor
B=Line Score and Total Score
L=Line Score
T=Total Score

64 AUC_SD_ID Number(5,0) INTEGER NOT NULL Source Definition ID

#	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	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_NAME	Character(50)	VARCHAR2(50) NOT NULL	Event Name
8	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
9	DESCRLONG	Long Character	CLOB	Long Description
10	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone Prompt Table: PSTIMEZONE
11	AUC_DTTM_PREVIEW	DateTime(26)	TIMESTAMP	Date Time Preview
12	AUC_DTTM_START	DateTime(26)	TIMESTAMP NOT NULL	Date Time Start
13	AUC_DTTM_FINISH	DateTime(26)	TIMESTAMP NOT NULL	Date Time Finish
14	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers. Prompt Table: PYMT_TR_EFF_VW
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BUS_UNIT_TBL_A1.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
16	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin
17	TAX_EXEMPT	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag Y/N Table Edit Default Value: BUS_UNIT_TBL_A1.TAX_EXEMPT
18	TAX_EXEMPT_ID	Character(30)	VARCHAR2(30) NOT NULL	Tax Exempt ID Default Value: BUS_UNIT_TBL_A1.TAX_EXEMPT_ID
19	BILL_LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Billing Location Default Value: BUS_UNIT_TBL_A1.BILL_LOCATION Prompt Table: LOCATION_TBL
20	PAYMENT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats. ACH=ACH CC=Credit Card CHK=Check CSH=Cash DD=Direct Debit DR=Draft EC=Electronic Check EFT=Electronic Fund Transfer GE=Giro - EFT PL=PayPal WIR=Wire Report
21	REQUESTOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Requestor id Prompt Table: RQSTR_ACTIVE_VW
22	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer Prompt Table: BUYER_ACTIVE_VW
23	AUC_EXTENSION_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Allow Extension Y/N Table Edit Default Value: N
24	AUC_EXTENSION_LAST	Number(10,0)	DECIMAL(10) NOT NULL	Last Bid
25	AUC_EXTENSION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Extension Type D=Days H=Hours M=Minutes
26	AUC_EXTENSION_QTY	Number(10,0)	DECIMAL(10) NOT NULL	Number of extensions
27	AUC_EXTENSION_LEN	Number(10,0)	DECIMAL(10) NOT NULL	Length of Extension
28	EXTENSION_LEN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Extension Length Type D=Days H=Hours M=Minutes
29	AUC_EXTENDED_DTTM	DateTime(26)	TIMESTAMP	Date Time extension
30	AUC_EXTENDED_QTY	Number(3,0)	SMALLINT NOT NULL	Number of Times Extended
31	AUC_ORIGINAL_ENDDT	DateTime(26)	TIMESTAMP	Original End Date
32	BLIND_FLG	Character(1)	VARCHAR2(1) NOT NULL	Sealed Event Y/N Table Edit Default Value: N
33	AUC_ALL_LINES_FLG	Character(1)	VARCHAR2(1) NOT NULL	Bid Required on all lines Y/N Table Edit Default Value: N
34	MULTIPLE_BIDS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Multiple Bids Allowed N=Not Allowed Y=Allowed Y/N Table Edit Default Value: Y
35	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
36	OPRID_MODIFIED_BY	Character(30)	VARCHAR2(30) NOT NULL	Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
37	AUC_TMPLTE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Auction Template Y/N Table Edit Default Value: N
38	AUC_TMPLTE_ID	Character(10)	VARCHAR2(10) NOT NULL	Template ID
39	AUC_TMPLTE_DESCR	Character(25)	VARCHAR2(25) NOT NULL	Template Description
40	RATE_DATE	Date(10)	DATE	Exchange Rate Date
41	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. Default Value: BUS_UNIT_TBL_A1.RT_TYPE Prompt Table: RT_TYPE_TBL
42	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
43	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
44	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
45	AUC_MULTI_CUR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Allow MultiCurrency Events N=No Y=Yes Default Value: N
46	AUC_DISP_WEIGHTING	Character(1)	VARCHAR2(1) NOT NULL	Display Weights Y/N Table Edit Default Value: Y
47	AUC_START_PRC_RL	Character(1)	VARCHAR2(1) NOT NULL	Start Price D=Display - Not Required to Beat N=Do Not Display Y=Display and Also Must Beat
48	AUC_PRELIM_BID	Character(1)	VARCHAR2(1) NOT NULL	Allow Preliminary Bids Y/N Table Edit Default Value: N
49	AUC_EDIT_RESP	Character(1)	VARCHAR2(1) NOT NULL	Edit Posted Response Y/N Table Edit Default Value: N
50	AUC_SCORE_RFI	Character(1)	VARCHAR2(1) NOT NULL	Score RFI Event Y/N Table Edit Default Value: N
51	CATEGORY_ID	Character(5)	VARCHAR2(5) NOT NULL	Category ID
52	BID_CNTR_BINDING	Character(1)	VARCHAR2(1) NOT NULL	Counter Offer Binding Y/N Table Edit Default Value: N
53	AUC_COLLAB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Collaboration Status A=Available C=Checked Out N=No Collaboration X=Collaboration Cancelled Default Value: N
54	AUC_COLLAB_SEQNUM	Number(3,0)	SMALLINT NOT NULL	Collaboration Sequence number Default Value: 0
55	AUC_COLLAB_DUEDT	DateTime(26)	TIMESTAMP	Collaboration Due Date
56	AUC_COLLAB_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Collaborator OPRID
57	AUC_COLLAB_CKOUT	DateTime(26)	TIMESTAMP	Check out date
58	AUC_AWD_COL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Collaboration Status A=Available C=Completed N=No Collaboration O=Checked Out Default Value: N
59	AUC_AWD_COL_DUEDT	DateTime(26)	TIMESTAMP	Collaboration Due Date
60	AUC_AWD_COL_SHWBID	Character(1)	VARCHAR2(1) NOT NULL	Award Collaboration Show Bid Y/N Table Edit Default Value: N
61	AUC_DISP_SCORE_DEF	Character(1)	VARCHAR2(1) NOT NULL	Display Scoring Algorithm Y/N Table Edit
62	WEIGHTING	Signed Number(10,5)	DECIMAL(8,5) NOT NULL	Used for applying a weighting to totals. e.g. Limit Utilisation totals
63	AUC_SCORE_FCTR	Character(1)	VARCHAR2(1) NOT NULL	Score Factor B=Line Score and Total Score L=Line Score T=Total Score
64	AUC_SD_ID	Number(5,0)	INTEGER NOT NULL	Source Definition ID