CS_AUCCOPY_VW

(SQL View)
 Index Back

Contract Search for PO's


SELECT B.BUSINESS_UNIT , B.AUC_ID , H.BUYER_ID , A.CNTRCT_BEGIN_DT , A.CNTRCT_EXPIRE_DT , A.CS_DOC_ID , A.CS_DOC_OWNER , A.CS_DOC_STATUS , A.CS_DOCUMENT_TYPE , A.CS_SETID , A.CS_SPONSOR , A.DEPTID , A.DESCR60 , H.ORIGIN , H.AUC_STATUS , A.CS_TEMPLATE_ID , F.CS_FILE_FORMAT , F.CS_RELXD_CHKIN , F.SCM_ATTACH_ID , F.ATT_VERSION , H.AUC_RFX_EDIT_FLG FROM PS_CS_DOC_HDR A , PS_CS_DOC_AUC_KEYS B , PS_AUC_HDR H , PS_CS_DOC_FILES F WHERE A.CS_SOURCE_TRANS = '04' AND A.CS_DOC_BLD_STATUS = '1' AND B.CS_DOC_ID = A.CS_DOC_ID AND H.BUSINESS_UNIT = B.BUSINESS_UNIT AND H.AUC_ID = B.AUC_ID AND H.AUC_ROUND = B.AUC_ROUND AND H.AUC_VERSION = B.AUC_VERSION AND F.CS_DOC_ID = A.CS_DOC_ID AND F.CS_DOC_TYPE = '001'

# 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 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
4 CNTRCT_BEGIN_DT Date(10) DATE Contract Begin Date
5 CNTRCT_EXPIRE_DT Date(10) DATE Expire Date
6 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
7 CS_DOC_OWNER Character(30) VARCHAR2(30) NOT NULL Document Administrator
8 CS_DOC_STATUS Character(2) VARCHAR2(2) NOT NULL Document Status
AA=Approved
AD=Denied
AP=Pending Approval
CC=Collaborated
CP=Pending Collaboration
CR=Collaborated, Pending Review
DC=Complete
DR=Draft
DS=Dispatched
EC=Pending External Collaboration
EX=Executed
PI=Pending Internal Review
9 CS_DOCUMENT_TYPE Character(20) VARCHAR2(20) NOT NULL Document Type
001=Main Document
002=Amendment
003=Preview Document
004=Compare File
10 CS_SETID Character(5) VARCHAR2(5) NOT NULL setid for the document objects
11 CS_SPONSOR Character(30) VARCHAR2(30) NOT NULL Sponsor
12 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
13 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
14 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
15 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
16 CS_TEMPLATE_ID Character(20) VARCHAR2(20) NOT NULL SCC 09/01/04
17 CS_FILE_FORMAT Character(1) VARCHAR2(1) NOT NULL Created in 9.2 to indicate xml version - word xml vs. open
0=Imported or Signature Document
1=Word 2003 XML
2=Word Open XML
18 CS_RELXD_CHKIN Character(1) VARCHAR2(1) NOT NULL Relaxed CheckIn Used
19 SCM_ATTACH_ID Character(64) VARCHAR2(64) NOT NULL The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
20 ATT_VERSION Number(3,0) SMALLINT NOT NULL The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.
21 AUC_USE_BDR_RFX Character(1) VARCHAR2(1) NOT NULL Use Bidder RFx