Penn State mark
FIS Home > Connect to DataMart

 

  Connecting to the FISDataMart



1.  Contact Cathy Helsel to request access: 

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  

2.  Install and configure connection to ODBC Database

  • There are numerous database query tools to choose from. 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 Todd Cardamone at (814) 865-9762 (email toddc@psu.edu) or Cathy Helsel at (814) 865-4039 (email chelsel@psu.edu). To avoid computer connectivity problems, please use the DNS host name when configuring computers.

    The host name of the server is: 128.118.75.73  
    ODBC Database Installation and Operating System Setup instructions.



Financial Information Systems
120 South Burrowes Street, 423 Rider Building
University Park, PA 16801-3857
Phone: 865-9699   Fax: 863-6862

Please direct all inquiries and comments about this Web site to chelsel@psu.edu
This site last updated: 16-November-2004

The Pennsylvania State University © Copyright 2004
Penn State is an Equal Opportunity Employer