EOCF_DT_PATH_VW (SQL View)	Index Back
App path view App path view

EOCF_DT_PATH_VW

(SQL View)

App path view

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_DT_APPCLASSID Character(30) VARCHAR2(30) NOT NULL Run Time App Class ID

2 EOCF_DT_APPCLSPATH Character(167) VARCHAR2(167) NOT NULL Run Time App Class Path

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOCF_DT_APPCLASSID	Character(30)	VARCHAR2(30) NOT NULL	Run Time App Class ID
2	EOCF_DT_APPCLSPATH	Character(167)	VARCHAR2(167) NOT NULL	Run Time App Class Path