GM_PROP_PAGE_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.BUSINESS_UNIT , A.PROPOSAL_ID , A.VERSION_ID , A.SCHEMA_NAME , B.ATTRIBUTE_VALUE FROM PS_GM_PROP_SCHEMA A , PS_GM_SCHEMA_ATR B WHERE B.SCHEMA_NAME = A.SCHEMA_NAME AND B.ATTRIBUTE_NAME = 'DATA_SOURCE' AND B.SETID = ( SELECT C.SETID FROM PS_SET_CNTRL_REC C WHERE C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME='GM_SCHEMA_ATR') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROPOSAL_ID | Character(25) | VARCHAR2(25) NOT NULL | Proposal ID |
| 3 | VERSION_ID | Character(7) | VARCHAR2(7) NOT NULL | Version ID |
| 4 | SCHEMA_NAME | Character(65) | VARCHAR2(65) NOT NULL | Schema Name |
| 5 | ATTRIBUTE_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Attribute Value |