AUC_ERN_USER_VW

(SQL View)
 Index Back

Event Reminder Notification

Event Reminder Notification View

SELECT DISTINCT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.BIDDER_SETID , A.BIDDER_ID , A.BIDDER_TYPE , A.BIDDER_LOC , A.BIDNUM , A.BID_INV_RESPONSE , A.SEQ_NBR , A.AUC_EVNT_END_DAYS , A.AUC_END_DATE , E.AUC_AUDIENCE , A.AUC_MSG_PRIORITY , %Substring(%DateTimeOut(A.AUC_DTTM_START), 1, 10) , %Substring(%DateTimeOut(A.AUC_DTTM_START), 12, 8) %Concat ' AM' , %Substring(%DateTimeOut(A.AUC_DTTM_FINISH), 1, 10) , %Substring(%DateTimeOut(A.AUC_DTTM_FINISH) ,12 ,8) %Concat ' AM' , A.AUC_DTTM_START , A.AUC_DTTM_FINISH , A.TIMEZONE , A.AUC_EVNT_REMIND_FL , A.AUC_EC_NOTIFY_DAYS , B.OPRID FROM PS_AUC_ERN_VW A , PSOPRALIAS B , PS_AUC_EVNT_ERN E WHERE ( A.BIDDER_ID = B.BIDDER_ID OR A.BIDDER_ID = B.VENDOR_ID ) AND A.BUSINESS_UNIT = E.BUSINESS_UNIT AND A.AUC_ID = E.AUC_ID AND A.AUC_ROUND = E.AUC_ROUND AND A.AUC_VERSION = E.AUC_VERSION AND A.SEQ_NBR = E.SEQ_NBR AND A.AUC_END_DATE = %CurrentDateIn AND CASE E.AUC_AUDIENCE WHEN 'A' THEN 'A' ELSE A.AUC_AUDIENCE END = E.AUC_AUDIENCE

# 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
3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
5 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
6 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
7 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
8 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
9 BIDNUM Signed Number(6,0) DECIMAL(5) NOT NULL Bid ID
10 BID_INV_RESPONSE Character(1) VARCHAR2(1) NOT NULL Invitation Accepted/Declined
A=Accepted
D=Declined
N=---
11 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
12 AUC_EVNT_END_DAYS Number(3,0) SMALLINT NOT NULL Day(s) Prior to Event End Date
13 AUC_END_DATE Date(10) DATE End Date
14 AUC_AUDIENCE Character(1) VARCHAR2(1) NOT NULL Audience
A=All
C=Accepted
I=In Progress
N=Not Started
15 AUC_MSG_PRIORITY Character(1) VARCHAR2(1) NOT NULL Message Priority
H=High
N=Normal
16 AUC_DATE1 Character(10) VARCHAR2(10) NOT NULL Date
17 AUC_TIME1 Character(15) VARCHAR2(15) NOT NULL Start Time
18 AUC_DATE2 Character(10) VARCHAR2(10) NOT NULL Date
19 AUC_TIME2 Character(15) VARCHAR2(15) NOT NULL Start Time
20 AUC_DTTM_START DateTime(26) TIMESTAMP Date Time Start
21 AUC_DTTM_FINISH DateTime(26) TIMESTAMP Date Time Finish
22 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
23 AUC_EVNT_REMIND_FL Character(1) VARCHAR2(1) NOT NULL Allow Event Reminder Notificat
24 AUC_EC_NOTIFY_DAYS Number(3,0) SMALLINT NOT NULL Notification to Event Creator
25 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).