RB_TSK_OPPY_VW

(SQL View)
 Index Back

View for Opportunity

Task view for OpportunityComponent. Used by OpportunityComponent.

SELECT OP.OPPORTUNITY_ID , TX.TASK_ID , T.DESCR60 , T.TASK_TYPE , T.TASK_STATUS , T.TASK_PRIORITY , T.START_DATE , T.START_TIME , T.END_DATE , T.END_TIME , T.TIMEZONE , T.TASK_LOCATION , T.PERSON_ID_OWNER FROM PS_RB_TSK T , PS_RB_TSK_TXN TX , PS_RSF_OPPORTUNITY OP WHERE TX.REL_TXN_SYNCID = OP.SYNCID AND TX.RB_TRANSACTION_ID = 'OPPRT' AND TX.TXN_MARKET = 'GBL' AND T.TASK_ID = TX.TASK_ID

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

Default Value: 999999999999

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: RB_TSK_TYPE

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.

Prompt Table: RB_TSK_PRTY_VW

7 START_DATE Date(10) DATE Start Date
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

Prompt Table: PSTIMEZONE

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