RB_TSK_EXTPRSN (SQL Table)	Index Back
Task External person. Task external person. Used by Task Management.

RB_TSK_EXTPRSN

(SQL Table)

Task External person.

Task external person. Used by Task Management.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TASK_ID Number(15,0) DECIMAL(15) NOT NULL TaskIID field. Key for RB_TSK record. Used by Task Management.

2 EXTPRSN_GUID Signed Number(32,0) DECIMAL(31) NOT NULL GUID for external person of a Task. Used by Task Management.

3 DISPLAY_NAME Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

4 PIM_EMAIL_TYPE Character(4) VARCHAR2(4) NOT NULL PIM Email Type for Task Management purpose.
DECN=DECNET
LNOT=Lotus Notes
MS=MS
SMTP=SMTP
UUCP=UUCP
X400=X400

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

6 TASK_ASGN_STATUS Character(4) VARCHAR2(4) NOT NULL Task Assignment Status. Used by Task Management.
ACPT=Accepted
CMPL=Completed
DCLN=Declined
OPEN=Assigned

7 INVITE_TYPE Character(4) VARCHAR2(4) NOT NULL Task Invitation Type. Used by Task Management.
FYI=FYI
OPTL=Optional
REQR=Required

8 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

9 TASK_ATTENDANCE Character(4) VARCHAR2(4) NOT NULL Note Task Attendance. Used by Task Management.
ABSN=Absent
ATND=Attended

10 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

11 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

12 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

13 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

14 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.

15 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TASK_ID	Number(15,0)	DECIMAL(15) NOT NULL	TaskIID field. Key for RB_TSK record. Used by Task Management.
2	EXTPRSN_GUID	Signed Number(32,0)	DECIMAL(31) NOT NULL	GUID for external person of a Task. Used by Task Management.
3	DISPLAY_NAME	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
4	PIM_EMAIL_TYPE	Character(4)	VARCHAR2(4) NOT NULL	PIM Email Type for Task Management purpose. DECN=DECNET LNOT=Lotus Notes MS=MS SMTP=SMTP UUCP=UUCP X400=X400
5	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email address to store the address of email.
6	TASK_ASGN_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Task Assignment Status. Used by Task Management. ACPT=Accepted CMPL=Completed DCLN=Declined OPEN=Assigned
7	INVITE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Task Invitation Type. Used by Task Management. FYI=FYI OPTL=Optional REQR=Required
8	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
9	TASK_ATTENDANCE	Character(4)	VARCHAR2(4) NOT NULL	Note Task Attendance. Used by Task Management. ABSN=Absent ATND=Attended
10	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
11	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
12	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
13	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
14	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.
15	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time