PIM_SO_TASK_VW (SQL View)	Index Back
SO task View This view is used to obtain the tasks for my service orders for the dataset rules.

PIM_SO_TASK_VW

(SQL View)

SO task View

This view is used to obtain the tasks for my service orders for the dataset rules.

SELECT DISTINCT A.BUSINESS_UNIT , A.SO_ID , B.OPRID , T.TASK_ID , T.TASK_STATUS , T.TASK_PRIORITY , T.TASK_TYPE , TT.SHOW_IN_CAL_FLG , TT.PIM_OUTLOOK_TYPE , TT.PIM_NOTES_TYPE , T.SYNCID , T.SYNCDTTM FROM PS_RF_SOLN_ASSIGN A , PSOPRALIAS B , PS_RF_SO_LINE C , PS_RB_TSK T , PS_RB_TSK_TXN TX , PS_RB_TSK_TYPE TT WHERE A.PERSON_ID = B.PERSON_ID AND A.PERSON_ID <> ' ' AND B.OPRALIASTYPE = 'PER' AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.SO_ID = A.SO_ID AND C.SO_LINE = A.SO_LINE AND TX.REL_TXN_SYNCID = C.SYNCID AND TX.RB_TRANSACTION_ID = 'SERVICE ORDER TASK' AND TX.TXN_MARKET = 'GBL' AND T.TASK_ID = TX.TASK_ID AND T.TASK_TYPE = TT.TASK_TYPE AND TT.ACTIVE_FLG = 'Y' AND TT.SHOW_IN_CAL_FLG = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT
Prompt Table: SP_BU_RF_NONVW

2 SO_ID Character(10) VARCHAR2(10) NOT NULL Service Order ID
Prompt Table: RF_SO_HDR

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

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

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

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

7 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

8 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

9 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

10 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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT Prompt Table: SP_BU_RF_NONVW
2	SO_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Order ID Prompt Table: RF_SO_HDR
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	TASK_ID	Number(15,0)	DECIMAL(15) NOT NULL	TaskIID field. Key for RB_TSK record. Used by Task Management.
5	TASK_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Task Status CMPL=Completed CNCL=Canceled INPR=In Progress OPEN=Open
6	TASK_PRIORITY	Character(4)	VARCHAR2(4) NOT NULL	Task Priority indicator for Task. Used in Task Management.
7	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
8	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
9	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
10	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
11	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.
12	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time