RB_PACKAGE_IDA=Active
I=Inactive
0=Shared
1=My Use Only
0=Do not Convert to PDF
1=Use PDF Format for Delivery
2=Use PDF format for Storage
3=Convert to PDF Format
RBC_PKG_TMPL_VW(SQL View) |
Index Back |
|---|---|
Template Package ViewCorrespondence Management Template Package View |
| SELECT A.RB_PACKAGE_ID , A.RB_PACKAGE_NAME , A.DESCR , A.EFF_STATUS , A.FROM_DATE , A.TO_DATE , A.LANGUAGE_CD , A.RB_SECURITY , A.RB_TEMPLATE_ID , A.RB_TEMPLATE_NAME , B.RB_TEMPLATE_ID , B.RB_TEMPLATE_NAME , B.RB_PDF_OPTIONS , B.SEQ_NUM FROM PS_RBC_PACKAGE_DFN A , PS_RBC_PACKAG_TMPL B WHERE A.RB_PACKAGE_ID = B.RB_PACKAGE_ID AND A.RB_PACKAGE_NAME = B.RB_PACKAGE_NAME AND A.LANGUAGE_CD = B.LANGUAGE_CD |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | FROM_DATE | Date(10) | DATE | From Date |
| 6 | TO_DATE | Date(10) | DATE | To Date |
| 7 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 8 | RB_SECURITY | Character(4) | VARCHAR2(4) NOT NULL |
Identifies the security
0=Shared 1=My Use Only |
| 9 | RB_TEMPLATE_ID2 | Number(10,0) | DECIMAL(10) NOT NULL | Template ID |
| 10 | RB_TEMPLATE_NAME2 | Character(30) | VARCHAR2(30) NOT NULL | Template Name |
| 11 | RB_TEMPLATE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Template ID |
| 12 | RB_TEMPLATE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Template Name |
| 13 | RB_PDF_OPTIONS | Character(4) | VARCHAR2(4) NOT NULL |
PDF conversion options
0=Do not Convert to PDF 1=Use PDF Format for Delivery 2=Use PDF format for Storage 3=Convert to PDF Format |
| 14 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |