SSRTREEACCSVWLN

(SQL View)
 Index Back

Rltd Lang-Tree Dfn name, effdt

SSRTREEACCSVWLN is the language record related to SSR_TREEACCS_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.setcntrlvalue= b.setcntrlvalue AND a.tree_name= b.tree_name AND a.effdt= b.effdt

  • Related Language Record for SSR_TREEACCS_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

    Prompt Table: INSTITUTN_SCRTY
    Set Control Field: INSTITUTION

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

    Prompt Table: SSR_TREESTR_VW

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

    Prompt Table: SSR_TREE_VW

    4 TREE_EFFDT Date(10) DATE Effective date of the Tree
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description