Standard Jet DBnb` Ugr@?~1y0̝cßFNa7`ޜ(.,`i{6߱JnC53 y[/|*$|?yf_Љ$g'DeFx -bT4.0dv YES EE Y   Y Y  Y Y  Y  Y  Y   Y  Y  Y  Y  Y 2SY  Y   Y  Y ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeYYIdParentIdName        OYSDY Y Y  Y 2ACMFInheritableObjectIdSID  AtYObjectId YSY  Y Y Y  Y  Y Y  Y FAttributeExpressionFlagLvExtra Name1 Name2ObjectId Ordernzf edY"ObjectIdAttribute -YSY Y Y  Y  Y  Y  Y F Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship   YYYszObject$szReferencedObjectszRelationshipYv1b N  : k & W  C t/ @*%P% ^ @@@@ @@@@@   @  @@@@@ Ji68D@oULJOdL[QMmMdOQk+YbmQiJUQbMviMfmkYb`JfkYbmQiJUQbMviMfmkiQOoMYbUQufQbOYmoiQkfq>:i66`JfkQufQbOYmoiQkLv`JfkdL[QMmMdOQ`JfkQufQbOYmoiQkLvkfQMYSYMdL[QMmMdOQ`JfkiQqQboQkLv`JfkdL[QMmMdOQ`JfkiQqQboQkLvkfQMYSYMdL[QMmMdOQ`JfkvmOfJvid^^LvJffi`bkMoQufQbOYmoiQkLvkfQMYSYM`JfkdL[QMmMdOQ`bkMoiQqQboQkLvkfQMYSYM`JfkdL[QMmMdOQobfdkmQOLokYbQkkQufQbkQkLvvQJiOJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk 68J`JfkJffiYbhoYiv 68L`JfkiQqQboQLoOUQmko``Jiv 6:`JfkkfQbmLv>OYUYmdL[QMmMdOQ 6<obfdkmQOLokYbQkkQufQbkQ 6>J`JfkiQqQboQkLvkfQMYSYMdL[QMmMdOQ  6>L`JfkQufQbOYmoiQkLvkfQMYSYMdL[QMmMdOQ! 6@J`bkMomiubkLv`JfkMdOQQ8kYOQ" 6@L`bkMomiubkLv`JfkMdOQQ:kYOQ# 6@M`bkMomiubkLv`JfkdL[MdOQ 6BJ`JfkJffidfiYJmYdbmiJbkSQimiJbk 6BL`bkMoJffidfiYJmYdbmiubk+kh+i`JfkQufQbOYmoiQkLv`JfkdL[QMmMdOQJJiQJO`QSYikmJJiQJO`QkQMdbOMdkm+MQbmQiQ`f^+fJvmUQbQiYM+miub+hivU^+JMMm YbmQiJUQbMviMfmk YbmQiJUQbMviMfmkiQOoMYbUQufQbOYmoiQkfq>:i66 `JfkvmOfJvid^^LvJffi `JfkvmOfJvid^^LvJffiOQmJY^k `kvkJMMQkkdL[QMmk`kvkJMMQkku`^`kvkJMQk`kvkY`QuMd^o`bk`kvkY`QukfQMk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkdL[QMm+MdOQdM+ko``JivhsWJf+JffidfiYJmYdbhsWJf+JffidfiYJmYdb+diUbhsWJf+LJ^+kWQQm+miJbk+WYkmhsWJf+LoOUQm+miJbkhsWJf+MJkW+OJY^v+LJ^JbMQhsWJf+QufQbOYmoiQkfhsWJf+QufQbkQ+LoOUQmfhsWJf+^Li+OkmLmbfhsWJf+iQqQboQfhsWJf+iQqQboQ+LoOUQmfmiubfomS+OQmJY^fomS+QqQbmfJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO  @ @ @ @ @ @ @ @            !"# ! " # $ "(+ 2GfINRUX\^`bdgfiflfnfpfyff @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @    $% & ' ( ) * + , - . / 0 1 2 3 456789:;<=>?@ABCDEFGHIJKLMNOP      ' ( )!-!.!/"0"1"2#3#4#5$6$7$8ABC      "!"""#($(%(&+*+++,292:2;2<G'G(G)I=I>I?I@NDNNRRRUUUXXX\\\^^^```bbb d!d"d#g$g%g&i*i+i,l-l.l/n0n1n2p3p4p5y6y7y89:;  !"# 1"!5.          !"#$%&'()* + , - . / 0 1 2 3 4 5789:;<=>?@A B C D E F G            6           !"#$%&'( )*+-./0123456789:; < = > ? @ABCD         ,    ! " #$%&'()*+,-./0 12 3 4 56        "$d _ Z g  ~K S C )~t40C!xZ1ed @b8PG@@#05b - Mnscu trxns by MAPS code - E2 siden-@@tttttttr @vZ@:G@P#05a - Mnscu trxns by MAPS code - E1 siden-@@tttttttr @q@m=@#04b - MAPS Expenditures by Specific Object Coden-@|@ @rNr@G@#04a - MAPS Revenues by Specific Object Coden-j@|@zzzzzzzx @ fDOq@7ǡG@#02 - MAPS spent by 4 digit Object Coden-@|@||pppppppn @(@N8G@#01b - Maps Revenue Budget summaryn-@|@~rrfffffffd @V@86oG@#01a - MAPS Appr Inquiryn-@|@j^^RRRRRRRP @70@p@UNPOSTED BUSINESS EXPENSES BY YEARn-ffffffffffd hA&s@p@MnSCU Revenues by Specific MAPS Object Coden-xxxxxxxxxxv Y,@p@MnSCU Expenditures by Specific MAPS Object Coden-~ $@p@MAPS YTD PAYROLL BY APPRn-RRRRRRRRRRP &)r@p@MAPS Revenues by Specific Object Coden-llllllllllj ÑACS@p@MAPS Revenues by MAPS Object Coden-ddddddddddb  s@p@MAPS Expenditures by Specific Object Coden-ttttttttttr  WL@p@MAPS Expenditures by MAPS Object Coden-llllllllllj  )d@p@Interagency Rcpts Reducing Expenditures PV4 2R00n-  <^@p@Interagency Rcpts in MAPSn-TTTTTTTTTTR  @p@AR0175UG - Bad Object Codesn-XXXXXXXXXXV  x@ x@UserDefinedn-88888888886  x@ x@SummaryInfon-@DDD88888886 @ f=x@=x@SysReln-.........., =x@=x@Scriptsn-0000000000. =x@=x@Reportsn-0000000000. =x@=x@Modulesn-0000000000. x@x@Formsn-,,,,,,,,,,* p@p@DataAccessPagesn-@@@@@@@@@@> /x@/x@MSysRelationshipso/DDDDDDDDDDB /x@/x@MSysQuerieso/88888888886 /x@/x@MSysACEso/22222222220 /x@/x@MSysObjectso/88888888886 /x@p@MSysDbn-"@:::......., @/x@/x@Relationshipso/<<<<<<<<<<: /x@/x@Databaseso/44444444442 /x@/x@Tableso/.........., HDmC O  e ;  } 5 y .  b HKs-L"e5zA@r7 EMPL_PAYT.APPRO_NBR2 g EMPL_PAYT.FISCAL_YEAR4 g EMPL_PAYT.RC_ID. g EMPL_PAYT.SERIAL_NBR3 g FICAVal([FICA_AMT])6 o ExpenseVal([SALARY_AMT])> oEMPL_PAYT.GFS_OBJECT_CODE8 gEMPL_PAYT.POST_DATE2 gEMPL_PAYT.POST_FLAG2 gEMPL_PAYT.PAY_DATE1 gEMPL_PAYT.SSN, gEMPL_PAYT.APPRO_NBR2 gEMPL_PAYT.FISCAL_YEAR4 gEMPL_PAYT.RC_ID. gEMPL_PAYT###  G G  G QWHAP_EXPENDITURES.OBJ_CD8 ' D@ ' QWHAP_EXPENDITURES.FISCAL_YR; ' @ ' QWHAP_EXPENDITURES.OBJ_CD8 g D@  g QWHAP_EXPENDITURES.FUND_CD9 g QWHAP_EXPENDITURES.ORGN_NBR: g QWHAP_EXPENDITURES.AGENCY_NBR< g QWHAP_EXPENDITURES.FISCAL_YR; gQWHAP_EXPENDITURES.OBJ_CD8 gSumOfEXPDTR_AMTD@ ;// oD@  gQWHAP_EXPENDITURES.FUND_CD9 gQWHAP_EXPENDITURES.ORGN_NBR: gQWHAP_EXPENDITURES.AGENCY_NBR< gQWHAP_EXPENDITURES.FISCAL_YR; gQWHAP_EXPENDITURES555  G G  G@  'F@  g!QWHAP_REVENUE_BUDGET.REV_SRC_CD> gH@ gQWHAP_REVENUE_BUDGET.FUND_CD; g QWHAP_REVENUE_BUDGET.FISCAL_YR= gQWHAP_REVENUE_BUDGET.RPTG_DT; gQWHAP_REVENUE_BUDGET999  G G  G") \@ ') "QWHAP_APPROPRIATION.EXPENDED_AMT? g) F@ g) D@ g) QWHAP_APPROPRIATION.CANCEL_AMT= g) "QWHAP_APPROPRIATION.REVERTED_AMT? g) F@ g) H@ g) L@ g) F@ g) F@ g) QWHAP_APPROPRIATION.FUND_CD: g) QWHAP_APPROPRIATION.FISCAL_YR< g) QWHAP_APPROPRIATION.RPTG_DT: g") QWHAP_APPROPRIATION777 )  G)  G")  )  GLVALt(V l & > TQWHAP_EXPENDITURES.TRANS_AGENCY_NBRQWHAP_EXPENDITURES.TRANS_LINE_NBRQWHAP_EXPENDITURES.ACCTG_TRANS_CDQWHAP_EXPENDITURES.APPROP_UNIT_NBR(((QWHAP_REVENUE.FISCAL_YR)=2007) AND ((QWHAP_REVENUE.APPROP_UNIT_NBR)="GEN") AND ((QWHAP_REVENUE.REV_SRCE_CD)="9830") AND ((QWHAP_REVENUE.APPROP_ORGN_NBR)="0305") AND ((QWHAP_REVENUE.AGENCY_NBR)="E26"))(((EMPL_PAYT.RC_ID)=[Enter RCID]) AND ((EMPL_PAYT.FISCAL_YEAR)=[Enter Fiscal Year]) AND ((EMPL_PAYT.APPRO_NBR)=[Enter Appropriation - ie GEN]) AND ((EMPL_PAYT.POST_FLAG) Is Null) AND ((EMPL_PAYT.GFS_OBJECT_CODE) Not In ("0000","7C00")) AND ((EMPL_PAYT.SERIAL_NBR)=0))QWHAP_EXPENDITURES.APPROP_UNIT_NBR(((QWHAP_EXPENDITURES.FISCAL_YR)=[Enter FY]) AND ((QWHAP_EXPENDITURES.AGENCY_NBR)="E26") AND ((QWHAP_EXPENDITURES.ORGN_NBR)=[Enter Org #]) AND ((QWHAP_EXPENDITURES.APPROP_UNIT_NBR)=[Enter Appr # (GEN, SGR, etc)]))QWHAP_EXPENDITURES.APPROP_UNIT_NBRSum(QWHAP_EXPENDITURES.EXPDTR_AMT)QWHAP_EXPENDITURES.APPROP_UNIT_NBR(((QWHAP_REVENUE_BUDGET.FISCAL_YR)=2007 Or (QWHAP_REVENUE_BUDGET.FISCAL_YR)=2008) AND ((QWHAP_REVENUE_BUDGET.APPROP_UNIT_NBR)=[Enter Appr # (GEN, SGR, etc)]) AND ((QWHAP_REVENUE_BUDGET.RPTG_MO_NBR)=[Enter Reporting month #(2008XX)]) AND ((QWHAP_REVENUE_BUDGET.AGENCY_NBR)="E26") AND ((QWHAP_REVENUE_BUDGET.APPROP_ORGN_NBR)=[Enter Org #]))QWHAP_REVENUE_BUDGET.RECOGNIZED_AMTQWHAP_REVENUE_BUDGET.APPROP_UNIT_NBR(((QWHAP_APPROPRIATION.FISCAL_YR)=2006 Or (QWHAP_APPROPRIATION.FISCAL_YR)=2007 Or (QWHAP_APPROPRIATION.FISCAL_YR)=2008) AND ((QWHAP_APPROPRIATION.RPTG_MO_NBR)=[Enter reporting month # (2008XX)]) AND ((QWHAP_APPROPRIATION.AGENCY_NBR)="E26") AND ((QWHAP_APPROPRIATION.ORGN_NBR)=[Enter four digit Org #]))QWHAP_APPROPRIATION.TRANSFER_IN_AMTQWHAP_APPROPRIATION.BAL_FWD_IN_AMTQWHAP_APPROPRIATION.BAL_FWD_OUT_AMTQWHAP_APPROPRIATION.TRANSFER_OUT_AMTQWHAP_APPROPRIATION.APPROP_CUR_MOD_AMTQWHAP_APPROPRIATION.ACTUAL_RCPT_AMTQWHAP_APPROPRIATION.APPROP_UNIT_NBR>EJ N l 4 c  H t 1  a C %  }SP&kM' {GP ERQGL_ACCT.APPRO_NBR0 gUTF_DETAIL.E2_SIGN1 gUTF_DETAIL.E2_ACCT_NBR5 gUTF_DETAIL.E2_OBJECT_CODE8 g UTF_DETAIL.E2_FY/ g UTF_DETAIL.E1_SIGN1 g UTF_DETAIL.E1_ACCT_NBR5 g UTF_DETAIL.E1_OBJECT_CODE8 g UTF_DETAIL.E1_FY/ gAMTX@# oUTF_DETAIL.LINE_ITEM_NBR7 gUTF_EVENT.RECEIPT_FLAG5 gUTF_DETAIL.SERIAL_NBR4 gUTF_EVENT.TRAN_TYPE_CODE7 gUTF_EVENT.OCCURANCE_DATE7 gUTF_EVENT.PROC_TIMESTAMP7 gUTF_EVENT.RC_ID. gOBJECT_CODE''' COST_CENTER''' GL_ACCT UTF_DETAIL%%% UTF_EVENT###  Gtrxn O  G@ ' QWHAP_EXPENDITURES.EXPDTR_AMT< gF@ gB@ gQWHAP_EXPENDITURES.TRANS_NBR; gB@ g"QWHAP_EXPENDITURES.ACCEPTANCE_DT? gQWHAP_EXPENDITURES.OBJ_CD8 gD@ gQWHAP_EXPENDITURES.FISCAL_YR; gQWHAP_EXPENDITURES555  G G  G QWHAP_REVENUE.ACCEPTANCE_DT: '@ ' QWHAP_REVENUE.FUND_CD4 g QWHAP_REVENUE.LINE_DESC6 g Expr1[REV_AMT]*-15 o QWHAP_REVENUE.TRANS_AGENCY_NBR= gQWHAP_REVENUE.TRANS_LINE_NBR; gQWHAP_REVENUE.TRANS_NBR6 gQWHAP_REVENUE.ACCTG_TRANS_CD; gQWHAP_REVENUE.ACCEPTANCE_DT: gQWHAP_REVENUE.APPROP_ORGN_NBR< gQWHAP_REVENUE.REV_SRCE_CD8 gQWHAP_REVENUE.APPROP_UNIT_NBR< gQWHAP_REVENUE.FISCAL_YR6 gQWHAP_REVENUE+++  G G  G @ ' EMPL_PAYT.SERIAL_NBR3 g Val([FICA_AMT]). g Val([SALARY_AMT])0 g EMPL_PAYT.GFS_OBJECT_CODE8 g EMPL_PAYT.POST_DATE2 g EMPL_PAYT.POST_FLAG2 g EMPL_PAYT.PAY_DATE1 g EMPL_PAYT.SSN, gLVAL!P ^  f $ z 8 * z Rh"Zl*h(((QWHAP_BUDGET_TRANS.FISCAL_YR)=[Enter FY]) AND ((QWHAP_BUDGET_TRANS.APPROP_UNIT_NBR)=[Enter Appr #]) AND ((QWHAP_BUDGET_TRANS.ACCTG_TRANS_CD)="TA") AND ((QWHAP_BUDGET_TRANS.TRANS_NBR)<"N") AND ((QWHAP_BUDGET_TRANS.AGENCY_NBR)="E26") AND ((QWHAP_BUDGET_TRANS.ORGN_NBR)=[Enter Org #]))QWHAP_BUDGET_TRANS.TRANS_AGENCY_NBRQWHAP_BUDGET_TRANS.TRANS_LINE_NBRQWHAP_BUDGET_TRANS.ACCTG_TRANS_CDQWHAP_BUDGET_TRANS.APPROP_UNIT_NBR(((QWHAP_BUDGET_TRANS.BAL_SHEET_ACCT_NBR)="ZZ99"))QWHAP_BUDGET_TRANS.TRANS_AGENCY_NBRQWHAP_BUDGET_TRANS.TRANS_LINE_NBRQWHAP_BUDGET_TRANS.ACCTG_TRANS_CDQWHAP_BUDGET_TRANS.APPROP_UNIT_NBR(((UTF_EVENT.RC_ID)="0305") AND ((UTF_EVENT.TRAN_TYPE_CODE)<>"EN" And (UTF_EVENT.TRAN_TYPE_CODE)<>"CB" And (UTF_EVENT.TRAN_TYPE_CODE)<>"EF") AND ((UTF_DETAIL.E2_FY)="2008") AND ((GL_ACCT.APPRO_NBR)="GEN") AND ((OBJECT_CODE.GFS_OBJECT_CODE)="8860"))COST_CENTER.CC_NBR = UTF_DETAIL.E2_ACCT_NBRCOST_CENTER.FY = UTF_DETAIL.E2_FYOBJECT_CODE.FY = UTF_DETAIL.E2_FYOBJECT_CODE.OBJECT_CODE = UTF_DETAIL.E2_OBJECT_CODECOST_CENTER.RC_ID = GL_ACCT.RC_IDUTF_EVENT.RC_ID = UTF_DETAIL.RC_IDUTF_DETAIL.RC_ID = COST_CENTER.RC_IDCOST_CENTER.GL_ACCT_NBR = GL_ACCT.GL_ACCT_NBRUTF_EVENT.SERIAL_NBR = UTF_DETAIL.SERIAL_NBRVal(IIf([E2_SIGN]="D",[AMOUNT]*-1,[AMOUNT]))(((UTF_EVENT.RC_ID)="0303") AND ((UTF_DETAIL.E1_FY)="2008") AND ((GL_ACCT.APPRO_NBR)="GEN") AND ((OBJECT_CODE.GFS_OBJECT_CODE)="2000"))COST_CENTER.RC_ID = GL_ACCT.RC_IDUTF_EVENT.RC_ID = UTF_DETAIL.RC_IDUTF_DETAIL.E1_OBJECT_CODE = OBJECT_CODE.OBJECT_CODEUTF_DETAIL.E1_FY = OBJECT_CODE.FYUTF_DETAIL.RC_ID = COST_CENTER.RC_IDCOST_CENTER.GL_ACCT_NBR = GL_ACCT.GL_ACCT_NBRUTF_DETAIL.E1_ACCT_NBR = COST_CENTER.CC_NBRUTF_DETAIL.E1_FY = COST_CENTER.FYUTF_EVENT.SERIAL_NBR = UTF_DETAIL.SERIAL_NBRVal(IIf([E1_SIGN]="D",[AMOUNT]*-1,[AMOUNT]))(((QWHAP_EXPENDITURES.FISCAL_YR)=2007) AND ((QWHAP_EXPENDITURES.APPROP_UNIT_NBR)="GEN") AND ((QWHAP_EXPENDITURES.OBJ_CD)="2S10") AND ((QWHAP_EXPENDITURES.AGENCY_NBR)="E26") AND ((QWHAP_EXPENDITURES.ORGN_NBR)="0000")) 7is w ' k ' b 2 l ' g  X~y3z.z*8Bp, G UTF_DETAIL.E1_OBJECT_CODE8 ' UTF_EVENT.TRAN_TYPE_CODE7 ' UTF_EVENT.PROC_TIMESTAMP7 '@ ' COST_CENTERUTF_DETAILV@G;' COST_CENTERUTF_DETAILB@G;' OBJECT_CODEUTF_DETAILB@G;' OBJECT_CODEUTF_DETAILf@G;' COST_CENTERGL_ACCTB@A5' UTF_EVENTUTF_DETAILD@C7# UTF_DETAILCOST_CENTERH@G;% COST_CENTERGL_ACCTZ@A5' UTF_EVENTUTF_DETAILX@ C7# GFS_OBJECT_CODEOBJECT_CODE.GFS_OBJECT_CODEX/ wAPPRO_NBRGL_ACCT.APPRO_NBRB# wE2_SIGNUTF_DETAIL.E2_SIGN? wE2_ACCT_NBRUTF_DETAIL.E2_ACCT_NBRK' wE2_OBJECT_CODEUTF_DETAIL.E2_OBJECT_CODET- w E2_FYUTF_DETAIL.E2_FY9 w E1_SIGNUTF_DETAIL.E1_SIGN? w E1_ACCT_NBRUTF_DETAIL.E1_ACCT_NBRK' w E1_OBJECT_CODEUTF_DETAIL.E1_OBJECT_CODET- w E1_FYUTF_DETAIL.E1_FY9 wAMTAMTX@ ) LINE_ITEM_NBRUTF_DETAIL.LINE_ITEM_NBRQ+ wRECEIPT_FLAGUTF_EVENT.RECEIPT_FLAGM) wSERIAL_NBRUTF_DETAIL.SERIAL_NBRH% wTRAN_TYPE_CODEUTF_EVENT.TRAN_TYPE_CODES- wOCCURANCE_DATEUTF_EVENT.OCCURANCE_DATES- wPROC_TIMESTAMPUTF_EVENT.PROC_TIMESTAMPS- wRC_IDUTF_EVENT.RC_ID8 wOBJECT_CODE''' COST_CENTER''' GL_ACCT UTF_DETAIL%%% UTF_EVENT###  Gtrxn O  G UTF_DETAIL.E1_OBJECT_CODE8 ' UTF_EVENT.TRAN_TYPE_CODE7 ' UTF_EVENT.PROC_TIMESTAMP7 '@  ' COST_CENTERGL_ACCTB@ A5' UTF_EVENTUTF_DETAILD@ C7# UTF_DETAILOBJECT_CODEf@G;% UTF_DETAILOBJECT_CODEB@G;% UTF_DETAILCOST_CENTERH@G;% COST_CENTERGL_ACCTZ@A5' UTF_DETAILCOST_CENTERV@G;% UTF_DETAILCOST_CENTERB@G;% UTF_EVENTUTF_DETAILX@C7# OBJECT_CODE.GFS_OBJECT_CODE: gc%R ~ Q MJ  Mh]h;*&A"AfbsyuG@syuG@QWHAP_BUDGET_TRANSF@&QWHAP.BUDGET_TRANS''4|a."qqqq"@'tPDDDf f`>=@U=@QWHAP_BAL_SHEET_TRANS_HISTn-F@&QWHAP.BAL_SHEET_TRANS_HIST''4|a."qqqq"@' @bVVT ^^S=@2=@QWHAP_APPROPRIATION_ORGNn-F@&QWHAP.APPROPRIATION_ORGN''4|a."qqqq"$  @^RRP ^\|=@Y=@QWHAP_APPROPRIATIONn-F@&QWHAP.APPROPRIATION''4|a."qqqq"z@' @zTHHF ^X >8@~0>8@OC_SUMMARYn-6@&ISRS.OC_SUMMARY[@24Ja."qqqq"0       ?@`B664 ^U5]8@}8@OBJECT_CODEn-6@&ISRSVAL.OBJECT_CODE_!4Ja."qqqq"N@'@jD886 ^R@@MSysIMEXSpecsn-<<<<<<<<<<: N M@@MSysIMEXColumnsn-@@@@@@@@@@> IDOq@DOq@MSysAccessXMLn-4MR2KeepLocal  T|||<<<<<<<: @2(uG@BuG@MSysAccessObjectsn-DDDDDDDDDDB $kj@:㯲=@MAPS YTD PAYROLL BY APPR - detailn-@|@|ppdddddddb @#$5@=@MAPS YTD PAYROLL BY APPRn-@|@j^^RRRRRRRP @"S|@[a=@Interagency Rcpts Reducing Expenditures PV4 2R00n-N@|@ @!_\@:4=@Interagency Rcptsn-'@|@\PPDDDDDDDB @ f oESC@oG@generic_trxn_qryn-@@ZNNBBBBBBB@ @(=@ ]=@EMPL_PAYTn-4@&ISRS.EMPL_PAYTЛl_4|a."qqqq"@'=@\@442 ^")68@8@COST_CENTERn-6@&ISRS.COST_CENTERx04|a."qqqq"@' @dD886 ^ @6@%/@~sq_rMAPS Expenditures by MAPS Object Coden-4MR2KeepLocal Tvvvvvvvt @Wn@4lG@#06b - MnSCU Appropriation trxnsn-0@@znnbbbbbbb` @L$ς@_G@#06a - MAPS Appropriation Transfer Transn-r@|@~~rrrrrrrp @9v#@wv#@#05c - MnSCU trxns by MAPS obj coden-@|@tthhhhhhhf @EN0L f  :  X p F m & xZ< zF ?xH J I 7AUTF_DETAILOBJECT_CODEB@G;% UTF_DETAILCOST_CENTERH@G;% COST_CENTERGL_ACCTZ@A5' UTF_DETAILCOST_CENTERV@G;% UTF_DETAILCOST_CENTERB@G;% UTF_EVENTUTF_DETAILX@C7# OBJECT_CODE.GFS_OBJECT_CODE: gGL_ACCT.APPRO_NBR0 gUTF_DETAIL.E2_SIGN1 gUTF_DETAIL.E2_ACCT_NBR5 gUTF_DETAIL.E2_OBJECT_CODE8 gUTF_DETAIL.E2_FY/ g UTF_DETAIL.E1_SIGN1 g UTF_DETAIL.E1_ACCT_NBR5 g UTF_DETAIL.E1_OBJECT_CODE8 g UTF_DETAIL.E1_FY/ g UTF_EVENT.RC_ID. gAMTX@# oUTF_DETAIL.LINE_ITEM_NBR7 gUTF_EVENT.RECEIPT_FLAG5 gUTF_DETAIL.SERIAL_NBR4 gUTF_EVENT.TRAN_TYPE_CODE7 gUTF_EVENT.OCCURANCE_DATE7 gUTF_EVENT.PROC_TIMESTAMP7 gUTF_EVENT.RC_ID. gOBJECT_CODE''' COST_CENTER''' GL_ACCT UTF_DETAIL%%% UTF_EVENT###  G G  G QWHAP_BUDGET_TRANS.TRANS_NBR; ' :@  ' QWHAP_BUDGET_TRANS.ORGN_NBR: g QWHAP_BUDGET_TRANS.AGENCY_NBR< g QWHAP_BUDGET_TRANS.LINE_DESC; g QWHAP_BUDGET_TRANS.TRANS_AMT; g F@ g B@ g QWHAP_BUDGET_TRANS.TRANS_NBR; g B@ g "QWHAP_BUDGET_TRANS.ACCEPTANCE_DT? g D@ g QWHAP_BUDGET_TRANS.FUND_CD9 g QWHAP_BUDGET_TRANS.FISCAL_YR; gd@ ' QWHAP_BUDGET_TRANS.LINE_DESC; g QWHAP_BUDGET_TRANS.TRANS_AMT; gF@ gB@ gQWHAP_BUDGET_TRANS.TRANS_NBR; gB@ g"QWHAP_BUDGET_TRANS.ACCEPTANCE_DT? gD@ gQWHAP_BUDGET_TRANS.FUND_CD9 gQWHAP_BUDGET_TRANS.FISCAL_YR; gQWHAP_BUDGET_TRANS555  G G  Gtrxn.*% gtrxn  G G  @ @ @ @ @ @ @ @ @ @ @ @ @ @          !"#$%&'()* + , - . / 0 1 2 3 4 5789:;<=>?@A B C D E F G            6           !"#$%&'( )*+-./0123456789:; < = > ? @ABCD         ,    ! " #$%&'()*+,-./0 12 3 4 56     . @ @ @ @ @ @ @ @ @ @ @ @ @ @#$%&'( )*+-./0123456789:; < = > ? @ABCD         ,    ! " #$%&'()*+,-./0 12 3 4 56                         ! "#%&'()*+,-./0123 4 5 6 7 89:;<=>?@ABCD    $                             ! " # $ % & ' ( )  !*!,!-!.!/!0!1!2!3!4!+PLVALP^ n , N  t2Z(((QWHAP_LBR_DSTBTN.AGENCY_NBR)="E26") AND ((QWHAP_LBR_DSTBTN.FISCAL_YR)=2006) AND ((QWHAP_LBR_DSTBTN.EMPL_NBR)="00579813"))(((QWHAP_LBR_DSTBTN.AGENCY_NBR)="E26") AND ((QWHAP_LBR_DSTBTN.FISCAL_YR)=2005) AND ((QWHAP_LBR_DSTBTN.APPROP_ORGN_NBR)="0156"))(((QWHAP_LBR_DSTBTN.OBJ_CD)<"1F00") AND ((QWHAP_LBR_DSTBTN.ERNG_TYPE_CD)<>"C15" And (QWHAP_LBR_DSTBTN.ERNG_TYPE_CD)<>"CE1"))Sum(QWHAP_LBR_DSTBTN.EMPLR_INS_AMT)Sum(QWHAP_LBR_DSTBTN.EMPLR_FICA_AMT)Sum(QWHAP_LBR_DSTBTN.EMPLR_RTRMT_AMT)QWHAP_EXPENDITURES.APPROP_UNIT_NBR(((QWHAP_EXPENDITURES.FISCAL_YR)=2006) AND ((QWHAP_EXPENDITURES.AGENCY_NBR)="E26") AND ((QWHAP_EXPENDITURES.ORGN_NBR)="0203") AND ((QWHAP_EXPENDITURES.OBJ_CD)="2R00"))QWHAP_EXPENDITURES.TRANS_AGENCY_NBRQWHAP_EXPENDITURES.ACCTG_TRANS_CDQWHAP_EXPENDITURES.APPROP_UNIT_NBR(((QWHAP_REVENUE.FISCAL_YR)=[FY ie 2000:]) AND ((QWHAP_REVENUE.AGENCY_NBR)="E26") AND ((QWHAP_REVENUE.ORGN_NBR)=[Enter your ORG:]) AND ((QWHAP_REVENUE.ACCTG_TRANS_CD)="PV"))(((UTF_DETAIL.E1_FY)>"2005") AND ((UTF_DETAIL.E1_OBJECT_CODE)="0831"))UTF_DETAIL.E2_ACCT_NBR = GL_ACCT.GL_ACCT_NBRUTF_EVENT.SERIAL_NBR = UTF_DETAIL.SERIAL_NBRUTF_EVENT.RC_ID = UTF_DETAIL.RC_ID(((UTF_EVENT.RC_ID)=[Enter RCID code]) AND ((UTF_EVENT.TRAN_TYPE_CODE)<>"EN" And (UTF_EVENT.TRAN_TYPE_CODE)<>"CB" And (UTF_EVENT.TRAN_TYPE_CODE)<>"EF") AND ((UTF_DETAIL.E1_FY)=[Enter FY]) AND ((UTF_DETAIL.E1_OBJECT_CODE)="9000" Or (UTF_DETAIL.E1_OBJECT_CODE)="9004") AND ((GL_ACCT.APPRO_NBR)="GEN"))UTF_EVENT.RC_ID = UTF_DETAIL.RC_IDCOST_CENTER.RC_ID = GL_ACCT.RC_IDUTF_DETAIL.E1_OBJECT_CODE = OBJECT_CODE.OBJECT_CODEUTF_DETAIL.E1_FY = OBJECT_CODE.FYUTF_DETAIL.RC_ID = COST_CENTER.RC_IDCOST_CENTER.GL_ACCT_NBR = GL_ACCT.GL_ACCT_NBRUTF_DETAIL.E1_ACCT_NBR = COST_CENTER.CC_NBRUTF_DETAIL.E1_FY = COST_CENTER.FYUTF_EVENT.SERIAL_NBR = UTF_DETAIL.SERIAL_NBRVal(IIf([E1_SIGN]="D",[AMOUNT]*-1,[AMOUNT]))@@^\ U 7  { O  K  G  F  D;}1WMu4j"Q! QWHAP_REVENUE.FUND_CD4 g! QWHAP_REVENUE.ORGN_NBR5 g! QWHAP_REVENUE.AGENCY_NBR7 g! QWHAP_REVENUE.FISCAL_YR6 g! QWHAP_REVENUE.TRANS_AGENCY_NBR= g! QWHAP_REVENUE.TRANS_LINE_NBR; g! QWHAP_REVENUE.TRANS_NBR6 g! QWHAP_REVENUE.REV_SRCE_CD8 g! Expr1[REV_AMT]*-15 o!QWHAP_REVENUE.REV_AMT4 g!QWHAP_REVENUE.ACCTG_TRANS_CD; g!QWHAP_REVENUE.ACCEPTANCE_DT: g!QWHAP_REVENUE.APPROP_UNIT_NBR< g!QWHAP_REVENUE.FUND_CD4 g!QWHAP_REVENUE.ORGN_NBR5 g!QWHAP_REVENUE.AGENCY_NBR7 g!QWHAP_REVENUE.FISCAL_YR6 g!QWHAP_REVENUE+++ ! G! G! ! G @ ' UTF_DETAILGL_ACCTX@ ?3%  UTF_DETAILGL_ACCT"UTF_DETAIL.RC_ID = GL_ACCT.RC_IDa3%  UTF_EVENTUTF_DETAILX@ C7#  UTF_EVENTUTF_DETAILD@ C7#  GL_ACCT.APPRO_NBR0 g UTF_EVENT.TRAN_DESC2 g UTF_EVENT.USER_ID0 g UTF_DETAIL.AMOUNT0 g UTF_DETAIL.E2_SIGN1 g UTF_DETAIL.E2_OBJECT_CODE8 g  UTF_DETAIL.E2_ACCT_NBR5 g  UTF_DETAIL.E2_FY/ g  UTF_DETAIL.E1_SIGN1 g  UTF_DETAIL.E1_OBJECT_CODE8 g  UTF_DETAIL.E1_ACCT_NBR5 g UTF_DETAIL.E1_FY/ g UTF_DETAIL.LINE_ITEM_NBR7 g UTF_EVENT.SERIAL_NBR3 g UTF_EVENT.TRAN_TYPE_CODE7 g UTF_EVENT.PROC_TIMESTAMP7 g UTF_EVENT.OCCURANCE_DATE7 g UTF_EVENT.CUSTOMER_ID4 g UTF_EVENT.RC_ID. g GL_ACCT  UTF_DETAIL%%%  UTF_EVENT###   G  G    GMAPS Expenditures by MAPS Object Code[[[   G  G UTF_DETAIL.E1_OBJECT_CODE8 ' UTF_EVENT.TRAN_TYPE_CODE7 ' UTF_EVENT.PROC_TIMESTAMP7 'V@  ' UTF_EVENTUTF_DETAILD@ C7# COST_CENTERGL_ACCTB@A5' UTF_DETAILOBJECT_CODEf@G;% ||Yx6N Y Query Notesv1 LVAL]_  N }  n RDprocessed on any given day will be included on the EAP2 Inqprocessed on any given day will be included on the EAP2 Inquiry screen, but not the IA Warehouse until the next morning.8) FINAL NOTE: Documents in rejected status in MAPS have not posted and will not be found with these queries. MAPS rejected documents updated ord) Click the OK button. h) Click on Close.c) Select the tables to be connected. g) You should get a message that all tables have been successfully linked.b) Click in the box Always prompt for new location. f) Select your database, click OK. It will prompt you to sign in.a) Click on Tools then Linked Table Manager. e) Click on the Machine Data Source tab.7. LINKING TO YOUR REPLICATED DATA:b) Security for the state IA Warehouse d) Your Computer set up with links to your Replicated Database and the IA warehousea) Security for your Replicated Database c) Security for MAPS (query only at least)From/Payable To Other Funds is available on the AC0581CP report in MnSCU.5. ADDITIONAL INFORMATION: You may not need to run any of the Balance Sheet Account queries/reports because the information for DueYou may export or Analyze in Excel either the queries or the reports.most of the queries/reports to input specific information for your institution. In most cases the reports offer some totals by appropriation or object code.4. SPECIAL INSTRUCTIONS: You may run either the query or the report (double clicking on a report also runs the query). The user will be prompted in3. DATA SOURCE: MnSCU REPLICATED DATA and the state IA_WAREHOUSEreconciliation process. The queries should help you isolate variances between MAPS and MnSCU accounting.2. DESCRIPTION: This database is designed as a tool to be used in conjunction with the Excel spreadsheet to assist with the monthly MAPS to MnSCU1. QUERY ID: AC00xx Version 1.0 - MAPS to MnSCU Reconciliation DATE: 1-21-00 Updated: 08/26/2005 |gRI4|gRI4z@@t@@@ |@ %@ @ @ 6. YOU WILL NEED:!K@@G@@@B@k@@@hY\N Y  Field1dv