RT_CWLIST_VW

(SQL View)
 Index Back

Lead Provider Group assigned

List Provider Group assignments to a Lead in an Audience list

SELECT R.LEAD_ID , B.SETID , B.PROVIDER_GRP_ID , B.NAME1 , R.ASSIGNED_TO , B.STATUS FROM PS_RC_CALL_RESULT R , PS_RF_PROVIDER_GRP 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: RT_CWLIST_LVW

    • # 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 SETID_PROV_GRP Character(5) VARCHAR2(5) NOT NULL SetID
    3 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.
    4 PROVIDER_GRP_NAME Character(50) VARCHAR2(50) NOT NULL Provider Group Name
    5 ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.
    6 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive