RB_BO_ADDR_VW (SQL View)	Index Back
RB BO view for credit card This is the RB BO view for credit card.

RB_BO_ADDR_VW

(SQL View)

RB BO view for credit card

This is the RB BO view for credit card.

SELECT DISTINCT D.PERSON_ID , A.PROFILE_CM_SEQ FROM PS_BO_CM A , PS_BO_CM_USE B , PS_RD_PERSON D WHERE A. BO_ID = B.BO_ID AND A.BO_ID = D.BO_ID AND A.PROFILE_CM_SEQ = B.PROFILE_CM_SEQ AND A.CM_TYPE_ID = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person 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.