PIM_TASK_INFO(SQL Table) |
Index Back |
|---|---|
Additional Task PIM InfoThis record stores information used to synch tasks. It supplements PIM_OBJ_HIST specifically for tasks. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(50) | VARCHAR2(50) NOT NULL | This field is used to store key values from PIM interface | |
| 2 | 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_TODO_STATUS | Character(40) | VARCHAR2(40) NOT NULL | Used by PIM History |
| 5 | PIM_NO_DATE_TIME | Character(1) | VARCHAR2(1) NOT NULL | Used by PIM_PREFERENCE for PIM Configuration |
| 6 | PIM_PRIVATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Used by PIM_PREFERENCE for PIM Configuration |
| 7 | PIM_PRIVATE_TXT | Character(254) | VARCHAR2(254) NOT NULL | Used by PIM_PREFERENCE for PIM Configuration |
| 8 | ALLDAYEVENT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
All Day Event Flag
Y/N Table Edit |
| 9 | PIM_ATTENDEES_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
PIM Attendees Flag. Used to determine whether PIM has sent ATTENDEES tag or not
N=Have not Attendees Tag Y=Have Attendees Tag |
| 10 | PIM_PARENT_GUID | Character(254) | VARCHAR2(254) NOT NULL | This field stores the MeetingLinkingGUID from Intellisync EA software |