EODI_CON(SQL Table) | 
Index Back | 
|---|---|
Contacts-Address Book EntriesContacts-Address Book Entries | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(15) | VARCHAR2(15) NOT NULL | 
Address Book Process ID
 Prompt Table: EODI_CON_REG  | 
|
| 2 | Character(70) | VARCHAR2(70) NOT NULL | Email Address | |
| 3 | EODI_EMAIL_ALT | Character(70) | VARCHAR2(70) NOT NULL | Alternate Email Address | 
| 4 | EODI_EMAIL_ALT2 | Character(70) | VARCHAR2(70) NOT NULL | Alternate Email Address | 
| 5 | EODI_TITLE | Character(10) | VARCHAR2(10) NOT NULL | Title | 
| 6 | EODI_NAME | Character(50) | VARCHAR2(50) NOT NULL | Full Name | 
| 7 | EODI_FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name | 
| 8 | EODI_MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Middle Name | 
| 9 | EODI_LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name | 
| 10 | EODI_SUFFIX | Character(10) | VARCHAR2(10) NOT NULL | Suffix | 
| 11 | EODI_COMPANY | Character(50) | VARCHAR2(50) NOT NULL | Company | 
| 12 | EODI_JOB_TITLE | Character(50) | VARCHAR2(50) NOT NULL | Job Title | 
| 13 | EODI_PHONE_BUS | Character(12) | VARCHAR2(12) NOT NULL | Telephone | 
| 14 | EODI_PHONE_HOME | Character(12) | VARCHAR2(12) NOT NULL | Telephone | 
| 15 | EODI_PHONE_MOBILE | Character(12) | VARCHAR2(12) NOT NULL | Telephone | 
| 16 | EODI_LAST_UP_DTTM | DateTime(26) | TIMESTAMP | Last Update Date Time | 
| 17 | EODI_DELETED | Character(1) | VARCHAR2(1) NOT NULL | 
Deleted Flag
 Y/N Table Edit Default Value: N  |