Table of Contents

Overview

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

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.

Group Store Table

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

Folder	Folder	Folder	Folder	Group Name
hawaii.edu:store:	sis:	curriculum:	<INST>:<COLL>:<DEPT>:<MAJOR--CONC---CAMPUS>:<LEVEL>:<DEGREE>:	<TERM>
"	"	instructor:	<TERM combinations>:	These instructor groups are no longer generally available. There are other, more efficient ways to get at this information. primary, (primary instructor) secondary, (secondary instructors, if any) primary+secondary
"	"	"	<TERM>:<INST>:	"
"	"	"	<TERM>:<INST>:<COURSE-ALPHA>:	"
"	"	"	<TERM>:<INST>:<COURSE-ALPHA>:<COURSE-NUMBER>:	"
"	"	"	<TERM>:<INST>:<COURSE-ALPHA>:<COURSE-NUMBER>:<CRN>:	"
"	"	registration:	<TERM combinations>:	enrolled
"	"	"	<TERM>:<INST>:	"
"	"	"	<TERM>:<INST>:<COURSE-ALPHA>:	"
"	"	"	<TERM>:<INST>:<COURSE-ALPHA>:<COURSE-NUMBER>:	"
"	"	"	<TERM>:<INST>:<COURSE-ALPHA>:<COURSE-NUMBER>:<CRN>:	enrolled, waitlisted, withdrawn Note that withdrawn groups may not be accurate as they do not include people who have completely withdrawn.
"	hris:	eac:		<eac> <college eac> (wildcard matching first four digits of EAC)
"	"	departmentID:		<departmentID> (available after 3/8/2022)
"	"	uhBargainingUnit		two-character bargaining unit
"	"	jobCode:		HR job code (e.g. 12345) HR job code wildcards (e.g. 123* and 1234*)
"	"	~~functionalCode:~~		This is obsolete and will eventually be removed HR functional code (e.g. 9876) HR functional code wildcards (e.g. 987* and 9876*)
"	"	aff:	<org>: any-org:	<role> <role combinations>
"	rcuh:	"	"	"
"	sece:	"	"	"
"	sis:	"	"	"
"	any-dataOrigin:	"	"	"
"	uhims:	"	"	"
"	"	general		Curated groupings: gcn-compliant gcn-compliant-renew isat-compliant isat-compliant-renew mfa-enabled faculty-staff Other: hris-fte-100 (100% full-time employees according to data coming from hris) under-age-of-majority aff-raw:<INST>\|any-org:preStudent[.admitted\|.accepted\|.applicant] (brings back applicant data that is lost when a person applies to one campus but is also registered at another campus)

References

<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

Role Combinations

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

A sample of the available store groups

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

hawaii.edu:store:any-dataOrigin:aff:uhm:faculty+staff
hawaii.edu:store:any-dataOrigin:aff:uhwo:overloadStaff
hawaii.edu:store:hris:aff:any-org:staff
hawaii.edu:store:uhims:aff:any-org:staff
hawaii.edu:store:any-dataOrigin:aff:hawcc:faculty+staff+student
hawaii.edu:store:rcuh:aff:rcuh:staff.noDetails
hawaii.edu:store:hris:aff:uhm:staff.nonCompensated
hawaii.edu:store:hris:aff:uhsystem:staff.executive

hawaii.edu:store:hris:eac:2211
hawaii.edu:store:hris:eac:22110100
hawaii.edu:store:hris:eac:22111100

hawaii.edu:store:sis:registration:201410:KAU:MATH:50:enrolled
hawaii.edu:store:sis:registration:201410:LEE:MATH:100:enrolled
hawaii.edu:store:sis:registration:201430:MAN:MATH:112:enrolled
hawaii.edu:store:sis:registration:201410:HAW:MATH:66:enrolled
hawaii.edu:store:sis:registration:201410:HIL:MATH:100:112233:enrolled
hawaii.edu:store:sis:registration:201410:HIL:MATH:100:223344:enrolled
hawaii.edu:store:sis:registration:201410:HIL:MATH:100:enrolled
hawaii.edu:store:sis:registration:201410:HIL:enrolled
hawaii.edu:store:sis:registration:201410:enrolled
hawaii.edu:store:sis:registration:20141:enrolled
hawaii.edu:store:sis:registration:2014:enrolled

hawaii.edu:store:sis:curricula:MAN:50:ARTH:ART:GR:MFA:201430
hawaii.edu:store:sis:curricula:MAN:50:ARTH:ART:GR:MFA:201430:begin-on-or-before
hawaii.edu:store:sis:curricula:MAN:50:ARTH:ART:GR:MFA:201430:end-before
hawaii.edu:store:sis:curricula:MAN:50:ARTH:ARTH:GR:MA:201430
hawaii.edu:store:sis:curricula:MAN:50:ARTH:ARTH:GR:MA:201430:begin-on-or-before
hawaii.edu:store:sis:curricula:MAN:50:ARTH:ARTH:GR:MA:201430:end-before
hawaii.edu:store:sis:curricula:MAN:50:PSY:PSY:GR:MA:201430
hawaii.edu:store:sis:curricula:MAN:50:PSY:PSY:GR:MA:201430:begin-on-or-before
hawaii.edu:store:sis:curricula:MAN:50:PSY:PSY:GR:MA:201430:end-before
hawaii.edu:store:sis:curricula:MAN:50:PSY:PSY:GR:PHD:201430
hawaii.edu:store:sis:curricula:MAN:50:PSY:PSY:GR:PHD:201430:begin-on-or-before
hawaii.edu:store:sis:curricula:MAN:50:PSY:PSY:GR:PHD:201430:end-before

Browser not supported