SSRTREESTRVWLNG (SQL View)	Index Back
Rltd Lang-Tree Def name, effdt SSRTREESTRVWLNG is the language record related to SSR_TREESTR_VW A related language record enables text fields on a table to be translated into various languages for use in other countries.

SSRTREESTRVWLNG

(SQL View)

Rltd Lang-Tree Def name, effdt

SSRTREESTRVWLNG is the language record related to SSR_TREESTR_VW A related language record enables text fields on a table to be translated into various languages for use in other countries.

SELECT DISTINCT A.TREE_STRCT_ID , A.LANGUAGE_CD , A.DESCR FROM PSTREESTRCTLANG A , PSTREEDEFN B WHERE A.TREE_STRCT_ID = B.TREE_STRCT_ID AND B.TREE_CATEGORY = 'TEST_ADMIN'

Related Language Record for SSR_TREESTR_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TREE_STRCT_ID Character(18) VARCHAR2(18) NOT NULL Tree Structure Name (see PSTREESTRCT).

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TREE_STRCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Tree Structure Name (see PSTREESTRCT).
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description