GM_AWD_TERMS

(SQL Table)
Index Back

Terms and Conditions

Allows users to enter terms and conditions specific to an award. In addition, the user can associate key words to a term/condition.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

Prompt Table: CA_CNTR_SRCH_VW

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: GM_AWARD.BUSINESS_UNIT

Prompt Table: SP_BU_CA_NONVW

3 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
4 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
5 GUIDE_ID Character(5) VARCHAR2(5) NOT NULL Guideline ID

Prompt Table: GM_GUIDELN_DTL

6 REF_AWD_NUMBER Character(25) VARCHAR2(25) NOT NULL Reference Award Number
7 DESCR150_MIXED Character(150) VARCHAR2(150) NOT NULL Description