HR_RFW_APH_VW

(SQL View)
Index Back

Application Path

Application Path

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