RSP_AUDN_PTYP_V

(SQL View)
Index Back

Plan Types valid for Audience

This record is used for prompting on the Plan Typesvalid for audience/segment planning

SELECT A.SETID , A.RSP_PLAN_TYPE , A.DESCR FROM %Table(RSP_PLAN_TYPE) A , %Table(RSP_PTYP_USAGE) B WHERE A.SETID = B.SETID AND A.RSP_PLAN_TYPE = B.RSP_PLAN_TYPE AND B.RSP_PLAN_USAGE = 'S' 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_TYPE Character(15) VARCHAR2(15) NOT NULL This field is used by the Strategic Planning to define various plan types setup in the system.
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description