RSP_PTYP_USG_VW (SQL View)	Index Back
Setup Plan Types by SETID. Setup Plan Types by SETID, used by Strategic Account Planning

RSP_PTYP_USG_VW

(SQL View)

Setup Plan Types by SETID.

Setup Plan Types by SETID, used by Strategic Account Planning

SELECT A.SETID , B.RSP_PLAN_USAGE , A.RSP_PLAN_TYPE , A.DESCR FROM PS_RSP_PLAN_TYPE A , PS_RSP_PTYP_USAGE B WHERE A.SETID = B.SETID AND A.RSP_PLAN_TYPE = B.RSP_PLAN_TYPE AND A.STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

2 RSP_PLAN_USAGE Character(1) VARCHAR2(1) NOT NULL This field is used by Strategic Planning to capture usage (Account Plan vs. Segment Plan) for a plan type.
A=Account Planning
S=Segment/Audience Planning

3 RSP_PLAN_TYPE Character(15) VARCHAR2(15) NOT NULL This field is used by the Strategic Planning to define various plan types setup in the system.

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	RSP_PLAN_USAGE	Character(1)	VARCHAR2(1) NOT NULL	This field is used by Strategic Planning to capture usage (Account Plan vs. Segment Plan) for a plan type. A=Account Planning S=Segment/Audience Planning
3	RSP_PLAN_TYPE	Character(15)	VARCHAR2(15) NOT NULL	This field is used by the Strategic Planning to define various plan types setup in the system.
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description