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 Field Type Column Type Description
    SETID Character(5) VARCHAR2(5) NOT NULL SetID
    REPORT_SCOPE Character(10) VARCHAR2(10) NOT NULL Report Scope
    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: NVS_SCOPE_2_VW

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

    Default: N

    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: 1

    Prompt Table: NVS_SCOPE_1_VW

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

    Prompt Table: %EDITTABLE2

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

    Prompt Table: %EDITTABLE4

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

    Prompt Table: EDITTABLE_VW

    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20