EODI_APT_PARTIC(SQL Table) | 
Index Back | 
|---|---|
Appointment ParticipantsAppointment Participants | 
| # | 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 | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address | |
| 4 | EODI_APT_GUID | Character(150) | VARCHAR2(150) NOT NULL | Appointment GUID | 
| 5 | EODI_EMAIL_NAME | Character(50) | VARCHAR2(50) NOT NULL | Email Name | 
| 6 | EODI_PARTIC_TYPE | Character(1) | VARCHAR2(1) NOT NULL | 
Participant Type
 E=Resource O=Optional R=Required Default Value: R  | 
| 7 | EODI_APT_RESPONSE | Character(1) | VARCHAR2(1) NOT NULL | 
Apt Response
 A=Accepted D=Declined I=Not Sent N=No Response P=Proposed New Time T=Tentative X=Deleted Default Value: I  | 
| 8 | EODI_START_DTTM | DateTime(26) | TIMESTAMP | Start Date/Time | 
| 9 | EODI_END_DTTM | DateTime(26) | TIMESTAMP | End Date Time | 
| 10 | TIMEZONE | Character(9) | VARCHAR2(9) NOT NULL | Time Zone | 
| 11 | EODI_LAST_UP_DTTM | DateTime(26) | TIMESTAMP | Last Update Date Time | 
| 12 | EODI_LAST_REP_DTTM | DateTime(26) | TIMESTAMP | Last Replication Date Time |