NVS_SCOPE_VALUE (SQL Table)	Index Back
PS/nVision Scope Values This record is maintained by PS/nVision. A scope specifies one or more fields, and their criteria, used to produce multiple instances of an nVision report for different parts of the organization. This record represents the field scroll; its child has values for each field.

NVS_SCOPE_VALUE

(SQL Table)

PS/nVision Scope Values

This record is maintained by PS/nVision. A scope specifies one or more fields, and their criteria, used to produce multiple instances of an nVision report for different parts of the organization. This record represents the field scroll; its child has values for each field.

Parent record: NVS_SCOPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 REPORT_SCOPE Character(10) VARCHAR2(10) NOT NULL Report Scope

3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

4 SELECT_VALUE Character(30) VARCHAR2(30) NOT NULL Select Value
Prompt Table: %EDITTABLE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	REPORT_SCOPE	Character(10)	VARCHAR2(10) NOT NULL	Report Scope
3	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
4	SELECT_VALUE	Character(30)	VARCHAR2(30) NOT NULL	Select Value Prompt Table: %EDITTABLE