Created by Corina C Larsen, last modified by Miki Yanagi on Jul 12, 2021

The fields on this view that do not exist on UM_GLQ_REPRTING, were converted from Discoverer, but have not been verified.  We recommend UM_GLQ_REPRTING table for Finance reporting.

More Information

Code behind PS_UM_GLQ_REPRT_VW

KeyRecord.FieldnameFormatXLATHeading TextSource table(s)
→ACCOUNT - AccountChar10
Account

UM_GLQ_REPRTING

→ACCOUNTING_PERIOD - Accounting PeriodNum3.0
PeriodUM_GLQ_REPRTING

AMT1 - Amount 1SNm25.3
Amount 1NOT IN USE UM_GLQ_REPRTING

AMT2 - Amount 2SNm25.3
Amount 2NOT IN USE UM_GLQ_REPRTING

AMT3 - Amount 3SNm25.3
Amount 3NOT IN USE UM_GLQ_REPRTING

AMT4 - Amount 4SNm25.3
Amount 4NOT IN USE UM_GLQ_REPRTING
→BUSINESS_UNIT - Business UnitChar5
UnitUM_GLQ_REPRTING
→CLASS_FLD - Class FieldChar5
ClassUM_GLQ_REPRTING
→DEPTID - DepartmentChar10
DeptUM_GLQ_REPRTING

DESCR - DescriptionChar30
DescrUM_GLQ_REPRTING
→FISCAL_YEAR - Fiscal YearNum4.0
YearUM_GLQ_REPRTING
→FUND_CODE - Fund CodeChar5
FundUM_GLQ_REPRTING
→OPERATING_UNIT - Operating UnitChar8
Oper UnitUM_GLQ_REPRTING
→PROGRAM_CODE - Program CodeChar5
ProgramUM_GLQ_REPRTING
→PROJECT_ID - ProjectChar15
ProjectUM_GLQ_REPRTING

PROJECT_STATUS - Project StatusChar1NStatusUM_GLQ_REPRTING

ROOT_NODE_NUM - Root Node NumberNum10.0
Root NodeUM_GLQ_REPRTING
→STATISTICS_CODE - Statistics CodeChar3
StatUM_GLQ_REPRTING

TREE_NODE - Tree NodeChar20
NodeUM_GLQ_REPRTING

UM_ACCOUNT_GROUP - Account GroupChar60
Acct Group

UM_ACCT_BAL_CLS - Account Balance Sheet ClassChar20
Bal ClassUM_GLQ_REPRTING

UM_ACCT_BAL_CLS_D - Account Balance Sheet ClassChar60
Bal ClassUM_GLQ_REPRTING

UM_ACCT_CASH_FLW - Account Cash Flow ClassChar20
Cash FlowUM_GLQ_REPRTING

UM_ACCT_CASH_FLW_D - Account Cash Flow ClassChar60
Cash FlowUM_GLQ_REPRTING

UM_ACCT_CATEG - Account CategoryChar60
Acct Categ

UM_ACCT_CATEG_SORT - Account Category SortChar5
Acct Categ Sort

Miriam wants to sort the data by this field, but we will need to survey to more people for usage of this field. (DM-327)

