GM_AWD_STAT_VW (SQL View)	Index Back
Award Status XLATview Awards Status Xlat View.

GM_AWD_STAT_VW

(SQL View)

Award Status XLATview

Awards Status Xlat View.

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

2 AWARD_STATUS_LONG Character(30) VARCHAR2(30) NOT NULL Award Status

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