RBC_TMPL_PKG_VW (SQL View)	Index Back
CM Template Definition Correspondence Management Template Definition

RBC_TMPL_PKG_VW

(SQL View)

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 , B.ATTACHSYSFILENAME , B.ATTACHUSERFILE , C.RB_PACKAGE_ID , C.SEQ_NUM FROM PS_RBC_PACKAG_TMPL C ,PS_RBC_TEMPLAT_DFN A , PS_RBC_TEMPLAT_FIL B WHERE C.RB_TEMPLATE_ID = A.RB_TEMPLATE_ID AND C.RB_TEMPLATE_NAME = A.RB_TEMPLATE_NAME AND C.LANGUAGE_CD = A.LANGUAGE_CD AND A.RB_TEMPLATE_ID = B.RB_TEMPLATE_ID AND A.RB_TEMPLATE_NAME = B.RB_TEMPLATE_NAME AND A.LANGUAGE_CD = B.LANGUAGE_CD

# 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 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename

14 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File

15 RB_PACKAGE_ID Number(10,0) DECIMAL(10) NOT NULL Package

16 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

#	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	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
14	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
15	RB_PACKAGE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Package
16	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence