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 |