EODI_APT_GROUP

(SQL Table)
Index Back

Appointment Group

Appointment Group

# 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_GROUP Character(5) VARCHAR2(5) NOT NULL Apt Group
3 EODI_APT_GUID Character(150) VARCHAR2(150) NOT NULL Appointment GUID
4 EODI_UNIQUE_INVITE Character(1) VARCHAR2(1) NOT NULL Use Unique Invite Flag

Y/N Table Edit

Default Value: N

5 EODI_APT_MASTER Character(1) VARCHAR2(1) NOT NULL Appt. Master Flag

Y/N Table Edit

Default Value: Y

6 EODI_APT_ICAL Character(1) VARCHAR2(1) NOT NULL iCal Flag

Y/N Table Edit

Default Value: N

7 EODI_APT_STATUS Character(1) VARCHAR2(1) NOT NULL Apt Status
A=Awaiting Responses
C=Canceled
H=On Hold - Do Not Schedule
I=Initial - Not Visible
Q=Queued For Scheduling
S=Scheduled
X=Queued For Canceling

Default Value: I

8 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
9 EODI_APT_SUBJECT Character(100) VARCHAR2(100) NOT NULL Apt Subject
10 EODI_APT_LOCATION Character(254) VARCHAR2(254) NOT NULL Appointment Location
11 EODI_CON_PROC_ID Character(15) VARCHAR2(15) NOT NULL Address Book Process ID

Prompt Table: EODI_CON_APT_VW

12 EODI_RESTRICT_ADDR Character(1) VARCHAR2(1) NOT NULL Restrict To Address Book

Y/N Table Edit

Default Value: N

13 EODI_DURATION Number(3,0) SMALLINT NOT NULL Duration
14 EODI_START_DTTM DateTime(26) TIMESTAMP Start Date/Time
15 EODI_END_DTTM DateTime(26) TIMESTAMP End Date Time
16 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

Prompt Table: PSTIMEZONE

17 EODI_APT_ALLDAY Character(1) VARCHAR2(1) NOT NULL All Day Event
18 EODI_APT_PRIORITY Character(1) VARCHAR2(1) NOT NULL Appointment Priority
H=High
L=Low
N=Normal
19 EODI_PRIVATE Character(1) VARCHAR2(1) NOT NULL Private

Y/N Table Edit

Default Value: N

20 EODI_APT_REMINDER DateTime(26) TIMESTAMP Appointment Reminder
21 EODI_DELETED Character(1) VARCHAR2(1) NOT NULL Deleted Flag

Y/N Table Edit

Default Value: N

22 EODI_LAST_UP_DTTM DateTime(26) TIMESTAMP Last Update Date Time
23 EODI_APT_SNT_DTTM DateTime(26) TIMESTAMP Apt Invitation Sent Date Time
24 EODI_APT_SCH_DTTM DateTime(26) TIMESTAMP Apt Scheduled Date Time
25 EODI_APT_DEL_DTTM DateTime(26) TIMESTAMP Apt Delete DateTime
26 EODI_APT_CAN_DTTM DateTime(26) TIMESTAMP Apt Canceled DateTime
27 EODI_MESSAGE Long Character CLOB Message