BUDGET_IDBUDGET_START_DTOPRIDMANAGER_IDWCS_ECM_MGR_VW(SQL View) |
Index Back |
|---|---|
WCS - Manage TransationsSearch Record for Manage Transactions Component |
| SELECT DISTINCT STS.BUDGET_ID , STS.BUDGET_START_DT , PSOPR.OPRID , ACSS.EMPLID FROM PS_WCS_ECM_NOD_STS STS , PS_WCS_ECM_ACCESS ACSS , PSOPRDEFN PSOPR WHERE STS.BUDGET_ID = ACSS.BUDGET_ID AND STS.BUDGET_START_DT = ACSS.BUDGET_START_DT AND STS.TREE_NODE_NUM = ACSS.TREE_NODE_NUM AND ACSS.EMPLID = PSOPR.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUDGET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Budget ID |
| 2 | BUDGET_START_DT |
Date(10) | DATE NOT NULL | Budget Start Date |
| 3 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | MANAGER_ID |
Character(11) | VARCHAR2(11) NOT NULL | Manager ID |