RBW_BO_PLAN_VW (SQL View)	Index Back
WM BO Plan view View of Plans for a given Wealth Management BO

RBW_BO_PLAN_VW

(SQL View)

WM BO Plan view

View of Plans for a given Wealth Management BO

SELECT BO_ID , RSP_UID20 , RSP_NAME , RSP_STATUS , START_DATE FROM PS_RSP_TP_HEADER

# 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 RSP_UID20 Character(20) VARCHAR2(20) NOT NULL This field is used as a primary key in Strategic Planning header table (RSP_TP_HEADER)

3 RSP_NAME Character(50) VARCHAR2(50) NOT NULL Stores the Strategic plan / template name.

4 RSP_STATUS Character(2) VARCHAR2(2) NOT NULL Status of a Strategic Plan or Template
10=Draft
20=Active
30=Inactive
40=Completed
50=Cancelled

5 START_DATE Date(10) DATE Start Date

#	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	RSP_UID20	Character(20)	VARCHAR2(20) NOT NULL	This field is used as a primary key in Strategic Planning header table (RSP_TP_HEADER)
3	RSP_NAME	Character(50)	VARCHAR2(50) NOT NULL	Stores the Strategic plan / template name.
4	RSP_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Status of a Strategic Plan or Template 10=Draft 20=Active 30=Inactive 40=Completed 50=Cancelled
5	START_DATE	Date(10)	DATE	Start Date