The CRC modified these 44 HCM queries so that currency values are displayed with two decimals (2619.00, for example): - MR_HR_SALARY_GRADE_STEP
- MR_JOB_DATA_FOR_VALID
- M_403B
- M_AM_DISTRICT_BALANCES
- M_AM_OVER_VAC_MAX
- M_AM_SICK_VAC_LIABILITY
- M_DAILY_CDAY_HRS
- M_EARNINGS_TBL
- M_EE_DCSA_GENL_DED
- M_EE_DUPLICATE_JED
- M_EE_FSA_GENL_DED
- M_EE_LTC_GENL_DED
- M_HR_ACTION_POS_0701
- M_HR_CERT_JULY_STEP_INCR
- M_HR_DW_DAILY_CDAYS
- M_HR_EMPL_CLASS
- M_HR_JOB_DATA_FOR_VALID
- M_HR_JOB_FOR_SD
- M_HR_JOB_FREQ_VAL
- M_HR_MR_DAILY_CDAYS
- M_HR_POS_CDAYS
- M_JOB_RATES
- M_PAYABLE_TIME_ALL
- M_PAYABLE_TIME_MISSING
- M_PY_DEDUCTION_AUDIT
- M_PY_JOB_INFO
- M_PY_JOB_INFO_V1
- M_PY_JOB_INFO_V2
- M_PY_PAYCHECK_EARNS
- M_PY_PAYSHEET_ADJ_AUDIT
- M_PY_PAYSHEET_DEDN_AUDIT
- M_PY_PAY_VALIDATION
- M_PY_TL_TIME_EMPLID
- M_PY_VAL_GENL_DEDN_BEN
- M_PY__TL_REPORTED_TIME_EMPLID
- M_RET_BENEFIT_PLANS
- M_RET_BEN_PLAN
- M_RPTD_HRS_BY_DATE_RANGE
- M_RPTD_VS_PAYABLE_TIME
- M_RP_EMPL_CLASS
- M_SECTION_457
- M_TL_PAYABLE_AUDIT
- M_TL_PAYABLE_AUDIT_V2
- 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.
|