SQL code - Alias A = UM_GLQ_REPRTNG 
(CASE
            WHEN (SUBSTR(A.ACCOUNT, 1, 1)) = '1' THEN
             (CASE
               WHEN A.ACCOUNT >= '10000' AND A.ACCOUNT <= '11099' THEN '110'
               WHEN A.ACCOUNT = '13900' THEN '110'
               WHEN A.ACCOUNT >= '11100' AND A.ACCOUNT <= '11199' THEN '110'
               WHEN A.ACCOUNT >= '11200' AND A.ACCOUNT <= '11250' THEN '110'
               WHEN A.ACCOUNT = '12025' THEN '112'
               WHEN A.ACCOUNT = '12024' THEN '112'
               WHEN A.ACCOUNT >= '12000' AND A.ACCOUNT <= '12023' THEN '112'
               WHEN A.ACCOUNT >= '12026' AND A.ACCOUNT <= '12059' THEN '112'
               WHEN A.ACCOUNT >= '13000' AND A.ACCOUNT <= '13002' THEN '114'
               WHEN A.ACCOUNT >= '13004' AND A.ACCOUNT <= '13159' THEN '114'
               WHEN A.ACCOUNT >= '13800' AND A.ACCOUNT <= '13899' THEN '114'
               WHEN A.ACCOUNT = '13003' THEN '114'
               WHEN A.ACCOUNT >= '13200' AND A.ACCOUNT <= '13266' THEN '116'
               WHEN A.ACCOUNT >= '13269' AND A.ACCOUNT <= '13359' THEN '116'
               WHEN A.ACCOUNT = '13400' THEN '118'
               WHEN A.ACCOUNT >= '13403' AND A.ACCOUNT <= '13449' THEN '118'
               WHEN A.ACCOUNT = '13401' THEN '118'
               WHEN A.ACCOUNT = '13402' THEN '118'
               WHEN A.ACCOUNT >= '14000' AND A.ACCOUNT <= '14999' THEN '120'
               WHEN A.ACCOUNT >= '15000' AND A.ACCOUNT <= '15199' THEN '122'
               WHEN A.ACCOUNT >= '15300' AND A.ACCOUNT <= '15999' THEN '122'
               WHEN A.ACCOUNT >= '16000' AND A.ACCOUNT <= '16199' THEN '124'
               WHEN A.ACCOUNT >= '16300' AND A.ACCOUNT <= '16999' THEN '124'
               WHEN A.ACCOUNT = '12064' THEN '112'
               WHEN A.ACCOUNT = '12065' THEN '112'
               WHEN A.ACCOUNT = '12700' THEN '126'
               WHEN A.ACCOUNT >= '13160' AND A.ACCOUNT <= '13162' THEN '114'
               WHEN A.ACCOUNT >= '13164' AND A.ACCOUNT <= '13199' THEN '114'
               WHEN A.ACCOUNT = '13163' THEN '116'
               WHEN A.ACCOUNT = '13267' THEN '116'
               WHEN A.ACCOUNT = '13268' THEN '116'
               WHEN A.ACCOUNT >= '13360' AND A.ACCOUNT <= '13399' THEN '116'
               WHEN A.ACCOUNT = '13450' THEN '118'
               WHEN A.ACCOUNT >= '13460' AND A.ACCOUNT <= '13499' THEN '118'
               WHEN A.ACCOUNT = '13451' THEN '118'
               WHEN A.ACCOUNT = '13452' THEN '118'
               WHEN A.ACCOUNT >= '12160' AND A.ACCOUNT <= '12200' THEN '128'
               WHEN A.ACCOUNT = '12300' THEN '128'
               WHEN A.ACCOUNT = '11260' THEN '128'
               WHEN A.ACCOUNT = '11360' THEN '128'
               WHEN A.ACCOUNT >= '13500' AND A.ACCOUNT <= '13749' THEN '130'
               WHEN A.ACCOUNT >= '16200' AND A.ACCOUNT <= '16299' THEN '130'
               WHEN A.ACCOUNT = '13750' THEN '130'
               WHEN A.ACCOUNT >= '15200' AND A.ACCOUNT <= '15299' THEN '132'
               WHEN A.ACCOUNT >= '17000' AND A.ACCOUNT <= '17059' THEN '134'
               WHEN A.ACCOUNT >= '17500' AND A.ACCOUNT <= '17560' THEN '134'
               WHEN A.ACCOUNT >= '17400' AND A.ACCOUNT <= '17499' THEN '134'
               WHEN A.ACCOUNT >= '17200' AND A.ACCOUNT <= '17259' THEN '134'
               WHEN A.ACCOUNT >= '17100' AND A.ACCOUNT <= '17159' THEN '134'
               WHEN A.ACCOUNT >= '17300' AND A.ACCOUNT <= '17359' THEN '134'
               WHEN A.ACCOUNT >= '17900' AND A.ACCOUNT <= '17959' THEN '134'
               WHEN A.ACCOUNT = '17060' THEN '134'
               WHEN A.ACCOUNT = '17260' THEN '134'
               WHEN A.ACCOUNT = '17160' THEN '134'
               WHEN A.ACCOUNT = '17360' THEN '134'
               WHEN A.ACCOUNT = '17960' THEN '134'
               WHEN A.ACCOUNT >= '10000' AND A.ACCOUNT <= '19999' THEN '136'
               ELSE '910'
             END)
            WHEN (SUBSTR(A.ACCOUNT, 1, 1)) = '2' THEN
             (CASE
               WHEN A.ACCOUNT >= '20100' AND A.ACCOUNT <= '20299' THEN
                '210'
               WHEN A.ACCOUNT >= '20500' AND A.ACCOUNT <= '20699' THEN
                '210'
               WHEN A.ACCOUNT >= '21000' AND A.ACCOUNT <= '21999' THEN
                '210'
               WHEN A.ACCOUNT >= '20000' AND A.ACCOUNT <= '20099' THEN
                '212'
               WHEN A.ACCOUNT >= '24000' AND A.ACCOUNT <= '24006' THEN
                '214'
               WHEN A.ACCOUNT >= '24008' AND A.ACCOUNT <= '24999' THEN
                '214'
               WHEN A.ACCOUNT >= '25000' AND A.ACCOUNT <= '25999' THEN
                '216'
               WHEN A.ACCOUNT = '20800' THEN
                '218'
               WHEN A.ACCOUNT = '20310' THEN
                '220'
               WHEN A.ACCOUNT = '20300' THEN
                '220'
               WHEN A.ACCOUNT = '20700' THEN
                '222'
               WHEN A.ACCOUNT = '20710' THEN
                '222'
               WHEN A.ACCOUNT = '20711' THEN
                '222'
               WHEN A.ACCOUNT = '26030' THEN
                '224'
               WHEN A.ACCOUNT >= '22100' AND A.ACCOUNT <= '22199' THEN
                '210'
               WHEN A.ACCOUNT = '24007' THEN
                '214'
               WHEN A.ACCOUNT = '23800' THEN
                '218'
               WHEN A.ACCOUNT = '23010' THEN
                '220'
               WHEN A.ACCOUNT >= '23000' AND A.ACCOUNT <= '23009' THEN
                '220'
               WHEN A.ACCOUNT >= '27000' AND A.ACCOUNT <= '27009' THEN
                '222'
               WHEN A.ACCOUNT >= '27010' AND A.ACCOUNT <= '27019' THEN
                '222'
               WHEN A.ACCOUNT = '26000' THEN
                '224'
               WHEN A.ACCOUNT = '26010' THEN
                '224'
               WHEN A.ACCOUNT = '26050' THEN
                '224'
               WHEN A.ACCOUNT = '27050' THEN
                '226'
               WHEN A.ACCOUNT >= '20000' AND A.ACCOUNT <= '29999' THEN
                '228'
               ELSE
                '910'
             END)
            WHEN (SUBSTR(A.ACCOUNT, 1, 1)) = '3' THEN
             (CASE
               WHEN A.ACCOUNT >= '30000' AND A.ACCOUNT <= '31999' THEN
                '310'
               WHEN A.ACCOUNT = '33111' THEN
                '310'
               WHEN A.ACCOUNT >= '32000' AND A.ACCOUNT <= '32999' THEN
                '320'
               WHEN A.ACCOUNT >= '33101' AND A.ACCOUNT <= '33110' THEN
                '320'
               WHEN A.ACCOUNT = '33112' THEN
                '320'
               WHEN A.ACCOUNT = '33100' THEN
                '330'
               WHEN A.ACCOUNT >= '35100' AND A.ACCOUNT <= '35199' THEN
                '340'
               WHEN A.ACCOUNT >= '34800' AND A.ACCOUNT <= '34899' THEN
                '350'
               WHEN A.ACCOUNT >= '35000' AND A.ACCOUNT <= '35099' THEN
                '360'
               WHEN A.ACCOUNT = '39999' THEN
                '370'
               WHEN A.ACCOUNT >= '30000' AND A.ACCOUNT <= '39999' THEN
                '380'
               ELSE
                '910'
             END)
            WHEN (SUBSTR(A.ACCOUNT, 1, 1)) = '4' THEN
             (CASE
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '401' THEN
                '410'
               WHEN A.ACCOUNT >= '40200' AND A.ACCOUNT <= '40249' THEN
                '410'
               WHEN A.ACCOUNT >= '40250' AND A.ACCOUNT <= '40269' THEN
                '410'
               WHEN A.ACCOUNT >= '40270' AND A.ACCOUNT <= '40299' THEN
                '410'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '403' THEN
                '410'
               WHEN A.ACCOUNT >= '40400' AND A.ACCOUNT <= '40449' THEN
                '410'
               WHEN A.ACCOUNT >= '40450' AND A.ACCOUNT <= '40469' THEN
                '410'
               WHEN A.ACCOUNT >= '40470' AND A.ACCOUNT <= '40499' THEN
                '410'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '405' THEN
                '410'
               WHEN A.ACCOUNT >= '40600' AND A.ACCOUNT <= '40649' THEN
                '410'
               WHEN A.ACCOUNT >= '40650' AND A.ACCOUNT <= '40669' THEN
                '410'
               WHEN A.ACCOUNT >= '40670' AND A.ACCOUNT <= '40699' THEN
                '410'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '407' THEN
                '410'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '408' THEN
                '410'
               WHEN A.ACCOUNT = '40900' THEN
                '410'
               WHEN A.ACCOUNT = '40901' THEN
                '410'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '410' THEN
                '410'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '411' THEN
                '410'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '412' THEN
                '410'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '413' THEN
                '410'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '414' THEN
                '410'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '415' THEN
                '410'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '416' THEN
                '410'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '420' THEN
                '410'
               WHEN A.ACCOUNT >= '42100' AND A.ACCOUNT <= '42999' THEN
                '410'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '430' THEN
                '412'
               WHEN A.ACCOUNT >= '43100' AND A.ACCOUNT <= '43101' THEN
                '412'
               WHEN A.ACCOUNT >= '43103' AND A.ACCOUNT <= '43499' THEN
                '412'
               WHEN A.ACCOUNT = '43102' THEN
                '412'
               WHEN A.ACCOUNT >= '43500' AND A.ACCOUNT <= '43519' THEN
                '414'
               WHEN (SUBSTR(A.ACCOUNT, 1, 4)) = '4352' THEN
                '414'
               WHEN A.ACCOUNT >= '43530' AND A.ACCOUNT <= '43599' THEN
                '414'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '436' THEN
                '416'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '438' THEN
                '416'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '437' THEN
                '416'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '440' THEN
                '418'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '441' THEN
                '418'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '442' THEN
                '420'
               WHEN A.ACCOUNT >= '44800' AND A.ACCOUNT <= '44819' THEN
                '422'
               WHEN A.ACCOUNT = '44890' THEN
                '422'
               WHEN A.ACCOUNT >= '45000' AND A.ACCOUNT <= '46999' THEN
                '424'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '470' THEN
                '426'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '471' THEN
                '426'
               WHEN A.ACCOUNT >= '47200' AND A.ACCOUNT <= '47999' THEN
                '426'
               WHEN (SUBSTR(A.ACCOUNT, 1, 2)) = '48' THEN
                '426'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '490' THEN
                '426'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '491' THEN
                '426'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '492' THEN
                '426'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '493' THEN
                '426'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '494' THEN
                '426'
               WHEN A.ACCOUNT >= '49500' AND A.ACCOUNT <= '49899' THEN
                '426'
               WHEN A.ACCOUNT >= '49900' AND A.ACCOUNT <= '49999' THEN
                '426'
               WHEN A.ACCOUNT >= '40000' AND A.ACCOUNT <= '49999' THEN
                '428'
               ELSE
                '910'
             END)
            WHEN (SUBSTR(A.ACCOUNT, 1, 1)) = '8' THEN
             (CASE
               WHEN A.ACCOUNT = '80000' THEN
                '610'
               WHEN A.ACCOUNT = '81500' THEN
                '810'
               WHEN A.ACCOUNT = '80300' THEN
                '610'
               WHEN A.ACCOUNT = '81600' THEN
                '810'
               WHEN A.ACCOUNT = '80400' THEN
                '610'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '824' THEN
                '610'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '810' THEN
                '610'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '813' THEN
                '610'
               WHEN A.ACCOUNT >= '81200' AND A.ACCOUNT <= '81210' THEN
                '610'
               WHEN A.ACCOUNT >= '82200' AND A.ACCOUNT <= '82210' THEN
                '610'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '820' THEN
                '610'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '823' THEN
                '610'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '811' THEN
                '610'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '821' THEN
                '610'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '831' THEN
                '610'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '851' THEN
                '610'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '818' THEN
                '710'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '828' THEN
                '710'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '848' THEN
                '710'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '825' THEN
                '610'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '826' THEN
                '610'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '827' THEN
                '610'
               WHEN A.ACCOUNT = '81900' THEN
                '540'
               WHEN A.ACCOUNT = '81902' THEN
                '540'
               WHEN A.ACCOUNT = '81920' THEN
                '540'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '829' THEN
                '540'
               WHEN A.ACCOUNT = '81901' THEN
                '540'
               WHEN A.ACCOUNT = '81910' THEN
                '540'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '850' THEN
                '610'
               WHEN A.ACCOUNT = '80099' THEN
                '610'
               WHEN A.ACCOUNT = '80399' THEN
                '610'
               WHEN A.ACCOUNT = '81299' THEN
                '610'
               WHEN A.ACCOUNT = '81599' THEN
                '810'
               WHEN A.ACCOUNT = '81699' THEN
                '810'
               WHEN A.ACCOUNT = '82299' THEN
                '610'
               WHEN A.ACCOUNT >= '80000' AND A.ACCOUNT <= '89999' THEN
                '610'
               WHEN A.ACCOUNT = '70000' THEN
                '612'
               WHEN A.ACCOUNT = '70050' THEN
                '612'
               WHEN A.ACCOUNT = '71500' THEN
                '812'
               WHEN A.ACCOUNT = '70300' THEN
                '612'
               WHEN A.ACCOUNT = '71600' THEN
                '812'
               WHEN A.ACCOUNT = '70400' THEN
                '612'
               WHEN A.ACCOUNT = '70410' THEN
                '612'
               WHEN A.ACCOUNT = '72400' THEN
                '612'
               WHEN A.ACCOUNT = '72410' THEN
                '612'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '710' THEN
                '612'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '713' THEN
                '612'
               WHEN A.ACCOUNT >= '71200' AND A.ACCOUNT <= '71250' THEN
                '612'
               WHEN A.ACCOUNT >= '72200' AND A.ACCOUNT <= '72210' THEN
                '612'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '720' THEN
                '612'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '723' THEN
                '612'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '711' THEN
                '612'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '721' THEN
                '612'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '731' THEN
                '612'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '751' THEN
                '612'
               WHEN A.ACCOUNT = '71800' THEN
                '710'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '728' THEN
                '710'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '748' THEN
                '710'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '725' THEN
                '612'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '726' THEN
                '612'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '727' THEN
                '612'
               WHEN A.ACCOUNT = '71900' THEN
                '540'
               WHEN A.ACCOUNT = '71920' THEN
                '540'
               WHEN A.ACCOUNT = '71921' THEN
                '710'
               WHEN A.ACCOUNT = '71922' THEN
                '550'
               WHEN A.ACCOUNT = '72900' THEN
                '540'
               WHEN A.ACCOUNT = '71801' THEN
                '540'
               WHEN A.ACCOUNT = '71910' THEN
                '540'
               WHEN A.ACCOUNT = '71911' THEN
                '710'
               WHEN A.ACCOUNT = '71912' THEN
                '550'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '750' THEN
                '612'
               WHEN A.ACCOUNT = '70099' THEN
                '612'
               WHEN A.ACCOUNT = '70399' THEN
                '612'
               WHEN A.ACCOUNT = '71299' THEN
                '612'
               WHEN A.ACCOUNT = '71599' THEN
                '812'
               WHEN A.ACCOUNT = '71699' THEN
                '812'
               WHEN A.ACCOUNT = '72299' THEN
                '612'
               WHEN A.ACCOUNT >= '70000' AND A.ACCOUNT <= '79999' THEN
                '612'
               ELSE
                '910'
             END)
            WHEN (SUBSTR(A.ACCOUNT, 1, 1)) = '5' THEN
             (CASE
               WHEN (SUBSTR(A.ACCOUNT, 1, 2)) = '50' THEN
                '510'
               WHEN (SUBSTR(A.ACCOUNT, 1, 2)) = '51' THEN
                '510'
               WHEN (SUBSTR(A.ACCOUNT, 1, 2)) = '52' THEN
                '510'
               WHEN A.ACCOUNT >= '53000' AND A.ACCOUNT <= '53899' THEN
                '510'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '539' THEN
                '510'
               WHEN (SUBSTR(A.ACCOUNT, 1, 2)) = '54' THEN
                '510'
               WHEN (SUBSTR(A.ACCOUNT, 1, 2)) = '55' THEN
                '530'
               WHEN A.ACCOUNT >= '60000' AND A.ACCOUNT <= '60299' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '603' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '609' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '604' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '605' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '606' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '607' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '608' THEN
                '520'
               WHEN A.ACCOUNT >= '61000' AND A.ACCOUNT <= '61399' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '614' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '615' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '616' THEN
                '520'
               WHEN A.ACCOUNT >= '62000' AND A.ACCOUNT <= '62007' THEN
                '520'
               WHEN A.ACCOUNT >= '62009' AND A.ACCOUNT <= '62060' THEN
                '520'
               WHEN A.ACCOUNT >= '62070' AND A.ACCOUNT <= '62207' THEN
                '520'
               WHEN A.ACCOUNT >= '62209' AND A.ACCOUNT <= '62499' THEN
                '520'
               WHEN A.ACCOUNT >= '62500' AND A.ACCOUNT <= '62507' THEN
                '710'
               WHEN A.ACCOUNT >= '62509' AND A.ACCOUNT <= '62707' THEN
                '710'
               WHEN A.ACCOUNT >= '62709' AND A.ACCOUNT <= '62999' THEN
                '710'
               WHEN A.ACCOUNT = '62008' THEN
                '520'
               WHEN A.ACCOUNT >= '62061' AND A.ACCOUNT <= '62069' THEN
                '520'
               WHEN A.ACCOUNT = '62208' THEN
                '520'
               WHEN A.ACCOUNT = '62508' THEN
                '520'
               WHEN A.ACCOUNT = '62708' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 2)) = '63' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '640' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '641' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '642' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '643' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '644' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '645' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '646' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '647' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '648' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '649' THEN
                '520'
               WHEN A.ACCOUNT >= '65000' AND A.ACCOUNT <= '65049' THEN
                '520'
               WHEN A.ACCOUNT >= '65051' AND A.ACCOUNT <= '65499' THEN
                '520'
               WHEN A.ACCOUNT = '65500' THEN
                '520'
               WHEN A.ACCOUNT = '65550' THEN
                '520'
               WHEN A.ACCOUNT = '66201' THEN
                '520'
               WHEN A.ACCOUNT >= '65600' AND A.ACCOUNT <= '65709' THEN
                '520'
               WHEN A.ACCOUNT >= '65710' AND A.ACCOUNT <= '65719' THEN
                '520'
               WHEN A.ACCOUNT >= '65720' AND A.ACCOUNT <= '65729' THEN
                '520'
               WHEN A.ACCOUNT >= '65730' AND A.ACCOUNT <= '65739' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '658' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '659' THEN
                '560'
               WHEN A.ACCOUNT = '66202' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '660' THEN
                '550'
               WHEN A.ACCOUNT = '66100' THEN
                '540'
               WHEN A.ACCOUNT = '66101' THEN
                '710'
               WHEN A.ACCOUNT = '66102' THEN
                '540'
               WHEN A.ACCOUNT = '67401' THEN
                '710'
               WHEN A.ACCOUNT >= '67000' AND A.ACCOUNT <= '67999' THEN
                '710'
               WHEN A.ACCOUNT >= '67000' AND A.ACCOUNT <= '67999' THEN
                '710'
               WHEN A.ACCOUNT = '65050' THEN
                '710'
               WHEN A.ACCOUNT = '66999' THEN
                '520'
               WHEN A.ACCOUNT >= '50000' AND A.ACCOUNT <= '69999' THEN
                '520'
               ELSE
                '910'
             END)
            WHEN (SUBSTR(A.ACCOUNT, 1, 1)) = '6' THEN
             (CASE
               WHEN (SUBSTR(A.ACCOUNT, 1, 2)) = '50' THEN
                '510'
               WHEN (SUBSTR(A.ACCOUNT, 1, 2)) = '51' THEN
                '510'
               WHEN (SUBSTR(A.ACCOUNT, 1, 2)) = '52' THEN
                '510'
               WHEN A.ACCOUNT >= '53000' AND A.ACCOUNT <= '53899' THEN
                '510'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '539' THEN
                '510'
               WHEN (SUBSTR(A.ACCOUNT, 1, 2)) = '54' THEN
                '510'
               WHEN (SUBSTR(A.ACCOUNT, 1, 2)) = '55' THEN
                '530'
               WHEN A.ACCOUNT >= '60000' AND A.ACCOUNT <= '60299' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '603' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '609' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '604' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '605' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '606' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '607' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '608' THEN
                '520'
               WHEN A.ACCOUNT >= '61000' AND A.ACCOUNT <= '61399' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '614' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '615' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '616' THEN
                '520'
               WHEN A.ACCOUNT >= '62000' AND A.ACCOUNT <= '62007' THEN
                '520'
               WHEN A.ACCOUNT >= '62009' AND A.ACCOUNT <= '62060' THEN
                '520'
               WHEN A.ACCOUNT >= '62070' AND A.ACCOUNT <= '62207' THEN
                '520'
               WHEN A.ACCOUNT >= '62209' AND A.ACCOUNT <= '62499' THEN
                '520'
               WHEN A.ACCOUNT >= '62500' AND A.ACCOUNT <= '62507' THEN
                '710'
               WHEN A.ACCOUNT >= '62509' AND A.ACCOUNT <= '62707' THEN
                '710'
               WHEN A.ACCOUNT >= '62709' AND A.ACCOUNT <= '62999' THEN
                '710'
               WHEN A.ACCOUNT = '62008' THEN
                '520'
               WHEN A.ACCOUNT >= '62061' AND A.ACCOUNT <= '62069' THEN
                '520'
               WHEN A.ACCOUNT = '62208' THEN
                '520'
               WHEN A.ACCOUNT = '62508' THEN
                '520'
               WHEN A.ACCOUNT = '62708' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 2)) = '63' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '640' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '641' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '642' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '643' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '644' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '645' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '646' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '647' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '648' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '649' THEN
                '520'
               WHEN A.ACCOUNT >= '65000' AND A.ACCOUNT <= '65049' THEN
                '520'
               WHEN A.ACCOUNT >= '65051' AND A.ACCOUNT <= '65499' THEN
                '520'
               WHEN A.ACCOUNT = '65500' THEN
                '520'
               WHEN A.ACCOUNT = '65550' THEN
                '520'
               WHEN A.ACCOUNT = '66201' THEN
                '520'
               WHEN A.ACCOUNT >= '65600' AND A.ACCOUNT <= '65709' THEN
                '520'
               WHEN A.ACCOUNT >= '65710' AND A.ACCOUNT <= '65719' THEN
                '520'
               WHEN A.ACCOUNT >= '65720' AND A.ACCOUNT <= '65729' THEN
                '520'
               WHEN A.ACCOUNT >= '65730' AND A.ACCOUNT <= '65739' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '658' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '659' THEN
                '560'
               WHEN A.ACCOUNT = '66202' THEN
                '520'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '660' THEN
                '550'
               WHEN A.ACCOUNT = '66100' THEN
                '540'
               WHEN A.ACCOUNT = '66101' THEN
                '710'
               WHEN A.ACCOUNT = '66102' THEN
                '540'
               WHEN A.ACCOUNT = '67401' THEN
                '710'
               WHEN A.ACCOUNT >= '67000' AND A.ACCOUNT <= '67999' THEN
                '710'
               WHEN A.ACCOUNT >= '67000' AND A.ACCOUNT <= '67999' THEN
                '710'
               WHEN A.ACCOUNT = '65050' THEN
                '710'
               WHEN A.ACCOUNT = '66999' THEN
                '520'
               WHEN A.ACCOUNT >= '50000' AND A.ACCOUNT <= '69999' THEN
                '520'
               ELSE
                '910'
             END)
            WHEN (SUBSTR(A.ACCOUNT, 1, 1)) = '7' THEN
             (CASE
               WHEN A.ACCOUNT = '80000' THEN
                '610'
               WHEN A.ACCOUNT = '81500' THEN
                '810'
               WHEN A.ACCOUNT = '80300' THEN
                '610'
               WHEN A.ACCOUNT = '81600' THEN
                '810'
               WHEN A.ACCOUNT = '80400' THEN
                '610'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '824' THEN
                '610'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '810' THEN
                '610'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '813' THEN
                '610'
               WHEN A.ACCOUNT >= '81200' AND A.ACCOUNT <= '81210' THEN
                '610'
               WHEN A.ACCOUNT >= '82200' AND A.ACCOUNT <= '82210' THEN
                '610'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '820' THEN
                '610'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '823' THEN
                '610'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '811' THEN
                '610'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '821' THEN
                '610'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '831' THEN
                '610'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '851' THEN
                '610'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '818' THEN
                '710'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '828' THEN
                '710'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '848' THEN
                '710'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '825' THEN
                '610'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '826' THEN
                '610'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '827' THEN
                '610'
               WHEN A.ACCOUNT = '81900' THEN
                '540'
               WHEN A.ACCOUNT = '81902' THEN
                '540'
               WHEN A.ACCOUNT = '81920' THEN
                '540'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '829' THEN
                '540'
               WHEN A.ACCOUNT = '81901' THEN
                '540'
               WHEN A.ACCOUNT = '81910' THEN
                '540'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '850' THEN
                '610'
               WHEN A.ACCOUNT = '80099' THEN
                '610'
               WHEN A.ACCOUNT = '80399' THEN
                '610'
               WHEN A.ACCOUNT = '81299' THEN
                '610'
               WHEN A.ACCOUNT = '81599' THEN
                '810'
               WHEN A.ACCOUNT = '81699' THEN
                '810'
               WHEN A.ACCOUNT = '82299' THEN
                '610'
               WHEN A.ACCOUNT >= '80000' AND A.ACCOUNT <= '89999' THEN
                '610'
               WHEN A.ACCOUNT = '70000' THEN
                '612'
               WHEN A.ACCOUNT = '70050' THEN
                '612'
               WHEN A.ACCOUNT = '71500' THEN
                '812'
               WHEN A.ACCOUNT = '70300' THEN
                '612'
               WHEN A.ACCOUNT = '71600' THEN
                '812'
               WHEN A.ACCOUNT = '70400' THEN
                '612'
               WHEN A.ACCOUNT = '70410' THEN
                '612'
               WHEN A.ACCOUNT = '72400' THEN
                '612'
               WHEN A.ACCOUNT = '72410' THEN
                '612'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '710' THEN
                '612'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '713' THEN
                '612'
               WHEN A.ACCOUNT >= '71200' AND A.ACCOUNT <= '71250' THEN
                '612'
               WHEN A.ACCOUNT >= '72200' AND A.ACCOUNT <= '72210' THEN
                '612'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '720' THEN
                '612'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '723' THEN
                '612'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '711' THEN
                '612'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '721' THEN
                '612'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '731' THEN
                '612'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '751' THEN
                '612'
               WHEN A.ACCOUNT = '71800' THEN
                '710'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '728' THEN
                '710'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '748' THEN
                '710'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '725' THEN
                '612'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '726' THEN
                '612'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '727' THEN
                '612'
               WHEN A.ACCOUNT = '71900' THEN
                '540'
               WHEN A.ACCOUNT = '71920' THEN
                '540'
               WHEN A.ACCOUNT = '71921' THEN
                '710'
               WHEN A.ACCOUNT = '71922' THEN
                '550'
               WHEN A.ACCOUNT = '72900' THEN
                '540'
               WHEN A.ACCOUNT = '71801' THEN
                '540'
               WHEN A.ACCOUNT = '71910' THEN
                '540'
               WHEN A.ACCOUNT = '71911' THEN
                '710'
               WHEN A.ACCOUNT = '71912' THEN
                '550'
               WHEN (SUBSTR(A.ACCOUNT, 1, 3)) = '750' THEN
                '612'
               WHEN A.ACCOUNT = '70099' THEN
                '612'
               WHEN A.ACCOUNT = '70399' THEN
                '612'
               WHEN A.ACCOUNT = '71299' THEN
                '612'
               WHEN A.ACCOUNT = '71599' THEN
                '812'
               WHEN A.ACCOUNT = '71699' THEN
                '812'
               WHEN A.ACCOUNT = '72299' THEN
                '612'
               WHEN A.ACCOUNT >= '70000' AND A.ACCOUNT <= '79999' THEN
                '612'
               ELSE
                '910'
             END)
            ELSE
             'Other'
          END)

