BO_SRCH_PHN

#	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	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.
3	BO_CM_START_DT	Date(10)	DATE	The date that a Contact Method of a Business Object takes effect.
4	CM_USE_START_DT	Date(10)	DATE	Contact Method Use Start Date
5	CM_USE_ID	Number(6,0)	INTEGER NOT NULL	Relationship Contact Method Purpose ID
6	ROLE_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID
7	BO_REL_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Relationship ID of a Business Object
8	BO_REL_POSITION	Character(1)	VARCHAR2(1) NOT NULL	This field describes the position of a Relationship pertaining to a BO. i.e. - To identify a BO in a relationship, BO_REL_ID and BO_REL_POSITION give you the relative position F = First, S = Second. F=First Position S=Second Postion
9	CM_ID	Number(31,0)	DECIMAL(31) NOT NULL	Contact Method ID
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	BO_CM_USE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Use type of a Busines Object's Contact Method. E=Business Object Relationship R=Business Object Role U=Contact Method Usage
14	CM_CONCAT	Character(100)	VARCHAR2(100) NOT NULL	Concatenated Contact Method
15	CM_CONCAT_UPPER	Character(100)	VARCHAR2(100) NOT NULL	Uppper Concatenated Contact Method
16	CM_PURPOSE_TYPE_ID	Number(6,0)	INTEGER NOT NULL	Relationship Contact Method Purpose ID
17	PHONE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	phone type field to store value of phone type. BUSN=Business Phone CAMP=Campus CELL=Cellular Phone DFLT=Default DORM=Dormitory FAX=FAX HOME=Home Phone MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex WORK=Work
18	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Country Code values.
19	PHONE	Character(24)	VARCHAR2(24) NOT NULL	This field stores the Telephone number.
20	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	This field stores the Phone extension.
21	ALT_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Alternate phone number for one-time use. Not part of customer data model.