Rules for Data
New File Loading Process
Follow these steps to provide a new Y1CE data file for loading to database:
If there are multiple files they can all be placed in the same location. |
Data Correction and Loading Process
You will be notified if there are any source data errors while loading the file(s). The email will mention the location and file name of the error log. Please note the error log will be in a .csv format and you will need to save the corrected data into a .xlsx format as indicated in the process. |
Follow these steps to provide a corrected Y1CE data file for loading to database:
Load Schedule
It is important that the Excel files be closed and are not open for editing before the load process begins. When the data load begins if the file is open, then the process will error out. The load is expected to run every Saturday at 9:05 am.