As a courtesy to users of the SQL Library, the Data Warehouse group will validate all code prior to it being published. . Sprinkled throughout DataLink at a column level is the introduction of a column decoder. This new functionality is in a very early stage. Once it is fully developed any column that contains coded data will have its translated description available. . The Data Stewards that provide DataLink with much needed descriptions now have a facility that will enable them to maintain metadata easily directly through DataLink.
Production runs weekly and monthly.
The process performs a complete refresh of all tables. This data is based on the ARM650 report that is supplied to Business and Financial Services. When approved, access will be granted on a table by table basis. The ISIS General Person data is now available in the 'gp' database for both main campus and Extended Studies. Due to the nature of this data, the database, all tables and views are secured.