TEMPLATE_IDFO_TEMPNAME_VW(SQL View) |
Index Back |
|---|---|
View for look-up tableView to get the Template name for the look-up table. |
| SELECT TEMPLATE_ID , DESCR FROM PS_FO_EMAIL_TMPL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TEMPLATE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Project Template |
| 2 | TEMPLATE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Template Description |