NVS_SCOPE_FIELD

(SQL Table)
 Index Back

PS/nVision Scope Field

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).

    Prompt Table: NVS_SCOPE_2_VW

    4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    5 BU_KEYED_TREE Character(1) VARCHAR2(1) NOT NULL Business Unit Keyed Tree

    Default Value: N

    6 HOW_FIELD_SPECIFY Character(1) VARCHAR2(1) NOT NULL How Specified
    1=All Detail Values
    2=Selected Detail Values
    3=Detail - Selected Parents
    4=Selected Tree Nodes
    5=Children at a Level
    6=All Nodes at Selected Levels
    7=Selected Summary ChrtFld Nodes
    9=Value Mask
    A=Account Type
    R=Range of Values

    Default Value: 1

    Prompt Table: NVS_SCOPE_1_VW

    7 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

    Prompt Table: %EDITTABLE2

    8 TREE_LEVEL Character(10) VARCHAR2(10) NOT NULL Tree Level Number

    Prompt Table: %EDITTABLE4

    9 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: EDITTABLE_VW