BO_ST_PHON_VW (SQL View)	Index Back
Site Rep Phones View containing Site Contact Phones.

BO_ST_PHON_VW

(SQL View)

Site Rep Phones

View containing Site Contact Phones.

SELECT B.SETID , B.SITE_ID , A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT , A.CM_TYPE_ID , A.CM_USE_START_DT , A.CM_USE_END_DT , A.CM_ID , A.PRIMARY_IND , A.PROFILE_CM_SEQ , A.CM_NICKNAME , A.CM_PURPOSE_TYPE_ID , A.PHYSICAL_LOCATION , A.COUNTRY_CODE , A.PHONE , A.EXTENSION FROM PS_RD_SITE B , PS_BO_REP_PHON_VW A WHERE B.BO_ID = A.BO_ID AND A.CM_TYPE_ID = 2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

2 SITE_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.

3 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

4 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact

5 CM_TYPE_ID Number(6,0) INTEGER NOT NULL Contact Method Type ID

6 CM_USE_START_DT Date(10) DATE Contact Method Use Start Date

7 CM_USE_END_DT Date(10) DATE End date of a Contact Method Use

8 CM_ID Number(31,0) DECIMAL(31) NOT NULL Contact Method ID

9 PRIMARY_IND Character(1) VARCHAR2(1) NOT NULL Flag that indicates whether or not it is Primary
N=No
Y=Yes

10 PROFILE_CM_SEQ Number(31,0) DECIMAL(31) NOT NULL The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.

11 CM_NICKNAME Character(30) VARCHAR2(30) NOT NULL Nickname of a Contact Method

12 CM_PURPOSE_TYPE_ID Number(6,0) INTEGER NOT NULL Relationship Contact Method Purpose ID
Prompt Table: CM_PURP_TYPE

13 PHYSICAL_LOCATION Character(30) VARCHAR2(30) NOT NULL Physical Location (Free-Form)

14 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL This field stores the Country Code values.

15 PHONE Character(24) VARCHAR2(24) NOT NULL This field stores the Telephone number.

16 EXTENSION Character(6) VARCHAR2(6) NOT NULL This field stores the Phone extension.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	SITE_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.
3	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
4	ROLE_TYPE_ID_CNTCT	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the contact
5	CM_TYPE_ID	Number(6,0)	INTEGER NOT NULL	Contact Method Type ID
6	CM_USE_START_DT	Date(10)	DATE	Contact Method Use Start Date
7	CM_USE_END_DT	Date(10)	DATE	End date of a Contact Method Use
8	CM_ID	Number(31,0)	DECIMAL(31) NOT NULL	Contact Method ID
9	PRIMARY_IND	Character(1)	VARCHAR2(1) NOT NULL	Flag that indicates whether or not it is Primary N=No Y=Yes
10	PROFILE_CM_SEQ	Number(31,0)	DECIMAL(31) NOT NULL	The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.
11	CM_NICKNAME	Character(30)	VARCHAR2(30) NOT NULL	Nickname of a Contact Method
12	CM_PURPOSE_TYPE_ID	Number(6,0)	INTEGER NOT NULL	Relationship Contact Method Purpose ID Prompt Table: CM_PURP_TYPE
13	PHYSICAL_LOCATION	Character(30)	VARCHAR2(30) NOT NULL	Physical Location (Free-Form)
14	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Country Code values.
15	PHONE	Character(24)	VARCHAR2(24) NOT NULL	This field stores the Telephone number.
16	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	This field stores the Phone extension.