TL_APCLSPTH_VW(SQL View) |
Index Back |
---|---|
App Class Path viewApp Class Path view |
SELECT PACKAGEROOT , %Sql(FUNCLIB_TL_STRING_RTRIM, APPCLASSID) FROM PS_TL_TAB_APPCLSVW WHERE QUALIFYPATH = ':' UNION SELECT PACKAGEROOT , %Sql(FUNCLIB_TL_STRING_RTRIM, QUALIFYPATH) %Concat ':' %Concat %Sql(FUNCLIB_TL_STRING_RTRIM, APPCLASSID) FROM PS_TL_TAB_APPCLSVW WHERE (QUALIFYPATH <> ':') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | TL_PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL |
TL Application Package Root
Prompt Table: TL_PACKAGE_VW |
2 | TL_CLASSPATH | Character(254) | VARCHAR2(254) NOT NULL |
TL Appl Class Path
Prompt Table: EOAWEMC_CLS_VW |