June 2018 New and Revised HCM Queries “Third Thursday Demo” available for playback

posted Jun 27, 2018, 1:56 PM by Peyri Herrera
The recorded Third Thursday demo of New and Revised HCM Queries is now posted on the Third Thursday page. For your convenience, below are the links to the demo and presentation.

New and Revised HCM Queries
Demo (58 min) | PowerPoint Slides (41 slides)

This is a walk-thru of new and recently revised HCM queries that are available to you for the following areas of PeopleSoft HCM: Combo Codes, Retirement, Human Resources, Payroll, Benefits, Time & Labor, and Absence Management. Presenters are from Education Business Systems (EBS) and the SDCOE Retirement Unit.

New HCM Queries

1. M_KK_COMBO_ACCTS_LIST_PROMPTS - Combo Code w/Chartfield Prompt

2. RET_EE_MBSHP_INFO - Employee Retirement Info

3. M_HR_ALL_MCOPS_BY_DIST - All EE MCOPs & Base

4. M_HR_AB119_LAW_REQ - AB119 Law Required Data

5. M_HR_AB119_LAW_PLUS - AB119 Data Addt’l Fields

6. M_PY_COMPENSATION_SPLIT - Employee Compensation Split

7. M_BN_RET_BEN_JOB_AUDIT - Retiree Benefits Job Audit

8. M_BN_CUR_BENEFIT_RATE_DATA - Current Benefit Rates

9. M_BN_HEALTH_CURR_ENROLLMENT_DP - Domestic Partner Enrollments

10. M_TL_HOLIDAY_SCHEDULE - List Holiday Schedules by Date

Revised Queries

1. M_HR_NAHRLY_STEP_ENTRY_DT - NAHRLY Step Entry Date

2. M_HR_NAANNL_STEP_ENTRY_DT - NAANNL Step Entry Date

3. M_PY_RETRO_COMBOCODE_2

4. M_PY_PAYSHEET_ADJ_AUDIT_BY_LN - Audit Paysheet Adj Entries

5. M_PY_MONTHLY_EARNS_BY_LN - Monthly Hours/Earnings Paid

6. M_BN_PAY_ONE_TIME_DED_PRORATE2

7. M_AM_DISTRICT_BALANCES - District Absence Balances

8. M_AM_LEAVE_TRANSACTIONS - All Leave Transactions

9. M_AM_ABSENCES_AUDIT - Absence Audit

Reminders

1. M_PY_CALC_ERROR_MSGS_BY_DIST

2. M_DATAENTRY_AUDIT

3. M_TL_PAYABLE_TIME_AUDIT

4. M_HR_MORE_PRIMARY_JOB_FLAG

5. M_PY_ADDL_PAY_OVERRIDE

6. M_BN_OPEN_BEN_ADMIN_EVENTS

7. M_BN_EMPL_DED_PROC_SVNGS

8. M_BN_EMPL_DED_PROC_NONHLTH

9. M_BN_EMPL_DED_PROC_HLTH

10. M_BN_EMPL_DED_PROC_GENDED

11. M_BN_BEN_PROG_JOB_DATA

12. M_EXCESS_LEAVE_RPT