EVENTS_TBL (SQL Table)	Index Back
SJE Events Schedule and Events record for integration with Contracts.

EVENTS_TBL

(SQL Table)

SJE Events

Schedule and Events record for integration with Contracts.

Related Language Record: EVENTS_TBL_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

2 SCHEDULE Character(10) VARCHAR2(10) NOT NULL Schedule for integration with Contracts.

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.
Default Value: 1

4 EVENT_DT Date(10) DATE NOT NULL 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	SCHEDULE	Character(10)	VARCHAR2(10) NOT NULL	Schedule for integration with Contracts.
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. Default Value: 1
4	EVENT_DT	Date(10)	DATE NOT NULL	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