Penn State mark   AIS Header AIS Home Page link ITS Home Page link
in:
AIS Home > Data Warehouse > Data Warehouse Database Developers > Developer's Standards

Developer's Standards



Date Fields
Any date field contained in the data file sent to the Warehouse must contain a valid date. If a valid date cannot be determined, then the field must contain null or blanks. Each field must be interrogated to make sure it is a valid field before it is sent to the Warehouse.

Fields Containing a decimal
Any currency or decimal fields need to have the decimal added to the field before it is sent to the warehouse.





Questions: Data Warehouse


Printer friendly view



The Pennsylvania State University © 2008 | Copyright | Privacy and Legal Statements | Alternative Media - Nondiscrimination Statement
This site is maintained by Administrative Information Services, a unit of Information Technology Services.
Provide site feedback to AIS-webmaster@psu.edu. Can't find it? Ask AIS
Last revised: Friday, September 28, 2007 8:51