RIM_CONTACT_VW (SQL View)	Index Back
RIM - Company List Super Set RIM - Company List Super Set Gets all Contacts (Contact for a Company, Primary Contact for a Company) and their primary information.

RIM_CONTACT_VW

(SQL View)

RIM - Company List Super Set

RIM - Company List Super Set Gets all Contacts (Contact for a Company, Primary Contact for a Company) and their primary information.

SELECT DISTINCT PER.SETID , PER.BO_ID , PER.PERSON_ID , NAM.BO_NAME_DISPLAY , PER.TITLE , ADR.CM_CONCAT , PHN.CM_CONCAT , IND.FAX , EML.EMAIL_ADDR , PER.SEX , PER.BIRTHDATE , BC.CR_RATING , REL.BO_ID_2 , REL.BO_REL_ID , REL.REL_TYPE_ID , %subrec(RB_AUDIT_SBR, PER) FROM PS_RD_PERSON PER , PS_BO_NAME NAM , PS_BO_SRCH_ADD ADR , PS_BO_SRCH_PHN PHN , PS_BO_SRCH_EML EML , PS_BC BC , PS_BO_REL REL , PS_BO_BASIC_IND IND WHERE PER.BO_ID = NAM.BO_ID AND PER.BO_ID = ADR.BO_ID AND PER.BO_ID = PHN.BO_ID AND PER.BO_ID = EML.BO_ID AND PER.BO_ID = BC.BO_ID AND PER.BO_ID = REL.BO_ID_1 AND PER.BO_ID = IND.BO_ID AND PHN.BO_REL_ID = REL.BO_REL_ID AND REL.REL_TYPE_ID IN (9, 10) AND PHN.PRIMARY_IND ='Y' AND PHN.CM_USE_ID = 0 AND PHN.ROLE_TYPE_ID = 0 AND EML.PRIMARY_IND ='Y' AND EML.CM_USE_ID = 0 AND EML.BO_REL_ID = 0 AND EML.ROLE_TYPE_ID = 8 AND IND.REL_TYPE_ID = 9 AND IND.ROLE_TYPE_ID = 8

# 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 BO_ID_1 Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID 1

3 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

4 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

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

6 ADDRESS_DESCR100 Character(100) VARCHAR2(100) NOT NULL Concatonated summary field for Address fields, limited to 100 characters.

7 CM_CONCAT Character(100) VARCHAR2(100) NOT NULL Concatenated Contact Method

8 FAX Character(24) VARCHAR2(24) NOT NULL This is the fax number field.

9 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address to store the address of email.

10 SEX Character(1) VARCHAR2(1) NOT NULL Gender of the person.
F=Female
M=Male
U=Unknown

11 BIRTHDATE Date(10) DATE Birthdate of the person.

12 CR_RATING Number(5,0) INTEGER NOT NULL Credit Rating Field. Used to store Credit Rating of a Company Or Consumer. It is used in BC (Business Contact) Record

13 BO_ID_2 Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID 2

14 BO_REL_ID Signed Number(32,0) DECIMAL(31) NOT NULL Relationship ID of a Business Object

15 REL_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Relationship Type ID

16 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

17 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

18 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

19 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

20 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

21 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	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	BO_ID_1	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID 1
3	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
4	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
5	TITLE	Character(35)	VARCHAR2(35) NOT NULL	Title
6	ADDRESS_DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Concatonated summary field for Address fields, limited to 100 characters.
7	CM_CONCAT	Character(100)	VARCHAR2(100) NOT NULL	Concatenated Contact Method
8	FAX	Character(24)	VARCHAR2(24) NOT NULL	This is the fax number field.
9	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email address to store the address of email.
10	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender of the person. F=Female M=Male U=Unknown
11	BIRTHDATE	Date(10)	DATE	Birthdate of the person.
12	CR_RATING	Number(5,0)	INTEGER NOT NULL	Credit Rating Field. Used to store Credit Rating of a Company Or Consumer. It is used in BC (Business Contact) Record
13	BO_ID_2	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID 2
14	BO_REL_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Relationship ID of a Business Object
15	REL_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Relationship Type ID
16	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
17	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
18	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
19	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
20	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
21	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time