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 |