APPCLASS_PATHAPPCLASSIDSAC_APPCLS1_VW(SQL View) |
Index Back |
|---|---|
SCM Arch AppClass nonroot viewSupply Chain Architecture Application Class prompt view for non-root paths. |
| SELECT %TrimSubstr(PACKAGEROOT,1,15) %Concat ':' %Concat QUALIFYPATH , APPCLASSID FROM PSAPPCLASSDEFN WHERE QUALIFYPATH <> ':' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | APPCLASS_PATH |
Character(254) | VARCHAR2(254) NOT NULL | Application Class Full Path |
| 2 | APPCLASSID |
Character(30) | VARCHAR2(30) NOT NULL | Application Class ID |