GM_VERSION_VW(SQL View) |
Index Back |
---|---|
Proposal Version VWView of proposals in gm_proposal |
SELECT a.business_unit , a.proposal_id , a.version_id , a.title56 FROM PS_GM_PROPOSAL a |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT_PROP | Character(5) | VARCHAR2(5) NOT NULL | Proposal Business Unit |
2 | RELATED_PROPOSAL | Character(25) | VARCHAR2(25) NOT NULL | Related Proposal ID |
3 | VERSION_ID_TO | Character(7) | VARCHAR2(7) NOT NULL | Version ID To |
4 | TITLE56 | Character(56) | VARCHAR2(56) NOT NULL | TITLE56 |