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 | EP_ITEM_ID | Character(12) | VARCHAR2(12) NOT NULL | Item unique identifier |
2 | EP_SUB_ID | 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 |