SETIDSCHEDULEEVENT_OCCURRENCEOI_STDJOEV_VW(SQL View) |
Index Back |
|---|---|
EventsOTBI Events View |
| SELECT A.SETID , A.SCHEDULE , A.EVENT_OCCURRENCE , A.EVENT_DT , A.TIME_HH , A.TIME_MM , A.DESCR FROM %Table(EVENTS_TBL) A UNION SELECT B.SETID , '-' , 0 , %DateIn('9999-12-31') , 0 , 0 , '-' FROM PS_SETID_TBL B UNION SELECT ' ' , '-' , 0 , %DateIn('9999-12-31') , 0 , 0 , '-' FROM %Table(INSTALLATION) C |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | SCHEDULE |
Character(10) | VARCHAR2(10) NOT NULL | Schedule ID |
| 3 | EVENT_OCCURRENCE |
Number(3,0) | SMALLINT NOT NULL | Identifies a user-defined event on a schedule for automatically creating standard and recurring journal entries. Event Occurrence is a number associated with a date for creation of the journal. |
| 4 | EVENT_DT | Date(10) | DATE | The date upon which an accounting event is scheduled to be processed and converted into corresponding accounting |
| 5 | TIME_HH | Number(2,0) | SMALLINT NOT NULL | Time - Hour |
| 6 | TIME_MM | Number(2,0) | SMALLINT NOT NULL | Time - Minute |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |