RAD_TMPL_VWA_LN(SQL Table) |
Index Back |
|---|---|
RAD Recommendation ControlsRecommendation Controls |
| # | 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_TMPL_TITLE | Character(30) | VARCHAR2(30) NOT NULL |
Score Styleclass
Prompt Table: RB_STYLECLAS_VW |
| 4 | RAD_TMPL_SUBTITLE | Character(30) | VARCHAR2(30) NOT NULL |
Score Styleclass
Prompt Table: RB_STYLECLAS_VW |
| 5 | RAD_TMPL_PG_NAV | Character(30) | VARCHAR2(30) NOT NULL |
Page Navigation Text style
Prompt Table: RB_STYLECLAS_VW |
| 6 | RAD_TMPL_PG_BOX | Character(30) | VARCHAR2(30) NOT NULL |
Page Navigation Text style
Prompt Table: RB_STYLECLAS_VW |
| 7 | RAD_TMPL_QA_STYLE | Character(30) | VARCHAR2(30) NOT NULL |
Question Style Class
Prompt Table: RB_STYLECLAS_VW |
| 8 | RAD_TMPL_ANS_STYLE | Character(30) | VARCHAR2(30) NOT NULL |
Question Style Class
Prompt Table: RB_STYLECLAS_VW |
| 9 | RAD_TMPL_EXP_STYLE | Character(30) | VARCHAR2(30) NOT NULL |
Explanation Styleclass
Prompt Table: RB_STYLECLAS_VW |
| 10 | RAD_TMPL_ANS_LOC | Character(1) | VARCHAR2(1) NOT NULL |
Answer Location
B=Below Question N=Next to Question Default Value: B |
| 11 | RAD_TMPL_PB_BOX | Character(30) | VARCHAR2(30) NOT NULL |
Action Box Style
Prompt Table: RB_STYLECLAS_VW |
| 12 | RAD_TMPL_PB_STYLE | Character(30) | VARCHAR2(30) NOT NULL |
Button StyleClass
Prompt Table: RB_STYLECLAS_VW |
| 13 | RAD_TMPL_SH_PGTLE | Character(1) | VARCHAR2(1) NOT NULL |
Show Dialog Title
Y/N Table Edit |
| 14 | RAD_TMPL_SH_TITLE | Character(1) | VARCHAR2(1) NOT NULL |
Show Dialog Title
Y/N Table Edit |
| 15 | RAD_TMPL_PG_TITLE | Character(75) | VARCHAR2(75) NOT NULL | Page Title |
| 16 | RAD_IMG_LOC | Character(1) | VARCHAR2(1) NOT NULL |
Image Location
L=Left of Explanation R=Right of Explanation |
| 17 | RAD_EXPLAIN_ID | Character(20) | VARCHAR2(20) NOT NULL |
Advisor Explanation ID - internally represents an explanation
Prompt Table: RAD_EXPLAIN_PRT |
| 18 | PSIMAGEVER | Number(10,0) | DECIMAL(10) NOT NULL | Image Version |
| 19 | RAD_IMG_JPG | Image / Attachment | CLOB | Advisor Success Rate Image for Recommendations |