RBC_APPRTPATH_V

(SQL View)
Index Back

Application Classes List

View to list all the application classes

SELECT APPCLASSID ,CASE WHEN %TrimSubstr(QUALIFYPATH,1,127) <> ':' THEN (%TrimSubstr(PACKAGEROOT,1,30) %Concat ':' %Concat %TrimSubstr(QUALIFYPATH,1,127)) ELSE %TrimSubstr(PACKAGEROOT,1,30) END FROM PSAPPCLASSDEFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
2 APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path