RAD_TMPL_SRCH

(SQL View)
Index Back

Search Record for Templates

Display 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

  • Related Language Record: RAD_TMPL_SRCHL
  • # 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