RSFD_TSKBASE_VW (SQL View)	Index Back
Tasks for dashboard Basic task information including assignee and task source as used in sales dashboard.

RSFD_TSKBASE_VW

(SQL View)

Tasks for dashboard

Basic task information including assignee and task source as used in sales dashboard.

SELECT TX.TASK_ID , TA.PERSON_ID_ASSIGNEE , 0 , TX.RB_TRANSACTION_ID , T.DESCR60 , T.TASK_TYPE , T.TASK_STATUS , T.TASK_PRIORITY , T.START_DATE , T.END_DATE , T.TASK_LOCATION , T.PERSON_ID_OWNER , T.APPLICATION_USAGE , TFA.TIMEFRAME_PERIOD , TFQ.TIMEFRAME_PERIOD , TX.REL_TXN_SYNCID , T.ROW_LASTMANT_DTTM , UTFA.TIMEFRAME_PERIOD , UTFQ.TIMEFRAME_PERIOD FROM PS_RB_TSK T , PS_RB_TSK_ASGN TA , PS_RB_TSK_TXN TX , PS_RSFD_REP_VW P , PS_RSFD_TFP_ANN_VW TFA , PS_RSFD_TFP_QTR_VW TFQ , PS_RSFD_TFP_ANN_VW UTFA , PS_RSFD_TFP_QTR_VW UTFQ WHERE TX.TXN_MARKET = 'GBL' AND TA.PERSON_ID_ASSIGNEE = P.PERSON_ID AND T.TASK_ID = TX.TASK_ID AND T.TASK_ID = TA.TASK_ID AND T.APPLICATION_USAGE IN ('SALS', 'ALL', 'RSP') AND TX.RB_TRANSACTION_ID IN ('CALLREPORT', 'OPPRT', 'LEAD' , 'RSP_PLANNING' ) AND T.PRIVATE_FLG = 'N' AND T.START_DATE BETWEEN TFA.BEGIN_DT AND TFA.END_DT AND T.START_DATE BETWEEN TFQ.BEGIN_DT AND TFQ.END_DT AND %DatePart(T.ROW_LASTMANT_DTTM) BETWEEN UTFA.BEGIN_DT AND UTFA.END_DT AND %DatePart(T.ROW_LASTMANT_DTTM) BETWEEN UTFQ.BEGIN_DT AND UTFQ.END_DT

# 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 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

3 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

4 RB_TRANSACTION_ID Character(25) VARCHAR2(25) NOT NULL Transaction ID

5 DESCR60 Character(60) VARCHAR2(60) NOT NULL Task Subject

6 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

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

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

9 START_DATE Date(10) DATE Start Date

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

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

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

13 APPLICATION_USAGE Character(4) VARCHAR2(4) NOT NULL Application Usage. Holds the info about the application.
ALL=All Applications
CHMG=Change Management
EVNT=Marketing Events
FLDS=Field Service
HIED=Higher Education
HLPD=HelpDesk
HRHD=HR Helpdesk
LEAD=Lead
OPPY=Opportunity
PIM=Personal Information Mgmt
RSP=Strategic Planning
SALS=Sales
SUPP=Support
Default Value: ALL

14 ACT_TF_ANNUAL Character(32) VARCHAR2(32) NOT NULL Timeframe period used in dashboard for estimated close date range

15 ACT_TF_QTR Character(32) VARCHAR2(32) NOT NULL Timeframe period used in dashboard for estimated close date range

16 REL_TXN_SYNCID Number(10,0) DECIMAL(10) NOT NULL SYNCID of the related transaction. Used by Task Management.

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

18 RSD_UPD_TF_ANN Character(32) VARCHAR2(32) NOT NULL Timeframe period used in dashboard for the annual period enclosing date when the record was updated.

19 RSD_UPD_TF_QTR Character(32) VARCHAR2(32) NOT NULL Timeframe period used in dashboard for the quarterly period enclosing date when the record was updated.

#	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	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
3	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
4	RB_TRANSACTION_ID	Character(25)	VARCHAR2(25) NOT NULL	Transaction ID
5	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Task Subject
6	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
7	TASK_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Task Status CMPL=Completed CNCL=Canceled INPR=In Progress OPEN=Open Default Value: OPEN
8	TASK_PRIORITY	Character(4)	VARCHAR2(4) NOT NULL	Task Priority indicator for Task. Used in Task Management. Prompt Table: RB_TSK_PRTY_VW
9	START_DATE	Date(10)	DATE	Start Date
10	END_DATE	Date(10)	DATE	End date field to store an end date.
11	TASK_LOCATION	Character(30)	VARCHAR2(30) NOT NULL	Task Location. Used by Task Management.
12	PERSON_ID_OWNER	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts Prompt Table: RB_WORKER_SRCH
13	APPLICATION_USAGE	Character(4)	VARCHAR2(4) NOT NULL	Application Usage. Holds the info about the application. ALL=All Applications CHMG=Change Management EVNT=Marketing Events FLDS=Field Service HIED=Higher Education HLPD=HelpDesk HRHD=HR Helpdesk LEAD=Lead OPPY=Opportunity PIM=Personal Information Mgmt RSP=Strategic Planning SALS=Sales SUPP=Support Default Value: ALL
14	ACT_TF_ANNUAL	Character(32)	VARCHAR2(32) NOT NULL	Timeframe period used in dashboard for estimated close date range
15	ACT_TF_QTR	Character(32)	VARCHAR2(32) NOT NULL	Timeframe period used in dashboard for estimated close date range
16	REL_TXN_SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	SYNCID of the related transaction. Used by Task Management.
17	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
18	RSD_UPD_TF_ANN	Character(32)	VARCHAR2(32) NOT NULL	Timeframe period used in dashboard for the annual period enclosing date when the record was updated.
19	RSD_UPD_TF_QTR	Character(32)	VARCHAR2(32) NOT NULL	Timeframe period used in dashboard for the quarterly period enclosing date when the record was updated.