ROS.60050( r    !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~8000800080008000800080008000800080008000800080008000 8000!8000"8000#8000$8000%8000&8000'8000(8000)8000*8000+8000,8000-8000.8000/800008000180002800038000480005800068000780008800098000:8000;8000<8000=8000>8000?8000@8000A8000B8000C8000D8000E8000F8000G8000H8000I8000J8000K8000L8000M8000N8000O8000P8000Q8000R8000S8000T8000U8000V8000W8000X8000Y8000Z8000[8000\8000]8000^8000_8000`8000a8000b8000c8000d8000e8000f8000g8000h8000i8000j8000k8000l8000m8000n8000o8000p8000q8000r8000s8000t8000u8000v@ tr08h,SA" p riView on screen pSave as filep (0@ROSOBJMAPros name->idqrs+hh)ROSSTRINGStk2 uiStrings*hh(ROSSTRUCTSstruct types*hh(ROSTdpC<` 88!(P 88  0 88W2 MO&00x $h> r88g25b75*08x (SRW2_LIS 00r100g75b88*08x(ORM 00r0g100b100pp6r hh"Revenue YTD_Activity"sum ( decode ( ftvatyp_internal_atyp_code , '50' , 1 , 0 ) * decode ( : fspd , '01' , fgbopal_01_ytd_actv , '02' , fgbopal_02_ytd_actv , '03' , fgbopal_03_ytd_actv , '04' , fgbopal_04_ytd_actv , '05' , fgbopal_05_ytd_actv , '06' , fgbopal_06_ytd_actv , '07' , fgbopal_07_ytd_actv , '08' , fgbopal_08_ytd_actv , '09' , fgbopal_09_ytd_actv , '10' , fgbopal_10_ytd_actv , '11' , fgbopal_11_ytd_actv , '12' , fgbopal_12_ytd_actv , '14' , fgbopal_14_ytd_actv ) )Revenue YTD_Activitypp3s"Personnel Balance"sum ( decode ( ftvatyp_internal_atyp_code , '60' , 1 , 0 ) * decode ( : fspd , '01' , fgbopal_01_adopt_bud + fgbopal_01_bud_adjt , '02' , fgbopal_02_adopt_bud + fgbopal_02_bud_adjt , '03' , fgbopal_03_adopt_bud + fgbopal_03_bud_adjt , '04' , fgbopal_04_adopt_bud + fgbopal_04_bud_adjt , '05' , fgbopal_05_adopt_bud + fgbopal_05_bud_adjt , '06' , fgbopal_06_adopt_bud + fgbopal_06_bud_adjt , '07' , fgbopal_07_adopt_bud + fgbopal_07_bud_adjt , '08' , fgbopal_08_adopt_bud + fgbopal_08_bud_adjt , '09' , fgbopal_09_adopt_bud + fgbopal_09_bud_adjt , '10' , fgbopal_10_adopt_bud + fgbopal_10_bud_adjt , '11' , fgbopal_11_adopt_bud + fgbopal_11_bud_adjt , '12' , fgbopal_12_adopt_bud + fgbopal_12_bud_adjt , '14' , fgbopal_14_adopt_bud + fgbopal_14_bud_adjt ) ) - sum ( decode ( ftvatyp_internal_atyp_code , '60' , 1 , 0 ) * decode ( : fspd , '01' , fgbopPersonnel Balance YFpGTUVW=8000>hG_orgn_titlevbpcqrst8000@8000A8000P_SERVER_NAMEybpctuvwC8000D8000EPersonnel_Budgethl Zp\ab(fpj8000G8000HPB_3C2 Zp\st(zp~8000J8000K80=B_Revenue_YTD_Activity 0D 0 h BpD Z\(bpf8000N80.M_G_orgn_title_GRPFRp0 00P8000Q8000R8000S8000T8000U8000V8000W8000X8000Y8000Z8000[8000\8000]8000^8000_8000`8000a8000b8000c8000d8000e8000f8000g8000h8000i8000j8000k8000l8000m8000n8000o8000p8000q8000r8000s8000t8000u8000vx0r 88  2jk0l8n0p8r8tv x0z0{|}0~ppppppqqsCsfsfs{s{s{s{s{s~~ssssssmee*iRm xh  4| 2



<< oFGJDDMG' ,B(F0JK@N@R@V@Z0^0_0`0a0b0c d0f0ghi8j8l0nop rtpuppvifs{s{s@@PjjiReport ParametersEnter values for the parameters ,$00x !" :black(00x " $&fgwhite%00x "#t_green_02)00x# $&'_0 darkgreenopa(00x " $&opgray96 = = =(00x " $&5'gray92zzz(00x " $&djgray88(00x " $&06gray84(((%00x !"#fgr0g0b0adj(00x "$%&t_ r25g0b0@(00x "$%&_0 r50g0b0(00x "$%& f r75g0b0(00x "$%&, r88g0b0(00x "$%&ud r100g0b0(00x!" $&par0g0b50*00x "$ &(d r25g0b50@dj*00x "$ &(atr50g0b50od*00x "$ &(e r75g0b50fg*00x "$ &(r88g0b50,00x $& (*0 r100g0b50(00x!" $&r0g0b75*00x "$ &(r25g0b75@0*00x "$ &(r50g0b75NA*00x "$ &(wr75g0b75*00x "$ &(r88g0b750,00x $& (*_B r100g0b75(00x!" $&r0g0b88*00x "$ &(r25g0b88@PB*00x "$ &(tr50g0b88*00x "$ &(0r75g0b88*00x "$ &(D_r88g0b88,00x $& (* r100g0b88(00x"# $&M_ r0g0b100,00x $& (*! r25g0b100@,00x $& (*" r50g0b100,00x $& (*0# r75g0b100,00x $& (*$ r88g0b100,00x $& (*% r100g0b100&00x  "$0&gray*00x " $ &('darkgray&00x "$(cyanr0*00x" $ &()darkcyan(00x " $&0*gray80333333(00x " $&+gray76=p=p=p(00x " $&,gray72GGG(00x " $&-gray68QQQ'00x! "$%0.r0g25b0@)00x " $&'/r25g25b0@@)00x " $&'0r50g25b0@0)00x " $&'1r75g25b0@)00x " $&'2r88g25b0@+00x $ &()3 r100g25b0@*00x" $ &(4r0g25b50@,00x $ & (*5 r25g25b50@@,00x $ & (*6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (*8 r88g25b50@,00x $ & (*9 r100g25b50@*00x" $ &(:r0g25b750@,00x $ & (*; r25g25b75@@,00x $ & (*< r50g25b75@,00x $ & (*= r75g25b75@8000v@ dr.hh,ROSATTRIBSclass attributesv+hh)ROSLFDESCros lf descripf)hh'sROSOBJMAPros name->idi+hh) ROSSTRINGStk2 uiStrings *hh( ROSSTRUCTSstruct typesty*hh(faROSTK2RESVtk2 reservedf;hhn:SRW2_ANCHORi&h!"h#$66SRW2_BODY_LOCATION 2p$h h!"tiSRW2_BOILERPLATEhh63SRW2_BUTTON!zhhdeSRW2_COLUMNl#hh !LESRW2_DATA_MODEL <$h h!"irSRW2_DISPLAY_TAG%h !h"#=pSRW2_DISTRIBUTION'> < hh_rSRW2_ELEMENThh_hSRW2_FIELD c)h$%h&'--SRW2_FORMAT_EXCEPTION&le hhngSRW2_FRAME=0hhtySRW2_GROUP> #hh !SRW2_HYPERLINK" <$h h!"tmSRW2_JAVA_APPLET$(h#$h%&JDSRW2_JAVA_PROPERTIES%hh(FSRW2_LAYOUT _%h !h"#8jSRW2_LAYOUT_GROUP vihh@SRW2_LINKhhorSRW2_LISTS nthhpaSRW2_MATRIX'h"#h$%!SRW2_OGD_COLUMN_MAP$h h!"fgSRW2_OG_DOCUMENT#hh !"SRW2_PARAM_FORM2hh#SRW2_QUERYrk%h !h"#SRW2_TEXT_SEGMENThhTOOL_ACCESS$ hhzTOOL_COMMENT hhayTOOL_LIBRARY hh06TOOL_MODULEhh TOOL_PLSQLg0$pp"0VG_COLORVG_COLOR+pp $&'()VG_COLORITEMID@g+pp $&'()VG_COLORCELLID@-pp &()*+VG_COLORNAME_SET@ /pp (*+,-VG_COLORNAME_LENGTH /pp (*+,-VG_COLORCOLOR_NAMEx"'pp "#$%VG_COLORRED )pp "$%&'VG_COLORGREEN )pp "$%&'VG_COLORBLUE /x-50Page &$9x7Eastern Kentucky University 0g0=x;!Financial Manager Organizations 08x60gFor Fiscal Year: &fsyr_code. x,Report Parameters< x: Enter values for the parameters' x%! Manager ID( x& " Fiscal Year# x!Output* x(Fiscal Period  x5CoA! x7Fund0! x009Orgn# x!M_;Budget) x' (= YTD Activity$ x" (?Balance# x!ABudget ) x'C YTD Activity$ $ x"EBalance# x!GBudget$ x"IEncumb.) x'rkK YTD Activity0$ x"anMBalance$ x"WRevenue& x$ $X Personnel33& x$ $Y Operating=p(00x " $&,gray72GGG(00x " $&-gray68QQQ'00x! "$%0.r0g25b0@)00x " $&'/r25g25b0@@)00x " $&'0r50g25b0@0)00x " $&'1r75g25b0@)00x " $&'2r88g25b0@+00x $ &()3 r100g25b0@*00x" $ &(4r0g25b50@,00x $ & (*5 r25g25b50@@,00x $ & (*6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (*8 r88g25b50@,00x $ & (*9 r100g25b50@*00x" $ &(:r0g25b750@,00x $ & (*; r25g25b75@@,00x $ & (*< r50g25b75@,00x $ & (*= r75g25b75@8000vPr 88 RIBSclass attributesv+hh)ROSLFDESCros lf descripf)hh'sROSOBJMAPros name->idi+hh) ROSSTRINGStk2 uiStrings *hh( ROSSTRUCTSstruct typesty*hh(faROSTK2RESVtk2 reservedf;hhn:SRW2_ANCHORi&h!"h#$66SRW2_BODY_LOCATION 2p$h h!"tiSRW2_BOILERPLATEhh63SRW2_BUTTON!zhhdeSRW2_COLUMNl#hh !LESRW2_DATA_MODEL <$h h!"irSRW2_DISPLAY_TAG%h !h"#=pSRW2_DISTRIBUTION'> < hh_rSRW2_ELEMENThh_hSRW2_FIELD c)h$%h&'--SRW2_FORMAT_EXCEPTION&le hhngSRW2_FRAME=0hhtySRW2_GROUP> #hh !SRW2_HYPERLINK" <$h h!"tmSRW2_JAVA_APPLET$(h#$h%&JDSRW2_JAVA_PROPERTIES%hh(FSRW2_LAYOUT _%h !h"#8jSRW2_LAYOUT_GROUP vihh@SRW2_LINKhhorSRW2_LISTS nthhpaSRW2_MATRIX'h"#h$%!SRW2_OGD_COLUMN_MAP$h h!"fgSRW2_OG_DOCUMENT#hh !"SRW2_PARAM_FORM2hh#SRW2_QUERYrk%h !h"#SRW2_TEXT_SEGMENThhTOOL_ACCESS$ hhzTOOL_COMMENT hhayTOOL_LIBRARY hh06TOOL_MODULEhh TOOL_PLSQLg0$pp"0VG_COLORVG_COLOR+pp $&'()VG_COLORITEMID@g+pp $&'()VG_COLORCELLID@-pp &()*+VG_COLORNAME_SET@ /pp (*+,-VG_COLORNAME_LENGTH /pp (*+,-VG_COLORCOLOR_NAMEx"'pp "#$%VG_COLORRED )pp "$%&'VG_COLORGREEN )pp "$%&'VG_COLORBLUE /x-50Page &$9x7Eastern Kentucky University 0g0=x;!Financial Manager Organizations 08x60gFor Fiscal Year: &fsyr_code. x,Report Parameters< x: Enter values for the parameters' x%! Manager ID( x& " Fiscal Year# x!Output* x(Fiscal Period  x5CoA! x7Fund0! x009Orgn# x!M_;Budget) x' (= YTD Activity$ x" (?Balance# x!ABudget ) x'C YTD Activity$ $ x"EBalance# x!GBudget$ x"IEncumb.) x'rkK YTD Activity0$ x"anMBalance$ x"WRevenue& x$ $X Personnel33& x$ $Y Operating=p(00x " $&,gray72GGG(00x " $&-gray68QQQ'00x! "$%0.r0g25b0@)00x " $&'/r25g25b0@@)00x " $&'0r50g25b0@0)00x " $&'1r75g25b0@)00x " $&'2r88g25b0@+00x $ &()3 r100g25b0@*00x" $ &(4r0g25b50@,00x $ & (*5 r25g25b50@@,00x $ & (*6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (*8 r88g25b50@,00x $ & (*9 r100g25b50@*00x" $ &(:r0g25b750@,00x $ & (*; r25g25b75@@,00x $ & (*< r50g25b75@,00x $ & (*= r75g25b75@8000v`r 88(RIBSclass attributesv+hh)ROSLFDESCros lf descripf)hh'sROSOBJMAPros name->idi+hh) ROSSTRINGStk2 uiStrings *hh( ROSSTRUCTSstruct typesty*hh(faROSTK2RESVtk2 reservedf;hhn:SRW2_ANCHORi&h!"h#$66SRW2_BODY_LOCATION 2p$h h!"tiSRW2_BOILERPLATEhh63SRW2_BUTTON!zhhdeSRW2_COLUMNl#hh !LESRW2_DATA_MODEL <$h h!"irSRW2_DISPLAY_TAG%h !h"#=pSRW2_DISTRIBUTION'> < hh_rSRW2_ELEMENThh_hSRW2_FIELD c)h$%h&'--SRW2_FORMAT_EXCEPTION&le hhngSRW2_FRAME=0hhtySRW2_GROUP> #hh !SRW2_HYPERLINK" <$h h!"tmSRW2_JAVA_APPLET$(h#$h%&JDSRW2_JAVA_PROPERTIES%hh(FSRW2_LAYOUT _%h !h"#8jSRW2_LAYOUT_GROUP vihh@SRW2_LINKhhorSRW2_LISTS nthhpaSRW2_MATRIX'h"#h$%!SRW2_OGD_COLUMN_MAP$h h!"fgSRW2_OG_DOCUMENT#hh !"SRW2_PARAM_FORM2hh#SRW2_QUERYrk%h !h"#SRW2_TEXT_SEGMENThhTOOL_ACCESS$ hhzTOOL_COMMENT hhayTOOL_LIBRARY hh06TOOL_MODULEhh TOOL_PLSQLg0$pp"0VG_COLORVG_COLOR+pp $&'()VG_COLORITEMID@g+pp $&'()VG_COLORCELLID@-pp &()*+VG_COLORNAME_SET@ /pp (*+,-VG_COLORNAME_LENGTH /pp (*+,-VG_COLORCOLOR_NAMEx"'pp "#$%VG_COLORRED )pp "$%&'VG_COLORGREEN )pp "$%&'VG_COLORBLUE /x-50Page &$9x7Eastern Kentucky University 0g0=x;!Financial Manager Organizations 08x60gFor Fiscal Year: &fsyr_code. x,Report Parameters< x: Enter values for the parameters' x%! Manager ID( x& " Fiscal Year# x!Output* x(Fiscal Period  x5CoA! x7Fund0! x009Orgn# x!M_;Budget) x' (= YTD Activity$ x" (?Balance# x!ABudget ) x'C YTD Activity$ $ x"EBalance# x!GBudget$ x"IEncumb.) x'rkK YTD Activity0$ x"anMBalance$ x"WRevenue& x$ $X Personnel33& x$ $Y Operating=p(00x " $&,gray72GGG(00x " $&-gray68QQQ'00x! "$%0.r0g25b0@)00x " $&'/r25g25b0@@)00x " $&'0r50g25b0@0)00x " $&'1r75g25b0@)00x " $&'2r88g25b0@+00x $ &()3 r100g25b0@*00x" $ &(4r0g25b50@,00x $ & (*5 r25g25b50@@,00x $ & (*6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (*8 r88g25b50@,00x $ & (*9 r100g25b50@*00x" $ &(:r0g25b750@,00x $ & (*; r25g25b75@@,00x $ & (*< r50g25b75@,00x $ & (*= r75g25b75@8000vpXrS N(0@@00@@@@@@000000ppp 00880 @A11A AAAAA1"1#A&A*1.1/A2A6A:A>ABAF1J1KLMNOPQ dpC<LPB@`` jj@lLPBW2@``LPB@``  #$66SRW2_BODY_LOCATION 2p$h h!"tiSRW2_BOILERPLATEhh63SRW2_BUTTON!zhhdeSRW2_COLUMNl#hh !LESRW2_DATA_MODEL <$h h!"irSRW2_DISPLAY_TAG%h !h"#=pSRW2_DISTRIBUTION'> < hh_rSRW2_ELEMENThh_hSRW2_FIELD c)h$%h&'--SRW2_FORMAT_EXCEPTION&le hhngSRW2_FRAME=0hhtySRW2_GROUP> #hh !SRW2_HYPERLINK" <$h h!"tmSRW2_JAVA_APPLET$(h#$h%&JDSRW2_JAVA_PROPERTIES%hh(FSRW2_LAYOUT _%h !h"#8jSRW2_LAYOUT_GROUP vihh@SRW2_LINKhhorSRW2_LISTS nthhpaSRW2_MATRIX'h"#h$%!SRW2_OGD_COLUMN_MAP$h h!"fgSRW2_OG_DOCUMENT#hh !"SRW2_PARAM_FORM2hh#SRW2_QUERYrk%h !h"#SRW2_TEXT_SEGMENThhTOOL_ACCESS$ hhzTOOL_COMMENT hhayTOOL_LIBRARY hh06TOOL_MODULEhh TOOL_PLSQLg0$pp"0VG_COLORVG_COLOR+pp $&'()VG_COLORITEMID@g+pp $&'()VG_COLORCELLID@-pp &()*+VG_COLORNAME_SET@ /pp (*+,-VG_COLORNAME_LENGTH /pp (*+,-VG_COLORCOLOR_NAMEx"'pp "#$%VG_COLORRED )pp "$%&'VG_COLORGREEN )pp "$%&'VG_COLORBLUE /x-50Page &$9x7Eastern Kentucky University 0g0=x;!Financial Manager Organizations 08x60gFor Fiscal Year: &fsyr_code. x,Report Parameters< x: Enter values for the parameters' x%! Manager ID( x& " Fiscal Year# x!Output* x(Fiscal Period  x5CoA! x7Fund0! x009Orgn# x!M_;Budget) x' (= YTD Activity$ x" (?Balance# x!ABudget ) x'C YTD Activity$ $ x"EBalance# x!GBudget$ x"IEncumb.) x'rkK YTD Activity0$ x"anMBalance$ x"WRevenue& x$ $X Personnel33& x$ $Y Operating=p(00x " $&,gray72GGG(00x " $&-gray68QQQ'00x! "$%0.r0g25b0@)00x " $&'/r25g25b0@@)00x " $&'0r50g25b0@0)00x " $&'1r75g25b0@)00x " $&'2r88g25b0@+00x $ &()3 r100g25b0@*00x" $ &(4r0g25b50@,00x $ & (*5 r25g25b50@@,00x $ & (*6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (*8 r88g25b50@,00x $ & (*9 r100g25b50@*00x" $ &(:r0g25b750@,00x $ & (*; r25g25b75@@,00x $ & (*< r50g25b75@,00x $ & (*= r75g25b75@8000v$r p@Save as file@000000ppp 00880 @A11A AAAAA1"1#A&A*1.1/A2A6A:A>ABAF1J1KLMNOPQ dpC<LPB@`` jj@lLPBW2@``LPB@``  #$66SRW2_BODY_LOCATION 2p$h h!"tiSRW2_BOILERPLATEhh63SRW2_BUTTON!zhhdeSRW2_COLUMNl#hh !LESRW2_DATA_MODEL <$h h!"irSRW2_DISPLAY_TAG%h !h"#=pSRW2_DISTRIBUTION'> < hh_rSRW2_ELEMENThh_hSRW2_FIELD c)h$%h&'--SRW2_FORMAT_EXCEPTION&le hhngSRW2_FRAME=0hhtySRW2_GROUP> #hh !SRW2_HYPERLINK" <$h h!"tmSRW2_JAVA_APPLET$(h#$h%&JDSRW2_JAVA_PROPERTIES%hh(FSRW2_LAYOUT _%h !h"#8jSRW2_LAYOUT_GROUP vihh@SRW2_LINKhhorSRW2_LISTS nthhpaSRW2_MATRIX'h"#h$%!SRW2_OGD_COLUMN_MAP$h h!"fgSRW2_OG_DOCUMENT#hh !"SRW2_PARAM_FORM2hh#SRW2_QUERYrk%h !h"#SRW2_TEXT_SEGMENThhTOOL_ACCESS$ hhzTOOL_COMMENT hhayTOOL_LIBRARY hh06TOOL_MODULEhh TOOL_PLSQLg0$pp"0VG_COLORVG_COLOR+pp $&'()VG_COLORITEMID@g+pp $&'()VG_COLORCELLID@-pp &()*+VG_COLORNAME_SET@ /pp (*+,-VG_COLORNAME_LENGTH /pp (*+,-VG_COLORCOLOR_NAMEx"'pp "#$%VG_COLORRED )pp "$%&'VG_COLORGREEN )pp "$%&'VG_COLORBLUE /x-50Page &$9x7Eastern Kentucky University 0g0=x;!Financial Manager Organizations 08x60gFor Fiscal Year: &fsyr_code. x,Report Parameters< x: Enter values for the parameters' x%! Manager ID( x& " Fiscal Year# x!Output* x(Fiscal Period  x5CoA! x7Fund0! x009Orgn# x!M_;Budget) x' (= YTD Activity$ x" (?Balance# x!ABudget ) x'C YTD Activity$ $ x"EBalance# x!GBudget$ x"IEncumb.) x'rkK YTD Activity0$ x"anMBalance$ x"WRevenue& x$ $X Personnel33& x$ $Y Operating=p(00x " $&,gray72GGG(00x " $&-gray68QQQ'00x! "$%0.r0g25b0@)00x " $&'/r25g25b0@@)00x " $&'0r50g25b0@0)00x " $&'1r75g25b0@)00x " $&'2r88g25b0@+00x $ &()3 r100g25b0@*00x" $ &(4r0g25b50@,00x $ & (*5 r25g25b50@@,00x $ & (*6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (*8 r88g25b50@,00x $ & (*9 r100g25b50@*00x" $ &(:r0g25b750@,00x $ & (*; r25g25b75@@,00x $ & (*< r50g25b75@,00x $ & (*= r75g25b75@8000v(r" p wView on screen~000000p( ppppppPersonnel_Budgeth!&Personnel Budgetce_'PERSONNEL_BUDGET/bpcz{|}~ppp000000p( ppppppPersonnel_YTD_Activityh!&Personnel Ytd Activity_'L_BUPERSONNEL_YTD_ACTIVITY63/bpcuvwxyzp~~pp000000p( ppppppPersonnel_Balance hh!&Personnel BalanceAc_''PERSONNEL_BALANCE/bpctuvwxypzzp{p{{|}~000000p( ppppppOperating_Budget h!&Operating Budgetanc_'OPERATING_BUDGET/bpcz{|}~ppp000000p( ppppppOperating_Encumbrances h!&Operating Encumbrances_'G_BUOPERATING_ENCUMBRANCESLIN/bpcz{|}~ppp000000p( ppppppOperating_YTD_Activity h!&Operating Ytd Activity_'G_BUOPERATING_YTD_ACTIVITYRW2/bpcuvwxyzp~~pp000000p( ppppppOperating_Balance hh!&Operating BalanceAc_''OPERATING_BALANCE*Zp[lm(nprpr@r8v8x8z|}~x000000p0_Cpage_number_SEC2"0 0U 0U ԵKgR*Zp[fg(jpnpn8n8p@r8vxyzx~000000p0-title_SEC2#EC0h h UD'VG_COLORGREEN )pp "$%&'VG_COLORBLUE /x-50Page &$9x7Eastern Kentucky University 0g0=x;!Financial Manager Organizations 08x60gFor Fiscal Year: &fsyr_code. x,Report Parameters< x: Enter values for the parameters' x%! Manager ID( x& " Fiscal Year# x!Output* x(Fiscal Period  x5CoA! x7Fund0! x009Orgn# x!M_;Budget) x' (= YTD Activity$ x" (?Balance# x!ABudget ) x'C YTD Activity$ $ x"EBalance# x!GBudget$ x"IEncumb.) x'rkK YTD Activity0$ x"anMBalance$ x"WRevenue& x$ $X Personnel33& x$ $Y Operating=p(00x " $&,gray72GGG(00x " $&-gray68QQQ'00x! "$%0.r0g25b0@)00x " $&'/r25g25b0@@)00x " $&'0r50g25b0@0)00x " $&'1r75g25b0@)00x " $&'2r88g25b0@+00x $ &()3 r100g25b0@*00x" $ &(4r0g25b50@,00x $ & (*5 r25g25b50@@,00x $ & (*6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (*8 r88g25b50@,00x $ & (*9 r100g25b50@*00x" $ &(:r0g25b750@,00x $ & (*; r25g25b75@@,00x $ & (*< r50g25b75@,00x $ & (*= r75g25b75@8000vr]0808[EE Oracle HTML Navigator
0800 00808function BeforeReport return boolean is report_name VARCHAR2(30); begin srw.get_report_name(report_name); report_name := rtrim(report_name); p_update_report_log(report_name); return (TRUE); end;0800F@0800P0800 0`0808function AfterPForm return boolean is begin select distinct spriden_pidm into :pidm from spriden where spriden_id = :id; return (TRUE); end; xK0808I331  $ 3F_ORGN_CODEFORMATTRIGGERfunction F_orgn_codeFormatTrigger return boolean is begin srw.set_hyperlink (:P_ACTION || 'SERVER=' || :P_SERVERNAME || '&REPORT=FGJDDOR.rep&USERID=' || :P_USER_CONNECT || 'DESTYPE=cache&DESFORMAT=HTML&PARAMFORM=no&ONEUPNO=' || to_number(:oneupno) || '&P_USER_CONNECT=' || :P_USER_CONNECT || '&ORGN_CODE=' || :orgn_code || '&FSYR_CODE=' || :fsyr_code || '&COAS_CODE=' || :coas_code); srw.set_hyperlink_attrs('target=_blank'); return (TRUE); end;@@n0808 function F_orgn_codeFormatTrigger return boolean is begin srw.set_hyperlink (:P_ACTION || 'SERVER=' || :P_SERVERNAME || '&REPORT=FGJDDOR.rep&USERID=' || :P_USER_CONNECT || 'DESTYPE=cache&DESFORMAT=HTML&PARAMFORM=no&ONEUPNO=' || to_number(:oneupno) || '&P_USER_CONNECT=' || :P_USER_CONNECT || '&ORGN_CODE=' || :orgn_code || '&FSYR_CODE=' || :fsyr_code || '&COAS_CODE=' || :coas_code); srw.set_hyperlink_attrs('target=_blank'); return (TRUE); end; 0800 1Np*>FNW(Z ^bp(z~((((5gSQL*ReportWriterKgREPORTEKU5FGJDDMGtr FULKERSONJONxh  4.tEKUxi !$v,00x $ & (*8 r88g25b50@,00x $ & (*9 r100g25b50@*00x" $ &(:r0g25b750@,00x $ & (*; r25g25b75@@,00x $ & (*< r50g25b75@,00x $ & (*= r75g25b75@8000vr,00x $ & (*8> r88g25b75@,00x $ & (* ? r100g25b75@*00x" $ &( 0@r0g25b885@,00x $ & (*A r25g25b88@@,00x $ & (**B r50g25b88@,00x $ & (*C r75g25b88@,00x $ & (*veD r88g25b88@,00x $ & (*E r100g25b88@*00x# $ &(F r0g25b100@p,00x $ & (*0G r25g25b100@@,00x $ & (* H r50g25b100@,00x $ & (*I r75g25b100@,00x $ & (*J r88g25b100@.00x & ( *,8K r100g25b100@0$00x  !"Lred(00x "$%&viMdarkred$00x " Nblue(00x"# $&Odarkblue(00x " $&Pgray64\(\(\((00x " $&Qgray60ffffff(00x " $&Rgray56ppp(00x " $&Sgray52zzz'00x! "$%*Tr0g50b0z)00x " $&'0Ur25g50b0@0)00x " $&'B_Vr50g50b0)00x " $&'Wr75g50b0)00x " $&'FXr88g50b0*+00x $ &()Y r100g50b0*00x" $ &(Zr0g50b50er,00x $ & (*[ r25g50b50@,00x $ & (*D\ r50g50b50,00x $ & (*v] r75g50b50,00x $ & (*0^ r88g50b50,00x $ & (*YT_ r100g50b50*00x" $ &(`r0g50b750D,00x $ & (*a r25g50b75@,00x $ & (*0b r50g50b75,00x $ & (* c r75g50b75,00x $ & (*d r88g50b75,00x $ & (*e r100g50b75*00x" $ &(fr0g50b8850,00x $ & (*g r25g50b88@,00x $ & (*h r50g50b88,00x $ & (*Di r75g50b88,00x $ & (*pzj r88g50b88,00x $ & (*k r100g50b88*00x# $ &(2l r0g50b100N,00x $ & (*m r25g50b100@,00x $ & (**n r50g50b100,00x $ & (*o r75g50b100,00x $ & (*vep r88g50b100.00x & ( *,q r100g50b100D'00x "$%3ryellow +00x $ &()s darkyellow*00x "$ &( tmagenta .00x &( *,u darkmagenta(00x " $&IDvgray48(00x " $&wgray44\\\(00x " $&xgray40(00x " $& ygray36ףף'00x! "$%zr0g75b0 )00x " $&'{r25g75b0@jOD)00x " $&'|r50g75b0j't)00x " $&'}r75g75b0j@)00x " $&'~r88g75b0+00x $ &()re r100g75b0i.08x& ( *, (00r0g75b50 |008x ( * ,.EP 00r25g75b50@008x ( * ,. ' 00r50g75b50008x ( * ,.'  00r75g75b50008x ( * ,.=' 00r88g75b50008x ( * ,.co 00r100g75b50.08x& ( *,_C00r0g75b750 008x ( * ,.ar 00r25g75b75@008x ( * ,.8 00r50g75b75008x ( * ,.(z 00r75g75b75008x ( * ,.EK 00r88g75b75008x ( * ,. 00r100g75b75.08x& ( *,00r0g75b885008x ( * ,.  00r25g75b88@008x ( * ,.g2 00r50g75b88008x ( * ,.b7 00r75g75b88008x ( * ,. 00r88g75b88 & (*= r75g25b75@8000vr008x ( * ,.8 00r100g75b88.08x' ( *,  00r0g75b100008x ( * ,.g2 00r25g75b100@008x ( * ,.b8 00r50g75b100008x ( * ,. 00r75g75b100008x ( * ,. 00r88g75b100208x * , .0 00r100g75b100 .08x & ( *,000custom1g2.08x & ( *,00custom2b1.08x & ( *, $00custom3.08x & ( *, (00custom4,08x $ & (*00gray32,08x $ & (*800gray28QQQ,08x $ & (*!00gray24,08x $ & (*00gray20+08x% &()ue00r0g88b0-08x & (*+00r25g88b0@" $-08x & (*+00r50g88b0Q-08x & (*+00r75g88b06p-08x & (*+ $00r88g88b0/08x ( *,- 00r100g88b0.08x& ( *,b000r0g88b50008x ( * ,. 00r25g88b50@008x ( * ,. 00r50g88b50008x ( * ,. 00r75g88b50008x ( * ,. 00r88g88b50008x ( * ,.0 00r100g88b50.08x& ( *,00r0g88b750b5008x ( * ,. $ 00r25g88b75@008x ( * ,. ( 00r50g88b75008x ( * ,.YT 00r75g88b75008x ( * ,. 00r88g88b75008x ( * ,.5g 00r100g88b75.08x& ( *,b700r0g88b885008x ( * ,. 00r25g88b88@008x ( * ,. 00r50g88b88008x ( * ,. 00r75g88b88008x ( * ,. 00r88g88b88008x ( * ,.0 00r100g88b88.08x' ( *, 00r0g88b100b8008x ( * ,. $ 00r25g88b100@008x ( * ,. ( 00r50g88b100008x ( * ,.2 00r75g88b100008x ( * ,.  00r88g88b100208x * , .00g 00r100g88b100.08x & ( *,00custom5 $.08x & ( *,00custom6 *.08x & ( *,D00custom7$.08x & ( *,00custom8 ,08x $ & (*000gray16 ,08x $ & (*000gray12GGG,08x $ & (*00gray8,08x $ & (*000gray4-08x& (*+00r0g100b00/08x ( *,- $ 00r25g100b0@/08x ( *,- 00r50g100b0/08x ( *,-b0 00r75g100b0/08x ( *,- 00r88g100b0"/08x ( *,-@ 00r100g100b0&.08x' ( *, 00r0g100b50re008x ( * ,. 00r25g100b50@008x ( * ,. 00r50g100b50008x ( * ,. 00r75g100b50008x ( * ,. 00r88g100b50208x * , .0 00r100g100b5000.08x' ( *,8 00r0g100b7500008x ( * ,.8 00r25g100b75@008x ( * ,.8 00r50g100b75008x ( * ,.8 00r75g100b75008x ( * ,.8 00r88g100b75208x * , .08 00r100g100b758g.08x' ( *, 00r0g100b8800008x ( * ,. 00r25g100b88@008x ( * ,. 00r50g100b88008x ( * ,. 00r75g100b88008x ( * ,. 00r88g100b88208x * , .0 00r100g100b88b88 & (*= r75g25b75@8000v lr008x( * ,.8 00r0g100b100208x * , .0  00r25g100b100@208x * , .0 00r50g100b100208x * , .000 00r75g100b1008208x * , .05g 00r88g100b100208x * , .0b1 00r100g100b100 *r>p?p?p?0UVWXYZ[\]^_` bdefghijklmnop|VT Special Charactersb>p?p?p?0EFGHIJKLMNOP RTUVWXYZ[\]^_`Ariale ]>p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ[ri b>p?p?p?0EFGHIJKLMNOP RTUVWXYZ[\]^_`Arialayb>p?p?p?0EFGHIJKLMNOP RTUVWXYZ[\]^_`Arialj>p?p?p?0MNOPQRSTUVWX Z\]^_`abcdefghMS Sans Serif]>p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ[S q j>p?p?p?0MNOPQRSTUVWX Z\]^_`abcdefghMS Sans Serif]>p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ[S q j >p@p@p@0NOPQRSTUVWXY Z\]^_`abcdefghMS Sans Serif 8j >p@p@p@0NOPQRSTUVWXY Z\]^_`abcdefghMS Sans Serif  (] >p@p@pB0BCDEFGHIJKLMNOPQRSTUVWXYZ[S] >p@p@pB0BCDEFGHIJKLMNOPQRSTUVWXYZ[dS 8b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_`hArial  8b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_`jArial 8b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_`lArial 81p"&'*./beforereport1p"&'*./beforepform  (-p"#&*+afterpform  (E p2 68>BCkf_orgn_codeformattrigger8 8b1N pp*p8CDE0F0GHIJKLrorgn_titleftvorgn_titleORGN_TITLE#g &P pp)p;EFG0H0IJKLMNCOAS_codefgbopal_coas_codeCOAS_CODEgP pp)p;EFG0H0IJKLMNfund_codefgbopal_fund_codeFUND_CODEgP pp)p;EFG0H0IJKLMNorgn_codefgbopal_orgn_codeORGN_CODEg? pp0s%45637389:;<="Revenue Budget"sum ( decode ( ftvatyp_internal_atyp_code , '50' , 1 , 0 ) * decode ( : fspd , '01' , fgbopal_01_adopt_bud + fgbopal_01_bud_adjt , '02' , fgbopal_02_adopt_bud + fgbopal_02_bud_adjt , '03' , fgbopal_03_adopt_bud + fgbopal_03_bud_adjt , '04' , fgbopal_04_adopt_bud + fgbopal_04_bud_adjt , '05' , fgbopal_05_adopt_bud + fgbopal_05_bud_adjt , '06' , fgbopal_06_adopt_bud + fgbopal_06_bud_adjt , '07' , fgbopal_07_adopt_bud + fgbopal_07_bud_adjt , '08' , fgbopal_08_adopt_bud + fgbopal_08_bud_adjt , '09' , fgbopal_09_adopt_bud + fgbopal_09_bud_adjt , '10' , fgbopal_10_adopt_bud + fgbopal_10_bud_adjt , '11' , fgbopal_11_adopt_bud + fgbopal_11_bud_adjt , '12' , fgbopal_12_adopt_bud + fgbopal_12_bud_adjt , '14' , fgbopal_14_adopt_bud + fgbopal_14_bud_adjt ) )Revenue Budget&g 00r25g100b75@008x ( * ,.8 00r50g100b75008x ( * ,.8 00r75g100b75008x ( * ,.8 00r88g100b75208x * , .08 00r100g100b758g.08x' ( *, 00r0g100b8800008x ( * ,. 00r25g100b88@008x ( * ,. 00r50g100b88008x ( * ,. 00r75g100b88008x ( * ,. 00r88g100b88208x * , .0 00r100g100b88b88 & (*= r75g25b75@8000v 8r  pp6r22"Revenue YTD_Activity"sum ( decode ( ftvatyp_internal_atyp_code , '50' , 1 , 0 ) * decode ( : fspd , '01' , fgbopal_01_ytd_actv , '02' , fgbopal_02_ytd_actv , '03' , fgbopal_03_ytd_actv , '04' , fgbopal_04_ytd_actv , '05' , fgbopal_05_ytd_actv , '06' , fgbopal_06_ytd_actv , '07' , fgbopal_07_ytd_actv , '08' , fgbopal_08_ytd_actv , '09' , fgbopal_09_ytd_actv , '10' , fgbopal_10_ytd_actv , '11' , fgbopal_11_ytd_actv , '12' , fgbopal_12_ytd_actv , '14' , fgbopal_14_ytd_actv ) )Revenue YTD_Activity&g pp1s33"Revenue Balance"sum ( decode ( ftvatyp_internal_atyp_code , '50' , 1 , 0 ) * decode ( : fspd , '01' , fgbopal_01_adopt_bud + fgbopal_01_bud_adjt , '02' , fgbopal_02_adopt_bud + fgbopal_02_bud_adjt , '03' , fgbopal_03_adopt_bud + fgbopal_03_bud_adjt , '04' , fgbopal_04_adopt_bud + fgbopal_04_bud_adjt , '05' , fgbopal_05_adopt_bud + fgbopal_05_bud_adjt , '06' , fgbopal_06_adopt_bud + fgbopal_06_bud_adjt , '07' , fgbopal_07_adopt_bud + fgbopal_07_bud_adjt , '08' , fgbopal_08_adopt_bud + fgbopal_08_bud_adjt , '09' , fgbopal_09_adopt_bud + fgbopal_09_bud_adjt , '10' , fgbopal_10_adopt_bud + fgbopal_10_bud_adjt , '11' , fgbopal_11_adopt_bud + fgbopal_11_bud_adjt , '12' , fgbopal_12_adopt_bud + fgbopal_12_bud_adjt , '14' , fgbopal_14_adopt_bud + fgbopal_14_bud_adjt ) ) - sum ( decode ( ftvatyp_internal_atyp_code , '50' , 1 , 0 ) * decode ( : fspd , '01' , fgbopRevenue Balance&geC pp2s'89:3;3<=>?@A"Personnel Budget"sum ( decode ( ftvatyp_internal_atyp_code , '60' , 1 , 0 ) * decode ( : fspd , '01' , fgbopal_01_adopt_bud + fgbopal_01_bud_adjt , '02' , fgbopal_02_adopt_bud + fgbopal_02_bud_adjt , '03' , fgbopal_03_adopt_bud + fgbopal_03_bud_adjt , '04' , fgbopal_04_adopt_bud + fgbopal_04_bud_adjt , '05' , fgbopal_05_adopt_bud + fgbopal_05_bud_adjt , '06' , fgbopal_06_adopt_bud + fgbopal_06_bud_adjt , '07' , fgbopal_07_adopt_bud + fgbopal_07_bud_adjt , '08' , fgbopal_08_adopt_bud + fgbopal_08_bud_adjt , '09' , fgbopal_09_adopt_bud + fgbopal_09_bud_adjt , '10' , fgbopal_10_adopt_bud + fgbopal_10_bud_adjt , '11' , fgbopal_11_adopt_bud + fgbopal_11_bud_adjt , '12' , fgbopal_12_adopt_bud + fgbopal_12_bud_adjt , '14' , fgbopal_14_adopt_bud + fgbopal_14_bud_adjt ) )Personnel Budget&g_$ pp8r22 !""Personnel YTD_Activity"sum ( decode ( ftvatyp_internal_atyp_code , '60' , 1 , 0 ) * decode ( : fspd , '01' , fgbopal_01_ytd_actv , '02' , fgbopal_02_ytd_actv , '03' , fgbopal_03_ytd_actv , '04' , fgbopal_04_ytd_actv , '05' , fgbopal_05_ytd_actv , '06' , fgbopal_06_ytd_actv , '07' , fgbopal_07_ytd_actv , '08' , fgbopal_08_ytd_actv , '09' , fgbopal_09_ytd_actv , '10' , fgbopal_10_ytd_actv , '11' , fgbopal_11_ytd_actv , '12' , fgbopal_12_ytd_actv , '14' , fgbopal_14_ytd_actv ) )Personnel YTD_Activity &gal_03_bud_adjt , '04' , fgbopal_04_adopt_bud + fgbopal_04_bud_adjt , '05' , fgbopal_05_adopt_bud + fgbopal_05_bud_adjt , '06' , fgbopal_06_adopt_bud + fgbopal_06_bud_adjt , '07' , fgbopal_07_adopt_bud + fgbopal_07_bud_adjt , '08' , fgbopal_08_adopt_bud + fgbopal_08_bud_adjt , '09' , fgbopal_09_adopt_bud + fgbopal_09_bud_adjt , '10' , fgbopal_10_adopt_bud + fgbopal_10_bud_adjt , '11' , fgbopal_11_adopt_bud + fgbopal_11_bud_adjt , '12' , fgbopal_12_adopt_bud + fgbopal_12_bud_adjt , '14' , fgbopal_14_adopt_bud + fgbopal_14_bud_adjt ) )Revenue Budget&g 00r25g100b75@008x ( * ,.8 00r50g100b75008x ( * ,.8 00r75g100b75008x ( * ,.8 00r88g100b75208x * , .08 00r100g100b758g.08x' ( *, 00r0g100b8800008x ( * ,. 00r25g100b88@008x ( * ,. 00r50g100b88008x ( * ,. 00r75g100b88008x ( * ,. 00r88g100b88208x * , .0 00r100g100b88b88 & (*= r75g25b75@8000vr pp3s33"Personnel Balance"sum ( decode ( ftvatyp_internal_atyp_code , '60' , 1 , 0 ) * decode ( : fspd , '01' , fgbopal_01_adopt_bud + fgbopal_01_bud_adjt , '02' , fgbopal_02_adopt_bud + fgbopal_02_bud_adjt , '03' , fgbopal_03_adopt_bud + fgbopal_03_bud_adjt , '04' , fgbopal_04_adopt_bud + fgbopal_04_bud_adjt , '05' , fgbopal_05_adopt_bud + fgbopal_05_bud_adjt , '06' , fgbopal_06_adopt_bud + fgbopal_06_bud_adjt , '07' , fgbopal_07_adopt_bud + fgbopal_07_bud_adjt , '08' , fgbopal_08_adopt_bud + fgbopal_08_bud_adjt , '09' , fgbopal_09_adopt_bud + fgbopal_09_bud_adjt , '10' , fgbopal_10_adopt_bud + fgbopal_10_bud_adjt , '11' , fgbopal_11_adopt_bud + fgbopal_11_bud_adjt , '12' , fgbopal_12_adopt_bud + fgbopal_12_bud_adjt , '14' , fgbopal_14_adopt_bud + fgbopal_14_bud_adjt ) ) - sum ( decode ( ftvatyp_internal_atyp_code , '60' , 1 , 0 ) * decode ( : fspd , '01' , fgbopPersonnel Balance &gaC pp2s'89:3;3<=>?@A"Operating Budget"sum ( decode ( ftvatyp_internal_atyp_code , '70' , 1 , 0 ) * decode ( : fspd , '01' , fgbopal_01_adopt_bud + fgbopal_01_bud_adjt , '02' , fgbopal_02_adopt_bud + fgbopal_02_bud_adjt , '03' , fgbopal_03_adopt_bud + fgbopal_03_bud_adjt , '04' , fgbopal_04_adopt_bud + fgbopal_04_bud_adjt , '05' , fgbopal_05_adopt_bud + fgbopal_05_bud_adjt , '06' , fgbopal_06_adopt_bud + fgbopal_06_bud_adjt , '07' , fgbopal_07_adopt_bud + fgbopal_07_bud_adjt , '08' , fgbopal_08_adopt_bud + fgbopal_08_bud_adjt , '09' , fgbopal_09_adopt_bud + fgbopal_09_bud_adjt , '10' , fgbopal_10_adopt_bud + fgbopal_10_bud_adjt , '11' , fgbopal_11_adopt_bud + fgbopal_11_bud_adjt , '12' , fgbopal_12_adopt_bud + fgbopal_12_bud_adjt , '14' , fgbopal_14_adopt_bud + fgbopal_14_bud_adjt ) )Operating Budget &g   pp8q22"Operating Encumbrances"sum ( decode ( ftvatyp_internal_atyp_code , '70' , 1 , 0 ) * decode ( : fspd , '01' , fgbopal_01_encumb , '02' , fgbopal_02_encumb , '03' , fgbopal_03_encumb , '04' , fgbopal_04_encumb , '05' , fgbopal_05_encumb , '06' , fgbopal_06_encumb , '07' , fgbopal_07_encumb , '08' , fgbopal_08_encumb , '09' , fgbopal_09_encumb , '10' , fgbopal_10_encumb , '11' , fgbopal_11_encumb , '12' , fgbopal_12_encumb , '14' , fgbopal_14_encumb ) )Operating Encumbrances &g B$ pp8r22 !""Operating YTD_Activity"sum ( decode ( ftvatyp_internal_atyp_code , '70' , 1 , 0 ) * decode ( : fspd , '01' , fgbopal_01_ytd_actv , '02' , fgbopal_02_ytd_actv , '03' , fgbopal_03_ytd_actv , '04' , fgbopal_04_ytd_actv , '05' , fgbopal_05_ytd_actv , '06' , fgbopal_06_ytd_actv , '07' , fgbopal_07_ytd_actv , '08' , fgbopal_08_ytd_actv , '09' , fgbopal_09_ytd_actv , '10' , fgbopal_10_ytd_actv , '11' , fgbopal_11_ytd_actv , '12' , fgbopal_12_ytd_actv , '14' , fgbopal_14_ytd_actv ) )Operating YTD_Activity &g pp3s33"Operating Balance"sum ( decode ( ftvatyp_internal_atyp_code , '70' , 1 , 0 ) * decode ( : fspd , '01' , fgbopal_01_adopt_bud + fgbopal_01_bud_adjt , '02' , fgbopal_02_adopt_bud + fgbopal_02_bud_adjt , '03' , fgbopal_03_adopt_bud + fgbopal_03_bud_adjt , '04' , fgbopal_04_adopt_bud + fgbopal_04_bud_adjt , '05' , fgbopal_05_adopt_bud + fgbopal_05_bud_adjt , '06' , fgbopal_06_adopt_bud + fgbopal_06_bud_adjt , '07' , fgbopal_07_adopt_bud + fgbopal_07_bud_adjt , '08' , fgbopal_08_adopt_bud + fgbopal_08_bud_adjt , '09' , fgbopal_09_adopt_bud + fgbopal_09_bud_adjt , '10' , fgbopal_10_adopt_bud + fgbopal_10_bud_adjt , '11' , fgbopal_11_adopt_bud + fgbopal_11_bud_adjt , '12' , fgbopal_12_adopt_bud + fgbopal_12_bud_adjt , '14' , fgbopal_14_adopt_bud + fgbopal_14_bud_adjt ) ) - sum ( decode ( ftvatyp_internal_atyp_code , '70' , 1 , 0 ) * decode ( : fspd , '01' , fgbopOperating Balance&gF&p'+,2p6p6p66788:8<8>8@BCDgQ_1 4 ff5g100b88008x ( * ,. 00r88g100b88208x * , .0 00r100g100b88b88 & (*= r75g25b75@8000vr FpGTUVWXY0Z[\0]^_0`abcdxj8j8l8n8p rtpupupppvahG_orgn_titleg 1 , >fKZXG_ORGN_TITLELIST_G_ORGN_TITLEd/bpclmnopqprrpspwwxyz{0|0}0~000pppppppYPRINTJOB YesPShow Print Job Dialogud/bpchijklmpnnpopwwxyz{0|0}0~000pppppppZMODE DefaultPOutput Mode f/bpcnopqrspvvpwpzz{|}~000000ppppppp[BACKGROUND tNoPRun in Backgroundd /bpcopqrstpzzp{p000000ppppppp\ORIENTATION NoLandscapePOrientation 1/bpcklmnoppvvpwpwwxyz{0|0}0~000ppppppp]DECIMALDecimal Indicator 1/bpcmnopqrpvvpwpwwxyz{0|0}0~000ppppppp^THOUSANDSThousands Indicatorjt/bpclmnopqprrpspsstu vx0y0z0{0|0}0~ppppppp_CURRENCYCurrency Symbolfg/bpcjklmnoprrpspuuvwxy0z0{0|0}0~0ppppppp`COPIES1Number of Copies_b/bpcmnopqrpvvpwp||}~ 000000pppppppaDESFORMATdfltDestination Format )/bpcklmnoppvvpwpwwxy z|0}0~0000pppppppbDESNAMEDestination Name, /bpcklmnoppvvpwp~~000000pppppppcDESTYPEScreenPDestination Type'0/bpcfghijkpnnpopoopqrs0t0u0v0w0x0ypz}~ppppppiID ( IdDIDcum /bpcmnopqrpvvpwpwwxyz{0|0}0~000pppq qqqjFSYR_CODE( Fsyr Codeselect ftvfsyr_fsyr_code from ftvfsyr where ftvfsyr_coas_code = 'E' order by ftvfsyr_start_dateftvfsyr_fsyr_code_COLFSYR_CODE/bpcnopqrspvvpwpwwxyz{0|0}0~000p( ppppppqorgn_titlehr#!Orgn Title'fsyrORGN_TITLEopa/bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~ppppppoutput| OutputOUTPUTsum/bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~ppppppP_PASS| P PassP_PASS_02/bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~ppppppP_ROLE| P RoleP_ROLE , /bpcklmnoppvvpwpwwxyz{0|0}0~000pppppppONEUPNO| OneupnoP_ROONEUPNOad/bpcrstuvwpzzp{p{{|}~000000pppppppP_USER_CONNECT|2 P User ConnectUP_USER_CONNECT14'/bpclmnopqprrpspsstuvw0x0y0z0{0|0}p~ppppppP_ACTIONd P ActionP_ACTIONgF&p'+,2p6p6p66788:8<8>8@BCDgQ_1 4 ff5g100b88008x ( * ,. 00r88g100b88208x * , .0 00r100g100b88b88 & (*= r75g25b75@8000vr/bpcqrstuvpzzp{p{{|}~000000pppppppP_SERVER_NAME 2 P Server Name UP_SERVER_NAME3/bpchijklmpnnpopoopqrs0t0u0v0w0x0ypzpq"#$%q&q&&'()q*q//01FSPD( Fspdselect ftvfspd_fspd_code from ftvfspd where ftvfspd_coas_code = 'E' and ftvfspd_fsyr_code = '03' union select '14' from dual order by 1ftvfspd_fspd_codeFSPD/bpchijklmpnnpopoopqrs0t0u0v0w0x0ypzppppppPIDM( PidmPIDMa/bpcmnopqrpvvpwpwwxyz{0|0}0~000p  ppppppCOAS_codeh!Coas1' 'spd_COAS1/bpcmnopqrpvvpwpwwxyz{0|0}0~000p  ppppppfund_codeh!Fund`'spd_FUND/bpcmnopqrpvvpwpwwxyz{0|0}0~000p  pppppporgn_codeh!Orgn` 'spd_ORGN/bpcrstuvwpzzp{p{{|}~000000p( ppppppRevenue_Budgeth!&Revenue Budgetspd__'d whREVENUE_BUDGET/bpcxyz{|}p~~pp000000p( ppppppRevenue_YTD_Activityh!&Revenue Ytd Activity'_'REVEREVENUE_YTD_ACTIVITYv/bpcstuvwxp~~pp000000p( ppppppRevenue_Balancehh!&Revenue Balance_'REVENUE_BALANCE0000pppppppbDESNAMEDestination Name, /bpcklmnoppvvpwp~~000000pppppppcDESTYPEScreenPDestination Type'0/bpcfghijkpnnpopoopqrs0t0u0v0w0x0ypz}~ppppppiID ( IdDIDcum /bpcmnopqrpvvpwpwwxyz{0|0}0~000pppq qqqjFSYR_CODE( Fsyr Codeselect ftvfsyr_fsyr_code from ftvfsyr where ftvfsyr_coas_code = 'E' order by ftvfsyr_start_dateftvfsyr_fsyr_code_COLFSYR_CODE/bpcnopqrspvvpwpwwxyz{0|0}0~000p( ppppppqorgn_titlehr#!Orgn Title'fsyrORGN_TITLEopa/bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~ppppppoutput| OutputOUTPUTsum/bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~ppppppP_PASS| P PassP_PASS_02/bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~ppppppP_ROLE| P RoleP_ROLE , /bpcklmnoppvvpwpwwxyz{0|0}0~000pppppppONEUPNO| OneupnoP_ROONEUPNOad/bpcrstuvwpzzp{p{{|}~000000pppppppP_USER_CONNECT|2 P User ConnectUP_USER_CONNECT14'/bpclmnopqprrpspsstuvw0x0y0z0{0|0}p~ppppppP_ACTIONd P ActionP_ACTIONgF&p'+,2p6p6p66788:8<8>8@BCDgQ_1 4 ff5g100b88008x ( * ,. 00r88g100b88208x * , .0 00r100g100b88b88 & (*= r75g25b75@8000v <r BpD Z\(bpfpf0f0g@j8npqrs0t0u0v0w0x0yz0{0|}~ .M_G_orgn_title_GRPFRp0 ti@$h! BpDWX Zp\p^0^0_@b8fhijk0l0m0n0o0p0qr0s0tuvwxyz |~/M_G_orgn_title_HDRp@h BpDST(Zp^p^0^8`@b8fhijk0l0m0n0o0p0qr0s0tuvwxyz |~0R_G_orgn_titleRp0@ h#JpK]^(bpfpf8f8h8j8lnopqrstuv0w0x0ypzp0current_date_SEC2!0 @UDD-MON-RR HH:MI AMatin~# JpLST(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{| PF_ID1te_SE0@ui0|# JpLZ[(^pbpb8b8d8f8hjklmnopqr0s0t0upvpv0vwxyz{|}~ PF_FSYR_CODE10#@uj/# JpLWX(^pbpb8b8d8f8hjklmnopqr0s0t0upvpv0vwxyz{|}~ PF_output109b@u`z# JpLTU(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwx PF_FSPD 0.@u# JpL Z\(bpfpf0f8h8j8lnopqrstuv0w0x0ypzpz0z{|}~ 1F_orgn_titleh.@uBq'0# JpL XZ(^pbpb0b8d8f8hjklmnopqr0s0t0upvpv0vwxyz{|} ~ 4F_COAS_codeh.0'0# JpL XZ(^pbpb8b8d8f8hjklmnopqr0s0t0upvpv0vwxyz{|} ~ 6F_fund_codeh.0 '0# JpL XZ(^pbpb8b8d8f8hjklmnopqr0s0t0upvpv0vwxyz{|} ~ 8F_orgn_codeh.0'0# JpL ^`(fpjpj8j8l8n8prstuvwxyz0{0|0}p~p0 :F_Revenue_Budget.h 00D NNNGNNNGNNNGNN0D00(0# JpL df(jpnpn8n8p8r8tvwxyz{|}~000pp0 F_Revenue_Balancehyh0v NNNGNNNGNNNGNN0D0000(0# JpL `b(fpjpj@j8n8p8rtuvwxyz{|0}0~0pp0 @F_Personnel_Budgethh0 NNNGNNNGNNNGNN0D00(0# JpL fh(nprpr@r8v8x8z|}~000pp0 BF_Personnel_YTD_Activityh00 NNNGNNNGNNNGNN0D00(0# JpL `b(fpjpj@j8n8p8rtuvwxyz{|0}0~0pp0 DF_Personnel_Balancehy0 NNNGNNNGNNNGNN0D00NN(0# JpL `b(fpjpj@j8n8p8rtuvwxyz{|0}0~0pp0 FF_Operating_Budgethy0 NNNGNNNGNNNGNN0D00NN(0# JpL fh(nprpr@r8v8x8z|}~000pp0 HF_Operating_Encumbrancesh00 NNNGNNNGNNNGNN0D00(0# JpL fh(nprpr@r8v8x8z|}~000pp0 JF_Operating_YTD_Activityh00 NNNGNNNGNNNGNN0D00(0# JpL `b(fpjpj@j8n8p8rtuvwxyz{|0}0~0pp0 LF_Operating_Balancehy0* NNNGNNNGNNNGNN0D00NN(0" pppppppOneupnoP_ROONEUPNOad/bpcrstuvwpzzp{p{{|}~000000pppppppP_USER_CONNECT|2 P User ConnectUP_USER_CONNECT14'/bpclmnopqprrpspsstuvw0x0y0z0{0|0}p~ppppppP_ACTIONd P ActionP_ACTIONgF&p'+,2p6p6p66788:8<8>8@BCDgQ_1 4 ff5g100b88008x ( * ,. 00r88g100b88208x * , .0 00r100g100b88b88 & (*= r75g25b75@8000v0#l1 $  BEFOREREPORTfunction BeforeReport return boolean is report_name VARCHAR2(30); begin srw.get_report_name(report_name); report_name := rtrim(report_name); p_update_report_log(report_name); return (TRUE); end; beforereportͫͫͫͫͫͫͫw SYSSTANDARD SRW P_UPDATE_REPORT_LOG p <<EKUP_UPDATE_REPORT_LOG xg PUBLICP_UPDATE_REPORT_LOGxf  2EKUSMGRP_UPDATE_REPORT_LOG$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 + $"PKG INIT"BEFOREREPORT"REPORT_NAME""#&')   l$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 ++++<eedAAe= r"FUNCTION"BEFOREREPORT"RETURN"BOOLEAN"REPORT_NAME"VARCHAR2"30"SRW"GET_REPORT_NAME"RTRIM"P_UPDATE_REPORT_LOG"TRUE"" #$(359:AIMPSUZ]aefjnrw{|h,cQWk .WeZO  ' &  (     )   *  #$   "%!!d ͫͫͫͫͫͫͫ0D mm  l&'<   %:9  &' $$$<$  "{tX% hg!0<0D0 BEFOREREPORThxf  2P_UPDATE_REPORT_LOGEKUSMGRP_UPDATE_REPORT_LOGP_UP_UPDATE_REPORT_LOG 8`$dh/Q\g@@_05_ytd_actv , '06' , fgbopal_06_ytd_actv , '07' , fgbopal_07_ytd_actv , '08' , fgbopal_08_ytd_actv , '09' , fgbopal_09_ytd_actv , '10' , fgbopal_10_ytd_actv , '11' , fgbopal_11_ytd_actv , '12' , fgbopal_12_ytd_actv , '14' , fgbopal_14_ytd_actv ) )Operating YTD_Activity &g p3ps33"Operating Balance"sum ( decode ( ftvatyp_internal_atyp_code , '70' , 1 , 0 ) * decode ( : fspd , '01' , fgbopal_01_adopt_bud + fgbopal_01_bud_adjt , '02' , fgbopal_02_adopt_bud + fgbopal_02_bud_adjt , '03' , fgbopal_03_adopt_bud + fgbopal_03_bud_adjt , '04' , fgbopal_04_adopt_bud + fgbopal_04_bud_adjt , '05' , fgbopal_05_adopt_bud + fgbopal_05_bud_adjt , '06' , fgbopal_06_adopt_bud + fgbopal_06_bud_adjt , '07' , fgbopal_07_adopt_bud + fgbopal_07_bud_adjt , '08' , fgbopal_08_adopt_bud + fgbopal_08_bud_adjt , '09' , fgbopal_09_adopt_bud + fgbopal_09_bud_adjt , '10' , fgbopal_10_adopt_bud + fgbopal_10_bud_adjt , '11' , fgbopal_11_adopt_bud + fgbopal_11_bud_adjt , '12' , fgbopal_12_adopt_bud + fgbopal_12_bud_adjt , '14' , fgbopal_14_adopt_bud + fgbopal_14_bud_adjt ) ) - sum ( decode ( ftvatyp_internal_atyp_code , '70' , 1 , 0 ) * decode ( : fspd , '01' , fgbopOperating Balance&gF&'p+,26p6p6p678:8<8>8@8BCDgQ_1f! 4 ff/bcpklmnopvpvwp~p~000000pppppppcDESTYPEScreenPDestination TypeDEPT rwlo@l1  $ F BEFOREPFORMfunction BeforePForm return boolean is vc_parameter_form varchar2(4000); vc_hidden_runtime_values varchar2(1000); vc_report_name varchar2(50); hold_cmd VARCHAR2(240); begin if :P_Role IS NOT NULL then -- Dev6i Patch 10 seems to strip away double quotes - they are needed if substr(:P_Pass,1,1) = chr(34) then Hold_Cmd := :P_Role || ' IDENTIFIED BY '||:P_Pass; else Hold_Cmd := :P_Role || ' IDENTIFIED BY '|| chr(34) ||:P_Pass ||chr(34); end if; DBMS_SESSION.SET_ROLE(Hold_Cmd); end if; srw.get_report_name(vc_report_name); vc_report_name := substr(vc_report_name,1,instr(vc_report_name,' ')-1); vc_hidden_runtime_values:='report='||rtrim(vc_report_name)||'.rep' ||'&destype=Cache'||'&server='||:p_servername||'&userid='||:p_user_connect ||'&desformat=html'||'&oneupno='||:oneupno ||'&p_servername='||:p_servername||'&p_user_connect='||:p_user_connect; vc_parameter_form:='
' ||'' ||'' ||'' ||'' ||'

' ||'
' ||'


'; srw.set_before_form_html (srw.text_escape, vc_parameter_form); if :fspd is null and :fsyr_code is null then select ftvfspd_fspd_code, ftvfspd_fsyr_code into :fspd, :fsyr_code from ftvfspd where ftvfspd_coas_code = 'E' and sysdate between ftvfspd_prd_start_date and ftvfspd_prd_end_date; end if; RETURN (TRUE); EXCEPTION WHEN OTHERS THEN SRW.MESSAGE(1000,'*ERROR* Before Parm trigger Could not set database role - report terminated.'); RETURN (FALSE); END; beforepform@@cpfghijknpnopopopqrst0u0v0w0x0y0zp}~ppppppiID ( IdDIDz /bcpmnopqrvpvwpwpwxyz{|0}0~0000ppp qqqqjFSYR_CODE( Fsyr Codeselect ftvfsyr_fsyr_code from ftvfsyr where ftvfsyr_coas_code = 'E' order by ftvfsyr_start_dateftvfsyr_fsyr_code_COLFSYR_CODE/bcpnopqrsvpvwpwpwxyz{|0}0~0000p( ppppppqorgn_titlehr#!Orgn Title'fsyrORGN_TITLE/bcpjklmnorprspspstuvwx0y0z0{0|0}0~pppppppoutput| OutputOUTPUT0b@/bcpjklmnorprspspstuvwx0y0z0{0|0}0~pppppppP_PASS| P PassP_PASSp/bcpjklmnorprspspstuvwx0y0z0{0|0}0~pppppppP_ROLE| P RoleP_ROLE/bcpklmnopvpvwpwpwxyz{|0}0~0000pppppppONEUPNO| OneupnoP_ROONEUPNOb8/bcprstuvwzpz{p{p{|}~000000pppppppP_USER_CONNECT|2 P User ConnectUP_USER_CONNECTB/bcplmnopqrprspspstuvwx0y0z0{0|0}0~pppppppP_ACTIONd P ActionP_ACTION~#JKpVWZ(^p^p^8`8b8d8fghijklmno0p0q0rprpr0stuvwxyz{|F_HIREDATE 00jv~#JKpQRV(ZpZpZ@^8`8b8defghijklm0n0o0pprpr0stuvwxyz{|F_SAL TE0yPlfunction BeforePForm return boolean is vc_parameter_form varchar2(4000); vc_hidden_runtime_values varchar2(1000); vc_report_name varchar2(50); hold_cmd VARCHAR2(240); begin if :P_Role IS NOT NULL then -- Dev6i Patch 10 seems to strip away double quotes - they are needed if substr(:P_Pass,1,1) = chr(34) then Hold_Cmd := :P_Role || ' IDENTIFIED BY '||:P_Pass; else Hold_Cmd := :P_Role || ' IDENTIFIED BY '|| chr(34) ||:P_Pass ||chr(34); end if; DBMS_SESSION.SET_ROLE(Hold_Cmd); end if; srw.get_report_name(vc_report_name); vc_report_name := substr(vc_report_name,1,instr(vc_report_name,' ')-1); vc_hidden_runtime_values:='report='||rtrim(vc_report_name)||'.rep' ||'&destype=Cache'||'&server='||:p_servername||'&userid='||:p_user_connect ||'&desformat=html'||'&oneupno='||:oneupno ||'&p_servername='||:p_servername||'&p_user_connect='||:p_user_connect; vc_parameter_form:='' ||'' ||'' ||'' ||'' ||'

' ||'
' ||'


'; srw.set_before_form_html (srw.text_escape, vc_parameter_form); if :fspd is null and :fsyr_code is null then select ftvfspd_fspd_code, ftvfspd_fsyr_code into :fspd, :fsyr_code from ftvfspd where ftvfspd_coas_code = 'E' and sysdate between ftvfspd_prd_start_date and ftvfspd_prd_end_date; end if; RETURN (TRUE); EXCEPTION WHEN OTHERS THEN SRW.MESSAGE(1000,'*ERROR* Before Parm trigger Could not set database role - report terminated.'); RETURN (FALSE); END;al_08_bud_adjt, '09', fgbopal_09_adopt_bud + fgbopal_09_bud_adjt, '10', fgbopal_10_adopt_bud + fgbopal_10_bud_adjt, '11', fgbopal_11_adopt_bud + fgbopal_11_bud_adjt, '12', fgbopal_12_adopt_bud + fgbopal_12_bud_adjt, '14', fgbopal_14_adopt_bud + fgbopal_14_bud_adjt)) - sum(decode(ftvatyp_internal_atyp_code, '50', 1, 0) * decode(:fspd, '01', fgbopal_01_ytd_actv, '02', fgbopal_02_ytd_actv, '03', fgbopal_03_ytd_actv, '04', fgbopal_04_ytd_actv, '05', fgbopal_05_ytd_actv, '06', fgbopal_06_ytd_actv, '07', fgbopal_07_ytd_actv, '08', fgbopal_08_ytd_actv, '09', fgbopal_09_ytd_actv, '10', fgbopal_10_ytd_actv, '11', fgbopal_11_ytd_actv, '12', fgbopal_12_ytd_actv, '14', fgbopal_14_ytd_actv)) "Revenue Balance", sum(decode(ftvatyp_internal_atyp_code, '60', 1, 0) *decode(:fspd, '01', fgbopal_01_adopt_bud + fgbopal_01_bud_adjt, '02', fgbopal_02_adopt_bud + fgbopal_02_bud_adjt, '03', fgbopal_03_adopt_bud + fgbopal_03_bud_adjt, '04', fgbopal_04_adopt_bud + fgbopal_04_bud_adjt, '05', fgbopal_05_adopt_bud + fgbopal_05_bud_adjt, '06', fgbopal_06_adopt_bud + fgbopal_06_bud_adjt, '07', fgbopal_07_adopt_bud + fgbopal_07_bud_adjt, '08', fgbopal_08_adopt_bud + fgbopal_08_bud_adjt, '09', fgbopal_09_adopt_bud + fgbopal_09_bud_adjt, '10', fgbopal_10_adopt_bud + fgbopal_10_bud_adjt, '11', fgbopal_11_adopt_bud + fgbopal_11_bud_adjt, '12', fgbopal_12_adopt_bud + fgbopal_12_bud_adjt, '14', fgbopal_14_adopt_bud + fgbopal_14_bud_adjt)) "Personnel Budget", sum(decode(ftvatyp_internal_atyp_code, '60', 1, 0) * decode(:fspd, '01', fgbopal_01_ytd_actv, '02', fgbopal_02_ytd_actv, '03', fgbopal_03_ytd_actv, '04', fgbopal_04_ytd_actv, '05', fgbopal_05_ytd_actv, '06', fgbopal_06_ytd_actv, '07', fgbop`l1 $" 0 AFTERPFORMfunction AfterPForm return boolean is begin select distinct spriden_pidm into :pidm from spriden where spriden_id = :id; return (TRUE); end; afterpform 1ͫͫͫͫͫͫͫw SYSSTANDARD p <<EKUSPRIDEN xg <PUBLICSPRIDENxh  9.SATURNSPRIDEN$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ086 ;"PKG INIT"AFTERPFORM""""#%+./024     ,R$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 0000L $  eeAeeA  U"FUNCTION"AFTERPFORM"RETURN"BOOLEAN"SPRIDEN_PIDM"PIDM""SPRIDEN"SPRIDEN_ID"ID"="TRUE""V #$(357<BFGKRSW\`aelmnuy|h,.|eZOcQcQ`       , +   '"#!  # ' %$& ( )(*( ., !"/- $d"!ͫͫͫͫͫͫͫ0D SSTw q{t ,w,4,t,44<<% hg!`9v8@Txd AFTERPFORM2 ,4 <(P(B M SELECT DISTINCT SPRIDEN_PIDM FROM SPRIDEN WHERE SPRIDEN_ID = :b1"@@pal_03_encumb, '04', fgbopal_04_encumb, '05', fgbopal_05_encumb, '06', fgbopal_06_encumb, '07', fgbopal_07_encumb, '08', fgbopal_08_encumb, '09', fgbopal_09_encumb, '10', fgbopal_10_encumb, '11', fgbopal_11_encumb, '12', fgbopal_12_encumb, '14', fgbopal_14_encumb)) "Operating Encumbrances", sum(decode(ftvatyp_internal_atyp_code, '70', 1, 0) * decode(:fspd, '01', fgbopal_01_ytd_actv, '02', fgbopal_02_ytd_actv, '03', fgbopal_03_ytd_actv, '04', fgbopal_04_ytd_actv, '05', fgbopal_05_ytd_actv, '06', fgbopal_06_ytd_actv, '07', fgbopal_07_ytd_actv, '08', fgbopal_08_ytd_actv, '09', fgbopal_09_ytd_actv, '10', fgbopal_10_ytd_actv, '11', fgbopal_11_ytd_actv, '12', fgbopal_12_ytd_actv, '14', fgbopal_14_ytd_actv)) "Operating YTD_Activity", sum(decode(ftvatyp_internal_atyp_code, '70', 1, 0) *decode(:fspd, '01', fgbopal_01_adopt_bud + fgbopal_01_bud_adjt, '02', fgbopal_02_adopt_bud + fgbopal_02_bud_adjt, '03', fgbopal_03_adopt_bud + fgbopal_03_bud_adjt, '04', fgbopal_04_adopt_bud + fgbopal_04_bud_adjt, '05', fgbopal_05_adopt_bud + fgbopal_05_bud_adjt, '06', fgbopal_06_adopt_bud + fgbopal_06_bud_adjt, '07', fgbopal_07_adopt_bud + fgbopal_07_bud_adjt, '08', fgbopal_08_adopt_bud + fgbopal_08_bud_adjt, '09'plselect fgbopal_coas_code COAS_code, fgbopal_fund_code fund_code, fgbopal_orgn_code orgn_code, ftvorgn_title orgn_title, sum(decode(ftvatyp_internal_atyp_code, '50', 1, 0) *decode(:fspd, '01', fgbopal_01_adopt_bud + fgbopal_01_bud_adjt, '02', fgbopal_02_adopt_bud + fgbopal_02_bud_adjt, '03', fgbopal_03_adopt_bud + fgbopal_03_bud_adjt, '04', fgbopal_04_adopt_bud + fgbopal_04_bud_adjt, '05', fgbopal_05_adopt_bud + fgbopal_05_bud_adjt, '06', fgbopal_06_adopt_bud + fgbopal_06_bud_adjt, '07', fgbopal_07_adopt_bud + fgbopal_07_bud_adjt, '08', fgbopal_08_adopt_bud + fgbopal_08_bud_adjt, '09', fgbopal_09_adopt_bud + fgbopal_09_bud_adjt, '10', fgbopal_10_adopt_bud + fgbopal_10_bud_adjt, '11', fgbopal_11_adopt_bud + fgbopal_11_bud_adjt, '12', fgbopal_12_adopt_bud + fgbopal_12_bud_adjt, '14', fgbopal_14_adopt_bud + fgbopal_14_bud_adjt)) "Revenue Budget", sum(decode(ftvatyp_internal_atyp_code, '50', 1, 0) * decode(:fspd, '01', fgbopal_01_ytd_actv, '02', fgbopal_02_ytd_actv, '03', fgbopal_03_ytd_actv, '04', fgbopal_04_ytd_actv, '05', fgbopal_05_ytd_actv, '06', fgbopal_06_ytd_actv, '07', fgbopal_07_ytd_actv, '08', fgbopal_08_ytd_actv, '09', fgbopal_09_ytd_actv, '10', fgbopal_10_ytd_actv, '11', fgbopal_11_ytd_actv, '12', fgbopal_12_ytd_actv, '14', fgbopal_14_ytd_actv)) "Revenue YTD_Activity", sum(decode(ftvatyp_internal_atyp_code, '50', 1, 0) *decode(:fspd, '01', fgbopal_01_adopt_bud + fgbopal_01_bud_adjt, '02', fgbopal_02_adopt_bud + fgbopal_02_bud_adjt, '03', fgbopal_03_adopt_bud + fgbopal_03_bud_adjt, '04', fgbopal_04_adopt_bud + fgbopal_04_bud_adjt, '05', fgbopal_05_adopt_bud + fgbopal_05_bud_adjt, '06', fgbopal_06_adopt_bud + fgbopal_06_bud_adjt, '07', fgbopal_07_adopt_bud + fgbopal_07_bud_adjt, '08', fgbopal_08_adopt_bud + fgbopal_08_bud_adjt, '09', fgbopal_09_adopt_bud + fgbopal_09_bud_adjt, '10', fgbopal_10_adopt_bud + fgbopal_10_bud_adjt, '11', fgbopal_11_adopt_bud + fgbopal_11_bud_adjt, '12', fgbopal_12_adopt_bud + fgbopal_12_bud_adjt, '14', fgbopal_14_adopt_bud + fgbopal_14_bud_adjt)) - sum(decode(ftvatyp_internal_atyp_code, '50', 1, 0) * decode(:fspd, '01', fgbopal_01_ytd_actv, '02', fgbopal_02_ytd_actv, '03', fgbopal_03_ytd_actv, '04', fgbopal_04_ytd_actv, '05', fgbopal_05_ytd_actv, '06', fgbopal_06_ytd_actv, '07', fgbopal_07_ytd_actv, '08', fgbopal_08_ytd_actv, '09', fgbopal_09_ytd_actv, '10', fgbopal_10_ytd_actv, '11', fgbopal_11_ytd_actv, '12', fgbopal_12_ytd_actv, '14', fgbopal_14_ytd_actv)) "Revenue Balance", sum(decode(ftvatyp_internal_atyp_code, '60', 1, 0) *decode(:fspd, '01', fgbopal_01_adopt_bud + fgbopal_01_bud_adjt, '02', fgbopal_02_adopt_bud + fgbopal_02_bud_adjt, '03', fgbopal_03_adopt_bud + fgbopal_03_bud_adjt, '04', fgbopal_04_adopt_bud + fgbopal_04_bud_adjt, '05', fgbopal_05_adopt_bud + fgbopal_05_bud_adjt, '06', fgbopal_06_adopt_bud + fgbopal_06_bud_adjt, '07', fgbopal_07_adopt_bud + fgbopal_07_bud_adjt, '08', fgbopal_08_adopt_bud + fgbopal_08_bud_adjt, '09', fgbopal_09_adopt_bud + fgbopal_09_bud_adjt, '10', fgbopal_10_adopt_bud + fgbopal_10_bud_adjt, '11', fgbopal_11_adopt_bud + fgbopal_11_bud_adjt, '12', fgbopal_12_adopt_bud + fgbopal_12_bud_adjt, '14', fgbopal_14_adopt_bud + fgbopal_14_bud_adjt)) "Personnel Budget", sum(decode(ftvatyp_internal_atyp_code, '60', 1, 0) * decode(:fspd, '01', fgbopal_01_ytd_actv, '02', fgbopal_02_ytd_actv, '03', fgbopal_03_ytd_actv, '04', fgbopal_04_ytd_actv, '05', fgbopal_05_ytd_actv, '06', fgbopal_06_ytd_actv, '07', fgboplal_07_ytd_actv, '08', fgbopal_08_ytd_actv, '09', fgbopal_09_ytd_actv, '10', fgbopal_10_ytd_actv, '11', fgbopal_11_ytd_actv, '12', fgbopal_12_ytd_actv, '14', fgbopal_14_ytd_actv)) "Personnel YTD_Activity", sum(decode(ftvatyp_internal_atyp_code, '60', 1, 0) *decode(:fspd, '01', fgbopal_01_adopt_bud + fgbopal_01_bud_adjt, '02', fgbopal_02_adopt_bud + fgbopal_02_bud_adjt, '03', fgbopal_03_adopt_bud + fgbopal_03_bud_adjt, '04', fgbopal_04_adopt_bud + fgbopal_04_bud_adjt, '05', fgbopal_05_adopt_bud + fgbopal_05_bud_adjt, '06', fgbopal_06_adopt_bud + fgbopal_06_bud_adjt, '07', fgbopal_07_adopt_bud + fgbopal_07_bud_adjt, '08', fgbopal_08_adopt_bud + fgbopal_08_bud_adjt, '09', fgbopal_09_adopt_bud + fgbopal_09_bud_adjt, '10', fgbopal_10_adopt_bud + fgbopal_10_bud_adjt, '11', fgbopal_11_adopt_bud + fgbopal_11_bud_adjt, '12', fgbopal_12_adopt_bud + fgbopal_12_bud_adjt, '14', fgbopal_14_adopt_bud + fgbopal_14_bud_adjt)) - sum(decode(ftvatyp_internal_atyp_code, '60', 1, 0) * decode(:fspd, '01', fgbopal_01_ytd_actv, '02', fgbopal_02_ytd_actv, '03', fgbopal_03_ytd_actv, '04', fgbopal_04_ytd_actv, '05', fgbopal_05_ytd_actv, '06', fgbopal_06_ytd_actv, '07', fgbopal_07_ytd_actv, '08', fgbopal_08_ytd_actv, '09', fgbopal_09_ytd_actv, '10', fgbopal_10_ytd_actv, '11', fgbopal_11_ytd_actv, '12', fgbopal_12_ytd_actv, '14', fgbopal_14_ytd_actv)) "Personnel Balance", sum(decode(ftvatyp_internal_atyp_code, '70', 1, 0) *decode(:fspd, '01', fgbopal_01_adopt_bud + fgbopal_01_bud_adjt, '02', fgbopal_02_adopt_bud + fgbopal_02_bud_adjt, '03', fgbopal_03_adopt_bud + fgbopal_03_bud_adjt, '04', fgbopal_04_adopt_bud + fgbopal_04_bud_adjt, '05', fgbopal_05_adopt_bud + fgbopal_05_bud_adjt, '06', fgbopal_06_adopt_bud + fgbopal_06_bud_adjt, '07', fgbopal_07_adopt_bud + fgbopal_07_bud_adjt, '08', fgbopal_08_adopt_bud + fgbopal_08_bud_adjt, '09', fgbopal_09_adopt_bud + fgbopal_09_bud_adjt, '10', fgbopal_10_adopt_bud + fgbopal_10_bud_adjt, '11', fgbopal_11_adopt_bud + fgbopal_11_bud_adjt, '12', fgbopal_12_adopt_bud + fgbopal_12_bud_adjt, '14', fgbopal_14_adopt_bud + fgbopal_14_bud_adjt)) "Operating Budget", sum(decode(ftvatyp_internal_atyp_code, '70', 1, 0) *decode(:fspd, '01', fgbopal_01_encumb, '02', fgbopal_02_encumb, '03', fgbopal_03_encumb, '04', fgbopal_04_encumb, '05', fgbopal_05_encumb, '06', fgbopal_06_encumb, '07', fgbopal_07_encumb, '08', fgbopal_08_encumb, '09', fgbopal_09_encumb, '10', fgbopal_10_encumb, '11', fgbopal_11_encumb, '12', fgbopal_12_encumb, '14', fgbopal_14_encumb)) "Operating Encumbrances", sum(decode(ftvatyp_internal_atyp_code, '70', 1, 0) * decode(:fspd, '01', fgbopal_01_ytd_actv, '02', fgbopal_02_ytd_actv, '03', fgbopal_03_ytd_actv, '04', fgbopal_04_ytd_actv, '05', fgbopal_05_ytd_actv, '06', fgbopal_06_ytd_actv, '07', fgbopal_07_ytd_actv, '08', fgbopal_08_ytd_actv, '09', fgbopal_09_ytd_actv, '10', fgbopal_10_ytd_actv, '11', fgbopal_11_ytd_actv, '12', fgbopal_12_ytd_actv, '14', fgbopal_14_ytd_actv)) "Operating YTD_Activity", sum(decode(ftvatyp_internal_atyp_code, '70', 1, 0) *decode(:fspd, '01', fgbopal_01_adopt_bud + fgbopal_01_bud_adjt, '02', fgbopal_02_adopt_bud + fgbopal_02_bud_adjt, '03', fgbopal_03_adopt_bud + fgbopal_03_bud_adjt, '04', fgbopal_04_adopt_bud + fgbopal_04_bud_adjt, '05', fgbopal_05_adopt_bud + fgbopal_05_bud_adjt, '06', fgbopal_06_adopt_bud + fgbopal_06_bud_adjt, '07', fgbopal_07_adopt_bud + fgbopal_07_bud_adjt, '08', fgbopal_08_adopt_bud + fgbopal_08_bud_adjt, '09' l, fgbopal_09_adopt_bud + fgbopal_09_bud_adjt, '10', fgbopal_10_adopt_bud + fgbopal_10_bud_adjt, '11', fgbopal_11_adopt_bud + fgbopal_11_bud_adjt, '12', fgbopal_12_adopt_bud + fgbopal_12_bud_adjt, '14', fgbopal_14_adopt_bud + fgbopal_14_bud_adjt)) - sum(decode(ftvatyp_internal_atyp_code, '70', 1, 0) * decode(:fspd, '01', fgbopal_01_ytd_actv, '02', fgbopal_02_ytd_actv, '03', fgbopal_03_ytd_actv, '04', fgbopal_04_ytd_actv, '05', fgbopal_05_ytd_actv, '06', fgbopal_06_ytd_actv, '07', fgbopal_07_ytd_actv, '08', fgbopal_08_ytd_actv, '09', fgbopal_09_ytd_actv, '10', fgbopal_10_ytd_actv, '11', fgbopal_11_ytd_actv, '12', fgbopal_12_ytd_actv, '14', fgbopal_14_ytd_actv)) - sum(decode(ftvatyp_internal_atyp_code, '60', 1, 0) * decode(:fspd, '01', fgbopal_01_ytd_actv, '02', fgbopal_02_ytd_actv, '03', fgbopal_03_ytd_actv, '04', fgbopal_04_ytd_actv, '05', fgbopal_05_ytd_actv, '06', fgbopal_06_ytd_actv, '07', fgbopal_07_ytd_actv, '08', fgbopal_08_ytd_actv, '09', fgbopal_09_ytd_actv, '10', fgbopal_10_ytd_actv, '11', fgbopal_11_ytd_actv, '12', fgbopal_12_ytd_actv, '14', fgbopal_14_ytd_actv)) "Operating Balance" from fgbopal a, ftvorgn b, ftvacct c, ftvatyp d where fgbopal_fsyr_code = :fsyr_code and ftvorgn_fmgr_code_pidm = :pidm and fgbopal_acct_code = ftvacct_acct_code and ftvacct_coas_code = fgbopal_coas_code and ftvacct_eff_date = (select max(ftvacct_eff_date) from ftvacct where ftvacct_acct_code = c.ftvacct_acct_code and ftvacct_coas_code = c.ftvacct_coas_code and ftvacct_eff_date <= sysdate) and fgbopal_orgn_code = ftvorgn_orgn_code and fgbopal_coas_code = ftvorgn_coas_code and ftvorgn_eff_date = (select max(ftvorgn_eff_date) from ftvorgn where ftvorgn_orgn_code = b.ftvorgn_orgn_code and ftvorgn_coas_code = b.FTVORGN_COAS_CODE and ftvorgn_eff_date <= sysdate) and ftvacct_atyp_code = ftvatyp_atyp_code and ftvacct_coas_code = ftvatyp_coas_code and ftvatyp_eff_date = (select max(ftvatyp_eff_date) from ftvatyp where ftvatyp_eff_date <= sysdate and ftvatyp_atyp_code = d.ftvatyp_atyp_code and ftvatyp_coas_code = d.ftvatyp_coas_code) and (decode(:fspd, '01', fgbopal_01_adopt_bud, '02', fgbopal_02_adopt_bud, '03', fgbopal_03_adopt_bud, '04', fgbopal_04_adopt_bud, '05', fgbopal_05_adopt_bud, '06', fgbopal_06_adopt_bud, '07', fgbopal_07_adopt_bud, '08', fgbopal_08_adopt_bud, '09', fgbopal_09_adopt_bud, '10', fgbopal_10_adopt_bud, '11', fgbopal_11_adopt_bud, '12', fgbopal_12_adopt_bud, '14', fgbopal_14_adopt_bud) != 0 or decode(:fspd, '01', fgbopal_01_bud_adjt, '02', fgbopal_02_bud_adjt, '03', fgbopal_03_bud_adjt, '04', fgbopal_04_bud_adjt, '05', fgbopal_05_bud_adjt, '06', fgbopal_06_bud_adjt, '07', fgbopal_07_bud_adjt, '08', fgbopal_08_bud_adjt, '09', fgbopal_09_bud_adjt, '10', fgbopal_10_bud_adjt, '11', fgbopal_11_bud_adjt, '12', fgbopal_12_bud_adjt, '14', fgbopal_14_bud_adjt) != 0 or decode(:fspd, '01', fgbopal_01_ytd_actv, '02', fgbopal_02_ytd_actv, '03', fgbopal_03_ytd_actv, '04', fgbopal_04_ytd_actv, '05', fgbopal_05_ytd_actv, '06', fgbopal_06_ytd_actv, '07', fgbopal_07_ytd_actv, '08', fgbopal_08_ytd_actv, '09', fgbopal_09_ytd_actv, '10', fgbopal_10_ytd_actv, '11', fgbopal_11_ytd_actv, '12', fgbopal_12_ytd_actv, '14', fgbopal_14_ytd_actv) != 0 or decode(:fspd, '01', fgbopal_01_encumb, '02', fgbopal_02_encumb, '03', fgbopal_03_encumb, '04', fgbopal_04_encumb, '05', fgbopal_05 l_encumb, '06', fgbopal_06_encumb, '07', fgbopal_07_encumb, '08', fgbopal_08_encumb, '09', fgbopal_09_encumb, '10', fgbopal_10_encumb, '11', fgbopal_11_encumb, '12', fgbopal_12_encumb, '14', fgbopal_14_encumb) != 0) group by fgbopal_coas_code , fgbopal_fund_code , fgbopal_orgn_code , ftvorgn_title order by 1, 2, 3'L_BUPERSONNEL_YTD_ACTIVITY ( /bcpuvwxyz~p~pp000000p( ppppppPersonnel_Balance hh!&Personnel BalanceAc_''PERSONNEL_BALANCE/bcptuvwxyzpz{p{p{|}~000000p( ppppppOperating_Budget h!&Operating Budgetanc_'OPERATING_BUDGET/bcpz{|}~ppp000000p( ppppppOperating_Encumbrances h!&Operating Encumbrances_'G_BUOPERATING_ENCUMBRANCES0/bcpz{|}~ppp000000p( ppppppOperating_YTD_Activity h!&Operating Ytd Activity_'G_BUOPERATING_YTD_ACTIVITY/bcpuvwxyz~p~pp000000p( ppppppOperating_Balance hh!&Operating BalanceAc_''OPERATING_BALANCE*Z[plmn(rprpr@v8x8z8|}~x000000p0page_number_SEC2"0 0U 0U ԵKg*Z[pfgj(npnpn8p8r@v8xyz~x000000p0@title_SEC2#EC0h h UDg88b100008x( * , . 00r88g88b100208x* , . 0 00r100g88b100.08x& ( * ,00custom5.08x& ( * ,00custom6.08x& ( * ,00custom7.08x& ( * ,00custom8,08x$ & ( *00gray16 ,08x$ & ( *00gray12GGG,08x$ & ( *00gray8,08x$ & ( *00gray4-08x&( *+00r0g100b0/08x( * ,- 00r25g100b0@/08x( * ,- 00r50g100b0/08x( * ,- 00r75g100b0/08x( * ,- 00r88g100b0/08x( * ,- 00r100g100b0.08x'( * , 00r0g100b50008x( * , . 00r25g100b50@008x( * , . 00r50g100b50008x( * , . 00r75g100b50008x( * , . 00r88g100b50208x* , . 0 00r100g100b50.08x'( * , 00r0g100b75008x( * , . 00r25g100b75@008x( * , . 00r50g100b75008x( * , . 00r75g100b75008x( * , . 00r88g100b75208x* , . 0 00r100g100b75.08x'( * , 00r0g100b88008x( * , . 00r25g100b88@008x( * , . 00r50g100b88008x( * , . 00r75g100b88008x( * , . 00r88g100b88208x* , . 0 00r100g100b88008x(* , . 00r0g100b100208x* , . 0 00r25g100b100@208x* , . 0 00r50g100b100208x* , . 0 00r75g100b100208x* , . 0 00r88g100b100208x* , . 0 00r100g100b100C r75g25b88@,00x$ & ( *D r88g25b88@rwlohr/bpctuvwxypzzp{p{{|}~000000p( ppppppPersonnel_Budgeth!&Personnel Budgetce_'PERSONNEL_BUDGET/bpcz{|}~ppp000000p( ppppppPersonnel_YTD_Activityh!&Personnel Ytd Activity_'L_BUPERSONNEL_YTD_ACTIVITY63/bpcuvwxyzp~~pp000000p( ppppppPersonnel_Balance hh!&Personnel BalanceAc_''PERSONNEL_BALANCE/bpctuvwxypzzp{p{{|}~000000p( ppppppOperating_Budget h!&Operating Budgetanc_'OPERATING_BUDGET/bpcz{|}~ppp000000p( ppppppOperating_Encumbrances h!&Operating Encumbrances_'G_BUOPERATING_ENCUMBRANCESLIN/bpcz{|}~ppp000000p( ppppppOperating_YTD_Activity h!&Operating Ytd Activity_'G_BUOPERATING_YTD_ACTIVITYRW2/bpcuvwxyzp~~pp000000p( ppppppOperating_Balance hh!&Operating BalanceAc_''OPERATING_BALANCE*Zp[lm(nprpr@r8v8x8z|}~x000000p0_Cpage_number_SEC2"0 0U 0U ԵKgR*Zp[fg(jpnpn8n8p@r8vxyzx~000000p0-title_SEC2#EC0h h UD'VG_COLORGREEN )pp "$%&'VG_COLORBLUE /x-50Page &$9x7Eastern Kentucky University 0g0=x;!Financial Manager Organizations 08x60gFor Fiscal Year: &fsyr_code. x,Report Parameters< x: Enter values for the parameters' x%! Manager ID( x& " Fiscal Year# x!Output* x(Fiscal Period  x5CoA! x7Fund0! x009Orgn# x!M_;Budget) x' (= YTD Activity$ x" (?Balance# x!ABudget ) x'C YTD Activity$ $ x"EBalance# x!GBudget$ x"IEncumb.) x'rkK YTD Activity0$ x"anMBalance$ x"WRevenue& x$ $X Personnel33& x$ $Y Operating=p(00x " $&,gray72GGG(00x " $&-gray68QQQ'00x! "$%0.r0g25b0@)00x " $&'/r25g25b0@@)00x " $&'0r50g25b0@0)00x " $&'1r75g25b0@)00x " $&'2r88g25b0@+00x $ &()3 r100g25b0@*00x" $ &(4r0g25b50@,00x $ & (*5 r25g25b50@@,00x $ & (*6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (*8 r88g25b50@,00x $ & (*9 r100g25b50@*00x" $ &(:r0g25b750@,00x $ & (*; r25g25b75@@,00x $ & (*< r50g25b75@,00x $ & (*= r75g25b75@8000vtr* Zp\ab(fpjpj8j8l8n8prstxzz~000000p0pPB_3C2&r3U* Zp\ab(fpjpj8j8l8n8prstxzz~000000p0 PB_4C2ISU* Zp\cd(jpnpn8n8p8r8tvwxx~000000p0/PB_ID1q#q#U* Zp\jk(nprpr8r8t8v8xz{|x000000p0BAPB_FSYR_CODE1% 8% 8* Zp\gh(nprpr8r8t8v8xz{|x000000p0ERPB_output1: : * Zp\de(fpjpj8j8l8n8prstxz000000p0_PB_FSPD0$: 0$ * Zp\hi(jpnpn0n8p8r8tvwxx~000000p0  5B_COAS_code0    4/pc* Zp\hi(jpnpn8n8p8r8tvwxx~000000p0  pe7B_fund_code0    6/* Zp\hi(jpnpn8n8p8r8tvwxx~000000p0  _C9B_orgn_code 0    8/R* Zp\mn(rpvpv8v8x8z8|~x000000p0  -;B_Revenue_Budget  0D   D  D:/GREEN )pp "$%&'VG_COLORBLUE /x-50Page &$9x7Eastern Kentucky University 0g0=x;!Financial Manager Organizations 08x60gFor Fiscal Year: &fsyr_code. x,Report Parameters< x: Enter values for the parameters' x%! Manager ID( x& " Fiscal Year# x!Output* x(Fiscal Period  x5CoA! x7Fund0! x009Orgn# x!M_;Budget) x' (= YTD Activity$ x" (?Balance# x!ABudget ) x'C YTD Activity$ $ x"EBalance# x!GBudget$ x"IEncumb.) x'rkK YTD Activity0$ x"anMBalance$ x"WRevenue& x$ $X Personnel33& x$ $Y Operating=p(00x " $&,gray72GGG(00x " $&-gray68QQQ'00x! "$%0.r0g25b0@)00x " $&'/r25g25b0@@)00x " $&'0r50g25b0@0)00x " $&'1r75g25b0@)00x " $&'2r88g25b0@+00x $ &()3 r100g25b0@*00x" $ &(4r0g25b50@,00x $ & (*5 r25g25b50@@,00x $ & (*6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (*8 r88g25b50@,00x $ & (*9 r100g25b50@*00x" $ &(:r0g25b750@,00x $ & (*; r25g25b75@@,00x $ & (*< r50g25b75@,00x $ & (*= r75g25b75@8000v r* Zp\st(zp~p~8~888x000000p0  E =B_Revenue_YTD_Activity 0D 0\   \  D</va* Zp\no(rpvpv8v8x8z8|~x000000p0  /*?B_Revenue_Balancety0r    r  DD>/[0* Zp\op(vpzpz@z8~88x000000p0  acAB_Personnel_Budgety00  r  @/ex* Zp\uv(zp~p~@~888x000000p0  iCB_Personnel_YTD_Activity00    B/fi* Zp\pq(rpvpv@v8z8|8~x000000p0  o EB_Personnel_Balance0     D/(f* Zp\op(vpzpz@z8~88x000000p0  * GB_Operating_Budget00    F/es* Zp\uv(zp~p~@~888x000000p0  mpIB_Operating_Encumbrances00    DH/><* Zp\uv(zp~p~@~888x000000p0  n"KB_Operating_YTD_Activity00    DJ/d>* Zp\pq(rpvpv@v8z8|8~x000000p0  rdMB_Operating_Balance0*   *  DDL//B* Zp\ np(vpzpz8z0|8~8x000000p0orWB_Revenue_Budget1d00DF*DFDr* Zp\ np(vpzpz@z0~88x000000p0XB_Revenue_Budget2d00FN*NDc* Zp\ np(vpzpz@z0~88x000000p0deYB_Revenue_Budget3d 00F`*`D3   R   i   t   e        |   &R  ID     5jSF  7jo&  9jmb  ;jP_  =jSE  ?jN_  Aj   Cjfs  EjOD  Gjsr  Ij't  Kjtu  Mj@   W   X   YFormatTrigger return boolean is begin srw.set_hyperlink (:P_ACTION || 'SERVER=' || :P_SERVERNAME || '&REPORT=FGJDDOR.rep&USERID=' || :P_USER_CONNECT || 'DESTYPE=cache&DESFORMAT=HTML&PARAMFORM=no&ONEUPNO=' || to_number(:oneupno) || '&P_USER_CONNECT=' || :P_USER_CONNECT || '&ORGN_CODE=' || :orgn_code || '&FSYR_CODE=' || :fsyr_code || '&COAS_CODE=' || :coas_code); srw.set_hyperlink_attrs('target=_blank'); return (TRUE); end; 0800 1Np*>FNW(Z ^bp(z~((((5gSQL*ReportWriterKgREPORTEKU5FGJDDMGtr FULKERSONJONxh  4.tEKUxi !$v,00x $ & (*8 r88g25b50@,00x $ & (*9 r100g25b50@*00x" $ &(:r0g25b750@,00x $ & (*; r25g25b75@@,00x $ & (*< r50g25b75@,00x $ & (*= r75g25b75@8000v