RB_APPCLASS_EXTAPPCLASSREFRB_APCLSCACHEVW(SQL View) |
Index Back |
|---|---|
Application Class Cache ViewView used to generate the application data cache store for the application class registry. |
| SELECT EXT.RB_APPCLASS_EXT , BAS.APPCLASSREF , CASE WHEN EXT.USE_BASE_CLASS = 'Y' THEN rtrim(BAS.APPCLASS_PATH) %Concat ':' %Concat BAS.APPCLASSID ELSE rtrim(EXT.APPCLASS_PATH) %Concat ':' %Concat EXT.APPCLASSID END FROM PS_RB_APPCLASS_BAS BAS , PS_RB_APPSET_EXT ST , PS_RB_APPCLASS_EXT EXT WHERE BAS.RB_APPCLASS_SET=ST.RB_APPCLASS_SET AND ST.RB_APPCLASS_EXT=EXT.RB_APPCLASS_EXT AND EXT.APPCLASSREF=BAS.APPCLASSREF |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RB_APPCLASS_EXT |
Character(15) | VARCHAR2(15) NOT NULL | Application Class Set |
| 2 | APPCLASSREF |
Character(30) | VARCHAR2(30) NOT NULL | Application Class ID Reference |
| 3 | RB_APPCLASS_PATH1 | Character(254) | VARCHAR2(254) NOT NULL | Field holds the value of the Application Class Path |