FO_TM_OP_AGN_VW(SQL View) |
Index Back |
|---|---|
MyAgenda - Team + OPRID unionView containing agenda events assigned to a Team or a Operator ID, to be used by MyAgenda pagelet |
| SELECT B.AGENDA_ID , B.EVENT_TYPE , B.USERID , B.START_DATE , B.END_DATE FROM PS_FO_AGENDA_TM_VW B , PS_FO_EVENTS_SETUP C WHERE B.COMPLETED ='N' AND B.EVENT_TYPE = C.EVENT_TYPE AND B.COMPLETED = 'N' AND C.EVENT = 'TMP' AND C.FO_EVNT_PROC <> 'Y' AND C.FO_CHECK1_PB = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AGENDA_ID | Number(15,0) | DECIMAL(15) NOT NULL | Agenda ID |
| 2 | EVENT_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Event Type |
| 3 | USERID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 4 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 5 | END_DATE | Date(10) | DATE | End Date |