July 31, 2008

DWSF & DWFA Table Updates

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.

Continue reading "DWSF & DWFA Table Updates" »

July 11, 2008

Remaining Table Changes

The remaining table changes related to the EFS Conversion are underway. Below is a schedule of what's to come in the next six weeks.

Continue reading "Remaining Table Changes" »

July 10, 2008

Data Warehouse Table Updates - July 3, 2008

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" »

July 8, 2008

Payroll Table Views

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.

June 27, 2008

Data Warehouse Table Updates Related to June 28th-July 1st PeopleSoft Financials Implementation

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.

Continue reading "Data Warehouse Table Updates Related to June 28th-July 1st PeopleSoft Financials Implementation" »

Data Groups Not Being Updated

DWFS, DWIN, DWRA and DWUS will not be updated with new PeopleSoft Financials information, and will become static on a staggered schedule over the next four months as CUFS updates come to an end. See below for more detailed information.

Data Groups that will Not be Updated with New PeopleSoft Data

  Data Group   Last Refresh Date
  DWFS   October 2008
  DWIN   August 2008
  DWRA   6/27/2008
  DWUS   6/27/2008

June 19, 2008

FS_C_COA_MAP_TBL

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.

Continue reading "FS_C_COA_MAP_TBL" »

June 17, 2008

Data Warehouse Table Updates

Updates to the tables scheduled to convert over the weekend of June 14th and 15th within the Data Warehouse are complete.

Continue reading "Data Warehouse Table Updates" »

June 16, 2008

HRMS Job and Position Tables

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.

Continue reading "HRMS Job and Position Tables" »

June 13, 2008

Extended System Maintenance

The normal maintenance window from 6:00 AM to 12:00 PM on Sundays will be extended this weekend because of the initial updates happening with the EFS conversion. The window for maintenance this Sunday, June 15th, will be from 6:00 AM - 3:00 PM. Please plan accordingly.

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.

Continue reading "Extended System Maintenance" »

June 6, 2008

Q & A from Thursday's Meeting

A recap of the questions from yesterday's meeting on the upcoming EFS Conversion:

Continue reading "Q & A from Thursday's Meeting" »

June 5, 2008

Agenda for Thursday's Meeting

Thursday, June 5th, 2008 Meeting Agenda

Following is the agenda for the June Analyst Group meeting that focuses on the upcoming EFS Conversion:

Continue reading "Agenda for Thursday's Meeting" »

Reports Update

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.

June 3, 2008

Link to Access Updated Tables

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.

June 2, 2008

Effective Dates for Phase I / Phase II Tables

Effective Dates for Phase I / Phase II Tables

Below are the earliest dates the following tables will be available to University users following conversion happening the weekends of June 14/15, June 28/29, and later. While we don't anticipate any problems and have attempted to identify all issues related to conversion and production deployment, there is some risk that not all tables will be immediately available. Please plan accordingly and check the main page of this blog for updates. Thank you.

Continue reading "Effective Dates for Phase I / Phase II Tables" »