AUC_HDR_RPT_VW

(SQL View)
 Index Back

Report View for Event Header

Report View for Event Header that includes Department ID Specific to DB platforms due to usage of Outer Join.

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.AUC_TMPLTE_TYPE ,A.AUC_TMPLTE_STATUS ,A.RATE_DATE ,A.RT_TYPE ,A.NAME1 ,A.PHONE ,A.EMAILID ,A.AUC_MULTI_CUR_FLG ,A.AUC_DISP_WEIGHTING ,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_SD_ID ,A.AUC_CREATE_XML_FLG ,A.AUC_DISP_ALL_BIDS ,A.AUC_DISP_AWD_DET ,A.AUC_DISP_BID_SCORE ,A.AUC_DISP_TOT_BID ,A.AUC_DISP_BID_FCTR ,A.AUC_BID_SCORE_OPT ,A.AUC_PRC_ONLY_FLG ,A.AUC_ALLOW_IDENTITY ,A.AUC_DSP_BID_HIST ,A.AUC_DSP_WIN_SCORE ,A.LAST_UPDATE_DTTM ,A.AUC_PREV_LOT_ID ,A.AUC_BEAT_PRC_FLG ,A.AUC_PROXY_FLG ,A.AUC_EVENT_BASE ,A.AUC_START_PRC_RL ,A.AUC_RANK_OPTIONS ,A.AUC_BID_COMPETE ,A.AUC_DSP_RNDVER ,A.AUC_SCORE_FCTR ,A.AUC_COMP_BID ,A.AUC_ALLOW_GRP ,A.AUC_ALLOW_GRP_PBRK ,A.AUC_SAVE_DTTM ,A.AUC_POST_DTTM ,B.DEPTID FROM PS_AUC_HDR A , PS_OPR_DEF_TBL_SS B WHERE A.OPRID_ENTERED_BY = B.OPRID(+)

# 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: %EDIT_BUYER

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

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

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 AUC_TMPLTE_TYPE Character(1) VARCHAR2(1) NOT NULL Template Type
B=Business Unit
D=Department
P=Personal
41 AUC_TMPLTE_STATUS Character(1) VARCHAR2(1) NOT NULL Template Status
A=Active
I=Inactive

Default Value: A

42 RATE_DATE Date(10) DATE Exchange Rate Date
43 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

44 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
45 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
46 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
47 AUC_MULTI_CUR_FLG Character(1) VARCHAR2(1) NOT NULL Allow MultiCurrency Events
N=No
Y=Yes

Default Value: N

48 AUC_DISP_WEIGHTING Character(1) VARCHAR2(1) NOT NULL Display Weights

Y/N Table Edit

Default Value: Y

49 AUC_PRELIM_BID Character(1) VARCHAR2(1) NOT NULL Allow Preliminary Bids

Y/N Table Edit

Default Value: N

50 AUC_EDIT_RESP Character(1) VARCHAR2(1) NOT NULL Edit Posted Response

Y/N Table Edit

Default Value: N

51 AUC_SCORE_RFI Character(1) VARCHAR2(1) NOT NULL Score RFI Event

Y/N Table Edit

Default Value: N

52 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
53 BID_CNTR_BINDING Character(1) VARCHAR2(1) NOT NULL Counter Offer Binding

Y/N Table Edit

Default Value: N

54 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

55 AUC_COLLAB_SEQNUM Number(3,0) SMALLINT NOT NULL Collaboration Sequence number

Default Value: 0

56 AUC_COLLAB_DUEDT DateTime(26) TIMESTAMP Collaboration Due Date
57 AUC_COLLAB_OPRID Character(30) VARCHAR2(30) NOT NULL Collaborator OPRID
58 AUC_COLLAB_CKOUT DateTime(26) TIMESTAMP Check out date
59 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

60 AUC_AWD_COL_DUEDT DateTime(26) TIMESTAMP Collaboration Due Date
61 AUC_AWD_COL_SHWBID Character(1) VARCHAR2(1) NOT NULL Award Collaboration Show Bid

Y/N Table Edit

Default Value: N

62 AUC_DISP_SCORE_DEF Character(1) VARCHAR2(1) NOT NULL Display Scoring Algorithm

