tried to user blogger

| No Comments

I decided to start blogging using blogger today. I even found a site that will convert your movabletype blogs into blogger format. The only problem i have is that it looks like google does not let you use blogger with your corporate google apps account. I was told differently but it doesn't seem to work for me.

Age AR outstanding balances update

| No Comments

The business did some testing and found some detail codes that were not in the report. It turns out there is bad dates on some of the AR records in banner where the effective date of the AR transaction exists before the first effective date of the FOAPAL distribution for that detail code. I modified the program to check and see if this condition exists and to find the first detail code distribution record if it does.

Faculty Load Status

| No Comments

I have been making changes to the report and update programs for faculty load to deal with the differences when processing summer workload. The changes to the report program are almost complete and the changes to the update program are about 60% complete.

Age AR outstanding balances

| No Comments

Wrote a program so the business can generate this report from job submission. Moved to production but waiting on the business to test the report. Will probably need to make changes to the program after they have run it.

Faculty Load Status

| No Comments

This week we have been setting up summer session in test. There have been a number of issues that needed to be resolved in order to setup summer correctly.

FZRMILE

| No Comments

The program we use to be able to report on mileage for finance was aborting. It turned out the field were we store the miles someone was reimbursed for is a text field and in some cases people enter text into the field when they are reporting on mileage. There was no logic in the program to test so see if the field was numeric before performing calculations on it.
I found a decode statement that allows you to put logic in-line in the sequel statement to do the check and convert the text to a zero which worked in this case.
decode(replace(translate(fobtext_text,'0123456789.','00000000000'),'0', null), null, to_number(fobtext_text), 0)
The code basically changes all numbers and decimal to a zero, then it replaces all zeros with null, then it tests the string and if it is null then the string was a number and it uses the string as a number otherwise it uses zero.

Faculty Load update

| No Comments

Started testing tenure / tenure track on WOUTST. Made some changes to the validation report PZRFCLD so it reports tenure/tenure track correctly. Met with business on the issues documented by payroll after running pzpfcap for the spring pilot. Started changing the update program to based on the meeting. Changed the test system to handle supervsion differently based on recommendations from the sungard consultant. Sent the consultant an email because I'm not sure how to handle early bird.

Leave Accrual Report Completed

| No Comments

The complete solution has been written,tested and moved to production.

Leave Acrrual Report Status

| No Comments

Met with business and reviewed forms. Built the first form that will display all the unclassified employees current sick and vacation balance that report to the supervisor running the form. Asked the business to test this form. Started coding on the second form.

faculty load and compensation update

| No Comments

built a wolf web application to allow the business to enter the rate for a specific faculty level for a given term and the program finds all the combinations of term, campus, college, contract type, and schedule type and creates the appropriate entries for them. The business would have had to use PTRFLAC to do this one at a time. For each faculty level there are 57 combinitions that would need to be entered for this spring term. For our spring pilot there are 30 different levels which means the business would have had to do 1,710 entries.

leave accrual report

| No Comments

Started working on the employee leave accrual report that will be accessed from wolf web. Created the query that pulls the vacation and sick numbers for all employees for a given supervisor. Mocked up the two forms that will be used and I am now waiting on the business to review the forms before writing any code.

Faculty Load Spring term status

| No Comments

Payroll records have been created from employee self-service. We have started working on summer term. set up some additional data fields using the suplimental data engine and added that information to the faculty load report.

connections training

| No Comments

attended the second session of connections training this week. Different name but the same type of training that organizations have had employees taking for years. It is good to have a refresher once in a while though.

Scarf Winter EOT

| No Comments

Continued working on the scarf process. I have must about done everything at this point. There are a couple cleanup steps that are left and I am waiting to go over them before I do them. Also wrapped up sending out reports for the end of term grades.

Faculty Load and Compensation - Status

| No Comments

Worked with business to get all their changes made in employee self-service. While doing this i noticed a number of changes needed for the report so I made those.

End of Term Grade processing

| No Comments

Have been working on the end of term grade process. lots of sequels to run and lots of review for accuracy between steps.

Faculty Load and Compensation

| No Comments

We have started the pilot for spring term with about 45 faculty. Currently all the information has been entered into the student side and it will be transfered into employee self-service this week. The two outstanding issues we still have to deal with before fall term are overload and job labor distribution for non-instructional workload. I developed a proposal for overload that we reviewed last week and made a modification to.

Health and Wellness Center

| No Comments

Tested the purchasing application, spent time looking at the ODBC setup, reviewed in the implementation plan.

faculty load - validation report

| No Comments

Have a new report 90% complete that will be used to validate the information in employee self-service before it is loaded into payroll. The report will also be used as an approval report and an informational report. It combines the information that is available when doing a data download from employee self-service with the information on the report when the load to payroll program is run and adds some additional data as well.

