OPR_DEF_TBL_RS (SQL Table)	Index Back
Operator Defaults for SRS Record to store the default for Operator.

OPR_DEF_TBL_RS

(SQL Table)

Operator Defaults for SRS

Record to store the default for Operator.

# 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: OPRID_VW

2 FIT_SCORE Signed Number(7,4) DECIMAL(5,4) NOT NULL Fit Score

3 MAX_COUNT_99 Number(2,0) SMALLINT NOT NULL Maximum Number of Candidates
Default Value: 10

4 BUSINESS_UNIT_HR Character(5) VARCHAR2(5) NOT NULL Business Unit HR
Prompt Table: BUS_UNIT_TBL_HR

5 TREE_SETID Character(5) VARCHAR2(5) NOT NULL Tree SetID

6 OWNERSHIP_ID Character(30) VARCHAR2(30) NOT NULL Owning Organization
Prompt Table: %EDITTABLE

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description

8 ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered by
Prompt Table: RS_OPR_NAME_VW

9 ASSIGNED_TO Character(30) VARCHAR2(30) NOT NULL Assigned To
Prompt Table: RS_OPR_NAME_VW1

10 RS_SINGLEUNIT_FLG Character(1) VARCHAR2(1) NOT NULL Use Selected Organization Only
Y/N Table Edit
Default Value: N

11 NODE_DETAIL Character(1) VARCHAR2(1) NOT NULL Tree Node or Tree detail Value
D=Detail
N=Node
Default Value: N

12 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: OPRID_VW
2	FIT_SCORE	Signed Number(7,4)	DECIMAL(5,4) NOT NULL	Fit Score
3	MAX_COUNT_99	Number(2,0)	SMALLINT NOT NULL	Maximum Number of Candidates Default Value: 10
4	BUSINESS_UNIT_HR	Character(5)	VARCHAR2(5) NOT NULL	Business Unit HR Prompt Table: BUS_UNIT_TBL_HR
5	TREE_SETID	Character(5)	VARCHAR2(5) NOT NULL	Tree SetID
6	OWNERSHIP_ID	Character(30)	VARCHAR2(30) NOT NULL	Owning Organization Prompt Table: %EDITTABLE
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered by Prompt Table: RS_OPR_NAME_VW
9	ASSIGNED_TO	Character(30)	VARCHAR2(30) NOT NULL	Assigned To Prompt Table: RS_OPR_NAME_VW1
10	RS_SINGLEUNIT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Use Selected Organization Only Y/N Table Edit Default Value: N
11	NODE_DETAIL	Character(1)	VARCHAR2(1) NOT NULL	Tree Node or Tree detail Value D=Detail N=Node Default Value: N
12	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.