RC_SG_RECORD

(SQL Table)
Index Back

Search Group Rec Setup

Search Group Record Setup. Store record information related.

  • Related Language Record: RC_SG_RECORD_LN
  • Parent record: RC_SEARCH_GROUP
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SEARCH_GROUP_ID Number(6,0) INTEGER NOT NULL Search Group ID
    2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: RC_IDX_TMPLT_VW

    3 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description
    4 REC_TYPE Character(3) VARCHAR2(3) NOT NULL Record Type of solution search group. It's a translated field contains different type of searchable solutions. It is used to transfer different solution page based on the type.
    CAS=Case
    DEF=Defect
    ERR=Error
    FIL=File
    FIX=Fix
    LIN=Link
    SOD=Service Order
    SOL=Solution
    TSG=Troubleshooting Guide
    5 ID_FIELDNAME Character(18) VARCHAR2(18) NOT NULL ID Fieldname

    Prompt Table: RB_SRCHIDX_SGVW

    6 TITLE_FIELDNAME Character(18) VARCHAR2(18) NOT NULL used by search group setup to contain the title of the field name

    Prompt Table: RB_SRCHIDX_SGVW

    7 SUMMARY_FIELDNAME Character(18) VARCHAR2(18) NOT NULL used by search group setup to contain the field name

    Prompt Table: RB_SRCHIDX_SGVW

    8 SUMMARY_FIELD_LEN Number(5,0) INTEGER NOT NULL used by search group setup to contain the length of the field name
    9 RC_MAINT_OWNER Character(1) VARCHAR2(1) NOT NULL Call center Maintenance Owner
    0=PeopleSoft
    1=PeopleSoft / Customer Modified
    2=Customer

    Default Value: 2

    10 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

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    18 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

    19 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