RSP_GOAL_NM_VW (SQL View)	Index Back
Strategic Plan Goals Setup table to define Goals which can be selected in template as well as in Plans.

RSP_GOAL_NM_VW

(SQL View)

Strategic Plan Goals

Setup table to define Goals which can be selected in template as well as in Plans.

SELECT A.SETID , A.RSP_PLAN_TYPE , A.GOAL_NAME , A.RSP_GOAL_ID , A.RSP_TARGET_TYPE , A.EOCF_LIB_TERM_ID , A.EOCF_CONFIG_ID , A.RSP_ASSESSMENT_CD , A.RSP_MAX_TARGET , A.RSP_MIN_TARGET , A.RSP_DFLT_TARGET , A.RSP_VARIANCE_IND FROM PS_RSP_GOAL_TBL A WHERE STATUS = 'A' AND RSP_GOAL_USAGE IN ('S', 'B')

# 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.
Prompt Table: RSP_PLAN_TYPE

3 GOAL_NAME Character(50) VARCHAR2(50) NOT NULL Used in strategic account planning for identifying goal name.

4 RSP_GOAL_ID Character(10) VARCHAR2(10) NOT NULL This field is used as a key on the Goal Setup table (RSP_GOAL) and is auto generated on save.
Default Value: NEXT

5 RSP_TARGET_TYPE Character(1) VARCHAR2(1) NOT NULL This field is used by Strategic Planning to define target type like Amount, Percent etc.
1=Amount
2=Percent
3=Quantity
4=Other

6 EOCF_LIB_TERM_ID Number(31,0) DECIMAL(31) NOT NULL a library element that can be evaluated. NOTE: this primary key value is actually a foreign key to the library element portion of a term. Terms are sub-types of elements.
Prompt Table: EOCF_TERM_DEFN

7 EOCF_CONFIG_ID Number(31,0) DECIMAL(31) NOT NULL the unique identifier for a phrase definition (ignoring versioning)

8 RSP_ASSESSMENT_CD Character(2) VARCHAR2(2) NOT NULL Assessment code to define status breaks (comparing attainment with target)
Prompt Table: RSP_ASSESSMENT

9 RSP_MAX_TARGET Signed Number(32,2) DECIMAL(30,2) NOT NULL Field used in the goal setup page to capture the maximum target value allowed for a goal.

10 RSP_MIN_TARGET Signed Number(32,2) DECIMAL(30,2) NOT NULL Field used in the goal setup page to capture the minimum target value allowed for a goal.

11 RSP_DFLT_TARGET Signed Number(32,2) DECIMAL(30,2) NOT NULL This field is used by Strategic Planning to define the default target value of a goal.

12 RSP_VARIANCE_IND Character(1) VARCHAR2(1) NOT NULL Field used by Strategic Planning to define Variance Indicator (High is positive vs. Low is positive)
H=High is Positive
L=Low is Positive
Default Value: H

#	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. Prompt Table: RSP_PLAN_TYPE
3	GOAL_NAME	Character(50)	VARCHAR2(50) NOT NULL	Used in strategic account planning for identifying goal name.
4	RSP_GOAL_ID	Character(10)	VARCHAR2(10) NOT NULL	This field is used as a key on the Goal Setup table (RSP_GOAL) and is auto generated on save. Default Value: NEXT
5	RSP_TARGET_TYPE	Character(1)	VARCHAR2(1) NOT NULL	This field is used by Strategic Planning to define target type like Amount, Percent etc. 1=Amount 2=Percent 3=Quantity 4=Other
6	EOCF_LIB_TERM_ID	Number(31,0)	DECIMAL(31) NOT NULL	a library element that can be evaluated. NOTE: this primary key value is actually a foreign key to the library element portion of a term. Terms are sub-types of elements. Prompt Table: EOCF_TERM_DEFN
7	EOCF_CONFIG_ID	Number(31,0)	DECIMAL(31) NOT NULL	the unique identifier for a phrase definition (ignoring versioning)
8	RSP_ASSESSMENT_CD	Character(2)	VARCHAR2(2) NOT NULL	Assessment code to define status breaks (comparing attainment with target) Prompt Table: RSP_ASSESSMENT
9	RSP_MAX_TARGET	Signed Number(32,2)	DECIMAL(30,2) NOT NULL	Field used in the goal setup page to capture the maximum target value allowed for a goal.
10	RSP_MIN_TARGET	Signed Number(32,2)	DECIMAL(30,2) NOT NULL	Field used in the goal setup page to capture the minimum target value allowed for a goal.
11	RSP_DFLT_TARGET	Signed Number(32,2)	DECIMAL(30,2) NOT NULL	This field is used by Strategic Planning to define the default target value of a goal.
12	RSP_VARIANCE_IND	Character(1)	VARCHAR2(1) NOT NULL	Field used by Strategic Planning to define Variance Indicator (High is positive vs. Low is positive) H=High is Positive L=Low is Positive Default Value: H