TRW_APPCLASS_LV (SQL View)	Index Back
Application Class Related Lang Related language record. This record retrieves active Application Class Name for the Application Usage of �REWARD CALCS�.

TRW_APPCLASS_LV

(SQL View)

Application Class Related Lang

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

SELECT l.HCSC_APPCLASS_ID , l.HCSC_APPCLASS_NAME , l.LANGUAGE_CD , l.HCSC_DISPLAY_LBL FROM PS_HCSC_APPCLS_REG r , PS_HCSC_CLSREG_LNG l WHERE r.HCSC_APPCLASS_ID = l.HCSC_APPCLASS_ID AND r.HCSC_APPCLASS_NAME = l.HCSC_APPCLASS_NAME AND r.HCSC_APPCLASS_USE = 'REWARD CALCS' AND r.HCSC_APPCLASS_STAT = '10'

Related Language Record for TRW_APPCLASS_VW

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 HCSC_DISPLAY_LBL Character(50) VARCHAR2(50) NOT NULL Display Label

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	HCSC_DISPLAY_LBL	Character(50)	VARCHAR2(50) NOT NULL	Display Label