UM_ACCT_DESCR - Account DescriptionChar30
Acct DescUM_GLQ_REPRTING

UM_ACCT_DESCRSHRT - Account Short DescriptionChar10
Acct Shrt DescUM_GLQ_REPRTING

UM_ACCT_DETAIL - Account DetailChar60
Acct Detail

UM_ACCT_DETAIL_SRT - Account Detail SortChar5
Acct Detail

UM_ACCT_FBAL_CLS - Account Fund Balance ClassChar20
Fund BalNOT IN USE UM_GLQ_REPRTING

UM_ACCT_FBAL_CLS_D - Account Fund Balance ClassChar60
Fund BalNOT IN USE UM_GLQ_REPRTING

UM_ACCT_GRP_SHORT - Account Group ShortChar1
Acct Grp Short

UM_ACCT_GRP_SHSORT - Account Group Short SortChar5
Acct Grp ShSort

UM_ACCT_GRP_SORT - Account Group SortChar5
Acct Grp Sort

UM_ACCT_REV2 - 2-Digit Account Revenue CodeChar20
2-Digit RevNOT IN USE UM_GLQ_REPRTING

UM_ACCT_REV2_D - 2-Digit Account Revenue CodeChar60
2-Digit RevNOT IN USE UM_GLQ_REPRTING

