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 |