RBC_TMPL_EML_VW

(SQL View)
 Index Back

CM Template Definition

Correspondence Management Template Definition

SELECT A.RB_TEMPLATE_ID , A.RB_TEMPLATE_NAME , A.LANGUAGE_CD , A.EFF_STATUS , A.DESCR , A.FROM_DATE , A.TO_DATE , A.RB_SECURITY , A.ROW_ADDED_OPRID , B.RB_DELV_CHANNEL , B.RB_ILAYOUT_ID , B.RB_ILAYOUT_NAME , C.SUBJECT , C.MSG_TEXT FROM PS_RBC_TEMPLAT_DFN A , PS_RBC_TEMPLAT_FIL B , PS_RBC_INTLAYOUT C WHERE A.RB_TEMPLATE_ID = B.RB_TEMPLATE_ID AND A.RB_TEMPLATE_NAME = B.RB_TEMPLATE_NAME AND A.LANGUAGE_CD = B.LANGUAGE_CD AND B.RB_ILAYOUT_NAME = C.RB_ILAYOUT_NAME AND B.RB_ILAYOUT_ID = C.RB_ILAYOUT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RB_TEMPLATE_ID Number(10,0) DECIMAL(10) NOT NULL Template ID
2 RB_TEMPLATE_NAME Character(30) VARCHAR2(30) NOT NULL Template Name
3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 FROM_DATE Date(10) DATE From Date
7 TO_DATE Date(10) DATE To Date
8 RB_SECURITY Character(4) VARCHAR2(4) NOT NULL Identifies the security
0=Shared
1=My Use Only

Default Value: 0

9 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
10 RB_DELV_CHANNEL Character(1) VARCHAR2(1) NOT NULL Delivery Channel. Please make sure to update the RB_DELV_CHANNEL2 field with the XLAT values in future when Fax channel is enabled. RB_DELV_CHANNEL2 field is used in the Correspondence search.
0=All
1=Email
2=Print
3=Fax
4=Print & Fax
11 RB_ILAYOUT_ID Number(10,0) DECIMAL(10) NOT NULL Internal Layout (Template)
12 RB_ILAYOUT_NAME Character(30) VARCHAR2(30) NOT NULL Internal Layout (Template) Name
13 SUBJECT Character(254) VARCHAR2(254) NOT NULL Subject
14 MSG_TEXT Long Character CLOB Message Text for Correspondence Management processing.