RB_PACKAGE_IDA=Active
I=Inactive
0=Shared
1=My Use Only
RBC_PKG_USG_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 , C.PNLGRPNAME FROM PS_RBC_PACKAGE_DFN A , PS_RBC_PACKAGE_USG B , PS_RBC_USAGE_DTL C 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 AND B.RB_USAGE_ID = C.RB_USAGE_ID |
| # | 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 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |