PTAFAPCLSPTH_VW

(SQL View)
Index Back

SELECT PACKAGEROOT , rtrim(APPCLASSID) FROM PSAPPCLASSDEFN WHERE QUALIFYPATH = ':' UNION SELECT PACKAGEROOT , rtrim(QUALIFYPATH) %Concat ':' %Concat rtrim(APPCLASSID) FROM PSAPPCLASSDEFN WHERE (QUALIFYPATH <> ':')

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