RAD_TMPL_SRCH(SQL View) |
Index Back |
---|---|
Search Record for TemplatesDisplay Template for Advisor Search |
SELECT A.RAD_TEMPLATE_ID , A.RAD_TMPL_NAME , A.RAD_STATUS 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 |
3 | RAD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status
A=Active I=Inactive |