EP_SUB_ITEM_VW(SQL View) |
Index Back |
|---|---|
Sub-Item ViewEmpty view used as a work record for search purposes. |
| SELECT ' ' , ' ' , ' ' , ' ' FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(12) | VARCHAR2(12) NOT NULL | Item unique identifier | |
| 2 | Character(12) | VARCHAR2(12) NOT NULL | Sub-Item unique identifier | |
| 3 | EP_TITLE | Character(60) | VARCHAR2(60) NOT NULL | Title of an item |
| 4 | EP_DESCR254 | Long Character(1325) | VARCHAR2(1325) | 1325 character description field used in ePerformance |