GM_PROP_ADD_VW(SQL View) |
Index Back |
|---|
| SELECT BUSINESS_UNIT ,PROPOSAL_ID ,VERSION_ID ,OPPORTUNITY_NUM ,COMPETITION_ID ,DESCR254 ,DATE_FROM ,DATE_TO ,CFDA ,FROM_FLAG ,GGOV_FLG FROM PS_GM_PROPOSAL |
| # | 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 | PROPOSAL_ID |
Character(25) | VARCHAR2(25) NOT NULL |
Proposal ID
Default Value: NEXT Prompt Table: GM_PROP_ID_VW |
| 3 | VERSION_ID |
Character(7) | VARCHAR2(7) NOT NULL |
Version ID
Prompt Table: GM_PROPOSAL |
| 4 | OPPORTUNITY_NUM |
Character(100) | VARCHAR2(100) NOT NULL | Opportunity Number |
| 5 | COMPETITION_ID |
Character(100) | VARCHAR2(100) NOT NULL | Competition ID |
| 6 | DESCR254 |
Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 7 | DATE_FROM |
Date(10) | DATE | Date From |
| 8 | DATE_TO |
Date(10) | DATE | Date To |
| 9 | CFDA |
Character(15) | VARCHAR2(15) NOT NULL |
CFDA
Prompt Table: GM_CFDA_TBL |
| 10 | FROM_FLAG |
Character(1) | VARCHAR2(1) NOT NULL | Create from Get Opportunity |
| 11 | GGOV_FLG | Character(1) | VARCHAR2(1) NOT NULL | GGOV_FLG |