RT_PROS_TZ_VW (SQL View)	Index Back
Prospect Timezone Timezone view for Prospects in Telemarketing

RT_PROS_TZ_VW

(SQL View)

Prospect Timezone

Timezone view for Prospects in Telemarketing

SELECT DISTINCT A.BO_ID ,D.LEAD_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_CONTACT AND D.ROLE_TYPE_ID_CUST IN(2,8,9)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

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

3 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	LEAD_ID	Character(15)	VARCHAR2(15) NOT NULL	Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
3	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone