RBC_TMPLT_PDGRP

(SQL Table)
Index Back

Template Table

Correspondence Template, Product, Pacakge table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RB_PACKAGE_NAME Character(30) VARCHAR2(30) NOT NULL Package Name
2 RB_PACKAGE_ID Number(10,0) DECIMAL(10) NOT NULL Package
3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive

Y/N Table Edit

Default Value: N

7 RC_MAINT_OWNER Character(1) VARCHAR2(1) NOT NULL Call center Maintenance Owner
0=PeopleSoft
1=PeopleSoft / Customer Modified
2=Customer

Default Value: 2

8 SYSD_APPLICATION01 Character(1) VARCHAR2(1) NOT NULL PS CRM Core
N=No
S=Sample Data
Y=Yes

Y/N Table Edit

Default Value: N

9 SYSD_APPLICATION02 Character(1) VARCHAR2(1) NOT NULL Financial Services
N=No
S=Sample Data
Y=Yes

Y/N Table Edit

Default Value: N

10 SYSD_APPLICATION03 Character(1) VARCHAR2(1) NOT NULL Telecommunications
N=No
S=Sample Data
Y=Yes

Y/N Table Edit

Default Value: N

11 SYSD_APPLICATION04 Character(1) VARCHAR2(1) NOT NULL Government
N=No
S=Sample Data
Y=Yes

Y/N Table Edit

Default Value: N

12 SYSD_APPLICATION05 Character(1) VARCHAR2(1) NOT NULL Energy
N=No
S=Sample Data
Y=Yes

Y/N Table Edit

Default Value: N

13 SYSD_APPLICATION06 Character(1) VARCHAR2(1) NOT NULL Insurance
N=No
S=Sample Data
Y=Yes

Y/N Table Edit

Default Value: N

14 SYSD_APPLICATION07 Character(1) VARCHAR2(1) NOT NULL High Technology
N=No
S=Sample Data
Y=Yes

Y/N Table Edit

Default Value: N

15 SYSD_APPLICATION08 Character(1) VARCHAR2(1) NOT NULL HR HelpDesk
N=No
S=Sample Data
Y=Yes

Y/N Table Edit

Default Value: N

16 SYSD_APPLICATION09 Character(1) VARCHAR2(1) NOT NULL System Data Field for Application 9. Application 9 is used for Wealth Management.
N=No
S=Sample Data
Y=Yes

Y/N Table Edit

Default Value: N

17 SYSD_APPLICATION10 Character(1) VARCHAR2(1) NOT NULL Used in Application 10
N=No
S=Sample Data
Y=Yes

Y/N Table Edit

Default Value: N