WCS_AWETRX_VW(SQL View) |
Index Back |
|---|---|
Compensation ApprovalsCompensation Approvals transactions. |
| SELECT STS.BUDGET_ID , STS.BUDGET_START_DT , STS.TREE_NODE_NUM , STS.WCS_NODE_STATUS , STS.WCS_TOT_COUNT , STS.WCS_TOT_SALARIES , STS.WCS_DIR_COUNT , STS.WCS_DIR_SALARIES , HDR.ORIGINATORID , STP.EOAWSTEP_STATUS , STP.OPRID , XRF.EOAWPRCS_ID FROM PS_WCS_ECM_NOD_STS STS , PS_WCS_AWE_NOD_HDR HDR , PS_WCS_ECM_AWE_XRF XRF , PS_EOAW_STEP_VW STP WHERE STS.BUDGET_ID = HDR.BUDGET_ID AND STS.BUDGET_START_DT = HDR.BUDGET_START_DT AND STS.TREE_NODE_NUM = HDR.TREE_NODE_NUM AND STS.BUDGET_ID = XRF.BUDGET_ID AND STS.BUDGET_START_DT = XRF.BUDGET_START_DT AND STS.TREE_NODE_NUM = XRF.TREE_NODE_NUM AND STP.EOAWPRCS_ID = XRF.EOAWPRCS_ID AND STP.EOAWDEFN_ID = XRF.EOAWDEFN_ID AND STP.EOAWTHREAD_ID = XRF.EOAWTHREAD_ID AND STP.EOAWSTEP_STATUS IN ('A','B','D','P') |
| # | 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 | TREE_NODE_NUM |
Number(10,0) | DECIMAL(10) NOT NULL | Internal beginning node range number |
| 4 | WCS_NODE_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Node Status
CLC=Calculated CME=Completed with Errors CMP=Completed CNF=Confirmed INP=In Progress PSB=Pushed Back RTL=Ready to Load SUB=Submitted |
| 5 | WCS_TOT_COUNT | Number(6,0) | INTEGER NOT NULL | Total Employees in Node (direct and indirect) |
| 6 | WCS_TOT_SALARIES | Number(22,6) | DECIMAL(21,6) NOT NULL | Total Employee Salaries in Node (direct and indirect) |
| 7 | WCS_DIR_COUNT | Number(6,0) | INTEGER NOT NULL | Total Direct Reports in Node |
| 8 | WCS_DIR_SALARIES | Number(22,6) | DECIMAL(21,6) NOT NULL | Total Direct Reports Salaries in Node |
| 9 | ORIGINATORID | Character(30) | VARCHAR2(30) NOT NULL | Originator Identifier |
| 10 | EOAWSTEP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Step Instance Status
A=Approved B=Pushed back C=Auto Approved D=Denied E=Administrator denied F=Deleted G=Bypassed H=On Hold I=No Action Taken K=Skipped L=Terminated M=Administrator approved N=Not Active P=Pending R=No longer in role T=Terminated U=Auto approved X=Deleted Z=Pending Denial |
| 11 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 12 | EOAWPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |