RB_TSK_CLRPT_VW (SQL View)	Index Back
View for Call Reports Task view for Lead Component. Used by Lead Component.

RB_TSK_CLRPT_VW

(SQL View)

View for Call Reports

Task view for Lead Component. Used by Lead Component.

SELECT CR.CALL_REPORT_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 , P.BO_NAME_DISPLAY , T.SYNCID , T.SYNCDTTM FROM PS_RB_TSK T , PS_RB_TSK_TXN TX , PS_RD_CALL_REPORT CR , PS_RD_PERSON_PN_VW P WHERE TX.REL_TXN_SYNCID = CR.SYNCID AND TX.RB_TRANSACTION_ID = 'CALLREPORT' AND TX.TXN_MARKET = 'GBL' AND T.TASK_ID = TX.TASK_ID AND T.PERSON_ID_OWNER = P.PERSON_ID

Related Language Record: RB_TSK_CLRP_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CALL_REPORT_ID Number(15,0) DECIMAL(15) NOT NULL Unique Identifier for Call Reports.

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 Task 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

14 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CALL_REPORT_ID	Number(15,0)	DECIMAL(15) NOT NULL	Unique Identifier for Call Reports.
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	Task 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
14	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
15	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.
16	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time