TREE_LVL_VW_LNG

(SQL View)
 Index Back

Tree Level View RLR

Tree Level View Related Language Record

SELECT B.SETID , A.TREE_NAME , A.TREE_LEVEL , L.LANGUAGE_CD , A.EFFDT , L.DESCR , L.DESCRSHORT FROM PSTREELEVEL A , PS_TREE_LEVEL_TBL B , PS_TREE_LEVEL_LNG L WHERE B.SETID = A.SETID AND B.TREE_LEVEL = A.TREE_LEVEL AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_TREE_LEVEL_TBL C WHERE C.SETID = B.SETID AND C.TREE_LEVEL = B.TREE_LEVEL AND C.EFFDT <= A.EFFDT) AND L.SETID = B.SETID AND L.TREE_LEVEL = B.TREE_LEVEL AND L.EFFDT = B.EFFDT

  • Related Language Record for TREE_LEVEL_VW3

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

    Prompt Table: PT_TREEDEFN_VW

    3 TREE_LEVEL Character(10) VARCHAR2(10) NOT NULL Tree Level Number

    Prompt Table: TREE_LEVEL_TBL

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 EFFDT Date(10) DATE NOT NULL Effective Date
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description