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 NameField TypeColumn TypeDescription
    SETIDCharacter(5)VARCHAR2(5) NOT NULLSetID
    REPORT_SCOPECharacter(10)VARCHAR2(10) NOT NULLReport Scope
    FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).

    Prompt Table: NVS_SCOPE_2_VW

    BUSINESS_UNITCharacter(5)VARCHAR2(5) NOT NULLBusiness Unit
    BU_KEYED_TREECharacter(1)VARCHAR2(1) NOT NULLBusiness Unit Keyed Tree

    Default: N

    HOW_FIELD_SPECIFYCharacter(1)VARCHAR2(1) NOT NULLHow 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_NAMECharacter(18)VARCHAR2(18) NOT NULLTree Name

    Prompt Table: %EDITTABLE2

    TREE_LEVELCharacter(10)VARCHAR2(10) NOT NULLTree Level Number

    Prompt Table: %EDITTABLE4

    RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).

    Prompt Table: EDITTABLE_VW

    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19