RS_OPR_SRCH_VW (SQL View)	Index Back
Operator Defaults for SRS

RS_OPR_SRCH_VW

(SQL View)

Operator Defaults for SRS

SELECT OPRID , FIT_SCORE , MAX_COUNT_99 , OWNERSHIP_ID , DESCR , ENTERED_BY , ASSIGNED_TO , RS_SINGLEUNIT_FLG , NODE_DETAIL , LASTUPDDTTM FROM %Table(OPR_DEF_TBL_RS)

# 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 OWNERSHIP_ID Character(30) VARCHAR2(30) NOT NULL Owning Organization
Prompt Table: %EDITTABLE

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

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

7 ASSIGNED_TO Character(30) VARCHAR2(30) NOT NULL Assigned To
Prompt Table: RS_OPR_NAME_VW

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

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

10 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	OWNERSHIP_ID	Character(30)	VARCHAR2(30) NOT NULL	Owning Organization Prompt Table: %EDITTABLE
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered by Prompt Table: RS_OPR_NAME_VW
7	ASSIGNED_TO	Character(30)	VARCHAR2(30) NOT NULL	Assigned To Prompt Table: RS_OPR_NAME_VW
8	RS_SINGLEUNIT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Use Selected Organization Only Y/N Table Edit Default Value: N
9	NODE_DETAIL	Character(1)	VARCHAR2(1) NOT NULL	Tree Node or Tree detail Value D=Detail N=Node Default Value: N
10	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.