RSF_OPP_TSK_VW (SQL View)	Index Back
View for Oppy Task Task view for Oppy Component. Used by Oppy Component.

RSF_OPP_TSK_VW

(SQL View)

View for Oppy Task

Task view for Oppy Component. Used by Oppy Component.

SELECT B.OPPORTUNITY_ID , A.TASK_ID , C.DESCR60 , C.TASK_TYPE , C.TASK_STATUS , C.TASK_PRIORITY , C.START_DATE , C.START_TIME , C.END_DATE , C.END_TIME , C.TIMEZONE , C.TASK_LOCATION , C.PERSON_ID_OWNER , C.DESCRLONG , C.ROW_ADDED_DTTM , C.SYNCID , C.SYNCDTTM FROM PS_RB_TSK_TXN A , PS_RSF_OPPORTUNITY B , PS_RB_TSK C WHERE A.REL_TXN_SYNCID = B.SYNCID AND A.TASK_ID = C.TASK_ID AND A.RB_TRANSACTION_ID = 'OPPRT' AND A.TXN_MARKET = 'GBL'

Related Language Record: RSF_OPPTSK_LNVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID

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

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

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

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

6 TASK_PRIORITY Character(4) VARCHAR2(4) NOT NULL Task Priority indicator for Task. Used in Task Management.
Default Value: 3
Prompt Table: RB_TSK_PRTY_VW

7 START_DATE Date(10) DATE Start Date for Gen Standing PO

8 START_TIME Time(15) TIMESTAMP Start Time

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

10 END_TIME Time(15) TIMESTAMP End Time

11 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

12 TASK_LOCATION Character(30) VARCHAR2(30) NOT NULL Task Location. Used by Task Management.

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

14 DESCRLONG Long Character CLOB Long Description

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPPORTUNITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Opportunity ID
2	TASK_ID	Number(15,0)	DECIMAL(15) NOT NULL	TaskIID field. Key for RB_TSK record. Used by Task Management.
3	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
4	TASK_TYPE	Character(18)	VARCHAR2(18) NOT NULL	Copied from Resouce Management (8.1). Added new label id for "Task Type" Prompt Table: RSF_TSK_TYPE_VW
5	TASK_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Task Status CMPL=Completed CNCL=Canceled INPR=In Progress OPEN=Open Default Value: OPEN
6	TASK_PRIORITY	Character(4)	VARCHAR2(4) NOT NULL	Task Priority indicator for Task. Used in Task Management. Default Value: 3 Prompt Table: RB_TSK_PRTY_VW
7	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
8	START_TIME	Time(15)	TIMESTAMP	Start Time
9	END_DATE	Date(10)	DATE	End date field to store an end date.
10	END_TIME	Time(15)	TIMESTAMP	End Time
11	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone
12	TASK_LOCATION	Character(30)	VARCHAR2(30) NOT NULL	Task Location. Used by Task Management.
13	PERSON_ID_OWNER	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts Prompt Table: RB_WORKER_SRCH
14	DESCRLONG	Long Character	CLOB	Long Description
15	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
16	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.
17	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time