RT_CWLIST_LVW (SQL View)	Index Back
Lead Provider Group assigned List Provider Group assignments to a Lead in an Audience list

RT_CWLIST_LVW

(SQL View)

Lead Provider Group assigned

List Provider Group assignments to a Lead in an Audience list

SELECT R.LEAD_ID , B.LANGUAGE_CD , B.NAME1 FROM PS_RC_CALL_RESULT R , PS_RF_PROVGRP_LNG B WHERE B.SETID = R.SETID_PROV_GRP AND B.PROVIDER_GRP_ID = R.PROVIDER_GRP_ID AND R.SEQNO = ( SELECT MAX(R2.SEQNO) FROM PS_RC_CALL_RESULT R2 WHERE R.LEAD_ID = R2.LEAD_ID)

Related Language Record for RT_CWLIST_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.

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

3 PROVIDER_GRP_NAME Character(50) VARCHAR2(50) NOT NULL Provider Group Name

#	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.
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	PROVIDER_GRP_NAME	Character(50)	VARCHAR2(50) NOT NULL	Provider Group Name