UM_ACCT_REV4 - 4-Digit Account Revenue CodeChar20
4-Digit RevNOT IN USE UM_GLQ_REPRTING

UM_ACCT_REV4_D - 4-Digit Account Revenue CodeChar60
4-Digit RevNOT IN USE UM_GLQ_REPRTING

UM_ACCT_STATUS - Account StatusChar1
Acct StUM_GLQ_REPRTING

UM_ACCT_SUBCAT_D - Account Subcategory DescrChar60
Acct Subcat DIt is currently using case statement, but should use UM_ACCT_SUBCAT_D field logic on UM_GLQ_ACCTA table

UM_ACCT_SUBCAT_SRT - Account SubCategory SortChar5
Acct Subcat Srt

UM_ACCT_SUM_MIX - Account SummaryChar20
Acct Sum

UM_ACCT_SUM_SHRT - Account Summary ShortChar20
Acct Sum Shrt

UM_ACCT_SUM_SHSORT - Account Sum Short SortChar5
Acct Sum ShSort

UM_ACCT_SUM_SORT - Account Sum SortChar5
Acct Sum Sort

UM_ACCT_TYPE_MIX - Account TypeChar60
Acct Type

UM_ACCT_TYPE_SORT - Account Type SortChar5
Acct Type Sort

UM_ACCT_YREND - Account Year End ScheduleChar20
Acct YrEndUM_GLQ_REPRTING

UM_ACCT_YREND_D - Account Year End ScheduleChar60
Acct YrEndUM_GLQ_REPRTING

UM_ACTUALS_CURR - Current MonthSNm25.2
Current MonthUM_GLQ_REPRTING

UM_ACTUALS_PTD - Actuals PTDSNm25.3
Actuals PTD

UM_ACTUALS_YTD - Actuals Year to DateSNm25.2
Year to DateUM_GLQ_REPRTING

UM_ACTUALS_YTD_C - Actuals Year to Date RecalcSNm25.2
Year to Date
SQL code - Alias A = UM_GLQ_REPRTNG 
CASE
WHEN (A.ACCOUNT >= '10000' AND A.ACCOUNT <= '29999') THEN        
A.UM_ACTUALS_YTD
WHEN (A.ACCOUNT >= '40000' AND A.ACCOUNT <= '89999') THEN         
A.UM_ACTUALS_YTD
WHEN A.ACCOUNT >= '30000' AND A.ACCOUNT <= '39999' THEN         
A.UM_PROJECT_TO_DT
ELSE   0
END

UM_ACTUALS_YTD_LY - Actuals YTD Last YearSNm25.2
Actuals YTD LY

UM_ACTUALS_YTD_PY - Actuals YTD Previous YearSNm25.2
Actuals YTD PY

UM_ACTUAL_ACTIVITY - Actuals ActivityChar1
Actuals ActivitUM_GLQ_REPRTING

UM_ASSET_CATEG - Asset CategoryChar60
Asset Categ

UM_ASSET_CATEG_SRT - Asset Category SortChar5
Asset Categ Sor

UM_ASSET_DETAIL - Asset DetailChar60
Asset Detail

UM_ASSET_DETL_SORT - Asset Detail SortChar5
Asset Detail SO

UM_ASSET_SUBCAT - Asset Sub CategoryChar20
Asset Subcat

UM_ASSET_SUBCT_SRT - Asset Sub Category SortChar5
Asset Subct Srt

UM_ASSET_TYPE - Asset TypeChar20
Asset Type

UM_ASSET_TYPE_SORT - Asset Type SortChar5
Asset Type Sort

UM_BASE_BUDGET - Base BudgetSNm25.2
Base BudgetUM_GLQ_REPRTING -SUM(POSTED_TOTAL_AMT) field from LEDGER_BUDG table

UM_BASE_BUDGET_CAL - Base Budget CalcSNm25.3
Base Budget

POSTED_TOTAL_AMT field from LEDGER_BUDG table - Limited to Revenue and Expense Accounts 40000-89999 (inclusive) 


UM_BBUDG_ACTIVITY - Base Budget Current ActivityChar1
Current ActivitUM_GLQ_REPRTING

UM_BENEFIT_CATEG - Benefit CategoryChar60
Benefit Categnot in use anymore

UM_BENEFIT_CAT_SRT - Benefit Category SortChar5
Benefit Cat Srtnot in use anymore

UM_BENEFIT_GROUP - Benefit GroupChar20
Benefit_groupnot in use anymore

UM_BENEFIT_GRP_SRT - Benefit Group SortChar5
Benefit Grp Srtnot in use anymore

