New HCM query to see Combo Codes and GL Accounts

posted May 16, 2014, 3:01 PM by Peyri Herrera
In PeopleSoft, combo codes are a new concept to many users accustomed to using account strings directly. In HCM, combo codes are simply a pointer or index number to a “chartstring” consisting of a valid combination of Fund, Resource, Goal, Function, Object and Site. Anywhere you need to enter a combo code in HCM, such as on the Job Earnings Distribution page or Timesheet, you can always search by any chart field and select the correct combo code from the search results. However, some people find an Excel spreadsheet or a printout listing all of their combo codes easier to search or quicker to refer to during data entry. Today, May 16, 2014, the CRC created a simple query in HCM called M_KK_COMBO_ACCTS_LIST that you can run. This query will show all of the combo codes for your district and the relevant chart field values that they map to. When prompted, enter your district’s SetID (business unit). The results are sorted by Fund, Resource, Goal, Function, Object, and Site.

  1. Log into the PeopleSoft Portal and launch HCM.
  2. Navigate to Main Menu > Reporting Tools > Query > Query Viewer.
  3. Search for M_KK_COMBO_ACCTS_LIST.
  4. Click HTML (for onscreen viewing) or Excel (to download). Enter your business unit, then click View Results.