IT_OPRID_TSETID(SQL View) |
Index Back |
|---|---|
IT Fin Stat oprid & tree setidIT Asset financial statistics oprid and tree setid view |
| SELECT A.OPRID , A.SETID , C.TREE_SETID , B.TREE_NAME , B.TREE_LEVEL , B.CURRENCY_CD , B.AMT_DISPLAY_IN , B.RT_TYPE , D.TREE_TYPE_ID FROM PS_OPR_DEF_TBL_FS A , PS_OPR_DEF_TBL_IT B , PS_IT_BU_TREESETID C , PS_IT_TREE_NAME D WHERE A.OPRID = B.OPRID AND B.TREE_NAME <> ' ' AND A.SETID = C.SETID AND B.TREE_NAME = C.TREE_NAME AND A.SETID = D.SETID AND B.TREE_NAME = D.TREE_NAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | TREE_SETID | Character(5) | VARCHAR2(5) NOT NULL | Tree SetID |
| 4 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 5 | TREE_LEVEL | Character(10) | VARCHAR2(10) NOT NULL | Tree Level Number |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 7 | AMT_DISPLAY_IN | Number(9,0) | DECIMAL(9) NOT NULL | Amount display in ex: 1000 or 1000000 |
| 8 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 9 | TREE_TYPE_ID | Character(1) | VARCHAR2(1) NOT NULL |
Tree Type Id
B=Business Unit D=Department |