CAFF_VIEWBY

(SQL Table)
Index Back

CAF FILTER View By Definition

CAF FILTER BUILDER - View By Definition

  • Related Language Record: CAFF_VIEWBY_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPERATOR_VW

    2 PAGELET_CONFIG_ID Character(18) VARCHAR2(18) NOT NULL FSWC-Workcenter ID
    3 CAFF_VIEWBY Character(36) VARCHAR2(36) NOT NULL Filter criteria identification
    4 FSPC_DESCR Character(40) VARCHAR2(40) NOT NULL Description
    5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    6 DEFAULT_FLAG Character(1) VARCHAR2(1) NOT NULL Default

    Y/N Table Edit

    Default Value: N

    7 SHOW_LINK Character(1) VARCHAR2(1) NOT NULL FSWC - Show Link

    Y/N Table Edit

    Default Value: Y

    8 DISPLAY_ORDER Number(3,0) SMALLINT NOT NULL Display order for ordering items in a list - web style