RTBL_PRS_PRM_VW (SQL View)	Index Back
Personalization parameter view

RTBL_PRS_PRM_VW

(SQL View)

Personalization parameter view

SELECT A.OPRID , A.RTBL_CONTAINER_NBR , A.RTBL_CURR_SCENARIO , A.SCE_ID , A.RTBL_SCENARIO , B.RTBL_PAGELET_ID , A.SCE_ANCHOR FROM PS_RTBL_USR_PARM A , PS_RTBL_USER_PRNLZ B WHERE A.OPRID = B.OPRID AND A.RTBL_CONTAINER_NBR = B.RTBL_CONTAINER_NBR AND A.RTBL_CURR_SCENARIO = B.RTBL_CURR_SCENARIO

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 RTBL_CONTAINER_NBR Number(5,0) INTEGER NOT NULL Container Number

3 RTBL_CURR_SCENARIO Character(10) VARCHAR2(10) NOT NULL Current Scenario

4 SCE_ID Character(10) VARCHAR2(10) NOT NULL ID

5 RTBL_SCENARIO Character(18) VARCHAR2(18) NOT NULL Scenario Name

6 RTBL_PAGELET_ID Character(30) VARCHAR2(30) NOT NULL Pagelet ID

7 SCE_ANCHOR Character(1) VARCHAR2(1) NOT NULL Y/N flag to to specify which scenario is the anchor for variance measurement (amount or percent) to other scenarios.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RTBL_CONTAINER_NBR	Number(5,0)	INTEGER NOT NULL	Container Number
3	RTBL_CURR_SCENARIO	Character(10)	VARCHAR2(10) NOT NULL	Current Scenario
4	SCE_ID	Character(10)	VARCHAR2(10) NOT NULL	ID
5	RTBL_SCENARIO	Character(18)	VARCHAR2(18) NOT NULL	Scenario Name
6	RTBL_PAGELET_ID	Character(30)	VARCHAR2(30) NOT NULL	Pagelet ID
7	SCE_ANCHOR	Character(1)	VARCHAR2(1) NOT NULL	Y/N flag to to specify which scenario is the anchor for variance measurement (amount or percent) to other scenarios.