FSPC_USR_QRYGRP

(SQL Table)
Index Back

User Pagelet Config - Queries

User level configuration

  • Related Language Record: FSPC_USR_QGRP_L
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PAGELET_CONFIG_ID Character(18) VARCHAR2(18) NOT NULL FSWC-Workcenter ID
    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 FSPC_GROUP_ID Character(36) VARCHAR2(36) NOT NULL Group ID
    4 FSPC_DESCR Character(40) VARCHAR2(40) NOT NULL Group Label
    5 COLLAPSE_PB Character(1) VARCHAR2(1) NOT NULL Start Group Collapsed

    Y/N Table Edit

    Default Value: N

    6 DISPLAY_ORDER Number(3,0) SMALLINT NOT NULL Display order for ordering items in a list - web style
    7 FSPC_DATA_SOURCE Character(1) VARCHAR2(1) NOT NULL Data Source
    1=Administrator
    2=User

    Default Value: 2