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 | 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_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 |