EODI_CON(SQL Table) |
Index Back |
---|---|
Contacts-Address Book EntriesContacts-Address Book Entries |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EODI_CON_PROC_ID | Character(15) | VARCHAR2(15) NOT NULL |
Address Book Process ID
Prompt Table: EODI_CON_REG |
2 | EODI_EMAIL | 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 |