Created by Tamara J Saarinen, last modified on Jan 12, 2018

Link to table: UM_F_POS_BUD_VW - view of Posi & Budger extract

Created Field Name

Description

Query Usage Example

Type

Aggregate Function?

Code

BASE_BAL

Calculate Budget Base Balance

DM-27 - PM Budgets vs Annual Distributions Closed


Signed Number, 15,3No
Select Expand source to see code... 
/*+ BASE_BAL 12_04_17 */
NVL(A.UM_POS_BUD_BAS_AMT,0)+NVL(A.UM_POS_BUD_PER_AMT,0)
 BUDGET_VS_ANNUAL_RT(Base Budget + Permanent Budget Adjustment) - Annual Rate from UM_F_ANNUAL_DIS

DM-27 - PM Budgets vs Annual Distributions Closed

Signed Number, 15,3No
Select Expand source to see code... 
/*+ BUDGET_VS_ANNUAL_RT 12_04_17 */
NVL(A.UM_POS_BUD_BAS_AMT,0)+NVL(A.UM_POS_BUD_PER_AMT,0)-NVL(B.ANNUAL_RT,0)
BUDGET_VS_ABBR (Base Budget + Permanent Budget Adjustment) - Annual Benefits Base Rate from UM_F_ANNUAL_DIS

DM-27 - PM Budgets vs Annual Distributions Closed

Signed Number, 15,3No
Select Expand source to see code... 
/*+ BUDGET_VS_ABBR 12_04_17 */
NVL(A.UM_POS_BUD_BAS_AMT,0)+NVL(A.UM_POS_BUD_PER_AMT,0)-NVL(A.ANNL_BENEF_BASE_RT,0)
POS_CURRENT_AMT Base Budget + Permanent Budget Adjustment + Temporary Budget Adjustment

DM-27 - PM Budgets vs Annual Distributions Closed

Signed Number, 15,3No
Select Expand source to see code... 
/*+ POS_CURRENT_AMT 12_04_17 */
NVL(A.UM_POS_BUD_BAS_AMT,0)+NVL(A.UM_POS_BUD_PER_AMT,0)+NVL(A.UM_POS_BUD_TEM_AMT,0)
REG_TEMP_ACCOUNT
Regular or Temporary Fringe Cost by Account and Fund Code

DM-27 - PM Budgets vs Annual Distributions Closed

Character, 10No
/*+REG_TEMP by ACCOUNT 01_12_18*/
CASE
WHEN A.ACCOUNT = '16001' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '16001' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '16004' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '16004' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '20155' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'TMP'
WHEN A.ACCOUNT = '20155' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'TMP'
WHEN A.ACCOUNT = '21600' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '21600' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '50000' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '50000' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '50001' THEN 'TMP'
WHEN A.ACCOUNT = '50002' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '50002' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '50003' THEN 'TMP'
WHEN A.ACCOUNT = '50004' THEN 'TMP'
WHEN A.ACCOUNT = '50005' THEN 'TMP'
WHEN A.ACCOUNT = '50006' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '50006' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '50007' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '50007' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '50008' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '50008' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '50009' THEN 'TMP'
WHEN A.ACCOUNT = '50010' THEN 'TMP'
WHEN A.ACCOUNT = '50011' THEN 'TMP'
WHEN A.ACCOUNT = '50012' THEN 'TMP'
WHEN A.ACCOUNT = '50013' THEN 'TMP'
WHEN A.ACCOUNT = '50014' THEN 'TMP'
WHEN A.ACCOUNT = '50015' THEN 'TMP'
WHEN A.ACCOUNT = '50016' THEN 'TMP'
WHEN A.ACCOUNT = '50017' THEN 'TMP'
WHEN A.ACCOUNT = '50018' THEN 'TMP'
WHEN A.ACCOUNT = '50019' THEN 'TMP'
WHEN A.ACCOUNT = '50030' THEN 'TMP'
WHEN A.ACCOUNT = '50030' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '50100' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '50100' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '50101' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '50101' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '50200' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '50200' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '50300' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '50300' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '50400' THEN 'TMP'
WHEN A.ACCOUNT = '50401' THEN 'TMP'
WHEN A.ACCOUNT = '50402' THEN 'TMP'
WHEN A.ACCOUNT = '50403' THEN 'TMP'
WHEN A.ACCOUNT = '50404' THEN 'TMP'
WHEN A.ACCOUNT = '51000' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '51000' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '51001' THEN 'TMP'
WHEN A.ACCOUNT = '51002' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '51002' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '51003' THEN 'TMP'
WHEN A.ACCOUNT = '51004' THEN 'TMP'
WHEN A.ACCOUNT = '51005' THEN 'TMP'
WHEN A.ACCOUNT = '51007' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '51007' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '51008' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '51008' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '51009' THEN 'TMP'
WHEN A.ACCOUNT = '51011' THEN 'TMP'
WHEN A.ACCOUNT = '51012' THEN 'TMP'
WHEN A.ACCOUNT = '51100' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '51100' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '51101' THEN 'TMP'
WHEN A.ACCOUNT = '51200' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '51200' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '51201' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '51201' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '51202' THEN 'TMP'
WHEN A.ACCOUNT = '51203' THEN 'TMP'
WHEN A.ACCOUNT = '52000' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '52000' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '52001' THEN 'TMP'
WHEN A.ACCOUNT = '52002' THEN 'TMP'
WHEN A.ACCOUNT = '52003' THEN 'TMP'
WHEN A.ACCOUNT = '52009' THEN 'TMP'
WHEN A.ACCOUNT = '52011' THEN 'TMP'
WHEN A.ACCOUNT = '52012' THEN 'TMP'
WHEN A.ACCOUNT = '52014' THEN 'TMP'
WHEN A.ACCOUNT = '52100' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '52100' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '52200' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '52200' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '52201' THEN 'TMP'
WHEN A.ACCOUNT = '52300' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '52300' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '52400' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '52400' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '52500' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '52500' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '53090' THEN 'TMP'
WHEN A.ACCOUNT = '53013' THEN 'TMP'
WHEN A.ACCOUNT = '53300' THEN 'TMP'
WHEN A.ACCOUNT = '53600' THEN 'TMP'
WHEN A.ACCOUNT = '53601' THEN 'TMP'
WHEN A.ACCOUNT = '53900' AND A.FUND_CODE IN('00','03','04','10','13','18','22') THEN 'REG'
WHEN A.ACCOUNT = '53900' AND A.FUND_CODE IN('20','23','24','28','89') THEN  'REG'
WHEN A.ACCOUNT = '53901' THEN 'TMP'
WHEN A.ACCOUNT = '53902' THEN 'TMP'
WHEN A.ACCOUNT = '53903' THEN 'REG'
WHEN A.ACCOUNT = '53904' THEN 'REG'
WHEN A.ACCOUNT = '54100' THEN 'TMP'
WHEN A.ACCOUNT = '54200' THEN 'REG'
WHEN A.ACCOUNT = '54202' THEN 'TMP'
WHEN A.ACCOUNT = '54204' THEN 'TMP'
WHEN A.ACCOUNT = '54218' THEN 'TMP'
WHEN A.ACCOUNT = '54330' THEN 'REG'
END






