RSP_PTYP_OBJ_VW

(SQL View)
 Index Back

Plan Type <-> Objective

Associate Objectives to a Plan Type

SELECT A.SETID , A.RSP_PLAN_TYPE , A.RSP_OBJECTIVE_CD , B.RSP_OBJECTIVE_NAME , A.SEQNUM , B.DESCRLONG , ' ' RSP_UID20 FROM %Table(RSP_PTYP_OBJ) A , %Table(RSP_OBJECTIVE) B WHERE A.SETID = B.SETID AND A.RSP_OBJECTIVE_CD = B.RSP_OBJECTIVE_CD AND A.STATUS = 'A' AND B.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 RSP_OBJECTIVE_CD Character(4) VARCHAR2(4) NOT NULL This field is used by the Strategic Planning to define Objectives for plans.

Prompt Table: RSP_OBJECTIVE

4 RSP_OBJECTIVE_NAME Character(50) VARCHAR2(50) NOT NULL Store the objective names used within Strategic Plans.
5 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
6 DESCRLONG Long Character CLOB Long Description
7 RSP_UID20 Character(20) VARCHAR2(20) NOT NULL This field is used as a primary key in Strategic Planning header table (RSP_TP_HEADER)