BUSINESS_UNITCONTRACT_NUMPrompt Table: PERSONAL_DATA
Default Value: GM_PROPOSAL.PROPOSAL_ID
Prompt Table: GM_PROP_ID_VW
Default Value: GM_PROPOSAL.TITLE56
GM_AWARD_VW2(SQL View) |
Index Back |
|---|---|
View of Award |
| SELECT a.business_unit , a.contract_num , a.emplid , a.name , a.proposal_id , a.title56 , a.descr254 FROM ps_gm_award a , PS_GM_PROPOSAL b WHERE a.business_unit = b.business_unit AND a.proposal_id = b.proposal_id AND a.version_id = b.version_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 5 | PROPOSAL_ID | Character(25) | VARCHAR2(25) NOT NULL |
Proposal ID
Default Value: GM_PROPOSAL.PROPOSAL_ID Prompt Table: GM_PROP_ID_VW |
| 6 | TITLE56 | Character(56) | VARCHAR2(56) NOT NULL |
TITLE56
Default Value: GM_PROPOSAL.TITLE56 |
| 7 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |