PSDMUNIT_IDPSDMT_RELDES_VW(SQL View) |
Index Back |
|---|
| SELECT PSDMUNIT_ID , DESCR50 , DESCRLONG FROM %Table(PSDMT_UNIT_HDR) A WHERE EXISTS( SELECT 'X' FROM %Table(PSDMT_UNITAM_VW) B WHERE B.PS_OWNER = A.PS_OWNER AND B.PSDMUNIT_ID = A.PSDMUNIT_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PSDMUNIT_ID |
Character(30) | VARCHAR2(30) NOT NULL | Transaction |
| 2 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 3 | DESCRLONG | Long Character | CLOB | Long Description |