GM_AWD_TYPE_VW (SQL View)	Index Back
Award Type XLAT view. Award Type XLAT view.

GM_AWD_TYPE_VW

(SQL View)

Award Type XLAT view.

SELECT FIELDVALUE , XLATLONGNAME FROM PSXLATITEM WHERE fieldname = 'AWARD_TYPE'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

2 AWARD_TYPE_LONG Character(30) VARCHAR2(30) NOT NULL Award Type

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	AWARD_TYPE_LONG	Character(30)	VARCHAR2(30) NOT NULL	Award Type