AUC_TL_EV_VW(SQL View) |
Index Back |
---|---|
PO Tile Events |
SELECT SEQ_NUM , TILE_EVENT_ID , TILE_EVENT_NAME , 'Y' , ' ' ,0 ,' ' FROM PS_AUC_TILE_EVENTS |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
2 | TILE_EVENT_ID | Character(10) | VARCHAR2(10) NOT NULL | Event Short Name |
3 | TILE_EVENT_NAME | Character(30) | VARCHAR2(30) NOT NULL | Transaction Name |
4 | SELECT_SLIDER | Character(1) | VARCHAR2(1) NOT NULL |
Select
N=No Y=Yes |
5 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
6 | EVENT_AMT_ATTRIB2 | Number(11,0) | DECIMAL(11) NOT NULL | Threshold |
7 | DESCR15 | Character(15) | VARCHAR2(15) NOT NULL | Short Description |