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.

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