UM_BENEFIT_TYPE - Benefit TypeChar60
Benefit Typenot in use anymore

UM_BENEFIT_TYP_SRT - Benefit Type SortChar5
Benefit Typ Srtnot in use anymore

UM_BUDGET_BALANCE - Budget BalanceSNm25.3
Budget Balance

UM_BU_DECODE - BU DecodeChar5
BU Decode

UM_BU_DECODE_SORT - BU Decode SortChar5
BU Decode Sort

UM_BU_DESCR - Business UnitChar30
Bus UnitUM_GLQ_REPRTING

UM_BU_DESCRSHORT - Business UnitChar10
Bus UnitUM_GLQ_REPRTING

UM_CAMPUS - CampusChar5
Campus

UM_CAMPUS_CATEG - Campus CategChar30
Campus Categ

UM_CAMPUS_CATG_SRT - Campus Categ SortChar5
Campus Catg Srt

UM_CAMPUS_GROUP - Campus GroupChar5
Campus Group

UM_CAMPUS_GRP_SRT - Campus Group SortChar5
Campus Grp Srt

UM_CAMPUS_NAME - Campus NameChar60
Campus Name

UM_CAMPUS_SORT - Campus SortChar5
Campus Sort

UM_CASH_BALANCE - Cash BalanceSNm25.3
Cash Balance

UM_CBUDG_ACTIVITY - Current Budget ActivityChar1
Current ActivitUM_GLQ_REPRTING

UM_CLASS_D - Class DescChar30
Class DescUM_GLQ_REPRTING

UM_COMP - CompChar20
CompIt is currently using case statement, but should use ALLOC_BEN_ACCOUNT tree.

UM_COMP1 - Comp1Char20
Comp1It is currently using case statement, but should use ALLOC_BEN_ACCOUNT tree.

UM_COMP_EXTERNAL - Comp ExternalChar20
Comp ExternalIt is currently using case statement, but should use ALLOC_BEN_ACCOUNT tree.

UM_COMP_INTERNAL - Comp InternalChar20
Comp InternalIt is currently using case statement, but should use ALLOC_BEN_ACCOUNT tree.

UM_CURRENT_BUDGET - Current BudgetSNm25.3
Current BudgertLimited to Revenue and Expense Accounts 40000-89999 (inclusive) 

CASE
WHEN (A.ACCOUNT >= '40000' AND A.ACCOUNT <= '89999') THEN  A.UM_Curr_Budget
ELSE 0 END


UM_CURR_BUDGET - Current BudgetSNm25.2
Current BudgetUM_GLQ_REPRTING

UM_CURR_BUDGET_LY - Current Budget Last YearSNm25.2
CurrBud LYUM_GLQ_REPRTING

UM_CURR_BUDGET_PY - Current Budget Previous YrSNm25.2
CurrBud PYUM_GLQ_REPRTING

UM_DEBT_SERVICE - Debt ServiceChar1
Debt Service

UM_DEPT_AUDIT_ADJ - Dept Audit AdjustmentChar1
Dept Audit Adj

UM_DEPT_CR_1 - Campus Responsibility Code 1Char20
CR_1UM_GLQ_REPRTING

UM_DEPT_CR_1_D - Campus Responsibility Code 1Char30
CR_1UM_GLQ_REPRTING

UM_DEPT_CR_2 - Campus Responsibility Code 2Char20
CR_2UM_GLQ_REPRTING

UM_DEPT_CR_2_D - Campus Responsibility Code 2Char30
CR_2UM_GLQ_REPRTING

UM_DEPT_CR_3 - Campus Responsibility Code 3Char20
CR_3UM_GLQ_REPRTING

UM_DEPT_CR_3_D - Campus Responsibility Code 3Char30
CR_3UM_GLQ_REPRTING

UM_DEPT_CR_4 - Campus Responsibility Code 4Char20
CR_4UM_GLQ_REPRTING

UM_DEPT_CR_4_D - Campus Responsibility Code 4Char30
CR_4UM_GLQ_REPRTING

UM_DEPT_DESCR - Department DescriptionChar30
Dept Desc

UM_DEPT_DESCR_SHRT - Department Short DescriptionChar10
Dept Short Desc

UM_DEPT_EXP2 - 2-Digit Department Expense CdChar20
Exp 2UM_GLQ_REPRTING

UM_DEPT_EXP2_D - 2-Digit Department Expense CdChar30
Exp 2UM_GLQ_REPRTING

UM_DEPT_EXP4 - 4-Digit Department Expense CdChar20
Exp 4UM_GLQ_REPRTING

UM_DEPT_EXP4_D - 4-Digit Department Expense CdChar30
Exp 4UM_GLQ_REPRTING

UM_DEPT_HR - Human resources departmentChar20
HR DeptUM_GLQ_REPRTING

UM_DEPT_HR_D - HR deptartment descriptionChar60
HR dept descrUM_GLQ_REPRTING

UM_DEPT_MGR - Department ManagerChar30
Dept MgrUM_GLQ_REPRTING

UM_DEPT_STATUS - Department StatusChar1
Dept St

UM_DEPT_YREND - Department Year EndChar20
Dept Yr EndUM_GLQ_REPRTING

UM_DEPT_YREND_D - Department YrEndChar60
Dept YrEndUM_GLQ_REPRTING

UM_ENCUMBRANCE - EncumbranceSNm25.3
Encumbrance

UM_ENCUM_ACTIVITY - Encumbrance Current ActivityChar1
Current ActivitUM_GLQ_REPRTING

UM_EXPENSE_CATEG - Expense CategChar60
Expense Categ

UM_EXPENSE_CATEG1 - Expense Categ1Char60
Expense Categ1

UM_EXPENSE_CAT_SRT - Expense Categ SortChar5
Expense Cat Srt

UM_EXPENSE_CT_SRT1 - Expense Categ Sort 1Char5
Expense Ct Srt1

UM_EXPENSE_DETAIL - Expense DetailChar60
Expense Detail

UM_EXPENSE_DETAIL1 - Expense Detail1Char60
Expense Detail1

UM_EXPENSE_DTL_SRT - Expense Detail SortChar5
Expense Det Srt

UM_EXPENSE_DT_SRT1 - Expense Detail Sort1Char5
Expense Dt Srt1

UM_EXPENSE_SBC_SRT - Expense Subcat SortChar5
Expense Sbc Srt

UM_EXPENSE_SB_SRT1 - Expense Subcat Sort1Char5
Expense Sb Srt1

UM_EXPENSE_SUBCAT - Expense SubcatChar60
Expense Subcat

UM_EXPENSE_SUBCAT1 - Expense Subcat1Char60
Expense Subcat1

UM_EXPENSE_TYPE - Expense TypeChar60
Expense Type

UM_EXPENSE_TYPE1 - Expense Type1Char60
Expense Type1

UM_EXPENSE_TYP_SR1 - Expense Type Sort1Char5
Expense Typ Sr1

UM_EXPENSE_TYP_SRT - Expense Type SortChar5
Expense Typ Srt

UM_FACILITIES_GRP - Facilities GroupChar60
Facilities Grp

UM_FACILITIES_G_SR - Facilities Group SortChar5
Facilities G Sr

UM_FUND_DESCR - Fund DescriptionChar30
Fund DescrUM_GLQ_REPRTING

UM_FUND_DESCRSHRT - Fund Short DescriptionChar10
Fund Shrt DescUM_GLQ_REPRTING

UM_FUND_EQ_CATEG - Fund EQ CategChar60
Fund EQ Categ

UM_FUND_EQ_CAT_SRT - Fund EQ Categ SortChar5
Fund EQ Cat Srt

UM_FUND_EQ_DETAIL - Fund EQ DetailChar60
Fund EQ Detail

UM_FUND_EQ_DTL_SRT - Fund EQ Detail SortChar5
Fund EQ Dtl Srt

UM_FUND_EQ_SBC_SRT - Fund EQ Subcat SortChar5
Fund EQ Sbc Srt

UM_FUND_EQ_SUBCAT - Fund EQ SubcatChar60
Fund EQ Subcat

UM_FUND_EQ_TYPE - Fund EQ TypeChar60
Fund EQ Type

UM_FUND_EQ_TYP_SRT - Fund EQ Type SortChar5
Fund EQ Typ Srt

UM_FUND_STATUS - Fund StatusChar1
Fund StatusUM_GLQ_REPRTING

UM_FUTURE_BUDGET - Future BudgetSNm25.2
Future BudgetUM_GLQ_REPRTING

UM_FUTURE_BUDGET_1 - Future Budget Scenerio 1SNm25.2
Future Budget 1UM_GLQ_REPRTING

UM_FUTURE_BUDGET_2 - Future Budget Scenerio 2SNm25.2
Future Budget 2UM_GLQ_REPRTING

UM_HR_GROUP - HR GroupChar60
HR Group

UM_HR_GROUP_SORT - HR Group SortChar5
HR Group Sort

UM_ITS_CATEGORY - ITS CategoryChar60
ITS Category

This case statement may be replaced by other existing field (Under investigation).

