RTBL_USR_PARM (SQL Table)	Index Back
Personalization Compare Set

RTBL_USR_PARM

(SQL Table)

Personalization Compare Set

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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
Prompt Table: %EDITTABLE5

6 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.
Y/N Table Edit
Default Value: N

7 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: OPERATOR_VW
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 Prompt Table: %EDITTABLE5
6	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. Y/N Table Edit Default Value: N
7	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.