BCPGNAMETEMPLATE_IDPR=Private
PU=Public
FO_ROLE_TMPL_VW(SQL View) |
Index Back |
|---|---|
Template-Role ViewView for templates based on role. |
| SELECT DISTINCT C.BCPGNAME , T.TEMPLATE_ID , T.DESCR , C.BCNAME , T.TEMPLATE_ACCESS , B.OPRID ,A.FO_SINGLE_MAIL ,A.FO_MULTIPLE_MAIL FROM PS_FO_EMAIL_CI C , PS_FO_EMAIL_TMPL T , PS_FO_ROLE_TMPL A , PSROLEUSER_VW B WHERE T.TEMPLATE_ID = C.TEMPLATE_ID AND T.ACTIVE_FLAG = 'A' AND A.ROLENAME = B.ROLENAME AND A.TEMPLATE_ID = C.TEMPLATE_ID AND T.DESCR = A.DESCR |
| # | 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). |
| 7 | FO_SINGLE_MAIL | Character(1) | VARCHAR2(1) NOT NULL | Single mail template field |
| 8 | FO_MULTIPLE_MAIL | Character(1) | VARCHAR2(1) NOT NULL | multiple mail template field |