RPM_UPDATE_LNG (SQL View)	Index Back
Metric Update Statistic view This view shows the result of SmartViews batch job for updating data.

RPM_UPDATE_LNG

(SQL View)

Metric Update Statistic view

This view shows the result of SmartViews batch job for updating data.

SELECT A.SETID , A.RSP_GOAL_ID , A.BEGINDTTM , A.OPRID , A.RUN_CNTL_ID , C.LANGUAGE_CD , B.GOAL_NAME , C.MESSAGE_TEXT FROM PS_RPM_GOAL_INFO A , PS_RSP_GOAL_TBL_LN B , PSMSGCATLANG C WHERE A.SETID = B.SETID AND A.RSP_GOAL_ID =B.RSP_GOAL_ID AND A.MSGSET = C.MESSAGE_SET_NBR AND A.MSGNUM = C.MESSAGE_NBR AND B.LANGUAGE_CD = C.LANGUAGE_CD

Related Language Record for RPM_UPDATE_VW

# 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_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.

3 BEGINDTTM DateTime(26) TIMESTAMP Begin Date/Time

4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

5 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

8 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.

#	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_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.
3	BEGINDTTM	DateTime(26)	TIMESTAMP	Begin Date/Time
4	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
5	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
6	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
7	GOAL_NAME	Character(50)	VARCHAR2(50) NOT NULL	Used in strategic account planning for identifying goal name.
8	MESSAGE_TEXT	Character(100)	VARCHAR2(100) NOT NULL	Message Text This field refers to the Text for a particular Message Number in the Message Catalog.