EOCF_APPPATH_VW (SQL View)	Index Back
Application Classes List View to list all the application classes

EOCF_APPPATH_VW

(SQL View)

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 EOCF_APPCLASSID Character(30) VARCHAR2(30) NOT NULL data library - aplication class id

2 EOCF_APPCLASS_PATH Character(167) VARCHAR2(167) NOT NULL Application Class Full Path

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOCF_APPCLASSID	Character(30)	VARCHAR2(30) NOT NULL	data library - aplication class id
2	EOCF_APPCLASS_PATH	Character(167)	VARCHAR2(167) NOT NULL	Application Class Full Path