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
- Cathy Helsel at (814) 865-4039
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 |