BO_SITECM_PHON (SQL View)	Index Back
Site Phones Voiew containing a lsit of Site Phones.

BO_SITECM_PHON

(SQL View)

Site Phones

Voiew containing a lsit of Site Phones.

SELECT A.SETID , A.SITE_ID , B.CM_ID , B.CM_TYPE_ID , B.CM_USE_START_DT , B.PROFILE_CM_SEQ , A.BO_ID , A.BO_ID_PARENT , B.BO_CM_START_DT , B.BO_CM_END_DT , B.CM_USE_END_DT , B.PRIMARY_IND , B.CM_NICKNAME , B.CM_PURPOSE_TYPE_ID , B.PHYSICAL_LOCATION , B.COUNTRY_CODE , B.PHONE , B.EXTENSION FROM PS_RD_SITE A , PS_BO_ROLECM_PHON B WHERE A.BO_ID = B.BO_ID AND B.ROLE_TYPE_ID = 3 AND B.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 CM_ID Number(31,0) DECIMAL(31) NOT NULL Contact Method ID

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

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

6 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.

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

8 BO_ID_PARENT Number(31,0) DECIMAL(31) NOT NULL Business Object ID of the Parent Company.

9 BO_CM_START_DT Date(10) DATE The date that a Contact Method of a Business Object takes effect.

10 BO_CM_END_DT Date(10) DATE End date of a Contact Method of a Business Object

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

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

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

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

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

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

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

18 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	CM_ID	Number(31,0)	DECIMAL(31) NOT NULL	Contact Method ID
4	CM_TYPE_ID	Number(6,0)	INTEGER NOT NULL	Contact Method Type ID
5	CM_USE_START_DT	Date(10)	DATE	Contact Method Use Start Date
6	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.
7	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
8	BO_ID_PARENT	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID of the Parent Company.
9	BO_CM_START_DT	Date(10)	DATE	The date that a Contact Method of a Business Object takes effect.
10	BO_CM_END_DT	Date(10)	DATE	End date of a Contact Method of a Business Object
11	CM_USE_END_DT	Date(10)	DATE	End date of a Contact Method Use
12	PRIMARY_IND	Character(1)	VARCHAR2(1) NOT NULL	Flag that indicates whether or not it is Primary N=No Y=Yes
13	CM_NICKNAME	Character(30)	VARCHAR2(30) NOT NULL	Nickname of a Contact Method
14	CM_PURPOSE_TYPE_ID	Number(6,0)	INTEGER NOT NULL	Relationship Contact Method Purpose ID Prompt Table: CM_PURP_TYPE
15	PHYSICAL_LOCATION	Character(30)	VARCHAR2(30) NOT NULL	Physical Location (Free-Form)
16	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Country Code values.
17	PHONE	Character(24)	VARCHAR2(24) NOT NULL	This field stores the Telephone number.
18	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	This field stores the Phone extension.