APPCLASSDFN_VW(SQL View) |
Index Back |
|---|
| SELECT APPCLASSID , PACKAGEROOT , QUALIFYPATH , APPCLASSREF , DESCR , RTRIM (APPCLASSID) FROM PSAPPCLASSDEFN WHERE (QUALIFYPATH = ':') UNION SELECT APPCLASSID , PACKAGEROOT , QUALIFYPATH , APPCLASSREF , DESCR , RTRIM (QUALIFYPATH) %Concat ':' %Concat RTRIM (APPCLASSID) FROM PSAPPCLASSDEFN WHERE (QUALIFYPATH <> ':') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL | Application Class ID |
| 2 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL | Root Package ID |
| 3 | QUALIFYPATH | Character(127) | VARCHAR2(127) NOT NULL | Qualified Package/Class Path |
| 4 | APPCLASSREF | Character(30) | VARCHAR2(30) NOT NULL | Application Class ID Reference |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | APPCLASS_PATH | Character(254) | VARCHAR2(254) NOT NULL | Application Class Full Path |