RAD_TMPL_REC_LN

(SQL Table)
 Index Back

RAD Recommendation Controls

Advisor Template Recommendation Controls, Language

  • Related Language Record for RAD_TMPL_RECOM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RAD_TEMPLATE_ID Character(20) VARCHAR2(20) NOT NULL Advisor Display Template Identifier - represent templates
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 RAD_RETURN_NUM Number(4,0) SMALLINT NOT NULL Advisor Recommendation threshold - number to retrun

    Default Value: 10

    4 RAD_TMPL_COMP_FLG Character(1) VARCHAR2(1) NOT NULL Compare Flag

    Y/N Table Edit

    5 RAD_TMPL_NEG_SCR Character(1) VARCHAR2(1) NOT NULL Show Negative Scores

    Y/N Table Edit

    6 RAD_TMPL_SRC_MIN Character(1) VARCHAR2(1) NOT NULL Score Minimum

    Y/N Table Edit

    7 RAD_TMPL_NUM_RECOM Character(1) VARCHAR2(1) NOT NULL Number to return

    Y/N Table Edit

    8 RAD_TMPL_REC_DISPL Character(1) VARCHAR2(1) NOT NULL Recommendation Template Display
    B=Use Both Number and Score
    N=Use Number Only
    S=Use Score Only

    Default Value: B

    9 RAD_MIN_SCORE Signed Number(6,0) DECIMAL(5) NOT NULL Minimum Score

    Default Value: 0

    10 RAD_TMPL_SCORE_TYP Character(1) VARCHAR2(1) NOT NULL Score Presentation
    I=Image Range
    N=Normalized List
    R=Ranking
    S=Raw Score

    Default Value: S

    11 RAD_TMPL_DFLT_CHAR Character(30) VARCHAR2(30) NOT NULL Default for empty Characteristic
    12 RAD_TMPL_RECOM_STY Character(30) VARCHAR2(30) NOT NULL RAd Style class for Recommendation box

    Prompt Table: RB_STYLECLAS_VW

    13 RAD_TMPL_ODDROW Character(30) VARCHAR2(30) NOT NULL Oddrow styleclass

    Prompt Table: RB_STYLECLAS_VW

    14 RAD_TMPL_EVENROW Character(30) VARCHAR2(30) NOT NULL Oddrow styleclass

    Prompt Table: RB_STYLECLAS_VW

    15 RAD_TMPL_LINK_STYL Character(30) VARCHAR2(30) NOT NULL Link Styleclass

    Prompt Table: RB_STYLECLAS_VW

    16 RAD_TMPL_DET_LAB Character(30) VARCHAR2(30) NOT NULL Advisor Recommendation Label Styleclass

    Prompt Table: RB_STYLECLAS_VW

    17 RAD_TMPL_DETAILS Character(30) VARCHAR2(30) NOT NULL Advisor Template Details fro Recommendation Styleclass
    18 RAD_TMPL_COMP_PB Character(30) VARCHAR2(30) NOT NULL Compare Button styleclass

    Prompt Table: RB_STYLECLAS_VW

    19 RAD_TMPL_SCR_STYLE Character(30) VARCHAR2(30) NOT NULL Score Styleclass

    Prompt Table: RB_STYLECLAS_VW

    20 RAD_TMPL_EXP_STYLE Character(30) VARCHAR2(30) NOT NULL Explanation Styleclass

    Prompt Table: RB_STYLECLAS_VW

    21 RAD_TMPL_PB_BOX Character(30) VARCHAR2(30) NOT NULL Action Box Style

    Prompt Table: RB_STYLECLAS_VW

    22 RAD_TMPL_PB_STYLE Character(30) VARCHAR2(30) NOT NULL Button StyleClass

    Prompt Table: RB_STYLECLAS_VW

    23 RAD_TMPL_RUNTIME Character(1) VARCHAR2(1) NOT NULL Flag whether to Show Passed information at Runtime

    Y/N Table Edit

    24 RAD_TMPL_SH_TITLE Character(1) VARCHAR2(1) NOT NULL Show Dialog Title

    Y/N Table Edit

    25 RAD_TMPL_SH_PGTLE Character(1) VARCHAR2(1) NOT NULL Show Dialog Title

    Y/N Table Edit

    26 RAD_TMPL_PG_TITLE Character(75) VARCHAR2(75) NOT NULL Page Title
    27 RAD_TMPL_TITLE Character(30) VARCHAR2(30) NOT NULL Score Styleclass

    Prompt Table: RB_STYLECLAS_VW

    28 RAD_TMPL_SUBTITLE Character(30) VARCHAR2(30) NOT NULL Score Styleclass

    Prompt Table: RB_STYLECLAS_VW

    29 RAD_IMG_LOC Character(1) VARCHAR2(1) NOT NULL Image Location
    L=Left of Explanation
    R=Right of Explanation
    30 RAD_EXPLAIN_ID Character(20) VARCHAR2(20) NOT NULL Advisor Explanation ID - internally represents an explanation

    Prompt Table: RAD_EXPLAIN_PRT

    31 PSIMAGEVER Number(10,0) DECIMAL(10) NOT NULL Image Version
    32 RAD_IMG_JPG Image / Attachment CLOB Advisor Success Rate Image for Recommendations