The UH Group Store is populated with data from official sources such as Banner, PeopleSoft, RCUH, SECE and UHIMS.  

Direct access to store groups is not allowed. You must request a grouping and specify the store groups it will use. Use this resource to understand the store groups available for designing the Basis for your grouping.  Store groups can be combined using set theory to address complex requirements if needed.

Here's is a table that provides an overview of the groups available:

• <COLL> is the Banner college code

• <departmentID> is an 8-character code from the PeopleSoft HR system which identifies a department in the org chart.

• <college eac> is the first 4 digits of the EAC, used as a super group of all EAC groups for that college

  • For example, there is no actual 22110000 EAC that is attached to a person in PeopleSoft, but we can offer a store group for all groups whose EAC begins with 2211 as hawaii.edu:store:hris:eac:2211

  • hawaii.edu:store:hris:eac:2211 is a group that esentially represents Manoa's College of Arts & Humanities by being a group of these EAC groups:

    • hawaii.edu:auto:hris:eac:22110100 A&H DEANS OFF
      hawaii.edu:auto:hris:eac:22111100 AMER STUDIES DEPT
      hawaii.edu:auto:hris:eac:22111200 DEPT OF ART AND ART HISTORY
      hawaii.edu:auto:hris:eac:22111300 THEATRE & DANCE DEPT
      hawaii.edu:auto:hris:eac:22111400 HISTORY DEPT
      hawaii.edu:auto:hris:eac:22111500 MUSIC DEPT
      hawaii.edu:auto:hris:eac:22111600 PHILOSOPHY DEPT
      hawaii.edu:auto:hris:eac:22111700 RELIGION DEPT
      hawaii.edu:auto:hris:eac:22111800 DEPARTMENT OF COMMUNICOLOGY
      hawaii.edu:auto:hris:eac:22111900 ACADEMY FOR CREATIVE MEDIA
      hawaii.edu:auto:hris:eac:22211100 INSTRUCTION

• <COURSE-ALPHA> the code for the course subject, e.g. ECON in ECON 101

• <COURSE-NUMBER> the course number, e.g. 101 in ECON 101

• <CRN> uniquely identifies each course being offered, even across sections.

• <DEGREE> is the degree being pursued (e.g. BA, MA, PHD)

• <DEPT> is the Banner department code

• <eac> is an actual PeopleSoft HR EAC value, e.g. 22503100 is for ITS

• <INST> is the Banner institution code, e.g. MAN, KAP, HON

• <LEVEL> has values such as UG (undergraduate) and GR (graduate)

• <MAJOR--CONC—CAMPUS> is most of the time just the major as stored in Banner, but if applicable, it can include the concentration (preceded by two hyphens) and Banner's "campus," which usually refers to one of the ten campuses plus other codes, such as those used for distance learning.

• <org> are the same values used by UHIMS Events - Message Specs

• <role> are the same values used by UHIMS Events - Message Specs

• <role combinations> are useful combinations of <role> values, e.g.

  • faculty+staff

  • faculty (encompasses all faculty.* values)

  • See <role combinations> for a complete list.

• <TERM> is an actual term code, e.g. 201410 = Fall 2015

• <TERM combinations> exist for the first 4 and first 5 digits in <TERM>, e.g.

  • 20141 includes all <TERM> that begin with 20141 (e.g. 201410, 201411, 201413), e.g.

    • hawaii.edu:store:sis:registration:20141:enrolled

  • 2014 includes all <TERM> that begin with 2014 (e.g. 201410, 201411, 201413, 201430, etc.), e.g.

    • hawaii.edu:store:sis:registration:2014:enrolled

All affiliation-based store groups offer the following role combinations as an added convenience:

• casual

• casualFaculty

• casualStaff

• faculty

• faculty+staff

• faculty+staff+student

• faculty+staff+student+other

• faculty+student

• faculty.communityCollege

• faculty.countyAgent

• faculty.courseInstructor

• faculty.emeritus

• faculty.graduateAssistant

• faculty.graduateAssistant.overload

• faculty.law

• faculty.lecturer

• faculty.lecturer.casual

• faculty.lecturer.overload

• faculty.librarian

• faculty.medical

• faculty.noDetails

• faculty.noDetails.casual

• faculty.noDetails.overload

• faculty.researchAssistant

• faculty.researcher

• faculty.specialist

• faculty.teachingAssistant

• faculty.university

• nonCreditStudent

• nonCreditStudent.noDetails

• ohana

• other

• overload

• overloadFaculty

• overloadStaff

• preStudent

• preStudent.accepted

• preStudent.admitted

• preStudent.financialAid

• retiree

• staff

• staff.apt

• staff.apt.casual

• staff.apt.overload

• staff.civilService

• staff.executive

• staff.noDetails

• staff.noDetails.casual

• staff.nonCompensated

• student

• student.graduate

• student.graduate.law

• student.graduate.medical

• student.graduate.noDetails

• student.other

• student.other.apprenticeship

• student.other.continuingEducation

• student.other.postBaccalaureate

• student.other.professional

• student.other.undeclared

• student.undergraduate

• student.undergraduate.noDetails

• studentEmployee

• studentEmployee.studentHire

• studentEmployee.workStudy

• The store groups are preselected useful combinations of groups provided for convenience.