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

RPM_UPDATE_VW

(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 , B.GOAL_NAME , A.ENDDTTM , A.RPM_CACHE_STATUS , A.MSGSET , A.MSGNUM , C.MESSAGE_TEXT FROM PS_RPM_GOAL_INFO A , PS_RSP_GOAL_TBL B , PSMSGCATDEFN 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

Related Language Record: RPM_UPDATE_LNG

# 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 GOAL_NAME Character(50) VARCHAR2(50) NOT NULL Used in strategic account planning for identifying goal name.

7 ENDDTTM DateTime(26) TIMESTAMP End Date/Time

8 RPM_CACHE_STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
F=Failed
I=In-Progress
S=Success

9 MSGSET Number(5,0) INTEGER NOT NULL Message Set Number

10 MSGNUM Number(5,0) INTEGER NOT NULL Message Number

11 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	GOAL_NAME	Character(50)	VARCHAR2(50) NOT NULL	Used in strategic account planning for identifying goal name.
7	ENDDTTM	DateTime(26)	TIMESTAMP	End Date/Time
8	RPM_CACHE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator F=Failed I=In-Progress S=Success
9	MSGSET	Number(5,0)	INTEGER NOT NULL	Message Set Number
10	MSGNUM	Number(5,0)	INTEGER NOT NULL	Message Number
11	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.