RAD_TMPL_PAG_LN(SQL Table) |
Index Back |
|---|---|
RAD Page ControlsPage Controls |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(20) | VARCHAR2(20) NOT NULL | Advisor Display Template Identifier - represent templates | |
| 2 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
| 3 | RAD_TMPL_QA_BOX | Character(30) | VARCHAR2(30) NOT NULL |
Question Box
Prompt Table: RB_STYLECLAS_VW |
| 4 | RAD_TMPL_QA_STYLE | Character(30) | VARCHAR2(30) NOT NULL |
Question Style Class
Prompt Table: RB_STYLECLAS_VW |
| 5 | RAD_TMPL_ANS_STYLE | Character(30) | VARCHAR2(30) NOT NULL |
Question Style Class
Prompt Table: RB_STYLECLAS_VW |
| 6 | RAD_TMPL_EXP_STYLE | Character(30) | VARCHAR2(30) NOT NULL |
Explanation Styleclass
Prompt Table: RB_STYLECLAS_VW |
| 7 | RAD_TMPL_PB_STYLE | Character(30) | VARCHAR2(30) NOT NULL |
Button StyleClass
Prompt Table: RB_STYLECLAS_VW |
| 8 | RAD_TMPL_PB_BOX | Character(30) | VARCHAR2(30) NOT NULL |
Action Box Style
Prompt Table: RB_STYLECLAS_VW |
| 9 | RAD_TMPL_EVENROW | Character(30) | VARCHAR2(30) NOT NULL |
Oddrow styleclass
Prompt Table: RB_STYLECLAS_VW |
| 10 | RAD_TMPL_ODDROW | Character(30) | VARCHAR2(30) NOT NULL |
Oddrow styleclass
Prompt Table: RB_STYLECLAS_VW |
| 11 | RAD_TMPL_QA_EXP | Character(30) | VARCHAR2(30) NOT NULL |
RAD Question Explanation Styleclass
Prompt Table: RB_STYLECLAS_VW |
| 12 | RAD_TMPL_NUM_QA | Character(1) | VARCHAR2(1) NOT NULL |
Should the Questions be numbered
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_SH_PGTLE | Character(1) | VARCHAR2(1) NOT NULL |
Show Dialog Title
Y/N Table Edit |
| 15 | RAD_TMPL_TITLE | Character(30) | VARCHAR2(30) NOT NULL |
Score Styleclass
Prompt Table: RB_STYLECLAS_VW |
| 16 | RAD_TMPL_SUBTITLE | Character(30) | VARCHAR2(30) NOT NULL |
Score Styleclass
Prompt Table: RB_STYLECLAS_VW |
| 17 | RAD_TMPL_PG_TITLE | Character(75) | VARCHAR2(75) NOT NULL | Page Title |
| 18 | RAD_EXPLAIN_ID | Character(20) | VARCHAR2(20) NOT NULL |
Advisor Explanation ID - internally represents an explanation
Prompt Table: RAD_EXPLAIN_PRT |
| 19 | RAD_IMG_LOC | Character(1) | VARCHAR2(1) NOT NULL |
Image Location
L=Left of Explanation R=Right of Explanation |
| 20 | RAD_TMPL_PATHGUIDE | Character(1) | VARCHAR2(1) NOT NULL |
Path Guide
Y/N Table Edit |
| 21 | RAD_TMPL_NDI_PAGE | Character(30) | VARCHAR2(30) NOT NULL |
Score Styleclass
Prompt Table: RB_STYLECLAS_VW |
| 22 | RAD_TMPL_NDI_QA | Character(30) | VARCHAR2(30) NOT NULL |
NDI Question Styleclass
Prompt Table: RB_STYLECLAS_VW |
| 23 | RAD_TMPL_NDI_AN | Character(30) | VARCHAR2(30) NOT NULL |
NDI Question Styleclass
Prompt Table: RB_STYLECLAS_VW |
| 24 | RAD_TMPL_NDI_PEL | Character(30) | VARCHAR2(30) NOT NULL |
Score Styleclass
Prompt Table: RB_STYLECLAS_VW |
| 25 | 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 |
| 26 | RAD_TMPL_INC_BR | Character(1) | VARCHAR2(1) NOT NULL |
Include Break Line
Y/N Table Edit |
| 27 | RAD_TMPL_PG_ROW | Character(30) | VARCHAR2(30) NOT NULL |
Score Styleclass
Prompt Table: RB_STYLECLAS_VW |
| 28 | RAD_TMPL_QA_ROW | Character(30) | VARCHAR2(30) NOT NULL |
Score Styleclass
Prompt Table: RB_STYLECLAS_VW |
| 29 | RAD_TMPL_BR_ROW | Character(30) | VARCHAR2(30) NOT NULL |
Score Styleclass
Prompt Table: RB_STYLECLAS_VW |
| 30 | PSIMAGEVER | Number(10,0) | DECIMAL(10) NOT NULL | Image Version |
| 31 | RAD_IMG_JPG | Image / Attachment | CLOB | Advisor Success Rate Image for Recommendations |