Y/N Table Edit

Default Value: N

63 WEIGHTING Signed Number(10,5) DECIMAL(8,5) NOT NULL Used for applying a weighting to totals. e.g. Limit Utilisation totals
64 AUC_SD_ID Number(5,0) INTEGER NOT NULL Source Definition ID
65 AUC_CREATE_XML_FLG Character(1) VARCHAR2(1) NOT NULL Event PDF File Flag

Y/N Table Edit

66 AUC_DISP_ALL_BIDS Character(1) VARCHAR2(1) NOT NULL Display all Bids

Y/N Table Edit

Default Value: N

67 AUC_DISP_AWD_DET Character(1) VARCHAR2(1) NOT NULL Show Award Details

Y/N Table Edit

Default Value: N

68 AUC_DISP_BID_SCORE Character(1) VARCHAR2(1) NOT NULL Display Bid Scores

Y/N Table Edit

Default Value: N

69 AUC_DISP_TOT_BID Character(1) VARCHAR2(1) NOT NULL Display Total

Y/N Table Edit

Default Value: N

70 AUC_DISP_BID_FCTR Character(1) VARCHAR2(1) NOT NULL Display Bid Factors

Y/N Table Edit

Default Value: N

71 AUC_BID_SCORE_OPT Character(1) VARCHAR2(1) NOT NULL Bid Score Optimization
B=Own Bid
W=Winning Bid

Default Value: B

72 AUC_PRC_ONLY_FLG Character(1) VARCHAR2(1) NOT NULL Price Only Flag

Y/N Table Edit

Default Value: N

73 AUC_ALLOW_IDENTITY Character(1) VARCHAR2(1) NOT NULL Allow Identity

Y/N Table Edit

Default Value: N

74 AUC_DSP_BID_HIST Character(1) VARCHAR2(1) NOT NULL Display Bid History

Y/N Table Edit

Default Value: Y

75 AUC_DSP_WIN_SCORE Character(1) VARCHAR2(1) NOT NULL Display Winning Score

Y/N Table Edit

Default Value: N

76 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
77 AUC_PREV_LOT_ID Character(10) VARCHAR2(10) NOT NULL Previous Lot ID

Prompt Table: AUC_NON_LOT_VW

78 AUC_BEAT_PRC_FLG Character(1) VARCHAR2(1) NOT NULL Bidder must beat Start Price

Y/N Table Edit

Default Value: Y

79 AUC_PROXY_FLG Character(1) VARCHAR2(1) NOT NULL Proxy Flag
N=Disabled
Y=Enabled

Default Value: N

80 AUC_EVENT_BASE Character(1) VARCHAR2(1) NOT NULL Event Base
P=Price Based
S=Score Based

Default Value: S

81 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

Default Value: Y

82 AUC_RANK_OPTIONS Character(3) VARCHAR2(3) NOT NULL Rank Options
BID=Display Rank\Total # of Bids
NON=Do Not Rank
RNK=Display Rank Only

Default Value: NON

83 AUC_BID_COMPETE Character(1) VARCHAR2(1) NOT NULL Bid Compete
L=Line Level
T=Event Level

Default Value: T

84 AUC_DSP_RNDVER Character(1) VARCHAR2(1) NOT NULL Display Round/Version
N=Do Not Display
R=Display Round
V=Display Round and Version

Default Value: V

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

Default Value: T

86 AUC_COMP_BID Character(1) VARCHAR2(1) NOT NULL Competitor Bids
X=Do Not Display
Y=Display and Show Identity
Z=Display but Hide Identity

Default Value: Z

87 AUC_ALLOW_GRP Character(1) VARCHAR2(1) NOT NULL Allow Groups

Y/N Table Edit

Default Value: N

88 AUC_ALLOW_GRP_PBRK Character(1) VARCHAR2(1) NOT NULL Allow Group Pricebreak

Y/N Table Edit

Default Value: N

89 AUC_SAVE_DTTM DateTime(26) TIMESTAMP Save DateTime
90 AUC_POST_DTTM DateTime(26) TIMESTAMP Post DateTime
91 DEPTID Character(10) VARCHAR2(10) NOT NULL Department