RBW_BO_REL_VW2 (SQL View)	Index Back
Household Rel view Relationship instances associated with a Household

RBW_BO_REL_VW2

(SQL View)

Household Rel view

Relationship instances associated with a Household

SELECT REL1.BO_ID_1 ,RC.REL_CLASS_ID , REL2.BO_REL_ID , REL2.BO_ID_1 , REL2.REL_TYPE_ID FROM PS_RD_HOUSEHOLD HH , PS_BO_REL REL1 , PS_BO_REL REL2 , PS_RBW_REL_CLASS RC WHERE HH.BO_ID = REL1.BO_ID_2 AND HH.BO_ID = REL2.BO_ID_2 AND REL1.BO_ID_1 <> REL2.BO_ID_1 AND RC.NEW_BO_FLG = 'Y' AND RC.ACTIVE_FLG = 'Y' AND REL1.START_DT <= %CurrentDateIn AND (REL1.END_DT > %CurrentDateIn OR REL1.END_DT IS NULL) AND REL1.START_DT <= %CurrentDateIn AND (REL1.END_DT > %CurrentDateIn OR REL1.END_DT IS NULL)

# 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 REL_CLASS_ID Number(12,0) DECIMAL(12) NOT NULL Unique identifier of a Relationship Classification in Wealth Management

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

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

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

#	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	REL_CLASS_ID	Number(12,0)	DECIMAL(12) NOT NULL	Unique identifier of a Relationship Classification in Wealth Management
3	BO_REL_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Relationship ID of a Business Object
4	BO_ID_2	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID 2
5	REL_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Relationship Type ID