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 | Character(5) | VARCHAR2(5) NOT NULL | Proposal Business Unit | |
2 | Character(25) | VARCHAR2(25) NOT NULL | Related Proposal ID | |
3 | Character(7) | VARCHAR2(7) NOT NULL | Version ID To | |
4 | TITLE56 | Character(56) | VARCHAR2(56) NOT NULL | TITLE56 |