PIM_ACT_BO_VW (SQL View)	Index Back
PIM Active Objects This record is used as a view of PIM active business objects. An object in CDM can be inactive, but if the BO has a corresponding record in PIM_PDUP_TBL with status of new, the BO is considered to be active for dataset rules.

PIM_ACT_BO_VW

(SQL View)

PIM Active Objects

This record is used as a view of PIM active business objects. An object in CDM can be inactive, but if the BO has a corresponding record in PIM_PDUP_TBL with status of new, the BO is considered to be active for dataset rules.

SELECT A.BO_ID , A.BO_NAME , A.MERGE_STATUS FROM %Table(BO) A WHERE A.MERGE_STATUS = 'A' OR (A.MERGE_STATUS = 'I' AND EXISTS ( SELECT 'X' FROM %Table(PIM_PDUP_TBL) B WHERE B.BO_ID = A.BO_ID AND B.PIM_DUP_STATUS = 'N'))

# 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 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

3 MERGE_STATUS Character(1) VARCHAR2(1) NOT NULL This field is used to indicate the BO status, for example, when it is in process of being merged.
A=Active
I=Inactive
M=Merge In Progress

#	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	BO_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
3	MERGE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate the BO status, for example, when it is in process of being merged. A=Active I=Inactive M=Merge In Progress