HCSC_CAL_APC_VW

(SQL View)
 Index Back

Application Class View

Application Class view used by Calendar Configurable Sections.

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

  • Parent record: SI_PKGROOT_VW

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