AUC_ERN_EC_VW

(SQL View)
 Index Back

Event Reminder Notification

Event Reminder Notification 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_START , A.AUC_DTTM_FINISH , %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_EC_NOTIFY_DAYS , A.OPRID_ENTERED_BY , B.TIMEZONEDSTLBL FROM PS_AUC_HDR A , PSTIMEZONE B WHERE ( B.TIMEZONE = A.TIMEZONE AND ( A.AUC_EC_NOTIFY_DAYS <> 0 AND A.AUC_STATUS IN ('O', 'P', 'S') AND %DateAdd(%datepart(A.AUC_DTTM_FINISH), 0 - A.AUC_EC_NOTIFY_DAYS) = %CurrentDateIn))

# 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 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
9 DESCRLONG Long Character CLOB Long Description
10 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
11 AUC_DTTM_START DateTime(26) TIMESTAMP Date Time Start
12 AUC_DTTM_FINISH DateTime(26) TIMESTAMP Date Time Finish
13 AUC_DATE1 Character(10) VARCHAR2(10) NOT NULL Date
14 AUC_TIME1 Character(15) VARCHAR2(15) NOT NULL Start Time
15 AUC_DATE2 Character(10) VARCHAR2(10) NOT NULL Date
16 AUC_TIME2 Character(15) VARCHAR2(15) NOT NULL Start Time
17 AUC_EC_NOTIFY_DAYS Number(3,0) SMALLINT NOT NULL Notification to Event Creator
18 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
19 TIMEZONEDSTLBL Character(8) VARCHAR2(8) NOT NULL Time Zone Daylight Label