PIM_MYCT_TSK_VW (SQL View)	Index Back
Scheduled tasks for my contact List of all the tasks belongs to my contacts, including sales activities, assigned service orders, holidays and time off.

PIM_MYCT_TSK_VW

(SQL View)

Scheduled tasks for my contact

List of all the tasks belongs to my contacts, including sales activities, assigned service orders, holidays and time off.

SELECT DISTINCT T.TASK_ID , B.OPRID , T.TASK_STATUS , T.DESCR60 , T.TASK_PRIORITY , T.PERSON_ID_OWNER , T.PERSON_ID_OWNER , T.TASK_TYPE , T.START_DATE , T.START_TIME , T.END_DATE , T.END_TIME , T.SHOW_IN_CAL_FLG , T.PIM_OUTLOOK_TYPE , T.PIM_NOTES_TYPE , %subrec(RB_AUDIT_SBR, T) FROM PS_PIM_TASK_VW T , PS_RB_TSK_CNTCT TC , PS_RD_CNTCT_LIST_V B WHERE TC.PERSON_ID_CNTCT = B.PERSON_ID AND TC.TASK_ID = T.TASK_ID

# 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.
Default Value: 999999999999

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 TASK_STATUS Character(4) VARCHAR2(4) NOT NULL Task Status
CMPL=Completed
CNCL=Canceled
INPR=In Progress
OPEN=Open

4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

5 TASK_PRIORITY Character(4) VARCHAR2(4) NOT NULL Task Priority indicator for Task. Used in Task Management.

6 PERSON_ID_OWNER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
Prompt Table: RB_WORKER_SRCH

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

8 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Copied from Resouce Management (8.1). Added new label id for "Task Type"
Prompt Table: RB_TSK_TYPE

9 START_DATE Date(10) DATE Start Date

10 START_TIME Time(15) TIMESTAMP Start Time

11 END_DATE Date(10) DATE End date field to store an end date.

12 END_TIME Time(15) TIMESTAMP End Time

13 SHOW_IN_CAL_FLG Character(1) VARCHAR2(1) NOT NULL Flag to indicate if the Task should be shown in Calendar. Used by Task Management.
N=No
Y=Yes
Y/N Table Edit
Default Value: Y

14 PIM_OUTLOOK_TYPE Character(1) VARCHAR2(1) NOT NULL Outlook Integration mapping. Used by Task Management for PIM
A=Appointment
C=Meeting
E=All Day Event
T=Task
Default Value: T

15 PIM_NOTES_TYPE Character(1) VARCHAR2(1) NOT NULL Lotus Notes Integration mapping. Used by Task Management for PIM
A=Appointment
E=All Day Event
M=Meeting
N=Anniversary
R=Reminder
T=To Do
Default Value: T

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

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

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

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

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

21 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. Default Value: 999999999999
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	TASK_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Task Status CMPL=Completed CNCL=Canceled INPR=In Progress OPEN=Open
4	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
5	TASK_PRIORITY	Character(4)	VARCHAR2(4) NOT NULL	Task Priority indicator for Task. Used in Task Management.
6	PERSON_ID_OWNER	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts Prompt Table: RB_WORKER_SRCH
7	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
8	TASK_TYPE	Character(18)	VARCHAR2(18) NOT NULL	Copied from Resouce Management (8.1). Added new label id for "Task Type" Prompt Table: RB_TSK_TYPE
9	START_DATE	Date(10)	DATE	Start Date
10	START_TIME	Time(15)	TIMESTAMP	Start Time
11	END_DATE	Date(10)	DATE	End date field to store an end date.
12	END_TIME	Time(15)	TIMESTAMP	End Time
13	SHOW_IN_CAL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate if the Task should be shown in Calendar. Used by Task Management. N=No Y=Yes Y/N Table Edit Default Value: Y
14	PIM_OUTLOOK_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Outlook Integration mapping. Used by Task Management for PIM A=Appointment C=Meeting E=All Day Event T=Task Default Value: T
15	PIM_NOTES_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Lotus Notes Integration mapping. Used by Task Management for PIM A=Appointment E=All Day Event M=Meeting N=Anniversary R=Reminder T=To Do Default Value: T
16	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
17	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
18	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
19	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
20	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.
21	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time