Connecting to the FISDataMart

  • Contact Saritha Kuchipudi at (814) 865-9565 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: 172.29.174.26

ODBC Database Installation for users within FIS Network

ODBC Database Installation for users outside of FIS Network

**Note: If you unsure of which of the two top links to use for ODBC setup please contact Saritha Kuchipudi

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