SQL code - Alias A = UM_GLQ_REPRTNG 
CASE
           WHEN A.ACCOUNT >= '40000' AND A.ACCOUNT <= '49999' THEN 'External Revenue'
           WHEN A.ACCOUNT >= '80000' AND A.ACCOUNT <= '89999' THEN 'External Revenue'
           WHEN A.ACCOUNT >= '65800' AND A.ACCOUNT <= '65899' AND A.DEPTID = '8450100' THEN  'Campus Allocation'
           WHEN A.ACCOUNT >= '65800' AND A.ACCOUNT <= '65899' THEN  'Internal Revenue - Interdepartmental Credits'
           WHEN A.ACCOUNT = '64012' AND A.DEPTID = '8750102' THEN  'Internal Revenue - Network Access Charges'
           WHEN A.ACCOUNT = '60802' AND A.DEPTID = '8750101' THEN 'Internal Revenue - Disk and Tape Rental Charges'
           WHEN A.ACCOUNT = '64000' AND A.DEPTID = '8750101' THEN 'Internal Revenue - Telephone Charges'
           WHEN A.ACCOUNT >= '60000' AND A.ACCOUNT <= '60102' THEN 'Consultants, Professional Services'
           WHEN A.ACCOUNT = '60103' THEN  'Supplies, Printing, Catering'
           WHEN A.ACCOUNT >= '60400' AND A.ACCOUNT <= '60499' THEN 'Supplies, Printing, Catering'
           WHEN A.ACCOUNT >= '60600' AND A.ACCOUNT <= '60699' THEN 'Supplies, Printing, Catering'
           WHEN A.ACCOUNT >= '61000' AND A.ACCOUNT <= '61005' THEN 'Supplies, Printing, Catering'
           WHEN A.ACCOUNT >= '61015' AND A.ACCOUNT <= '61099' THEN 'Supplies, Printing, Catering'
           WHEN A.ACCOUNT = '60109' THEN 'Professional Development, Training, Subscriptions'
           WHEN A.ACCOUNT >= '60300' AND A.ACCOUNT <= '60305' THEN  'Professional Development, Training, Subscriptions'
           WHEN A.ACCOUNT >= '60900' AND A.ACCOUNT <= '60999' THEN 'Professional Development, Training, Subscriptions'
           WHEN A.ACCOUNT >= '64000' AND A.ACCOUNT <= '64099' THEN 'Telecom, Computing, Television Services'
           WHEN A.ACCOUNT = '65000' THEN 'Telecom, Computing, Television Services'
           WHEN A.ACCOUNT >= '60800' AND A.ACCOUNT <= '60899' THEN  'Rentals, Leases'
           WHEN A.ACCOUNT = '64700' AND A.DEPTID = '8450100' THEN  'Maintenance, Software'
           WHEN A.ACCOUNT = '64700' AND A.DEPTID = '8750101' AND A.CLASS_FLD = '03' THEN  'Maintenance, Software'
           WHEN A.ACCOUNT = '64700' THEN 'Maintenance, Hardware'
           WHEN A.ACCOUNT = '64750' THEN  'Maintenance, Software'
           WHEN A.ACCOUNT >= '62000' AND A.ACCOUNT <= '62013' THEN 'Equipment, <$5,000'
           WHEN A.ACCOUNT = '62200' THEN 'Equipment, <$5,000'
           WHEN A.ACCOUNT = '62204' THEN 'Equipment, <$5,000'
           WHEN A.ACCOUNT >= '62500' AND A.ACCOUNT <= '62504' THEN  'Equipment, >$5,000 (capital)'
           WHEN A.ACCOUNT = '62700' THEN 'Equipment, >$5,000 (capital)'
           WHEN A.ACCOUNT = '62704' THEN 'Equipment, >$5,000 (capital)'          
           WHEN A.ACCOUNT = '62016' THEN 'Software Licenses, <$5,000'
           WHEN A.ACCOUNT = '62216' THEN  'Software Licenses, <$5,000'
           WHEN A.ACCOUNT = '62516' THEN   'Software Licenses, >$5,000 (capital)'
           WHEN A.ACCOUNT >= '61400' AND A.ACCOUNT <= '61499' THEN 'Travel'
           WHEN A.ACCOUNT >= '61500' AND A.ACCOUNT <= '61599' THEN 'Travel'
           WHEN A.ACCOUNT >= '64100' AND A.ACCOUNT <= '64300' THEN  'Facilities Maintenance, Electricity, Renovation, Moving'
           WHEN A.ACCOUNT = '64409' THEN  'Facilities Maintenance, Electricity, Renovation, Moving'
           WHEN A.ACCOUNT = '64800' THEN  'Facilities Maintenance, Electricity, Renovation, Moving'
           WHEN A.ACCOUNT = '64900' THEN   'Facilities Maintenance, Electricity, Renovation, Moving'
           WHEN A.ACCOUNT = '60701' THEN   'Vehicles'
           WHEN A.ACCOUNT = '62715' THEN   'Vehicles'
           WHEN A.ACCOUNT = '64703' THEN    'Vehicles'
           WHEN A.ACCOUNT >= '64600' AND A.ACCOUNT <= '64699' THEN  'Vehicles'
           WHEN A.ACCOUNT = '66100' THEN   'Depreciation, Debt Service'
           WHEN A.ACCOUNT >= '65900' AND A.ACCOUNT <= '65999' THEN  'Depreciation, Debt Service'
           WHEN A.ACCOUNT >= '71900' AND A.ACCOUNT <= '71999' THEN  'Depreciation, Debt Service'
           WHEN A.ACCOUNT = '61008' THEN 'Transfers'
           WHEN A.ACCOUNT >= '70000' AND A.ACCOUNT <= '79999' THEN  'Transfers'
           WHEN A.ACCOUNT >= '67000' AND A.ACCOUNT <= '67999' THEN  'ERP Capital'
           WHEN A.ACCOUNT >= '50000' AND A.ACCOUNT <= '54999' THEN   'Compensation'
           ELSE  'Other'
         END

UM_ITS_CATEGRY_SRT - ITS Category SortChar5
ITS Categry Srt

This case statement may be replaced by other existing field (Under investigation).

SQL code - Alias A = UM_GLQ_REPRTING 
CASE
          WHEN A.ACCOUNT >= '60000' AND A.ACCOUNT <= '60102' THEN   '01'
           WHEN A.ACCOUNT = '60109' THEN  '02'
           WHEN A.ACCOUNT >= '60300' AND A.ACCOUNT <= '60305' THEN  '02'
           WHEN A.ACCOUNT >= '60900' AND A.ACCOUNT <= '60999' THEN  '02'
           WHEN A.ACCOUNT >= '62000' AND A.ACCOUNT <= '62013' THEN   '03'
           WHEN A.ACCOUNT = '62200' THEN  '03'
           WHEN A.ACCOUNT = '62204' THEN  '03'
           WHEN A.ACCOUNT >= '62500' AND A.ACCOUNT <= '62504' THEN  '04'
           WHEN A.ACCOUNT = '62700' THEN  '04'
           WHEN A.ACCOUNT = '62704' THEN  '04'
           WHEN A.ACCOUNT = '62016' THEN  '05'
           WHEN A.ACCOUNT = '62216' THEN  '05'
           WHEN A.ACCOUNT = '62516' THEN  '06'
           WHEN A.ACCOUNT = '64700' THEN  '07'
           WHEN A.ACCOUNT = '64700' AND A.DEPTID = '8450100' THEN '08'
           WHEN A.ACCOUNT = '64700' AND A.DEPTID = '8750101' AND   A.CLASS_FLD = '03' THEN  '08'
           WHEN A.ACCOUNT = '64750' THEN  '08'
           WHEN A.ACCOUNT >= '64000' AND A.ACCOUNT <= '64099' THEN  '09'
           WHEN A.ACCOUNT = '65000' THEN  '09'
           WHEN A.ACCOUNT >= '60800' AND A.ACCOUNT <= '60899' THEN  '10'
           WHEN A.ACCOUNT = '60103' THEN   '11'
           WHEN A.ACCOUNT >= '60400' AND A.ACCOUNT <= '60499' THEN  '11'
           WHEN A.ACCOUNT >= '60600' AND A.ACCOUNT <= '60699' THEN   '11'
           WHEN A.ACCOUNT >= '61000' AND A.ACCOUNT <= '61005' THEN  '11'
           WHEN A.ACCOUNT >= '61015' AND A.ACCOUNT <= '61099' THEN  '11'  
           WHEN A.ACCOUNT >= '61400' AND A.ACCOUNT <= '61499' THEN  '12'
           WHEN A.ACCOUNT >= '61500' AND A.ACCOUNT <= '61599' THEN  '12'
           WHEN A.ACCOUNT = '60701' THEN  '13'
           WHEN A.ACCOUNT = '62715' THEN  '13'
           WHEN A.ACCOUNT = '64703' THEN  '13'
           WHEN A.ACCOUNT >= '64600' AND A.ACCOUNT <= '64699' THEN  '13'
           WHEN A.ACCOUNT = '64900' THEN  '14'           
           WHEN A.ACCOUNT >= '64100' AND A.ACCOUNT <= '64300' THEN  '14'
           WHEN A.ACCOUNT = '64409' THEN  '14'
           WHEN A.ACCOUNT = '64800' THEN  '14'
           WHEN A.ACCOUNT = '66100' THEN  '15'
           WHEN A.ACCOUNT >= '65900' AND A.ACCOUNT <= '65999' THEN  '15'
           WHEN A.ACCOUNT >= '71900' AND A.ACCOUNT <= '71999' THEN '15'
           WHEN A.ACCOUNT = '61008' THEN '17'
           WHEN A.ACCOUNT >= '70000' AND A.ACCOUNT <= '79999' THEN '17'
           WHEN A.ACCOUNT >= '50000' AND A.ACCOUNT <= '54999' THEN  '18'
           WHEN A.ACCOUNT >= '67000' AND A.ACCOUNT <= '67999' THEN  '19'
           WHEN A.ACCOUNT >= '40000' AND A.ACCOUNT <= '49999' THEN '20'
           WHEN A.ACCOUNT >= '80000' AND A.ACCOUNT <= '89999' THEN  '20'
           WHEN A.ACCOUNT >= '65800' AND A.ACCOUNT <= '65899' AND  A.DEPTID = '8450100' THEN  '21'
           WHEN A.ACCOUNT >= '65800' AND A.ACCOUNT <= '65899' THEN  '22'
           WHEN A.ACCOUNT = '64012' AND A.DEPTID = '8750102' THEN   '23'
           WHEN A.ACCOUNT = '60802' AND A.DEPTID = '8750101' THEN  '24'
           WHEN A.ACCOUNT = '64000' AND A.DEPTID = '8750101' THEN   '25'
           ELSE  '16'
         END

