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