RBW_BO_CL_VW (SQL View)	Index Back
BO Classification view Relationship Classification instances associated with a BO

RBW_BO_CL_VW

(SQL View)

BO Classification view

Relationship Classification instances associated with a BO

SELECT BO.BO_ID , RC.REL_CLASS_ID , RC.SEQNO , RC.NEW_BO_FLG FROM PS_BO BO , PS_RBW_REL_CLASS RC , PS_RBW_REL_CLS_ROL RCR , PS_BO_REL_TYPE RELT , PS_BO_REL REL WHERE (BO.BO_ID = REL.BO_ID_1 OR BO.BO_ID = REL.BO_ID_2) AND RC.REL_CLASS_ID = RCR.REL_CLASS_ID AND (REL.ROLE_TYPE_ID_1 = RELT.ROLE_TYPE_ID_1 OR REL.ROLE_TYPE_ID_2 = RELT.ROLE_TYPE_ID_1) AND RELT.REL_TYPE_ID = REL.REL_TYPE_ID AND RELT.REL_TYPE_ID = RCR.REL_TYPE_ID AND RC.ACTIVE_FLG = 'Y' AND REL.START_DT <= %CurrentDateIn AND (REL.END_DT > %CurrentDateIn OR REL.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 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

4 NEW_BO_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether a Relationship Classification should result in a new Business Object
Y/N Table Edit

#	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	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
4	NEW_BO_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether a Relationship Classification should result in a new Business Object Y/N Table Edit