UM_ITS_CLASS_CODE - ITS Class CodeChar60
ITS Class Code

This case statement may be replaced by other existing field (Under investigation).

SQL code - Alias A = UM_GLQ_REPRTING 
CASE
           WHEN A.DEPTID = '8450102' AND A.FUND_CODE = '00' AND A.CLASS_FLD = '55' THEN 'Competency Center'
           WHEN A.DEPTID = '8450102' AND A.Program_Code = '87677' AND  A.FUND_CODE = '00' THEN            
       CASE
              WHEN A.ACCOUNT = '60002' AND A.CLASS_FLD = '01' THEN  'Touchnet'
              WHEN A.ACCOUNT = '60002' AND A.CLASS_FLD = '20' THEN  'SciQuest'
              WHEN A.ACCOUNT = '60100' AND A.CLASS_FLD = '16' THEN  'Academe Solutions'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '01' THEN  'FSA'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '02' THEN  'Oracle Metrics'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '03' THEN  'RMS Housing'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '04' THEN  'SunGard'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '05' THEN  'T & E'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '06' THEN  'Oracle Warehouse'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '07' THEN  'Safari/Financier'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '08' THEN  'CAFM'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '09' THEN  'VFA'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '10' THEN  'Document Management'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '11' THEN  'WEBDSIS - Oakleaf'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '12' THEN  'CRM'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '13' THEN  'UPK'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '14' THEN  'Resource 25'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '15' THEN  'Address Cleansing - QAS'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '16' THEN  'Academe Solutions'
              ELSE   ' '   END
           WHEN A.DEPTID = '8450102' AND A.Program_Code = '87678' AND A.FUND_CODE = '00' THEN
            CASE
              WHEN A.ACCOUNT = '64700' AND A.CLASS_FLD = '02' THEN  'MaineStreet Hardware Maintenance'
              WHEN A.ACCOUNT = '64700' AND A.CLASS_FLD = '05' THEN  'Backup Systems'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '02' THEN  'MaineStreet Software Maintenance'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '05' THEN  'Oracle Software'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '08' THEN  'ImageNow Software'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '10' THEN  'Oracle MicroFocus COBOL'
              ELSE  ' ' END
           WHEN A.DEPTID = '8750101' AND A.FUND_CODE = '00' THEN
            CASE
              WHEN A.ACCOUNT = '64700' AND A.CLASS_FLD = '01' THEN  'IBM Hardware'
              WHEN A.ACCOUNT = '64700' AND A.CLASS_FLD = '02' THEN  'SUN Hardware'
              WHEN A.ACCOUNT = '64700' AND A.CLASS_FLD = '04' THEN  'Other/Misc'
              WHEN A.ACCOUNT = '64700' AND A.CLASS_FLD = '05' THEN  'Storage Maintenance'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '01' THEN  'IBM Software'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '02' THEN  'SUN Software'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '03' THEN  'Quantum Hardware'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '04' THEN  'Blackboard'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '05' THEN  'Oracle DB'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '06' THEN  'Mainframe Non-IBM'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '07' THEN  'State GIS SLA'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '08' THEN  'ImageNow'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '09' THEN  'Other/Misc'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '10' THEN  'Oracle COBOL'
              WHEN A.ACCOUNT = '64750' AND A.CLASS_FLD = '11' THEN  'StorageScape - ID Mgt'
              ELSE    ' '   END
           WHEN A.DEPTID = '8750102' AND A.FUND_CODE = '00' THEN
            CASE
              WHEN A.ACCOUNT = '64012' AND A.CLASS_FLD = '03' THEN  'Internet 2 Fees'
              WHEN A.ACCOUNT = '64012' AND A.CLASS_FLD = '04' THEN  'Internet Access'
              WHEN A.ACCOUNT = '64012' AND A.CLASS_FLD = '05' THEN  'Digital Certificates/Domain Names'
              WHEN A.ACCOUNT = '64012' AND A.CLASS_FLD = '09' THEN  'DIC CIRC/CREDIT (Internal Credits)'
              ELSE  ' '  END
           ELSE   ' ' END

UM_ITS_GROUP - ITS GroupChar60
ITS Group

UM_ITS_GROUP_SORT - ITS Group SortChar5
ITS Group Sort

UM_ITS_REV_EXP - ITS Rev ExpChar20
ITS Rev Exp

UM_LIAB_CATEG - Liab CategChar20
Liab Categ

UM_LIAB_CATEG_SORT - Liab Categ SortChar5
Liab Categ Sort

UM_LIAB_DETAIL - Liab DetailChar60
Liab Detail

UM_LIAB_DETAIL_SRT - Liab Detail SortChar5
Liab Detail Srt

UM_LIAB_SUBCAT - Liab SubcatChar60
Liab Subcat

UM_LIAB_SUBCAT_SRT - Liab Subcat SortChar5
Liab Subcat Srt

UM_LIAB_TYPE - Liab TypeChar60
Liab Type

UM_LIAB_TYPE_SORT - Liab Type SortChar5
Liab Type Sort

UM_MONTH_ENDING - Month EndingChar13
Month Ending

UM_NET_TRFR_CATEG - Net Trfr CategChar20
Net Trfr Categ

UM_NET_TRFR_CT_SRT - Net Trfr Categ SortChar5
Net Trfr Ct Srt

UM_NET_TRFR_DETAIL - Net Trfr DetailChar60
Net Trfr Detail

UM_NET_TRFR_DT_SRT - Net Trfr Detail SortChar5
Net Trfr Dt Srt

UM_NET_TRFR_SB_SRT - NET TRFR SUBCAT SORTChar5
Net Trfr Sb Srt

UM_NET_TRFR_SUBCAT - Net Trfr SubcatChar60
Net Trfr Subcat

UM_NET_TRFR_TP_SRT - Net Trfr Type SortChar5
Net Trfr Tp Srt

UM_NET_TRFR_TYPE - Net Trfr TypeChar60
Net Trfr Type

UM_OPUN_DESCR - Operating Unit DescriptionChar30
Oper Unit DescUM_GLQ_REPRTING

UM_OPUN_DESCRSHRT - Operating Unit Short DescrChar10
OpUn DescrshrtUM_GLQ_REPRTING

UM_OPUN_STATUS - Operating Unit StatusChar1
Oper Unit St

UM_PRE_ENCUMBRANCE - Pre-EncumbranceSNm25.2
Pre-EncumbranceUM_GLQ_REPRTING

UM_PRIOR_PERIOD_AD - Prior Period AdjustmentChar1
Prior Period Ad

UM_PROG_CAT1 - Program Category 1Char20
Prog Cat 1UM_GLQ_REPRTING

UM_PROG_CAT1_D - Program Category 1Char30
Prog Cat 1UM_GLQ_REPRTING

UM_PROG_CAT2 - Program Category 2Char20
Prog Cat 2UM_GLQ_REPRTING

UM_PROG_CAT2_D - Program Category 2Char30
Prog Cat 2UM_GLQ_REPRTING

UM_PROG_CAT3 - Program Category 3Char20
Prog Cat 3UM_GLQ_REPRTING

UM_PROG_CAT3_D - Program Category 3Char30
Prog Cat 3UM_GLQ_REPRTING

UM_PROG_CAT4 - Program Category 4Char20
Prog Cat 4UM_GLQ_REPRTING

UM_PROG_CAT4_D - Program Category 4Char30
Prog Cat 4UM_GLQ_REPRTING

UM_PROG_DESCR - Program DescriptionChar30
Prog DescrUM_GLQ_REPRTING

UM_PROG_DESCR_SHRT - Program Short DescriptionChar30
Prog Shrt DescrUM_GLQ_REPRTING

UM_PROG_ENDOW_DIST - Program Endow DistChar20
Prog Endow DistUM_GLQ_REPRTING

UM_PROG_EXPENSE - Program Expenditure CategoryChar20
Prog Exp CatUM_GLQ_REPRTING

UM_PROG_EXPENSE_D - Program Expenditure CategoryChar60
Prog Exp CatUM_GLQ_REPRTING

UM_PROG_MGR_NAME - Program Manager NameChar30
Prog MgrUM_GLQ_REPRTING

UM_PROG_RESTR_1 - Program Restriction 1Char20
Prog Restr 1UM_GLQ_REPRTING

UM_PROG_RESTR_1_D - Program Restriction 1Char30
Prog Restr 1UM_GLQ_REPRTING

UM_PROG_RESTR_2 - Program Restriction 2Char20
Prog Restr 2UM_GLQ_REPRTING

UM_PROG_RESTR_2_D - Program Restriction 2Char30
Prog Restr 2UM_GLQ_REPRTING

UM_PROG_RESTR_3 - Program Restriction 3Char20
Prog Restr 3UM_GLQ_REPRTING

UM_PROG_RESTR_3_D - Program Restriction 3Char30
Prog Restr 3UM_GLQ_REPRTING

UM_PROG_STATUS - Program StatusChar1
Prog StUM_GLQ_REPRTING

UM_PROG_TI_INC_DST - Program TI INC DistChar20
Proj TI INC DstUM_GLQ_REPRTING

UM_PROG_YREND - Program YrEndChar20
Prog YrEndUM_GLQ_REPRTING

UM_PROG_YREND_D - Program YrEndChar30
Prog YrEndUM_GLQ_REPRTING

UM_PROJECT_TO_DT - Project to DateSNm25.2
Project to DateUM_GLQ_REPRTING

UM_PROJ_BILL_CD - Project Billing CodeChar20
Proj Bill CdUM_GLQ_REPRTING

UM_PROJ_BILL_CD_D - Project Billing CodeChar60
Proj Bill CdUM_GLQ_REPRTING

UM_PROJ_BLD_LIFE - Project BLD LifeChar20
Project BLD LifUM_GLQ_REPRTING

