RI_RSF_LEAD_LVW (SQL View)	Index Back
Language record -Sales - Leads This is the related language record for level0 record for the lead component. Attributes on this record include customer name, site name, lead status, lead rating etc.

RI_RSF_LEAD_LVW

(SQL View)

Language record -Sales - Leads

This is the related language record for level0 record for the lead component. Attributes on this record include customer name, site name, lead status, lead rating etc.

SELECT LL.LEAD_ID , LL.LANGUAGE_CD , LL.DESCR50 FROM PS_RSF_LEAD L , PS_RSF_LEAD_LANG LL WHERE L.LEAD_ID = LL.LEAD_ID AND L.RC_PROSPECT_SW = 'N'

Related Language Record for RI_RSF_LEADS_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LEAD_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
Default Value: NEXT

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LEAD_ID	Character(15)	VARCHAR2(15) NOT NULL	Used by Sales Force Automation, this field uniquely identifies a Sales Lead. Default Value: NEXT
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50