COMPETEN_VW_ACC

(SQL View)
Index Back

SELECT A.COMPETENCY , B.DESCR , C.TREE_NODE , D.DESCR Treename , C.PARENT_NODE_NAME , ( SELECT E.DESCR FROM PS_RS_TYPE_TBL E WHERE E.rs_type = C.PARENT_NODE_NAME) ParentTreeName, C.TREE_NAME, C.TREE_NODE_NUM FROM PS_COMPETENCY_TYPS A , PS_COMPETENCY_TBL B, PSTREENODE C, PS_RS_TYPE_TBL D WHERE A.COMPETENCY = B.COMPETENCY AND A.RS_TYPE = C.TREE_NODE AND C.TREE_NODE = D.RS_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
4 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
5 PARENT_NODE_NAME Character(20) VARCHAR2(20) NOT NULL Name of parent node
6 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
7 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
8 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number