EODI_APT_GROUP(SQL Table) |
Index Back |
---|---|
Appointment GroupAppointment 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 |