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

RB_TSK_CLRP_LVW

(SQL View)

View for Call Reports

Task view for Lead Component. Used by Lead Component.

SELECT CR.CALL_REPORT_ID , TX.TASK_ID , TG.LANGUAGE_CD , T.DESCR60 FROM PS_RB_TSK T ,PS_RB_TSK_LANG TG , 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 TG.TASK_ID = T.TASK_ID AND T.TASK_ID = TX.TASK_ID AND T.PERSON_ID_OWNER = P.PERSON_ID

Related Language Record for RB_TSK_CLRPT_VW

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Task Description

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Task Description