EODI_APT_PARTIC(SQL Table) |
Index Back |
---|---|
Appointment ParticipantsAppointment Participants |
# | 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 | EMAILID | 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 |