RSP_TP_GOAL_VW (SQL View)	Index Back
View for Strategic Plan Goals This view is used to retrieve the Strategic Plan Goals.

RSP_TP_GOAL_VW

(SQL View)

View for Strategic Plan Goals

This view is used to retrieve the Strategic Plan Goals.

SELECT RSP_UID20 , UID20 , RSP_GOAL_ID , GOAL_NAME , RSP_TARGET_TYPE , RSP_TARGET_VAL , RSP_ACTUAL_VAL , RSP_ASSESSMENT_CD , RSP_PRORATE_FLG , EOCF_LIB_TERM_ID , EOCF_CONFIG_ID , RSP_VARIANCE_IND , RSP_ALLOC_METHOD , ' ' , ' ' FROM %Table(RSP_TP_GOAL)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RSP_UID20 Character(20) VARCHAR2(20) NOT NULL This field is used as a primary key in Strategic Planning header table (RSP_TP_HEADER)

2 UID20 Character(20) VARCHAR2(20) NOT NULL This field is for UID of 20 characters long.

3 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.

4 GOAL_NAME Character(50) VARCHAR2(50) NOT NULL Used in strategic account planning for identifying goal name.
Prompt Table: %EDITTABLE

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 RSP_TARGET_VAL 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.

7 RSP_ACTUAL_VAL 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.

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_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate target for goals as defined for strategic plans.
N=No
Y=Yes
Default Value: N

10 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

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

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

13 RSP_ALLOC_METHOD Character(1) VARCHAR2(1) NOT NULL Allocation method used for goals when rolling over a plan from audience/segment to individual accounts.
A=# of Accounts in Segments
B=# of Selected Segments
C=Copy as is
N=Set Target to 0

14 VISIBLE Character(1) VARCHAR2(1) NOT NULL Show Sub Page

15 OWNER Character(1) VARCHAR2(1) NOT NULL Owner
N=No
Y=Yes

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RSP_UID20	Character(20)	VARCHAR2(20) NOT NULL	This field is used as a primary key in Strategic Planning header table (RSP_TP_HEADER)
2	UID20	Character(20)	VARCHAR2(20) NOT NULL	This field is for UID of 20 characters long.
3	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.
4	GOAL_NAME	Character(50)	VARCHAR2(50) NOT NULL	Used in strategic account planning for identifying goal name. Prompt Table: %EDITTABLE
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	RSP_TARGET_VAL	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.
7	RSP_ACTUAL_VAL	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.
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_PRORATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorate target for goals as defined for strategic plans. N=No Y=Yes Default Value: N
10	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
11	EOCF_CONFIG_ID	Number(31,0)	DECIMAL(31) NOT NULL	the unique identifier for a phrase definition (ignoring versioning)
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
13	RSP_ALLOC_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Allocation method used for goals when rolling over a plan from audience/segment to individual accounts. A=# of Accounts in Segments B=# of Selected Segments C=Copy as is N=Set Target to 0
14	VISIBLE	Character(1)	VARCHAR2(1) NOT NULL	Show Sub Page
15	OWNER	Character(1)	VARCHAR2(1) NOT NULL	Owner N=No Y=Yes