HCSC_TBLDCLS_LN (SQL View)	Index Back
Tree Builder AppClass Vw Lang This is the related language support view for the Tree Builder application class prompt view

HCSC_TBLDCLS_LN

(SQL View)

Tree Builder AppClass Vw Lang

This is the related language support view for the Tree Builder application class prompt view

SELECT L.HCSC_APPCLASS_ID , L.LANGUAGE_CD , L.HCSC_APPCLASS_NAME FROM PS_HCSC_APPCLS_REG B , PS_HCSC_CLSREG_LNG L WHERE B.HCSC_APPCLASS_USE = 'TREE_BUILDER' AND B.HCSC_APPCLASS_STAT = '10' AND L.HCSC_APPCLASS_ID = B.HCSC_APPCLASS_ID

Related Language Record for HCSC_TBLDCLS_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 HCSC_APPCLASS_NAME Character(30) VARCHAR2(30) NOT NULL This is a descriptive name for an application class.

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	HCSC_APPCLASS_NAME	Character(30)	VARCHAR2(30) NOT NULL	This is a descriptive name for an application class.