PIM_TASK_A_INFO (SQL Table)	Index Back
Additional Task PIM Info This is the record that stores the attendee information for synched task. It is a child of PIM_TASK_INFO and an adjunct to PIM_OBJ_HIST.

PIM_TASK_A_INFO

(SQL Table)

Additional Task PIM Info

This is the record that stores the attendee information for synched task. It is a child of PIM_TASK_INFO and an adjunct to PIM_OBJ_HIST.

# 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 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

4 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

5 PIM_EMAIL_ADDR_TYP Character(10) VARCHAR2(10) NOT NULL Email address type such as SMTP, LNOTES, X400, MS, UUCP, DECNET.

6 OWNER Character(1) VARCHAR2(1) NOT NULL Owner
N=No
Y=Yes

7 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address to store the address of email.

8 PERSON_ID_ASSIGNEE Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

9 PIM_ATTENDANCE Character(10) VARCHAR2(10) NOT NULL Attendee's Attendance: REQUIRED, OPTIONAL, or RESOURCE

10 PIM_RESPONSE Character(10) VARCHAR2(10) NOT NULL This field is used in PIM task processing. It is used to store the response of an attendee.

11 VALID_FLAG Character(1) VARCHAR2(1) NOT NULL Valid XLAT flag
Y/N Table Edit

#	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	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
4	BO_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
5	PIM_EMAIL_ADDR_TYP	Character(10)	VARCHAR2(10) NOT NULL	Email address type such as SMTP, LNOTES, X400, MS, UUCP, DECNET.
6	OWNER	Character(1)	VARCHAR2(1) NOT NULL	Owner N=No Y=Yes
7	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email address to store the address of email.
8	PERSON_ID_ASSIGNEE	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
9	PIM_ATTENDANCE	Character(10)	VARCHAR2(10) NOT NULL	Attendee's Attendance: REQUIRED, OPTIONAL, or RESOURCE
10	PIM_RESPONSE	Character(10)	VARCHAR2(10) NOT NULL	This field is used in PIM task processing. It is used to store the response of an attendee.
11	VALID_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Valid XLAT flag Y/N Table Edit