RB_SRCH_PARMS

(SQL Table)
 Index Back

Search Parameters

Used to save System Wide Parameters used for Verity Searches.

  • Related Language Record: RB_SRCH_PARMSLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SRCH_COLLECTN_NAME Character(28) VARCHAR2(28) NOT NULL Search Collection Name
    2 RB_COLLECTION_NAME Character(30) VARCHAR2(30) NOT NULL Used to specify the Search Collection Name
    3 RB_COLLECTN_NAME2 Character(30) VARCHAR2(30) NOT NULL Used to specify the Temporary Search Collection Name that is built then renamed to the Search Collection Name.
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 RB_AGING_INTERVAL Number(3,0) SMALLINT NOT NULL Specifies the aging interval between the last update of the usage count of an object and the time the value is decremented. Used by Verity Searches.

    Default Value: 30

    6 RB_USAGE_INCREMENT Number(3,0) SMALLINT NOT NULL Specifies the usage decrement of an object each time the age interval has expired. Used by Verity Searches.

    Default Value: 1

    7 RB_USAGE_DECREMENT Number(3,0) SMALLINT NOT NULL Specifies the Usage increment of an object eact time the object is selected via the 'Use' feature.

    Default Value: 1

    8 RB_CREATE_DTTM DateTime(26) TIMESTAMP Created date time
    9 RB_UPDATE_DTTM DateTime(26) TIMESTAMP Updated Date Time
    10 RB_OPTIMIZE_FREQ Number(3,0) SMALLINT NOT NULL Specifies the aging interval between the last update of the usage count of an object and the time the value is decremented. Used by Verity Searches.

    Default Value: 5

    11 RB_INCRUPD_COUNT Number(10,0) DECIMAL(10) NOT NULL Specifies the aging interval between the last update of the usage count of an object and the time the value is decremented. Used by Verity Searches.

    Default Value: 0

    12 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
    13 SCHEDULENAME Character(30) VARCHAR2(30) NOT NULL Schedule Name

    Prompt Table: RB_SCHDLDEFN_VW

    14 VQL_OPERATOR Character(1) VARCHAR2(1) NOT NULL VQL Operator
    15 JOBNAMESRC Character(8) VARCHAR2(8) NOT NULL Job Name Source

    Prompt Table: SCHDLDEFN

    16 RC_MAINT_OWNER Character(1) VARCHAR2(1) NOT NULL Call center Maintenance Owner
    0=PeopleSoft
    1=PeopleSoft / Customer Modified
    2=Customer

    Default Value: 2

    17 SYSD_APPLICATION01 Character(1) VARCHAR2(1) NOT NULL PS CRM Core
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    18 SYSD_APPLICATION02 Character(1) VARCHAR2(1) NOT NULL Financial Services
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    19 SYSD_APPLICATION03 Character(1) VARCHAR2(1) NOT NULL Telecommunications
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    20 SYSD_APPLICATION04 Character(1) VARCHAR2(1) NOT NULL Government
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    21 SYSD_APPLICATION05 Character(1) VARCHAR2(1) NOT NULL Energy
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    22 SYSD_APPLICATION06 Character(1) VARCHAR2(1) NOT NULL Insurance
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    23 SYSD_APPLICATION07 Character(1) VARCHAR2(1) NOT NULL High Technology
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    24 SYSD_APPLICATION08 Character(1) VARCHAR2(1) NOT NULL HR HelpDesk
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    25 SYSD_APPLICATION09 Character(1) VARCHAR2(1) NOT NULL System Data Field for Application 9. Application 9 is used for Wealth Management.
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    26 SYSD_APPLICATION10 Character(1) VARCHAR2(1) NOT NULL Used in Application 10
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    27 RB_BIF_DOC_COUNT Number(6,0) INTEGER NOT NULL Maximum number of documents per BIF (Bulk Insert) file.

    Default Value: 5000