TRW_APPCLASS_VW

(SQL View)
Index Back

TRW Application Class Name Vw

This record retrieves active Application Class Name for the Application Usage of �REWARD CALCS�

SELECT HCSC_APPCLASS_ID , HCSC_APPCLASS_NAME , HCSC_DISPLAY_LBL FROM PS_HCSC_APPCLS_REG WHERE HCSC_APPCLASS_USE = 'REWARD CALCS' AND HCSC_APPCLASS_STAT = '10'

  • Related Language Record: TRW_APPCLASS_LV
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HCSC_APPCLASS_ID Character(25) VARCHAR2(25) NOT NULL This is used to hold a dynamically generated unique string that serves as a key for an Application Class. AppClasses do not have a key, other than their full class path, which is too cumbersome to use for searching purposes
    2 HCSC_APPCLASS_NAME Character(30) VARCHAR2(30) NOT NULL This is a descriptive name for an application class.
    3 HCSC_DISPLAY_LBL Character(50) VARCHAR2(50) NOT NULL Display Label