RAD_TEMPLATE_IDLANGUAGE_CDPrompt Table: RAD_TMPL_PRMPT
RAD_TMPL_PRMPL(SQL View) |
Index Back |
|---|---|
Template PromptTemplate Prompt |
| SELECT A.RAD_TEMPLATE_ID , A.LANGUAGE_CD , A.RAD_TMPL_NAME FROM PS_RAD_TEMPLATE_LN A , PS_RAD_TEMPLATE B WHERE A.RAD_TEMPLATE_ID = B.RAD_TEMPLATE_ID AND B.RAD_STATUS = 'A' |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | RAD_TMPL_NAME | Character(30) | VARCHAR2(30) NOT NULL |
Advisor Display Template Name or short description
Prompt Table: RAD_TMPL_PRMPT |