SETIDTD_TREE_IDEFFDTDefault Value: %date
OPRIDTD_NODE_IDTD_ROOTS_PRODVW(SQL View) |
Index Back |
|---|---|
Prod Tree Roots By OPRIDReturns starting nodes for Product tree by operator |
| SELECT DISTINCT A.SETID , A.TD_TREE_ID , A.EFFDT , C.OPRID , A.TD_NODE_ID FROM PS_TD_TREE_NODE A , PS_TD_TREE_USERS B , PSOPRDEFN C WHERE A.SETID = B.SETID AND A.TD_TREE_ID = B.TD_TREE_ID AND A.EFFDT = B.EFFDT AND A.TD_NODE_ID = B.TD_NODE_ID AND ((B.TD_SECURITY_TYPE = 'U' AND B.TD_SECURITY_ID = C.OPRID) OR (B.TD_SECURITY_TYPE = 'R' AND (EXISTS ( SELECT 'X' FROM PSROLEUSER R WHERE R.ROLENAME = B.TD_SECURITY_ID AND R.ROLEUSER = C.OPRID)))) AND NOT EXISTS ( SELECT 'X' FROM PS_TD_TREE_USERS B1 , PSOPRDEFN C1 WHERE A.SETID = B1.SETID AND A.TD_TREE_ID = B1.TD_TREE_ID AND A.EFFDT = B1.EFFDT AND B1.TD_NODE_ID = A.TD_NODE_PARENT_ID AND B1.TD_SECURITY_ID = B.TD_SECURITY_ID AND ((B1.TD_SECURITY_TYPE = 'U' AND B1.TD_SECURITY_ID = C1.OPRID) OR (B1.TD_SECURITY_TYPE = 'R' AND (EXISTS ( SELECT 'X' FROM PSROLEUSER R1 WHERE R1.ROLENAME = B1.TD_SECURITY_ID AND R1.ROLEUSER = C1.OPRID))))) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | TD_TREE_ID |
Character(8) | VARCHAR2(8) NOT NULL | Tree ID |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 5 | TD_NODE_ID |
Character(8) | VARCHAR2(8) NOT NULL | Node ID |