OPRIDSETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
TD_FUND_CODESETID_TREETD_TREE_IDEFFDTTD_NODE_IDTD_NODE_PARENT_IDTD_CUST_ROOTVW2(SQL View) |
Index Back |
|---|---|
Customer Node Security ViewCustomer Node Security View: OPRID keyed view: Bring back valid NODE_IDs based on OPRID |
| SELECT DISTINCT C1.OPRID , C.SETID , C.TD_FUND_CODE , A1.SETID , A1.TD_TREE_ID , A1.EFFDT , A1.TD_NODE_ID , A1.TD_NODE_PARENT_ID , A1.TD_SEQNO , A1.TREE_NODE_NUM , A1.TREE_NODE_NUM_END , A1.DESCR , A1.TD_TREE_BRANCH , A1.TD_TREE_BRANCH_PAR , A1.TD_NODE_LEVEL FROM PS_TD_TREE_NODE A1 , PS_TD_TREE_APPROVE B1 , PSOPRDEFN C1 , PS_TD_FUND_CUST C , PS_TD_TREE_NODE X WHERE A1.SETID = B1.SETID AND A1.TD_TREE_ID = B1.TD_TREE_ID AND A1.EFFDT = B1.EFFDT AND A1.TD_NODE_ID = B1.TD_NODE_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)))) AND A1.SETID = X.SETID AND A1.TD_TREE_ID = X.TD_TREE_ID AND A1.EFFDT = X.EFFDT AND X.CUST_ID = C.CUST_ID AND X.TD_TREE_BRANCH = A1.TD_TREE_BRANCH |
| # | 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
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 3 | TD_FUND_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Promotions Management Fund Code |
| 4 | SETID_TREE |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | TD_TREE_ID |
Character(8) | VARCHAR2(8) NOT NULL | Tree ID |
| 6 | EFFDT |
Date(10) | DATE | Effective Date |
| 7 | TD_NODE_ID |
Character(8) | VARCHAR2(8) NOT NULL | Node ID |
| 8 | TD_NODE_PARENT_ID |
Character(8) | VARCHAR2(8) NOT NULL | Node ID |
| 9 | TD_SEQNO | Number(15,4) | DECIMAL(14,4) NOT NULL | Sequence Number |
| 10 | TREE_NODE_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Internal beginning node range number |
| 11 | TREE_NODE_NUM_END | Number(10,0) | DECIMAL(10) NOT NULL | Internal ending node range number |
| 12 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 13 | TD_TREE_BRANCH | Character(20) | VARCHAR2(20) NOT NULL | Tree Branch Node ID |
| 14 | TD_TREE_BRANCH_PAR | Character(20) | VARCHAR2(20) NOT NULL | Parent Branch |
| 15 | TD_NODE_LEVEL | Number(3,0) | SMALLINT NOT NULL | Node Level |