RSP_TP_OBJ_LNG (SQL Table)	Index Back
Template and Plan Objectives. Multiple objectives can be associated to a strategic template or Plan.

RSP_TP_OBJ_LNG

(SQL Table)

Template and Plan Objectives.

Multiple objectives can be associated to a strategic template or Plan.

Related Language Record for RSP_TP_OBJ

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 RSP_OBJECTIVE_NAME Character(50) VARCHAR2(50) NOT NULL Store the objective names used within Strategic Plans.

5 DESCRLONG Long Character CLOB Long Description

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	RSP_OBJECTIVE_NAME	Character(50)	VARCHAR2(50) NOT NULL	Store the objective names used within Strategic Plans.
5	DESCRLONG	Long Character	CLOB	Long Description