Standard Jet DBnb` Ugr@?~1y0̝cßFNa7/ޜ(a,`&{6߱nC53Fy[/|*$|u:pf_Љ$g'DeFx -bT4.0dv Y&"""S && Y   Y Y  Y Y  Y  Y  Y   Y u Y o Y n Y z Y 2lY  Y  z Y  pY ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeni"YYIdParentIdName        OYtS%Y Y Y  Y 2ACMFInheritableObjectIdSID  AtYObjectId YSY  Y `Y Y  Y  Y Y  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Order 0qY"ObjectIdAttribute -Y"""SY Y Y  Y  Y  Y " Y " Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship""" """" """" "YYYszObject$szReferencedObjectszRelationshipYv1b N  : k & W  C t/  dd@ @@@ @ @  LJ^JbMQkfJvid^^OQSJo^mMMksOJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk 8`JfkMJkWLJ^JbMQ :`bkMoM^iF886LJ^JbMQk <`bkMoF8HHLJ^JbMQk >fJvid^^OQSJo^mMMLJ^JbMQk @obfdkmQOLokYbQkkQufQbkQ BOQmJY^ `bkMoM^ibvS^JUmiJbkJMmYdbk DOQmJY^ `bkMoU^F8HHmiJbkJMmYdbk FOQmJY^ `JfkM^iQufQbOYmoiQkMM+ko``JivMdkm+MQbmQiQ`f^+fJvmU^+JMMmU^+ko``JivWQL+Ybkm`kvkJMMQkkdL[QMmk `kvkJMMQkku`^!`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkhsWJf+JffidfiYJmYdb9hsWJf+QufQbOYmoiQk9omS+OQmJY^9omS+QqQbm9JMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO  @ @ @ @ @           #&* 2!79:9<9I9  @ @ @ @ @ @ @ @ @ @ @ @ @ @PPPPPPPPP P P P PPPPPPPPPPPPP$P% P& P' P( P) P* P+ P, P- P. P/ P0 P1 P2 P3 P4P5P6P7P8P9P:P;P<P=P>P?P@W WWWW W W WWWWWWPAPBPCPDPEPFPGPHPI PJ PK PL#PM#PN#PO&PP&W&W*W*W*W*W2W2W2W2W 7W7W7W:W:W:W<W<W<WIW IW!IW"PPPP PP PPPP!P"P# @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @                                         !  "  #  $  %  &  '  ( * + , - . / 0 1 2 3 4 5 6 7  8  9  :  ;  <  =  > ) ? A B C D E F                        @     ! " # $ % & ' (  )  *  + ,-/0123456789:; < = > ? @A   .           ! " #%&'()*+,-./ 0 1 2 3 4 5 6 7 8  9  : ; < = > ?$   ! "    "d _ Z g  ~K O IA dF*% 9@22VN@VN@MSys2VN@VN@MSysAccessXML::::::::::: 9*v+VN@VN@MSysAccessObjectsDDDDDDDDDDB &M?9@3AI9@HEB_INSTF@HEB_INST42tX8}?.ssss   @VN>220 ^#-9S/A@NS/A@GL_SUMMARY4@ISRS.GL_SUMMARY4|a."qqqq"*       @R`B664 ^  oR/A@VrS/A@GL_ACCT4@ISRS.GL_ACCT~M4|a."qqqq"6     (   @VT<00. ^PEQ/A@jYnR/A@EMPL_PAYT4@ISRS.EMPL_PAYT̟&`4|a."qqqq"@=@V\@442 ^ Q/A@NdQ/A@COST_CENTER4@ISRS.COST_CENTER_4|a."qqqq"@ @VdD886 ^ Uj@Uj@MSysRelationshipsDDDDDDDDDDB Uj@(o@MSysQueries88888888886 Uj@1@MSysACEs22222222220 Uj@Uj@MSysObjects88888888886 Uj@2ؘP@MSysDb"@R:::......., @Uj@Uj@Relationships<<<<<<<<<<: Uj@Uj@Databases44444444442 Uj@Uj@Tables..........,  GDI d  | ^ @ "  m 0 o - ! _\2\#g%ERTp>  GL_ACCT.RC_ID, g GL_ACCT  COST_CENTER'''  CC_SUMMARY%%%   G  G    G @  ' GL_ACCT.BANK_ACCT_CODE5 g GL_SUMMARY.OBJECT_CODE5 g GL_ACCT.ACCT_NAME0 g GL_SUMMARY.GL_ACCT_NBR5 g GL_ACCT.APPRO_NBR0 g GL_ACCT.RC_ID, g "(((Val([YTD_ACTUAL_AMT]))<>"0"))? ' GL_SUMMARYGL_ACCT"GL_SUMMARY.RC_ID = GL_ACCT.RC_IDa3%  GL_SUMMARYGL_ACCTX@?3%  AmountSum(Val([YTD_ACTUAL_AMT]))E o GL_ACCT.BANK_ACCT_CODE5 g GL_SUMMARY.OBJECT_CODE5 g GL_ACCT.ACCT_NAME0 g GL_SUMMARY.GL_ACCT_NBR5 g GL_ACCT.APPRO_NBR0 g GL_ACCT.RC_ID, g GL_ACCT  GL_SUMMARY%%%   G  G    G @ ' GL_ACCT.BANK_ACCT_CODE5 g GL_SUMMARY.OBJECT_CODE5 g GL_ACCT.ACCT_NAME0 g GL_SUMMARY.GL_ACCT_NBR5 g GL_ACCT.APPRO_NBR0 g GL_ACCT.RC_ID, g  "(((Val([YTD_ACTUAL_AMT]))<>"0"))? ' GL_SUMMARYGL_ACCT"GL_SUMMARY.RC_ID = GL_ACCT.RC_IDa3%  GL_SUMMARYGL_ACCTX@?3%  AmountSum(Val([YTD_ACTUAL_AMT]))E o GL_ACCT.BANK_ACCT_CODE5 g GL_SUMMARY.OBJECT_CODE5 g GL_ACCT.ACCT_NAME0 g GL_SUMMARY.GL_ACCT_NBR5 g GL_ACCT.APPRO_NBR0 g GL_ACCT.RC_ID, g  GL_ACCT   GL_SUMMARY%%%   G  G    G @ ' @ ' QWHAP_APPROPRIATION.FISCAL_YR< g !QWHAP_APPROPRIATION.RPTG_MO_NBR> g F@ g QWHAP_APPROPRIATION.ORGN_NBR; g @ ' QWHAP_APPROPRIATION.FISCAL_YR< g !QWHAP_APPROPRIATION.RPTG_MO_NBR> g Approp Bal@1%% o F@ g QWHAP_APPROPRIATION.ORGN_NBR; g QWHAP_APPROPRIATION777   G  G    GLVAL H  &6HhUTF_DETAIL.E2_ACCT_NBR = GL_ACCT.GL_ACCT_NBRUTF_EVENT.SERIAL_NBR = UTF_DETAIL.SERIAL_NBRVal(IIf([E1_SIGN]="C",[AMOUNT]*-1,[AMOUNT]))(((EMPL_PAYT.RC_ID)="0152") AND ((EMPL_PAYT.APPRO_NBR)="CLR") AND ((EMPL_PAYT.POST_FLAG)<>"Y") AND ((EMPL_PAYT.GFS_OBJECT_CODE) Not In ("0000","7C00")) AND ((EMPL_PAYT.SERIAL_NBR)=0))(((GL_ACCT.RC_ID)="0152") AND ((CC_SUMMARY.FY)>"2004") AND ((GL_ACCT.APPRO_NBR)="CLR") AND ((COST_CENTER.CC_NBR)>"000114" And (COST_CENTER.CC_NBR)<"000140"))(((CC_SUMMARY.OBJECT_CODE)<"0800"))COST_CENTER.RC_ID = GL_ACCT.RC_IDCC_SUMMARY.RC_ID = COST_CENTER.RC_IDCC_SUMMARY.CC_NBR = COST_CENTER.CC_NBRCOST_CENTER.GL_ACCT_NBR = GL_ACCT.GL_ACCT_NBR(((GL_ACCT.RC_ID)="0152") AND ((GL_SUMMARY.OBJECT_CODE)="8199"))GL_SUMMARY.GL_ACCT_NBR = GL_ACCT.GL_ACCT_NBR(((GL_ACCT.RC_ID)="0152") AND ((GL_ACCT.APPRO_NBR)="CLR") AND ((GL_SUMMARY.OBJECT_CODE)="8110"))GL_SUMMARY.GL_ACCT_NBR = GL_ACCT.GL_ACCT_NBRSum([QWHAP_APPROPRIATION]![BAL_FWD_IN_AMT]-[QWHAP_APPROPRIATION]![CANCEL_AMT]-[QWHAP_APPROPRIATION]![REVERTED_AMT]+[QWHAP_APPROPRIATION]![ACTUAL_RCPT_AMT]+[QWHAP_APPROPRIATION]![TRANSFER_IN_AMT]-[QWHAP_APPROPRIATION]![TRANSFER_OUT_AMT]-[QWHAP_APPROPRIATION]![EXPENDED_AMT]-[QWHAP_APPROPRIATION]![BAL_FWD_OUT_AMT]+[QWHAP_APPROPRIATION]![APPROP_CUR_MOD_AMT])(((QWHAP_APPROPRIATION.ORGN_NBR)="0152") AND ((QWHAP_APPROPRIATION.APPROP_UNIT_NBR)="CLR") AND ((QWHAP_APPROPRIATION.RPTG_MO_NBR)=200712))QWHAP_APPROPRIATION.APPROP_UNIT_NBR(((QWHAP_APPROPRIATION.FISCAL_YR)>2005) AND ((QWHAP_APPROPRIATION.AGENCY_NBR)="E26"))Sum([QWHAP_APPROPRIATION]![BAL_FWD_IN_AMT]-[QWHAP_APPROPRIATION]![CANCEL_AMT]-[QWHAP_APPROPRIATION]![REVERTED_AMT]+[QWHAP_APPROPRIATION]![ACTUAL_RCPT_AMT]+[QWHAP_APPROPRIATION]![TRANSFER_IN_AMT]-[QWHAP_APPROPRIATION]![TRANSFER_OUT_AMT]-[QWHAP_APPROPRIATION]![EXPENDED_AMT]-[QWHAP_APPROPRIATION]![BAL_FWD_OUT_AMT]+[QWHAP_APPROPRIATION]![APPROP_CUR_MOD_AMT])QWHAP_APPROPRIATION.APPROP_UNIT_NBRBL k O  e (  a C %  [  ` ! NSX[1W+w3h$c#AMTX@# o# UTF_DETAIL.E2_SIGN1 g# UTF_DETAIL.E2_OBJECT_CODE8 g# UTF_DETAIL.E1_SIGN1 g# UTF_DETAIL.E1_ACCT_NBR5 g# UTF_DETAIL.SERIAL_NBR4 g#UTF_EVENT.OCCURANCE_DATE7 g#UTF_EVENT.PROC_TIMESTAMP7 g#UTF_DETAIL.E1_OBJECT_CODE8 g#UTF_EVENT.RECEIPT_FLAG5 g#UTF_EVENT.TRAN_TYPE_CODE7 g#GL_ACCT.APPRO_NBR0 g#UTF_DETAIL.E1_FY/ g#UTF_EVENT.RC_ID. g#GL_ACCT #UTF_DETAIL%%% #UTF_EVENT### # G# G# # G n@ ' 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.EMPL_NAME2 g 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.EMPL_NAME2 gEMPL_PAYT.APPRO_NBR2 gEMPL_PAYT.FISCAL_YEAR4 gEMPL_PAYT.RC_ID. gEMPL_PAYT###  G G  G :@ ' COST_CENTER.ACCT_NAME4 g COST_CENTER.CC_NBR1 g GL_ACCT.APPRO_NBR0 g CC_SUMMARY.FY, g GL_ACCT.RC_ID, g F@ ' COST_CENTERGL_ACCTB@ A5'  CC_SUMMARYCOST_CENTERH@ G;%  CC_SUMMARYCOST_CENTERL@ G;%  CC_SUMMARYCOST_CENTER CC_SUMMARY.FY = COST_CENTER.FYg;%  COST_CENTERGL_ACCTZ@ A5'  AmountSum(Val([YTD_ACTUAL_AMT]))E o COST_CENTER.ACCT_NAME4 g COST_CENTER.CC_NBR1 g GL_ACCT.APPRO_NBR0 g CC_SUMMARY.FY, g@d|8 s U 7  n 1 i % ^  f  z Z<Xw+U V,S O "QWHAP_EXPENDITURES.ACCEPTANCE_DT? ' B@  ' QWHAP_EXPENDITURES.ORGN_NBR: ' QWHAP_EXPENDITURES.FISCAL_YR; ' @  ' QWHAP_EXPENDITURES.AGENCY_NBR< g QWHAP_EXPENDITURES.EXPDTR_AMT< g QWHAP_EXPENDITURES.OBJ_CD8 g QWHAP_EXPENDITURES.TRANS_NBR; g "QWHAP_EXPENDITURES.ACCEPTANCE_DT? g B@  g QWHAP_EXPENDITURES.FUND_CD9 g D@  g QWHAP_EXPENDITURES.ORGN_NBR: g QWHAP_EXPENDITURES.FISCAL_YR; g QWHAP_EXPENDITURES.EXPDTR_AMT< gQWHAP_EXPENDITURES.OBJ_CD8 gQWHAP_EXPENDITURES.TRANS_NBR; g"QWHAP_EXPENDITURES.ACCEPTANCE_DT? gB@ gQWHAP_EXPENDITURES.FUND_CD9 gD@ gQWHAP_EXPENDITURES.ORGN_NBR: gQWHAP_EXPENDITURES.FISCAL_YR; gQWHAP_EXPENDITURES555  G G  G UTF_EVENT.OCCURANCE_DATE7 ' UTF_EVENT.TRAN_TYPE_CODE7 '@ 'UTF_DETAILGL_ACCT"UTF_DETAIL.RC_ID = GL_ACCT.RC_IDa3% UTF_EVENTUTF_DETAILD@C7# UTF_DETAILGL_ACCTX@?3% UTF_EVENTUTF_DETAILX@C7#  AMTX@# o UTF_DETAIL.E2_SIGN1 g UTF_DETAIL.E2_OBJECT_CODE8 g UTF_DETAIL.E1_OBJECT_CODE8 g UTF_DETAIL.E1_ACCT_NBR5 gUTF_DETAIL.SERIAL_NBR4 gUTF_EVENT.OCCURANCE_DATE7 gUTF_EVENT.PROC_TIMESTAMP7 gUTF_EVENT.RECEIPT_FLAG5 gUTF_DETAIL.E2_ACCT_NBR5 gUTF_EVENT.TRAN_TYPE_CODE7 gGL_ACCT.APPRO_NBR0 gUTF_EVENT.RC_ID. gGL_ACCT UTF_DETAIL%%% UTF_EVENT###  G G  G #UTF_EVENT.PROC_TIMESTAMP7 ' #UTF_DETAIL.E1_OBJECT_CODE8 ' #UTF_EVENT.TRAN_TYPE_CODE7 '#@ '#UTF_DETAILGL_ACCT"UTF_DETAIL.RC_ID = GL_ACCT.RC_IDa3% #UTF_EVENTUTF_DETAILD@C7# #UTF_DETAILGL_ACCTX@?3% #UTF_EVENTUTF_DETAILX@C7# LVAL   Z  T   QWHAP_EXPENDITURES.ACCTG_TRANS_CD(((QWHAP_EXPENDITURES.FISCAL_YR)>2005) AND ((QWHAP_EXPENDITURES.ORGN_NBR)="0152") AND ((QWHAP_EXPENDITURES.APPROP_UNIT_NBR)="CLR") AND ((QWHAP_EXPENDITURES.ACCEPTANCE_DT)>#8/30/2007#) AND ((QWHAP_EXPENDITURES.AGENCY_NBR)="E26"))QWHAP_EXPENDITURES.ACCTG_TRANS_CDQWHAP_EXPENDITURES.APPROP_UNIT_NBRQWHAP_EXPENDITURES.ACCTG_TRANS_CDQWHAP_EXPENDITURES.APPROP_UNIT_NBR(((UTF_EVENT.RC_ID)="0152") AND ((UTF_EVENT.PROC_TIMESTAMP)>#12/1/2007#) AND ((UTF_DETAIL.E1_OBJECT_CODE)="8199"))UTF_EVENT.RC_ID = UTF_DETAIL.RC_IDUTF_DETAIL.E2_ACCT_NBR = GL_ACCT.GL_ACCT_NBRUTF_EVENT.SERIAL_NBR = UTF_DETAIL.SERIAL_NBRVal(IIf([E2_SIGN]="C",[AMOUNT]*-1,[AMOUNT]))(((UTF_EVENT.RC_ID)="0152") AND ((UTF_DETAIL.E1_FY)>"2005") AND ((GL_ACCT.APPRO_NBR)="CLR") AND ((UTF_EVENT.TRAN_TYPE_CODE)<>"PR") AND ((UTF_EVENT.PROC_TIMESTAMP)>#8/30/2007#) AND ((UTF_DETAIL.E2_OBJECT_CODE)="8110"))UTF_EVENT.RC_ID = UTF_DETAIL.RC_ID <Y<<N  Y  Y q Y Y Y  Y qqY ""Y Y Y ""Y ""Y  Y FY CC_NBROBJECT_CODEUD1_BUDGET_AMTUD2_BUDGET_AMTUD3_BUDGET_AMTUD4_BUDGET_AMTUD5_BUDGET_AMTCURR_BUDGET_AMTENCUM_AMTMTD_ACTUAL_AMTYTD_ACTUAL_AMT RC_ID ""YCC_SUMMARY_PKv1@ LVAL  d 0 p*DSN=REPL;DBQ=REPL;DBA=W;APA=T;EXC=F;FEN=T;QTO=F;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O;DSN=REPL;DBQ=REPL;DBA=W;APA=T;EXC=F;FEN=T;QTO=F;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O;DSN=IA_Warehouse;DBQ=DOFIA;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O;DSN=IA_Warehouse;DBQ=DOFIA;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O;DSN=Normandale CC Replicated DB;SVR=replnrc.mnscu.edu;CLS=generic;DATABASE=attach 'filename isrsmnscunrcdb_roota:[data]isrs_db';XPT=2;CSO=1;DBA=R;DSO=0;TLL=;TLO=0;DSN=REPL;DBQ=REPL;DBA=W;APA=T;EXC=F;FEN=T;QTO=F;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O;DSN=REPL;DBQ=REPL;DBA=W;APA=T;EXC=F;FEN=T;QTO=F;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O;DSN=REPL;DBQ=REPL;DBA=W;APA=T;EXC=F;FEN=T;QTO=F;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O;DSN=REPL;DBQ=REPL;DBA=W;APA=T;EXC=F;FEN=T;QTO=F;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O;DSN=REPL;DBQ=REPL;DBA=W;APA=T;EXC=F;FEN=T;QTO=F;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O; LVAL\ J l     0                                  x        d                  C C B                                        (                     x              AY@@N""" Y  Y  Y  Y  Y p Y Xr Y r Y  Y  Y  Y P Y , Y , Y   Y  Y ,0 Y , Y 0 Y 0 Y , Y , Y  Y  Y , Y , Y  Y  Y , Y , Y  Y  Y , Y ! , Y!!" FY CC_NBRGL_ACCT_NBRCAMPUS_ID"OFF_CAMPUS_LOC_IDPROGRAM_CODESUBPROGRAM_CODEGRANT_PROJ_NBRACTV_CODEUBIT_CODEACCT_NAMESHORT_NAMEEXP_ALLOW_FLAGREVN_ALLOW_FLAG BUDGET_CTRL_CODERESP_NAMEBLDG_CODEADDR_LINE1_TEXTADDR_LINE2_TEXTFREEZE_FLAGREVIEW_FLAGFY_ROLL_FLAGPAR_CC_NBRUSER_FIELD1USER_FIELD2USER_FIELD3USER_FIELD4USER_FIELD5USER_FIELD6USER_FIELD7USER_FIELD8USER_FIELD9COMMENTS RC_ID!OEN!CTENDYY COST_CENTER_NDX1COST_CENTER_PKv1   YDDN Y  Y [r Y  Y 8 Y ^ Y Vr Y r Y $Y ddY ٴٴY Y dd Y d Y  ٴ Y  Y d Y dY ٴٴ Y  Y dY  Y ٴ Y SSNFISCAL_YEARPAY_DATEPOST_DATEAPPRO_NBR CC_NBROBJECT_CATEGORYEMPL_NAMESALARY_AMTRETIREMENT_AMTFICA_AMTINSURANCE_AMTPOSITION_NBR SWA_FYSWA_DEPTSWA_DIVISIONSWA_TRAN_TYPEPAY_HOURSPOST_FLAGGFS_OBJECT_CODESERIAL_NBRS4_RCDZ_NBR RC_IDdٴYEMPL_PAYT_PKv1