BUDGET_IDBUDGET_START_DTTREE_NODE_NUMTREE_NODE_NUM_ENDEMPLIDEMPL_RCDWCS_PG_SLPF_VW1(SQL View) |
Index Back |
|---|---|
Salary by Performance View |
| SELECT DMG.BUDGET_ID , DMG.BUDGET_START_DT , DMG.TREE_NODE_NUM , STS.TREE_NODE_NUM_END , dmg.emplid , dmg.empl_rcd , SUM(SAL.WCS_P_AMT ) , CASE WHEN SUM(%DecMult(%DecDiv(%Coalesce(SAL.WCS_P_AMT, SAL.WCS_A_AMT), dmg.wcs_annual_rt), 100)) > 999.99 THEN 999.99 ELSE %Round(SUM(%DecMult(%DecDiv(%Coalesce(SAL.WCS_P_AMT, SAL.WCS_A_AMT), dmg.wcs_annual_rt), 100)),2) END , SAL.SEQNUM , MAX(SAL.WCS_MIN_PCT ) , MAX(SAL.WCS_MAX_PCT ) FROM PS_WCS_ECM_EE_DMG DMG , PS_WCS_ECM_NOD_STS STS , PS_WCS_ECM_EE_SAL SAL WHERE DMG.BUDGET_ID = STS.BUDGET_ID AND DMG.BUDGET_START_DT = STS.BUDGET_START_DT AND DMG.TREE_NODE_NUM = STS.TREE_NODE_NUM AND DMG.BUDGET_ID = SAL.BUDGET_ID AND DMG.BUDGET_START_DT = SAL.BUDGET_START_DT AND DMG.TREE_NODE_NUM = SAL.TREE_NODE_NUM AND DMG.EMPLID = SAL.EMPLID AND DMG.EMPL_RCD = SAL.EMPL_RCD GROUP BY DMG.BUDGET_ID , DMG.BUDGET_START_DT , DMG.TREE_NODE_NUM , STS.TREE_NODE_NUM_END , dmg.emplid ,dmg.empl_rcd, SAL.SEQNUM |
| # | 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 | Budget Start Date |
| 3 | TREE_NODE_NUM |
Number(10,0) | DECIMAL(10) NOT NULL | Internal beginning node range number |
| 4 | TREE_NODE_NUM_END |
Number(10,0) | DECIMAL(10) NOT NULL | Internal ending node range number |
| 5 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 6 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 7 | WCS_P_AMT | Number(16,6) | DECIMAL(15,6) NOT NULL | Employee Proposed Amount |
| 8 | WCS_C_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Calculated Percent |
| 9 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 10 | WCS_MIN_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Minimum Percentage |
| 11 | WCS_MAX_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Maximum Percentage |