RBC_PKG_CLTR_V1

(SQL View)
 Index Back

Template Package View

Correspondence Management Template Package View

SELECT DISTINCT A.RB_PACKAGE_ID , A.RB_PACKAGE_NAME , A.LANGUAGE_CD , A.DESCR , A.EFF_STATUS , A.FROM_DATE , A.TO_DATE , A.RB_SECURITY , A.OPRID , C.MARKET , C.PNLGRPNAME , ' ' , A.RB_TEMPLATE_ID , A.RB_TEMPLATE_NAME , E.FROM_DATE , E.TO_DATE , F.RB_DELV_CHANNEL , E.RB_SECURITY , E.OPRID FROM PS_RBC_PACKAGE_DFN A , PS_RBC_PACKAGE_USG B , PS_RBC_USAGE_DTL C , PS_RBC_TEMPLAT_DFN E , PS_RBC_TEMPLAT_FIL F WHERE A.EFF_STATUS = 'A' AND A.WORKFLOW_IND <> 'Y' AND DOCUMENT_FLAG <> 'Y' AND A.RB_PACKAGE_ID = B.RB_PACKAGE_ID AND A.RB_PACKAGE_NAME = B.RB_PACKAGE_NAME AND A.LANGUAGE_CD = B.LANGUAGE_CD AND B.RB_USAGE_ID = C.RB_USAGE_ID AND A.RB_TEMPLATE_ID = E.RB_TEMPLATE_ID AND A.RB_TEMPLATE_NAME = E.RB_TEMPLATE_NAME AND A.LANGUAGE_CD = E.LANGUAGE_CD AND E.RB_TEMPLATE_ID = F.RB_TEMPLATE_ID AND E.RB_TEMPLATE_NAME = F.RB_TEMPLATE_NAME AND E.LANGUAGE_CD = F.LANGUAGE_CD AND A.FROM_DATE <= %CurrentDateIn AND A.TO_DATE >= %CurrentDateIn AND E.FROM_DATE <= %CurrentDateIn AND E.TO_DATE >= %CurrentDateIn AND E.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RB_PACKAGE_ID Number(10,0) DECIMAL(10) NOT NULL Package
2 RB_PACKAGE_NAME Character(30) VARCHAR2(30) NOT NULL Package Name
3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
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
9 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
10 MARKET Character(3) VARCHAR2(3) NOT NULL Market
11 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
12 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code
13 RB_TEMPLATE_ID Number(10,0) DECIMAL(10) NOT NULL Template ID
14 RB_TEMPLATE_NAME Character(30) VARCHAR2(30) NOT NULL Template Name
15 DATE_BEGIN Date(10) DATE Start Date
16 DATE_END Date(10) DATE End Date
17 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
18 RB_SECURITY2 Character(4) VARCHAR2(4) NOT NULL Identifies the security
0=Shared
1=My Use Only
19 ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By User ID