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

EOCF_TXT_PATHVW

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

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

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