CLASS_IND
Descriptor for Account Class Indicator Code

DM-27 - PM Budgets vs Annual Distributions Closed

Character, 30No
Select Expand source to see code... 
/*+ CLASS_IND 12_04_17 */
CASE
WHEN A.CLASS_INDC = 'E'	THEN 'Benefits-Related'
WHEN A.CLASS_INDC = 'G' THEN 'Grad Asst'
WHEN A.CLASS_INDC = 'H' THEN 'Academic Administrator'
WHEN A.CLASS_INDC = 'L' THEN 'Overload'
WHEN A.CLASS_INDC = 'M' THEN 'Overtime'
WHEN A.CLASS_INDC = 'P' THEN 'Part-Time Temp Fac'
WHEN A.CLASS_INDC = 'R' THEN 'Regular'
WHEN A.CLASS_INDC = 'S' THEN 'Student'
WHEN A.CLASS_INDC = 'T' THEN 'Temporary'
WHEN A.CLASS_INDC = 'X' THEN 'Position Budget Transfer'
WHEN A.CLASS_INDC = 'Y' THEN 'Salary Pool'
END

POS_BASE_BUDGET


Base budget for the position (Base Salary and Wages)

DM-30 - PM Vacant Positions Closed DM-26 - pm budget rprt-No Totals Closed DM-23 - pm budget rprt Alicias all funds salary all cells FY16 Closed

DM-34 - pm budget rprt NSFA All Funds salary Rev Closed DM-21 - pm budget rprt BI Tool

Signed Number, 10,2Yes
Select Expand source to see code... 
/*+POS_BASE_BUDGET 09-11-17*/
SUM(A.UM_POS_BUD_BAS_AMT + A.UM_POS_BUD_PER_AMT)

POS_BASE_FRINGE


Base Fringe for the position

DM-30 - PM Vacant Positions Closed DM-26 - pm budget rprt-No Totals Closed DM-23 - pm budget rprt Alicias all funds salary all cells FY16 Closed DM-34 - pm budget rprt NSFA All Funds salary Rev Closed DM-21 - pm budget rprt BI Tool

Signed Number, 10,2Yes
Select Expand source to see code... 
/*+POS_BASE_FRINGE 09-11-17*/
SUM(A.UM_POS_BUD_FRB_AMT + A.UM_POS_BUD_FRP_AMT)

CUR_FRINGE

Current Fringe

DM-26 - pm budget rprt-No Totals Closed DM-23 - pm budget rprt Alicias all funds salary all cells FY16 Closed DM-21 - pm budget rprt BI Tool

Signed Number, 10,2Yes
Select Expand source to see code... 
/*+FR_CURR 09-12-17*/
Sum(A.UM_POS_BUD_FRB_AMT + A.UM_POS_BUD_FRP_AMT
+ A.UM_POS_BUD_FRT_AMT)

CURR_SAL_WAGE

Current Salary and Wages

DM-26 - pm budget rprt-No Totals Closed DM-23 - pm budget rprt Alicias all funds salary all cells FY16 Closed DM-21 - pm budget rprt BI Tool

Signed Number, 10,2Yes
Select Expand source to see code... 
/*+SALARY&WAGES_CURR 09-12-17*/
Sum(A.UM_POS_BUD_BAS_AMT + A.UM_POS_BUD_PER_AMT
+ A.UM_POS_BUD_TEM_AMT)