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 |
|---|---|---|
| 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 |