SYNCIDA=From PIA
M=From PIM
PIM_TASK(SQL Table) |
Index Back |
|---|---|
PIM tasksThis table keeps task information, independent of users, originated from PIM. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SYNCID |
Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 2 | PIM_INIT_SYNC_SRC | Character(1) | VARCHAR2(1) NOT NULL |
The Initial Sync source
A=From PIA M=From PIM |
| 3 | PIM_MEETING_GUID | Character(254) | VARCHAR2(254) NOT NULL | This field stores the MeetingLinkingGUID from Intellisync EA software |
| 4 | PIM_PARENT | Character(1) | VARCHAR2(1) NOT NULL | This field indicate a task is the parent (root) of a repeat task |
| 5 | MEETING_CREATE_DAT | Character(10) | VARCHAR2(10) NOT NULL | Field to add to CRM to map with the field meetingCreationDate sent from IMS side. |
| 6 | MEETING_CREATE_TIM | Character(10) | VARCHAR2(10) NOT NULL | Field to add to CRM to map with the field meetingCreationTime sent from IMS side. |