AUC_ANLIMP_SRCH

(SQL View)
 Index Back

Analyze Search

Analyze Import Search record

SELECT A.business_unit , A.auc_id , A.auc_round , a.auc_version , A.auc_format , A.auc_type , A.blind_flg , A.auc_name , A.auc_status , A.auc_dttm_finish FROM PS_AUC_HDR A WHERE (A.blind_flg <> 'Y' OR A.auc_dttm_finish <= %CurrentDateTimeIn) AND (A.auc_status = 'P' OR A.auc_status = 'A' OR A.auc_status = 'T' OR A.auc_status = 'U' OR A.auc_status = 'X' OR a.auc_status = 'N' OR A.auc_status = 'I' OR a.auc_status = 'D' OR A.auc_status = 'Q') AND A.auc_format <> 'E' AND NOT EXISTS ( SELECT 'X' FROM PS_AUC_AWARD_HDR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.AUC_ID = B.AUC_ID AND A.AUC_ROUND = B.AUC_ROUND AND A.AUC_VERSION = B.AUC_VERSION AND B.AUC_AWARD_LOCK_FLG = 'Y')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_AUC_BU_NONVW

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 BLIND_FLG Character(1) VARCHAR2(1) NOT NULL Sealed Event
8 AUC_NAME Character(50) VARCHAR2(50) NOT NULL Event Name
9 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

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