EODI_APT_PARTIC

(SQL Table)
Index Back

Appointment Participants

Appointment 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