EP_ITEM_IDEP_ITEM_SRCH_VW(SQL View) |
Index Back |
|---|---|
Item Search ViewEmpty view used as a work record for search purposes. |
| SELECT ' ' , ' ' , ' ' , %DateNull , %DateNull , %TextIn(' ') , %TextIn(' ') ,' ' ,' ' 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_TITLE | Character(60) | VARCHAR2(60) NOT NULL | Title of an item |
| 3 | RATING_MODEL | Character(4) | VARCHAR2(4) NOT NULL | Rating Model |
| 4 | EP_ITEM_DUE_DT | Date(10) | DATE | Date that an item is due. |
| 5 | EP_ITEM_REMIND_DT | Date(10) | DATE | Date to remind an item is due. |
| 6 | EP_DESCR254 | Long Character | CLOB | 1325 character description field used in ePerformance |
| 7 | EP_MEASURE | Long Character | CLOB | 1325 Character Item measurement description |
| 8 | EP_J_CONTENT_GRP_T | Character(15) | VARCHAR2(15) NOT NULL | Content Group Type |
| 9 | EP_J_CONTENT_GROUP | Character(12) | VARCHAR2(12) NOT NULL | Content Group |