RAD_TMPL_PAGE

(SQL Table)
 Index Back

RAD Page Controls

Page Controls

  • Related Language Record: RAD_TMPL_PAG_LN

    • # 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 RAD_TMPL_QA_BOX Character(30) VARCHAR2(30) NOT NULL Question Box

    Prompt Table: RB_STYLECLAS_VW

    3 RAD_TMPL_QA_STYLE Character(30) VARCHAR2(30) NOT NULL Question Style Class

    Prompt Table: RB_STYLECLAS_VW

    4 RAD_TMPL_ANS_STYLE Character(30) VARCHAR2(30) NOT NULL Question Style Class

    Prompt Table: RB_STYLECLAS_VW

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

    Prompt Table: RB_STYLECLAS_VW

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

    Prompt Table: RB_STYLECLAS_VW

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

    Prompt Table: RB_STYLECLAS_VW

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

    Prompt Table: RB_STYLECLAS_VW

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

    Prompt Table: RB_STYLECLAS_VW

    10 RAD_TMPL_QA_EXP Character(30) VARCHAR2(30) NOT NULL RAD Question Explanation Styleclass

    Prompt Table: RB_STYLECLAS_VW

    11 RAD_TMPL_NUM_QA Character(1) VARCHAR2(1) NOT NULL Should the Questions be numbered

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

    14 RAD_TMPL_TITLE Character(30) VARCHAR2(30) NOT NULL Score Styleclass

    Prompt Table: RB_STYLECLAS_VW

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

    Prompt Table: RB_STYLECLAS_VW

    16 RAD_TMPL_ERROR Character(30) VARCHAR2(30) NOT NULL Error Styleclass

    Prompt Table: RB_STYLECLAS_VW

    17 RAD_TMPL_ERROR_QA Character(30) VARCHAR2(30) NOT NULL Error Question Styleclass

    Prompt Table: RB_STYLECLAS_VW

    18 RAD_TMPL_PG_TITLE Character(75) VARCHAR2(75) NOT NULL Page Title
    19 RAD_EXPLAIN_ID Character(20) VARCHAR2(20) NOT NULL Advisor Explanation ID - internally represents an explanation

    Prompt Table: RAD_EXPLAIN_PRT

    20 RAD_IMG_LOC Character(1) VARCHAR2(1) NOT NULL Image Location
    L=Left of Explanation
    R=Right of Explanation
    21 RAD_TMPL_PATHGUIDE Character(1) VARCHAR2(1) NOT NULL Path Guide

    Y/N Table Edit

    22 RAD_TMPL_NDI_PAGE Character(30) VARCHAR2(30) NOT NULL Score Styleclass

    Prompt Table: RB_STYLECLAS_VW

    23 RAD_TMPL_NDI_QA Character(30) VARCHAR2(30) NOT NULL NDI Question Styleclass

    Prompt Table: RB_STYLECLAS_VW

    24 RAD_TMPL_NDI_AN Character(30) VARCHAR2(30) NOT NULL NDI Question Styleclass

    Prompt Table: RB_STYLECLAS_VW

    25 RAD_TMPL_NDI_PEL Character(30) VARCHAR2(30) NOT NULL Score Styleclass

    Prompt Table: RB_STYLECLAS_VW

    26 RAD_TMPL_NDI_LINK Character(1) VARCHAR2(1) NOT NULL Edit Link
    A=Answer Only
    B=Both Page and Answer
    N=Neither Page nor Answer
    P=Page Only
    27 RAD_TMPL_INC_BR Character(1) VARCHAR2(1) NOT NULL Include Break Line

    Y/N Table Edit

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

    Prompt Table: RB_STYLECLAS_VW

    29 RAD_TMPL_QA_ROW Character(30) VARCHAR2(30) NOT NULL Score Styleclass

    Prompt Table: RB_STYLECLAS_VW

    30 RAD_TMPL_BR_ROW Character(30) VARCHAR2(30) NOT NULL Score Styleclass

    Prompt Table: RB_STYLECLAS_VW

    31 PSIMAGEVER Number(10,0) DECIMAL(10) NOT NULL Image Version
    32 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    33 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    34 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    35 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    36 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.
    37 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
    38 RAD_IMG_JPG Image / Attachment CLOB Advisor Success Rate Image for Recommendations