FO_CNTC_HOT_VW (SQL View)	Index Back
Order Hot List Order Hot List

FO_CNTC_HOT_VW

(SQL View)

Order Hot List

SELECT H.OPRID , T.SETID , T.CONTACT_ID , T.NAME1 , T.TITLE , H.DATETIME_ADDED , T.EMAILID , P.PHONE , C.SETID , C.CUST_ID , C.NAME1 , D.ADDRESS_SEQ_NUM FROM PS_FO_CNTC_HOT_TBL H , PS_CUSTOMER C , PS_CONTACT T , PS_CONTACT_PHN P , PS_CONTACT_CUST D WHERE H.SETID = T.SETID AND H.CONTACT_ID = T.CONTACT_ID AND H.CUSTOMER_SETID = C.SETID AND H.CUST_ID = C.CUST_ID AND T.EFFDT = ( SELECT MAX(T_ED.EFFDT) FROM PS_CONTACT T_ED WHERE T.SETID = T_ED.SETID AND T.CONTACT_ID = T_ED.CONTACT_ID AND T_ED.EFFDT <= %CurrentDateIn) AND P.EFFDT = T.EFFDT AND T.EFF_STATUS = 'A' AND T.SETID = P.SETID AND T.CONTACT_ID = P.CONTACT_ID AND P.PRIMARY_PHONE = 'Y' AND D.SETID = T.SETID AND D.CONTACT_ID = T.CONTACT_ID AND D.EFFDT = T.EFFDT AND D.CUSTOMER_SETID = H.CUSTOMER_SETID AND D.CUST_ID = H.CUST_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

3 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

4 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2

5 TITLE Character(35) VARCHAR2(35) NOT NULL Title

6 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added

7 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address

8 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone

9 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID

10 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

11 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

12 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
4	NAME2	Character(40)	VARCHAR2(40) NOT NULL	Name 2
5	TITLE	Character(35)	VARCHAR2(35) NOT NULL	Title
6	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
7	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
8	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
9	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
10	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
11	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
12	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number