CONTRACT_NUMPrompt Table: CA_CNTR_SRCH_VW
Default Value: GM_AWARD.BUSINESS_UNIT
Prompt Table: SP_BU_CA_NONVW
KEY_WORDPrompt Table: GM_KEYWORD_TBL
GM_AWD_KEYWORD(SQL Table) |
Index Back |
|---|---|
KeywordAllows the user to link key words to an award. |
| # | 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 | KEY_WORD |
Character(20) | VARCHAR2(20) NOT NULL |
Key Word
Prompt Table: GM_KEYWORD_TBL |