Below is a schedule of tentative dates for the release of remaining DWSF and DWFA tables. Please note that the dates are subject to change and depend entirely on the availability of PeopleSoft data. These tables will be released as soon as data is available in PeopleSoft, and the updated tables have been tested.
Updates to the tables scheduled to convert during the week of June 28th - July 3rd within the Data Warehouse are complete.
Continue reading "Data Warehouse Table Updates - July 3, 2008" »
The following will be views of payroll tables prior to fiscal year 2009:
ps_dwpy_hsa_hist_vw and ps_dwpy_pay_frng_hist_vw.
For fiscal years 2009 and beyond, the views are named ps_dwpy_hsa_hist_efs_vw and ps_dwpy_pay_frng_hist_efs_vw.
Beginning the afternoon of Monday, June 30th, several tables will be unavailable while they undergo updates related to the EFS implementation. Backup versions of some of these tables will be available either in a permanent historical format or a temporary conversion backup table. New versions of tables will be released after they have been tested.
In addition to the tables being updated, some tables will become static between June 27th and July 1st. Many of these tables are fiscal year based, and their new counterparts will be created over the same time period. Others will be updated in Phase II, and a few do not have updated versions.
DWFS, DWIN, DWRA and DWUS will not be updated with new EFS data, and will become static on a staggered schedule over the next four months as CUFS updates come to an end.
Finally, some tables won’t change structurally, but will have new EFS data appear over the coming week.
| Data Group | Last Refresh Date |
| DWFS | October 2008 |
| DWIN | August 2008 |
| DWRA | 6/27/2008 |
| DWUS | 6/27/2008 |
Chart of Accounts (COA)
A COA conversion table (CUFS to EFS) can be found in the Data Warehouse and is accessible to all users who previously had access to financial tables in the Data Warehouse. These tables are under the datagroup of DWFS. The table name is FS_C_COA_MAP_TBL and is available for immediate use. This table does not require a functional ID and is open to people with current access to DWFS tables.
If a financial user who does not currently have access to this table would like to request access to it, they need to fill out an access request form (ARF) through OIT Data Security, which can be found at http://www1.umn.edu/datasec/security/ARF_pdf.htm. The ARF along with the following attachment needs to be filled out, signed by the appropriate authorities, and submitted to Data Security: Financial DW Tables - DWFS (found under the Financial Systems & Data heading).
The COA conversion table will also be available in July within the EFS reporting instance.
Updates to the tables scheduled to convert over the weekend of June 14th and 15th within the Data Warehouse are complete.
On June 14, 2008, HRMS Job and Position tables converted to include the new 5-digit Department ID. Some Job data did not convert to the new 5-digit Department ID and will continue to only contain the Entity in the Department ID field.
After 10pm on Sunday, several tables will be unavailable for up to 48 hours, while they undergo conversion to EFS format. During the outage, backup version of these tables will be available. We anticipate that the maximum amount of time a table may be down is 48 hours. The tables will be released after they have been tested.
Another set of tables will become static over the weekend, and will continue to be available in the Data Warehouse. Some of these will be updated during Phase II.
Finally, two new tables will be available starting on Monday following the conversion.
A recap of the questions from yesterday's meeting on the upcoming EFS Conversion:
Following is the agenda for the June Analyst Group meeting that focuses on the upcoming EFS Conversion:
Beginning June 16th, 2008, IMS will update UM Reports with the new values needed from the Enterprise Financial System (EFS). Reports will be updated on the following schedule. The schedule is tentative and may be subject to change based on EFS conversion.
Updates:
- HR – conversion complete
- Payroll - beginning June 30th (with the exception of the Pre-Payroll Distributions and Employees with Change of Status in Pay Period reports, which were converted the week of June 16th and the Current Month YTD Encumbrance Payroll Summary scheduled to be converted the beginning of August)
- Student Finance - beginning July 2nd
- Financial Aid and Work Study – beginning July 7th
- Student and Instruction - beginning July 17th
- Tuition Allocation – beginning August 18th
Individual reports will be listed on the UM Reports homepage as they are converted, and will be unavailable while the updates occur.
Once conversion is complete, we will post a message when reports are available for use.
Please use DWTEST to access updated tables.
DWTEST can be accessed by using the following link:
http://dw-test.ims.umn.edu
Please note this is a development environment and all functionality of the web query tool is not guaranteed. For the best access to DWTEST please consider using a tool like SQL Developer or Toad.
Continue reading "Effective Dates for Phase I / Phase II Tables" »