| RAD_TMPL_PRMPT(SQL View) | Index Back | 
|---|---|
| Template PromptTemplate Prompt | 
| SELECT RAD_TEMPLATE_ID , RAD_TMPL_NAME FROM PS_RAD_TEMPLATE WHERE RAD_STATUS = 'A' | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | 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 Prompt Table: RAD_TMPL_PRMPT |