HCM queries modified to show currency with only two decimals

posted Jun 11, 2014, 10:11 AM by Peyri Herrera
The CRC modified these 44 HCM queries so that currency values are displayed with two decimals (2619.00, for example):
  1. MR_HR_SALARY_GRADE_STEP
  2. MR_JOB_DATA_FOR_VALID
  3. M_403B
  4. M_AM_DISTRICT_BALANCES
  5. M_AM_OVER_VAC_MAX
  6. M_AM_SICK_VAC_LIABILITY
  7. M_DAILY_CDAY_HRS
  8. M_EARNINGS_TBL
  9. M_EE_DCSA_GENL_DED
  10. M_EE_DUPLICATE_JED
  11. M_EE_FSA_GENL_DED
  12. M_EE_LTC_GENL_DED
  13. M_HR_ACTION_POS_0701
  14. M_HR_CERT_JULY_STEP_INCR
  15. M_HR_DW_DAILY_CDAYS
  16. M_HR_EMPL_CLASS
  17. M_HR_JOB_DATA_FOR_VALID
  18. M_HR_JOB_FOR_SD
  19. M_HR_JOB_FREQ_VAL
  20. M_HR_MR_DAILY_CDAYS
  21. M_HR_POS_CDAYS
  22. M_JOB_RATES
  23. M_PAYABLE_TIME_ALL
  24. M_PAYABLE_TIME_MISSING
  25. M_PY_DEDUCTION_AUDIT
  26. M_PY_JOB_INFO
  27. M_PY_JOB_INFO_V1
  28. M_PY_JOB_INFO_V2
  29. M_PY_PAYCHECK_EARNS
  30. M_PY_PAYSHEET_ADJ_AUDIT
  31. M_PY_PAYSHEET_DEDN_AUDIT
  32. M_PY_PAY_VALIDATION
  33. M_PY_TL_TIME_EMPLID
  34. M_PY_VAL_GENL_DEDN_BEN
  35. M_PY__TL_REPORTED_TIME_EMPLID
  36. M_RET_BENEFIT_PLANS
  37. M_RET_BEN_PLAN
  38. M_RPTD_HRS_BY_DATE_RANGE
  39. M_RPTD_VS_PAYABLE_TIME
  40. M_RP_EMPL_CLASS
  41. M_SECTION_457
  42. M_TL_PAYABLE_AUDIT
  43. M_TL_PAYABLE_AUDIT_V2
  44. M_TL_REPORTED_TIME_AUDIT
To use a query, launch PeopleSoft HCM, then navigate to Main Menu > Reporting Tools > Query > Query Viewer. Enter the name or a portion of the query name (MR_HR_SALARY_GRADE_STEP, for example), then click Search. Click HTML to view the query onscreen; click Excel to download the query.