PIM_KEYUSERIDY/N Table Edit
PIM_CNTS_INFO(SQL Table) |
Index Back |
|---|---|
Additional Contacts PIM InfoThis record keeps additional contact's information that are not stored into CDM. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PIM_KEY |
Character(50) | VARCHAR2(50) NOT NULL | This field is used to store key values from PIM interface |
| 2 | USERID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 3 | PIM_CATEGORY | Character(254) | VARCHAR2(254) NOT NULL | Used by PIM History |
| 4 | PIM_DELETED | Character(1) | VARCHAR2(1) NOT NULL |
Used by PIM_CNTS_INFO for keeping track of deleted objects
Y/N Table Edit |
| 5 | PIM_COMPANY_NAME | Character(254) | VARCHAR2(254) NOT NULL | Used by PIM_CNTS_INFO for keeping track of potentially invalid companies. |