UM_PROJ_CAP_TYPE - Project Capital TypeChar20
Proj Cap TypeUM_GLQ_REPRTING

UM_PROJ_CAP_TYPE_D - Project Capital TypeChar30
Proj Cap TypeUM_GLQ_REPRTING

UM_PROJ_CATEGORY - Project CategoryChar20
Proj CategoryUM_GLQ_REPRTING

UM_PROJ_CATEGORY_D - Project CategoryChar30
Proj CategoryUM_GLQ_REPRTING

UM_PROJ_CFDA_N - Project CFDA NumberChar20
Proj CFDA NbrUM_GLQ_REPRTING

UM_PROJ_CFDA_N_D - Project CFDA NumberChar60
Proj CFDA NbrUM_GLQ_REPRTING

UM_PROJ_CLOSNCOMBO - Project Closing CombinationChar20
Proj ClsComboUM_GLQ_REPRTING

UM_PROJ_CLSCOMBO_D - Project Closing CombinationChar30
Proj ClsCombo DUM_GLQ_REPRTING

UM_PROJ_DEPR_ST - Project Depreciation StatusChar20
Proj Depr StUM_GLQ_REPRTING

UM_PROJ_DEPR_ST_D - Project Depreciation StatusChar60
Proj Depr StUM_GLQ_REPRTING

UM_PROJ_DESCR - Project DescriptionChar30
Proj DescrUM_GLQ_REPRTING

UM_PROJ_EFF_STATUS - Project Effective StatusChar1
Proj Eff StUM_GLQ_REPRTING

UM_PROJ_END_DT - Project End DateDate
Proj End DtUM_GLQ_REPRTING

UM_PROJ_EXPENSE - Project Expenditure CategoryChar20
Proj Exp CatUM_GLQ_REPRTING

UM_PROJ_EXPENSE_D - Project Expenditure CategoryChar60
Proj Exp CatUM_GLQ_REPRTING

UM_PROJ_FACIL_ID - Project Facilty NumberChar20
Proj Facil NbrUM_GLQ_REPRTING

UM_PROJ_FACIL_ID_D - Project Facility NumberChar60
Proj Facil NbrUM_GLQ_REPRTING

UM_PROJ_FED_AGCY - Project Federal AgencyChar20
Proj Fed AgncyUM_GLQ_REPRTING

UM_PROJ_FED_AGCY_D - Project Federal AgencyChar60
Proj Fed AgncyUM_GLQ_REPRTING

UM_PROJ_FIN_CONT - Project Fin ContactChar20
Project Fin ConUM_GLQ_REPRTING

UM_PROJ_FIN_CONT_D - Project Fin ContactChar60
Project Fin ConUM_GLQ_REPRTING

UM_PROJ_GC_RPT - Project GC ReportChar20
Project GC RepoUM_GLQ_REPRTING

UM_PROJ_GC_RPT_D - Project GC ReportChar60
Project GC RptUM_GLQ_REPRTING

UM_PROJ_GC_TYPE - Project Grant/Contract TypeChar20
Proj GC TypeUM_GLQ_REPRTING

UM_PROJ_GC_TYPE_D - Project Grant/ContractTypeChar60
Proj GC TypeUM_GLQ_REPRTING

UM_PROJ_GRANT_N - Project Grant NumberChar20
Proj Grant NbrUM_GLQ_REPRTING

UM_PROJ_GRANT_N_D - Project Grant NumberChar60
Proj Grant NbrUM_GLQ_REPRTING

UM_PROJ_GROUP - Project GroupChar20
Proj GroupUM_GLQ_REPRTING

UM_PROJ_GROUP_D - Project GroupChar30
Proj GroupUM_GLQ_REPRTING

UM_PROJ_IMPVT_LIFE - Project IMPVT LifeChar20
Proj IMPVT LifeUM_GLQ_REPRTING

UM_PROJ_IN_SRVC - Project In-Service DateDate
Proj In-Srvc DtUM_GLQ_REPRTING

UM_PROJ_LOC_EXPIRE - Project Loc ExpireChar20
Project Loc ExpUM_GLQ_REPRTING

UM_PROJ_LOC_NUM - Project Letter of Credit NbrChar20
Proj LOC NbrUM_GLQ_REPRTING

UM_PROJ_LOC_NUM_D - Project Letter of Credit NbrChar60
Proj LOC NbrUM_GLQ_REPRTING

UM_PROJ_LOC_SRCE - Project Letter of Cred SourceChar20
Proj LOC SourceUM_GLQ_REPRTING

UM_PROJ_LOC_SRCE_D - Project Letter of Cred SourceChar30
Proj LOC SourceUM_GLQ_REPRTING

UM_PROJ_MAJSRC - Project Major Funding SourceChar20
Proj Maj SourceUM_GLQ_REPRTING

UM_PROJ_MAJSRC_D - Project Major Funding SourceChar30
Proj Maj SourceUM_GLQ_REPRTING

UM_PROJ_MGR_EFFDT - Project Manager EffdtDate
Proj Mgr EffUM_GLQ_REPRTING

UM_PROJ_MGR_ID - Project Manager IdChar11
Proj Mgr IdUM_GLQ_REPRTING

UM_PROJ_MGR_NAME - Project ManagerChar30
Proj MgrUM_GLQ_REPRTING

UM_PROJ_MINSRC - Project Minor Funding SourceChar20
Proj Min SourceUM_GLQ_REPRTING

UM_PROJ_MINSRC_D - Project Minor Funding SourceChar30
Proj Min SourceUM_GLQ_REPRTING

UM_PROJ_START_DT - Project Start DateDate
Proj Start dtUM_GLQ_REPRTING

UM_PROJ_STAT_EFFDT - Project status effdtDate
Proj Status EffUM_GLQ_REPRTING

UM_PROJ_SUBGROUP - Project SubgroupChar20
Proj SubgroupUM_GLQ_REPRTING

UM_PROJ_SUBGROUP_D - Project SubgroupChar30
Proj SubgroupUM_GLQ_REPRTING

UM_REPORTING_FLAG - Reporting FlagChar1
Reporting Flag

UM_REVENUE_CATEG - Revenue CategChar60
Revenue Categ

UM_REVENUE_CAT_SRT - Revenue Categ SortChar5
Revenue Cat Srt

UM_REVENUE_DETAIL - Revenue DetailChar60
Revenue Detail

UM_REVENUE_DET_SRT - Revenue Detail SortChar5
Revenue Det Srt

UM_REVENUE_DIV - Revenue DivChar60
Revenue Div

UM_REVENUE_DIV_SRT - Revenue Div SortChar5
Revenue Div Srt

UM_REVENUE_SUBCAT - Revenue SubcatChar60
Revenue Subcat

UM_REVENUE_SUB_SRT - Revenue Subcat SortChar5
Revenue Sub Srt

UM_REVENUE_TYPE - Revenue TypeChar60
Revenue Type

UM_REVENUE_TYP_SRT - Revenue Type SortChar5
Revenue Typ Srt

UM_RPT_CATEG - Rpt CategChar60
Rpt Categ

UM_RPT_EXPENSE_CAT - Rpt Expense Categ 1Char60
Rpt Expense Cat

UM_RPT_EXPENSE_TP1 - Rpt Expense Type1Char60
Rpt Expense Tp1

UM_RPT_EXPENSE_TYP - Rpt Expense TypeChar60
Rpt Expense Typ

UM_RPT_EXP_CT_SRT1 - Rpt Expense Categ Sort1Char5
Rpt Exp Ct Srt1

UM_RPT_EXP_GP_SRT1 - Rpt Expense Group Sort1Char5
Rpt Exp Gp Srt1

UM_RPT_EXP_TYP_SR1 - Rpt Expense Type Sort1Char5
Rpt Exp Typ Sr1

UM_RPT_EXP_TYP_SRT - Rpt Expense Type SortChar5
Rpt Exp Typ Srt

UM_RPT_GROUP_SORT - Rpt Group SortChar5
Rpt Group Srt

UM_RPT_NET_TFR_CAT - Rpt Net Trfr CategChar60
Rpt Net Tfr Cat

UM_RPT_NET_TFR_C_S - Rpt Net Trfr Categ SortChar5
Rpt Net Tfr C S

UM_RPT_NET_TFR_G_S - Rpt Net Trfr Group SortChar5
Rpt Net Tfr G S

UM_RPT_NET_TRFR_TP - Rpt Net Trfr TypeChar60
Rpt Net Trfr Tp

UM_RPT_NET_TRFR_TS - Rpt Net Trfr Type SortChar5
Rpt Net Trfr TS

UM_RPT_REVENUE_CAT - Rpt Revenue CategChar60
Rpt Revenue Cat

UM_RPT_REVENUE_C_S - Rpt Revenue Categ SortChar5
Rpt Revenue C S

UM_RPT_REVENUE_G_S - Rpt Revenue Group SortChar5
Rpt Revenue G S

UM_RPT_REVENUE_TYP - Rpt Revenue TypeChar60
Rpt Revenue Typ

UM_RPT_REVENUE_T_S - Rpt Revenue Type SortChar5
Rpt Revenue T S

UM_RPT_TYPE_D - Report Type DescriptionChar60
Rpt Typ D

UM_RPT_TYPE_SORT - Rpt_Type SortChar5
Rpt Type Sort

UM_SYS_SCHOLARSHP1 - System Scholarships1Char3
Sys Scholarshp1

UM_SYS_SCHOLARSHP2 - System Scholarships2Char3
Sys Scholarshp2

UM_TIER1_PROJECTS - Tier1 ProjectsChar1
Tier1 Projects

UM_TOT_ENCUMBRANCE - Total EncumbranceSNm25.2
EncumbranceUM_GLQ_REPRTING

UM_YR_END_CLOSEOUT - Year End CloseoutChar1
Yr End Closeout