RDT_TMPL_OPT

(SQL Table)
 Index Back

Configured general options

Configured general options for the display template.

  • Related Language Record: RDT_TMPL_OPT_L

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DISP_TMPL_ID Character(30) VARCHAR2(30) NOT NULL Template identifier to define the display template.
    2 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    3 MARKET Character(3) VARCHAR2(3) NOT NULL Market
    4 RB_APPCLASS_EXT Character(15) VARCHAR2(15) NOT NULL Application Class Set

    Prompt Table: RB_APPSET_EXTVW

    5 ADAPTER_ID Character(20) VARCHAR2(20) NOT NULL Adapter ID

    Prompt Table: RBQ_ADPTR

    6 VERSION_360 Character(4) VARCHAR2(4) NOT NULL Corresponding 360 version to be used for the configurable component.
    CUST=Customer
    HIED=Constituent
    HRHD=HRHD Worker
    PART=Partner
    WORK=Worker
    7 LIC_PROD_CD Character(18) VARCHAR2(18) NOT NULL Licensed product code for the configurable component.

    Prompt Table: LIC_PROD_CD_VW

    8 LIC_PROD_DESCR Character(30) VARCHAR2(30) NOT NULL Licensed product description for the configurable component.
    9 SS_CONFIRM_FLG Character(1) VARCHAR2(1) NOT NULL Flag to determine whether to display the confirmation page upon save. (applicable for call center self-service case pages)
    N=No
    Y=Yes

    Default Value: N

    10 RC_PREDEFN_ID Character(10) VARCHAR2(10) NOT NULL Pre-defined search definition to be used for the configurable component. (applicable for call center self-service case components)

    Prompt Table: RC_DEFNSRCH_HDR

    11 SEARCH_DEFN_NAME Character(30) VARCHAR2(30) NOT NULL Search Definition Name

    Prompt Table: RB_VRTY_PG_CFG

    12 EMAIL_FORMID_NOTE Character(20) VARCHAR2(20) NOT NULL Email Form ID to use for Emailing Case Notes

    Prompt Table: RBC_PACKG_DT_VW

    13 EMAIL_FORMID_SOLN Character(20) VARCHAR2(20) NOT NULL email form id to use for emailing solutions

    Prompt Table: RBC_PACKG_DT_VW

    14 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).

    Prompt Table: RB_TD_PORTAL_VW

    15 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name

    Prompt Table: RB_TD_POBJ_VW

    16 LINK_GROUP Character(5) VARCHAR2(5) NOT NULL Link Group setup table

    Prompt Table: RC_LINK_GROUP

    17 APPLICATION_USAGE Character(4) VARCHAR2(4) NOT NULL Application Usage. Holds the info about the application.
    ALL=All Applications
    CHMG=Change Management
    EVNT=Marketing Events
    FLDS=Field Service
    HIED=Higher Education
    HLPD=HelpDesk
    HRHD=HR Helpdesk
    LEAD=Lead
    OPPY=Opportunity
    PIM=Personal Information Mgmt
    RSP=Strategic Planning
    SALS=Sales
    SUPP=Support
    18 SITE_ONLY Character(1) VARCHAR2(1) NOT NULL Site Only Case
    N=No
    Y=Yes

    Default Value: N

    19 ASSET_INT_FLAG Character(1) VARCHAR2(1) NOT NULL Yes/No Flag used to indicate if integration to Asset management system is turned on or off
    N=No
    Y=Yes

    Default Value: N

    20 CACHE_SEQ_NUMBER Number(20,0) DECIMAL(20) NOT NULL Sequence number to assign when expanding all the fields in a page including subpages
    21 TOOLBAR_ID Character(30) VARCHAR2(30) NOT NULL TOOLBAR_ID

    Prompt Table: RB_TOOLBAR_DEFN

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

    Default Value: 2

    23 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

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    31 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

    32 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

    33 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    34 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    35 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    36 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    37 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    38 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time