The plan is to also add some validation logic in the report that will let help payroll in finding changes that should not have happened.

banner interface to rectrack

| No Comments

We meet with food services and during the discussion on how the new process would work we realized we need an extract from their system so that when the cards are encoded they have the correct lost card number based on what food service already knows about.
We meet with the business and the consultant about the interface and what codes need to be sent to rectrack. We also talked about household id, household member #, and lost card number and how rectrack works with these. The result of the discussion is a change in how we are going to encode the form and a change in how we will send the data.

faculty load

| No Comments

still trying to work through how we will handle deferred pay and overload. Working on an application that will properly set appointment percentage, hours per pay, default earnings, and rate.

P-Card processing

| No Comments

We have now had meetings at both OSU and PSU to understand how both universities have implemented p-card processing. We will be implementing this at WOU. This solution will automate much of the process of accounting for purchases using a credit card and reduce some of the financial transactions that are required today.

Faculty Load

| No Comments

Continue to work on FTE logic and making sure everyone is entering what is needed for our second round of testing.

faculty load

| No Comments

Had two phone calls with people from Jamestown Community College because they have recenlty implemented faculty workload. Meet with HR to go over the setup screens they need to maintain. Starting writing the code to determine what the FTE should be based on the workload.

Faculty Load and Compensation

| No Comments

We had a meeting to discuss business process flow and starting looking at where changes may need to take place for faculty load. I modified SIRTCAL so that it shows the right workload and FTE values in the term workload analysis section. It still needs to be modified to do the same thing in the contract analysis section but the business can work with it for now until we have time to make the other change.

continue to look at the FTE and labor distribution numbers to try and understand how the system calculates these. We many need to build mods to get these numbers correct.

Three days of little things

| No Comments

This has been a week of working on lots of little things. Loaded an updated payroll program and an updated finance program from OUS. Attended a meeting at OSU on p-card processing. Did the monthly load roster process for payroll. Worked with dean's offices on more faculty load setup. continue to try out different google apps functionality.

faculty load and compensation

| No Comments

We had a conference call with Old Dominion University this week to understand their implementation and see they were able to resolve some of the problems we have run into. IT was a great converastion and we learned some things but many of the issues we have they don't because they have different business processes than we do.

Met with our consultant and I presented the four key issues we have and we work some on these. Still no good resolution for them.

Health and Wellness Center Access - business requirements

| No Comments

Worked with the team on developing business requirements for accessing the health and wellness center. Also started to help with defining some of the high level technical design.

Payroll report of MEC deductions

| No Comments

There was an issue of some people not getting the correct pay and a request was made ot create this report to be run during the payroll process to help in making sure issues are resolved before the payroll process is completed.

Created report, business tested, then I moved it to production.

faculty load and compensation

| No Comments

originally we planned on using the salary view for this process but once we met with the consultant and understood better what budgeting/payroll would like to have the system do we are going to switch to the course compensation view. Did some setup for this and worked with the business to develop some rates and push some records through to see how this will look.

Also processed a two new people, one as salary view and one as course compensation view and processed them all the way through to creating NBAJOB records so we can compare how the two processes work.

We had the system run the update query in the middle of the nightly feed last night that processed the missing transactions. This morning we did a sql update of the invoice table so that the invoice transaction date represented the date the refunds where processed on the student side.

electronic refunds - invoice and checks

| No Comments

Moved the code to production that will start creating the invoices and echecks for electronic refunds. Requested OUS to move their code as well so they have the correct prefixes on each type of document.

Faculty Workload - setup pilot faculty on test

| No Comments

Worked with the business to setup all the faculty we will be using for the pilot on our test system. Also prepared to do a demo with our sungard consultant.

Electronic refunds - invoice and check update

| No Comments

Have run a number of tests and we have had invoices and checks created but the last two tests did not have checks created. Working with OUS to figure out why not.

The business has noticed that we are not getting the finance entries we should be when we process electronic refunds. Studied the feed process and discovered that the detail code for the transactions was missing a setting that would have caused the records to be created. We need to also create some logic to change the document number that is passed over to have a unique prefix. We need OUS to make a few mods on their end so that the check number gets created with a prefix of D.

I also needed to create a program that will generate a pipe delimited file of the records that are missing because the detail code wasn't set correctly.

IBM Cognos Author Professional Reports training

| No Comments

Last week I attended the report authoring class for Cognos. This was a great class and showed that the new reporting tools have a lot of power. I am looking forward to making the transistion from BI-Query to Cognos Reporting.

IBM Cognos framework manager training

| No Comments

Just completed a week of training on framework manager. This tools builds the packages that contain the models that represent our data. You can not build reports with any of the Cognos reporting tools until you have a package created. I was able to create a package against aero while in class so that we can create reports. I still need to clean up the model but it gives us a starting point.