EODI_APT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EODI_APT_TRANS_ID	Number(15,0)	DECIMAL(15) NOT NULL	Apt Transaction ID
2	EODI_APT_PROC_ID	Character(15)	VARCHAR2(15) NOT NULL	Apt Process ID Prompt Table: EODI_APT_REG
3	EODI_APT_GUID	Character(150)	VARCHAR2(150) NOT NULL	Appointment GUID
4	EODI_APT_SUBJECT	Character(100)	VARCHAR2(100) NOT NULL	Apt Subject
5	EODI_APT_LOCATION	Character(254)	VARCHAR2(254) NOT NULL	Appointment Location
6	EODI_CON_PROC_ID	Character(15)	VARCHAR2(15) NOT NULL	Address Book Process ID Prompt Table: EODI_CON_APT_VW
7	EODI_RESTRICT_ADDR	Character(1)	VARCHAR2(1) NOT NULL	Restrict To Address Book Y/N Table Edit Default Value: N
8	EODI_APT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Apt Type A=Appointment G=Meeting Group M=Meeting Default Value: G
9	EODI_START_DTTM	DateTime(26)	TIMESTAMP	Start Date/Time
10	EODI_END_DTTM	DateTime(26)	TIMESTAMP	End Date Time
11	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone Prompt Table: PSTIMEZONE
12	EODI_APT_ALLDAY	Character(1)	VARCHAR2(1) NOT NULL	All Day Event
13	EODI_APT_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Appointment Priority H=High L=Low N=Normal
14	EODI_PRIVATE	Character(1)	VARCHAR2(1) NOT NULL	Private Y/N Table Edit Default Value: N
15	EODI_APT_REMINDER	DateTime(26)	TIMESTAMP	Appointment Reminder
16	EODI_APT_TIME_LOCK	Character(1)	VARCHAR2(1) NOT NULL	Lock Apt to Time Window Y/N Table Edit Default Value: N
17	EODI_APT_DAY_LOCK	Character(1)	VARCHAR2(1) NOT NULL	Lock to one day Y/N Table Edit Default Value: Y
18	EODI_APT_TIME_STAT	Character(1)	VARCHAR2(1) NOT NULL	Apt Status B=Busy F=Free O=Out Of Office T=Tentative Default Value: B
19	EODI_DELETED	Character(1)	VARCHAR2(1) NOT NULL	Deleted Flag Y/N Table Edit Default Value: N
20	EODI_LAST_UP_DTTM	DateTime(26)	TIMESTAMP	Last Update Date Time
21	EODI_APT_DEL_DTTM	DateTime(26)	TIMESTAMP	Apt Delete DateTime
22	EODI_MESSAGE	Long Character	CLOB	Message