RAD_TMPL_VWANS(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 | RAD_TMPL_TITLE | Character(30) | VARCHAR2(30) NOT NULL |
Score Styleclass
Prompt Table: RB_STYLECLAS_VW |
| 3 | RAD_TMPL_SUBTITLE | Character(30) | VARCHAR2(30) NOT NULL |
Score Styleclass
Prompt Table: RB_STYLECLAS_VW |
| 4 | RAD_TMPL_PG_NAV | Character(30) | VARCHAR2(30) NOT NULL |
Page Navigation Text style
Prompt Table: RB_STYLECLAS_VW |
| 5 | RAD_TMPL_PG_BOX | Character(30) | VARCHAR2(30) NOT NULL |
Page Navigation Text style
Prompt Table: RB_STYLECLAS_VW |
| 6 | RAD_TMPL_QA_STYLE | Character(30) | VARCHAR2(30) NOT NULL |
Question Style Class
Prompt Table: RB_STYLECLAS_VW |
| 7 | RAD_TMPL_ANS_STYLE | Character(30) | VARCHAR2(30) NOT NULL |
Question Style Class
Prompt Table: RB_STYLECLAS_VW |
| 8 | RAD_TMPL_EXP_STYLE | Character(30) | VARCHAR2(30) NOT NULL |
Explanation Styleclass
Prompt Table: RB_STYLECLAS_VW |
| 9 | RAD_TMPL_ANS_LOC | Character(1) | VARCHAR2(1) NOT NULL |
Answer Location
B=Below Question N=Next to Question Default Value: B |
| 10 | RAD_TMPL_PB_BOX | Character(30) | VARCHAR2(30) NOT NULL |
Action Box Style
Prompt Table: RB_STYLECLAS_VW |
| 11 | RAD_TMPL_PB_STYLE | Character(30) | VARCHAR2(30) NOT NULL |
Button StyleClass
Prompt Table: RB_STYLECLAS_VW |
| 12 | RAD_TMPL_SH_PGTLE | Character(1) | VARCHAR2(1) NOT NULL |
Show Dialog Title
Y/N Table Edit |
| 13 | RAD_TMPL_SH_TITLE | Character(1) | VARCHAR2(1) NOT NULL |
Show Dialog Title
Y/N Table Edit |
| 14 | RAD_TMPL_PG_TITLE | Character(75) | VARCHAR2(75) NOT NULL | Page Title |
| 15 | RAD_IMG_LOC | Character(1) | VARCHAR2(1) NOT NULL |
Image Location
L=Left of Explanation R=Right of Explanation |
| 16 | RAD_EXPLAIN_ID | Character(20) | VARCHAR2(20) NOT NULL |
Advisor Explanation ID - internally represents an explanation
Prompt Table: RAD_EXPLAIN_PRT |
| 17 | PSIMAGEVER | Number(10,0) | DECIMAL(10) NOT NULL | Image Version |
| 18 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 19 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 20 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 21 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 22 | 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. |
| 23 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |
| 24 | RAD_IMG_JPG | Image / Attachment | CLOB | Advisor Success Rate Image for Recommendations |