EODI_APT_GROUP(SQL Table) | 
Index Back | 
|---|---|
Appointment GroupAppointment Group | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Number(15,0) | DECIMAL(15) NOT NULL | Apt Transaction ID | |
| 2 | 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 |