RT_LEAD_VW

(SQL View)
 Index Back

Lead View

View for leads in Telemarketing......

SELECT DISTINCT D.BUSINESS_UNIT ,D.LEAD_ID ,D.PERSON_ID ,A.BO_ID ,B.TIMEZONE FROM PS_BO_CM A , PS_CM B , PS_BO_ROLE_CM C , PS_RC_AGT_PRSPT_VW D WHERE A.CM_TYPE_ID = 1 AND A.BO_CM_START_DT <= %CurrentDateIn AND A.BO_CM_END_DT > %CurrentDateIn AND B.CM_TYPE_ID = A.CM_TYPE_ID AND B.CM_ID = A.CM_ID AND A.BO_ID = C.BO_ID AND C.CM_TYPE_ID = A.CM_TYPE_ID AND C.PROFILE_CM_SEQ = A.PROFILE_CM_SEQ AND C.PRIMARY_IND = 'Y' AND A.BO_ID = D.BO_ID_CUST AND D.ROLE_TYPE_ID_CUST = C.ROLE_TYPE_ID AND D.ROLE_TYPE_ID_CUST IN(2,8,9) AND B.TIMEZONE <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT

Prompt Table: SP_BU_RA_CLSVW

2 LEAD_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation, this field uniquely identifies a Sales Lead.

Prompt Table: RSF_LEAD

3 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
4 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
5 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone