RAD_TMPL_COMP(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_DFLT_CHAR | Character(30) | VARCHAR2(30) NOT NULL | Default for empty Characteristic |
| 3 | RAD_TMPL_SCR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Show Score
Y/N Table Edit |
| 4 | RAD_TMPL_COMP_STYL | Character(30) | VARCHAR2(30) NOT NULL |
RAD Comparison Box Styleclass
Prompt Table: RB_STYLECLAS_VW |
| 5 | RAD_TMPL_EVENROW | Character(30) | VARCHAR2(30) NOT NULL |
Oddrow styleclass
Prompt Table: RB_STYLECLAS_VW |
| 6 | RAD_TMPL_ODDROW | Character(30) | VARCHAR2(30) NOT NULL |
Oddrow styleclass
Prompt Table: RB_STYLECLAS_VW |
| 7 | RAD_TMPL_LINK_STYL | Character(30) | VARCHAR2(30) NOT NULL |
Link Styleclass
Prompt Table: RB_STYLECLAS_VW |
| 8 | RAD_TMPL_CRIT_STYL | Character(30) | VARCHAR2(30) NOT NULL |
Criteria
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_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_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_PG_TITLE | Character(75) | VARCHAR2(75) NOT NULL | Page Title |
| 17 | RAD_TMPL_RUNTIME | Character(1) | VARCHAR2(1) NOT NULL |
Flag whether to Show Passed information at Runtime
Y/N Table Edit |
| 18 | RAD_IMG_LOC | Character(1) | VARCHAR2(1) NOT NULL |
Image Location
L=Left of Explanation R=Right of Explanation |
| 19 | RAD_EXPLAIN_ID | Character(20) | VARCHAR2(20) NOT NULL |
Advisor Explanation ID - internally represents an explanation
Prompt Table: RAD_EXPLAIN_PRT |
| 20 | PSIMAGEVER | Number(10,0) | DECIMAL(10) NOT NULL | Image Version |
| 21 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 22 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 23 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 24 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 25 | 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. |
| 26 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |
| 27 | RAD_IMG_JPG | Image / Attachment | CLOB | Advisor Success Rate Image for Recommendations |