Monday, December 8, 2008
Friday, November 21, 2008
New or Changed Tables and Views Operational Warehouse Staging (OWS) Tables/Views -Student Records
Changes to EPM Business Rules and Logic - None
Friday, September 12, 2008
New or Changed Tables and Views
Changed: Operational Warehouse Staging (OWS) Tables/Views. These record definitions were altered to match changes in PeopleSoft SAPRD:
PS_ASU_AI0008_PLAN (CRM #312173)
PS_AUDIT_ASU_AI10 (CRM #313183)
PS_ ASU_SFSTDRES_VW (CRM #312506)
New: Operational Warehouse Staging (OWS) Tables/Views in Student Records mart:
PS_HOME_CAMPUS_TBL (CRM #309127)
Changes to EPM Business Rules and Logic
Multi-Dimensional Warehouse Tables/Views
PS_ASU_D_PERSON and PS_ASU_D_PERSON_VW: resolved delivered Oracle issue preventing future-dated person attributes from being reflected consistently (CRM #313577)
Friday, September 5, 2008
Three new views and one new table have been added to the Human Resources Data Warehouse:
The ASU_BPC_VW views contain BPC related information consolidated from several sources. Data includes Fiscal Year, Account, Position Number, Employee ID, Original Budget, Budget Adjustments, Expense, Encumbrance, and budgeted FTE. The Original Budget and budgeted FTE are sourced from STAR. The Expense and Encumbrance amounts originate from the PeopleSoft. The Budget Adjustments come from the Advantage fed Financial data warehouse. The ASU_BPC_VW combines all fiscal years in a single view.
ST_ORIGINAL_BUDGET contains the data that has been interfaced from STAR into the Human Resource Data Warehouse that was used for the ASU_BPC_VW_2009.
As of today these views and table are available to My Reports users; however, the budget amounts are not yet complete. State budgets are loaded but not yet finalized. Local budgets are expected to be loaded during September.
A new query, Budget Position Control.bqy is available in the Human Resource folder. Some enhancements have been added to the BPC 2008 query. Fund, ABOR classification, and Grade have been added.
The BPC 2009 dashboard went into Production 9/4/2008 at http://dashboards.asu.edu. The BPC 2008 dashboard has been removed from the main dashboard menu but can be accessed from within the BPC 2009 dashboard.
Wednesday, August 27, 2008
Monday, August 18, 2008
Tuesday, August 12, 2008
Thursday, August 7, 2008
Wednesday, July 23, 2008
Tuesday, July 15, 2008
Monday, June 30, 2008
The current logic for setting the JOB_INDICATOR is:
If there is only one job for the employee, that is the primary job. If the employee has multiple jobs, the primary job is the job with the highest annual salary that is not terminated or retired (PS_JOB.EMPL_STATUS = R or T). If there is more than one job with the same annual salary, then the job with the lowest PS_JOB.EMPL_RCD is be set to be the primary job.
What is the difference between N and S?
Currently, non-primary jobs are assigned a job indicator code = N. In the past, non-primary jobs were assigned a job indicator code = S. There were some challenges with early versions of the job indicator assignment program. When the current version of the program was rolled out on June 11, 2008, it was decided not to fix historical records but to begin anew with a different coding structure.
Wednesday, May 28, 2008
Thanks to Denise DeSouza and Elaine Moore for developing this new query.
Thursday, May 22, 2008
Employees can update their emergency contact information via ASU Interactive > Employee Self Service > Personal Information at https://www.asu.edu/go/personalinformation/. Changes will be reflected in the ASU Data Warehouse the next day.
Friday, May 16, 2008
As you know ERE encumbrances are applied to Sponsored Program's Accounts only. The encumbrance amount is calculated by using the actuals and encumbrance JVs that are interfaced between HRIS and Advantage, so these files are retained after each payroll cycle. The amount that is encumbered is calculated using the following formula:
ERE Rate = (ERE Actuals) / (Salaries)
ERE Encumbrance amount = (Encumbrances) X (ERE Rate)
This process is performed in a job that runs after both the Expenses (Actuals) and Encumbrances have interfaced into Advantage. The process also zeros out the previous encumbrance amount, so it is a full reset.
- Provide for a merge of RA/TA expenses (which are currently entered by way of a file provided by FS), so that those expenses are part of the calculation.
- Off-cycle ERE encumbrance calculations have been "off" because the actuals are limited to only those accounts with activity, yet we get a full encumbrance file. The solution, for now, is to retain the calculated rates from the On-cycles and then apply those rates to the encumbrances during off-cycle processing.
PS_ASU_PAY_EXP_VW contains salaries, wages, and ERE expenditures. PS_ASU_PAY_ERN_VW contains only salaries and wages; and PS_ASU_PAY_ERE_VW contains only ERE.
All three views contain both original payroll distribution records as well as redistribution transactions that have been approved.
The existing Human Resource myReport query, HR Expenditures.bqy has been modified to use the new views.
All three views contain the same columns of data:
- Distrib Type
- Source Cd
- Pay End Dt
- Off Cycle
- Page Num
- Line Num
- Fiscal Year
- Accounting Period
- Acct Cd
- Budget Data
- Position Nbr
- Transaction Nbr
- ASU AgcyOrg
- Fund Code
- ASU Sorg
- ASU Expenditure Cd
- Approval Status
- Paycheck Option
- Approval Oprid
A big thank you to Laura Lee for making this happen.
Thursday, May 15, 2008
Wednesday, May 14, 2008
The batch query output, Output from Daily(cycle) of job Pay Check, which was in the Human Resource/Content Underdevelopment folder will no longer be produced. Human Resource data warehouse users should now use PS_ASU_PAYCK_AR_VW as an alternative source of this information.
Wednesday, May 7, 2008
Tuesday, May 6, 2008
Previously, if an employee selected the option that the primary emergency contact's phone number was as the same as the employee's home phone number, Emerg_Phone_Num would be blank in PS_ASU_D_EMP_AR_VW. This has been changed so that the employee's home phone number now appears in the Emerg_Phone_Num.
A query named "Emergency Contact.bqy" is available in the myReports Human Resource folder.
More complete emergency contact information is available in the PS_EMERGENCY_CNTCT table.
Friday, May 2, 2008
Thursday, May 1, 2008
The PS_ASU_HR158_VW was inspired by the legacy data warehouse's tblHR158, hence the name. The goal was to provide current job information including position funding sources. Based on the PS_JOB table, the view pulls in data from ten other tables including the current position distribution, job code salary ranges, tenure information, and vacation plan information.
Some of the column names require some explanation:
- DEPTID2 is the home department which should be the department of an employee's primary job.
- DEPTID_LD is the description of the home department.
- DESCR is the title associated with the job code.
- DEPTID is the department associated with the job.
- DESCR2 is the job department's description
- Amount is Annual Rate * position distribution percentage
We plan to create a view on top of this view that will have more descriptive column names, but do not want to do this until you all have had a chance to use the existing view and point out all its shortcomings. So please, let us know if you see data that looks incorrect.PS_ASU_CUR_JOB_VW was created along the way as a convenience while working on the PS_ASU_HR158_VW table. It is simply the PS_JOB table filtered to only the current record.
Kudos to Mark Monninger for developing these helpful new tables and to Robin Gonzalez for defining the requirements.