RAD_TEMPLATE_IDRAD_TMPL_NAMERAD_TMPL_ADD(SQL View) |
Index Back |
|---|---|
Search Record for TemplatesDisplay Template for Advisor Search for Add Mode |
| SELECT A.RAD_TEMPLATE_ID , A.RAD_TMPL_NAME FROM PS_RAD_TEMPLATE A , PS_RAD_TMPL_PAGE B , PS_RAD_TMPL_RECOM C , PS_RAD_TMPL_COMP D , PS_RAD_TMPL_VWANS E WHERE A.RAD_TEMPLATE_ID = B.RAD_TEMPLATE_ID AND A.RAD_TEMPLATE_ID = C.RAD_TEMPLATE_ID AND A.RAD_TEMPLATE_ID = D.RAD_TEMPLATE_ID AND A.RAD_TEMPLATE_ID = E.RAD_TEMPLATE_ID |
| # | 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_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Advisor Display Template Name or short description |