PIM_SO_CAL_VW

(SQL View)
 Index Back

SO Calendar Item View

This view shows existing Service Order for a calendar

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 = 'Y'

# 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