CA_GMCONSRCH_VW

(SQL View)
 Index Back

Award Search View for Console

Award Search View for Console

SELECT DISTINCT AWD.BUSINESS_UNIT , AWD.CONTRACT_NUM , %Substring(AWD.TITLE56,1,30) , AWD.REF_AWD_NUMBER , DTL.PROJECT_ID , AWD.EMPLID , AWD.PROPOSAL_ID , AWD.AWARD_TYPE , AWD.AWARD_STATUS , AWD.CUST_ID FROM PS_GM_AWARD AWD , PS_CA_DETAIL_PROJ DTL WHERE AWD.CONTRACT_NUM = DTL.CONTRACT_NUM

# 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_CA.BUSINESS_UNIT

Prompt Table: SP_BU_CA_NONVW

2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Award ID
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 REF_AWD_NUMBER Character(25) VARCHAR2(25) NOT NULL Reference Award Number
5 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: SP_GM_PRJ_NONVW

6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: GM_ELIG_PI_VW

7 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID

Prompt Table: GM_PROP_ID_SRCH

8 AWARD_TYPE Character(3) VARCHAR2(3) NOT NULL Award Type
BOA=Basic Ordering Agreement
CLI=Clinical Trial
CON=Contract
CP=Cooperative Agreement
FDP=FDP
FIX=Fixed
GR=Grant
IPA=IPA
LIC=License
LN=Loan
MOU=MOU
MTA=MTA
NDA=NDA
OTH=Other
PA=Patent Agreement
PO=Purchase Order
SB=SubContract
TO=Task Order
9 AWARD_STATUS Character(3) VARCHAR2(3) NOT NULL Award Status
ACP=Accepted
CLS=Closed
HOL=Holding
NEG=Under Negotiation
PEN=Pending
PRE=Pre-Award
REF=Refused
TER=Terminated
TRA=Transfer
WTH=Withdrawn
10 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

Prompt Table: GM_CUSTOMER_VW