RBC_TOKEN_DTL

(SQL Table)
 Index Back

CM Token Definition Table

Correspondence Management native token definition

  • Related Language Record: RBC_TOKN_DTL_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RB_TOKEN_NAME Character(30) VARCHAR2(30) NOT NULL Correspondence Management Token Name
    2 RB_TOKEN_ID Number(31,0) DECIMAL(31) NOT NULL Unique Token Identifier
    3 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

    Prompt Table: RBC_PANELGRP_VW

    4 MARKET Character(3) VARCHAR2(3) NOT NULL Market

    Default Value: GBL

    5 RB_USAGE_ID Number(10,0) DECIMAL(10) NOT NULL Unique Usage Identifier
    6 RB_TKN_RESL_BY Character(4) VARCHAR2(4) NOT NULL Identifies the data source for the token
    APP=Application Class
    CI=Component Interface
    CNST=Constant
    QRY=PS Query
    SYS=System Variable

    Default Value: CI

    7 BCNAME Character(30) VARCHAR2(30) NOT NULL Business Component Name (see PSBCDEFN).

    Prompt Table: RBC_TKN_CI_VW

    8 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

    Prompt Table: RBC_APPCLASS_VW

    9 METHODNAME Character(32) VARCHAR2(32) NOT NULL Method Name
    10 APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path

    Prompt Table: RBC_APPRTPATH_V

    11 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name

    Prompt Table: RBC_PSQRY_VW

    12 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: %EDITTABLE39

    13 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: %EDITTABLE40

    14 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    15 RC_MAINT_OWNER Character(1) VARCHAR2(1) NOT NULL Call center Maintenance Owner
    0=PeopleSoft
    1=PeopleSoft / Customer Modified
    2=Customer

    Default Value: 2

    16 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

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    24 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

    25 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