Connecting to the FISDataMart

    • Contact Robert Miller to request access:
    • Install and configure connection to ODBC Database-
      • The tool you select needs to have the ODBC component in order to access the SQL server.
      • Support for connectivity problems can be obtained from

    To avoid computer connectivity problems, please use the DNS host name when configuring computers.

    The host name of the server is: 128.118.75.84
    ODBC Database Installation and Operating System Setup instructions.

    TABLE NAME DESCRIPTION DATA DICTIONARY
    FISDataMart Table Information
    fac_BLD1 Facilities building details  
    fac_BLD2    
    fac_BLD3    
    fac_BLD4    
    fac_BldgClassCategory    
    fac_BldgClassCode    
    fac_FACFIN Facilities building financial transactions  
    fac_RENV1 Facilities building renovation details  
    fac_RENV2    
    hdr_AGNDATA    
    hdr_CNTDATA   ContractData.pdf
    hdr_CNTERR    
    hdr_COAFUNDS Header information for all accounts (open and closed) COAFunds.pdf
    hdr_FNDERR    
    hdr_PRJDATA   ProjectData.pdf
    hdr_PRJERR    
    ibis_codesets Object Codes Descriptions  
    ibis_detail#1_currentFY Current Fiscal Year details-- summarized salary data  
    ibis_detail#1_allFY Detail#1 details for current Fiscal Year and 4 previous fiscal years -- summarized salary data  
    ibis_RSTR_currentFY Details from Detail#1, Restricted Accounts ONLY  
    pcard_cardholder Purchasing Card -- cardholder data  
    curr_pcard_detail Purchasing Card -- data for current year only  
    hist_pcard_detail Purchasing Card -- data prior to current fiscal year  
    piData Property Inventory -- Equipment file  
    ledger_details Ledger Documentation -- ledger details ledgerDetails.pdf
    ledger_totals Ledger Documentation -- ledger totals ledgerTotals.pdf
    journal_voucher Ledger Documentation -- journal voucher journalVoucher.pdf

    Please direct all inquiries and comments about this Web site to chelsel@psu.edu
    This site last updated: 12/2012