SFTWR_TITLEIT_MAPSFTWR_VW(SQL View) |
Index Back |
|---|---|
IT Software mapped view |
| SELECT A.SFTWR_TITLE FROM PS_IT_SFTWR A WHERE EXISTS ( SELECT 'Y' FROM PS_IT_MAP_CD B WHERE B.IT_MAP_TYPE = '020' AND B.SETID = 'SFTWR' AND A.SFTWR_TITLE = B.IT_MAP_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SFTWR_TITLE |
Character(50) | VARCHAR2(50) NOT NULL | Software Title |