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

SSRTREEDEFNVWLN

(SQL View)

Rlted lng-Tree Def name, effdt

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

SELECT %Substring(A.SETID,1,5) INSTITUTION , A.TREE_STRCT_ID , A.TREE_NAME , A.EFFDT , B.LANGUAGE_CD , B.DESCR FROM PSTREEDEFN A ,PSTREEDEFNLANG B WHERE A.TREE_CATEGORY ='TEST_ADMIN' AND A.EFFDT <= %CurrentDateIn AND A.SETID=B.SETID AND A.SETCNTRLVALUE=B.SETCNTRLVALUE AND A.TREE_NAME=B.TREE_NAME AND A.EFFDT=B.EFFDT

Related Language Record for SSR_TREEDEFN_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION

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

3 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

4 EFFDT Date(10) DATE Effective Date
Default Value: %date

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION
2	TREE_STRCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Tree Structure Name (see PSTREESTRCT).
3	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description