WCS_PG_PEER_VW2

(SQL View)
 Index Back

Peer Analysis Group View


SELECT DMG.BUDGET_ID , DMG.BUDGET_START_DT , DMG.TREE_NODE_NUM , STS.TREE_NODE_NUM_END , dmg.emplid , dmg.empl_rcd , %Round(AVG(DMG.WCS_ANNUAL_RT),3) , %Round(AVG(DMG.min_rt_annual),3) , %Round(AVG(DMG.max_rt_annual),3) , %Round(AVG(DMG.mid_rt_annual),3) , 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 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 AND dmg.WCS_ECM_EXCLUDED='N' AND DMG.WCS_ANNUAL_RT <>0 GROUP BY DMG.BUDGET_ID , DMG.BUDGET_START_DT , DMG.TREE_NODE_NUM , STS.TREE_NODE_NUM_END , dmg.emplid , dmg.empl_rcd

# 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 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate
8 MIN_RT_ANNUAL Number(19,3) DECIMAL(18,3) NOT NULL Minimum Pay Rate-Annual
9 MAX_RT_ANNUAL Number(19,3) DECIMAL(18,3) NOT NULL Maximum Pay Rate-Annual
10 MID_RT_ANNUAL Number(19,3) DECIMAL(18,3) NOT NULL Midpoint Pay Rate-Annual
11 WCS_C_PCT Number(6,2) DECIMAL(5,2) NOT NULL Calculated Percent