RBD_CONT_AREAOCD=Order Capture Dashboard
SDB=Service Dashboard
SLD=Sales Dashboard
RB_USAGE_IDRB_USAGE_NAMERBD_EML_TMPL_VW(SQL View) |
Index Back |
|---|---|
Dashboard Email TemplateThis is the record for the Dashboard Email Template view. |
| SELECT A.RBD_CONT_AREA , B.RB_USAGE_ID , B.RB_USAGE_NAME , C.RB_PACKAGE_ID , E.RB_TEMPLATE_ID , E.RB_TEMPLATE_NAME , F.SUBJECT , F.MSG_TEXT FROM %Table(RBD_EML_TMPL) A , %Table(RBC_USAGE_DFN) B , %Table(RBC_PACKAGE_USG) C , %Table(RBC_PACKAG_TMPL) D , %Table(RBC_TEMPLAT_FIL) E , %Table(RBC_INTLAYOUT) F WHERE A.RB_USAGE_ID = B.RB_USAGE_ID AND B.RB_USAGE_ID = C.RB_USAGE_ID AND C.RB_PACKAGE_ID = D.RB_PACKAGE_ID AND D.RB_TEMPLATE_ID = E.RB_TEMPLATE_ID AND E.RB_ILAYOUT_ID = F.RB_ILAYOUT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RBD_CONT_AREA |
Character(3) | VARCHAR2(3) NOT NULL |
This is the field for the Content Area designations.
OCD=Order Capture Dashboard SDB=Service Dashboard SLD=Sales Dashboard |
| 2 | RB_USAGE_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Unique Usage Identifier |
| 3 | RB_USAGE_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Usage Name |
| 4 | RB_PACKAGE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Package |
| 5 | RB_TEMPLATE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Template ID |
| 6 | RB_TEMPLATE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Template Name |
| 7 | SUBJECT | Character(254) | VARCHAR2(254) NOT NULL | Subject |
| 8 | MSG_TEXT | Long Character | CLOB | Message Text for Correspondence Management processing. |