BCPGNAMETEMPLATE_IDPR=Private
PU=Public
FO_EMTMPL_VW(SQL View) |
Index Back |
|---|---|
Email Template View |
| SELECT C.BCPGNAME , T.TEMPLATE_ID , T.DESCR , C.BCNAME , T.TEMPLATE_ACCESS , T.OPRID FROM PS_FO_EMAIL_CI C , PS_FO_EMAIL_TMPL T WHERE T.TEMPLATE_ID = C.TEMPLATE_ID AND T.ACTIVE_FLAG = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BCPGNAME |
Character(30) | VARCHAR2(30) NOT NULL | Panel Group Name |
| 2 | TEMPLATE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Project Template |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | BCNAME | Character(30) | VARCHAR2(30) NOT NULL | Business Component Name (see PSBCDEFN). |
| 5 | TEMPLATE_ACCESS | Character(2) | VARCHAR2(2) NOT NULL |
Template Access
PR=Private PU=Public |
| 6 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |