Set Control Values

Tablesets are identified by a set control value. The set control value is also a tableset ID. The set control value used to identify a tableset is not the same as the tableset ID that PeopleTools uses to retrieve the data from the tables in the database. Sometimes the set control value is the same as the tableset ID, but other times it is not.

Here is an example of how this works. Suppose that a community college district has three campuses and a main office:

Community College Office and Campuses	Tableset ID
Community College Main District Office	CCMDO
North Campus	NORTH
West Campus	WESTC
Far South Campus	SOUTH

Two of the campuses share location and facility information, and all three share the grading scheme and level or load rules. Here are the shared record groups:

Record Group	Campuses Sharing Record Groups
FACILITY (Facility table)	North Campus and West Campus
HR_03 (Location table)	North Campus and West Campus
CAREER (Grading Scheme and Level/Load tables)	North Campus, West Campus, and Far South Campus

This table shows how set control values and tableset IDs are used to identify which rows appear in prompt boxes:

Set Control Value	Record Group	Tableset ID
NORTH	FACILITY	NORTH
	HR_03	NORTH
	CAREER	CCMDO
WESTC	FACILITY	NORTH
	HR_03	NORTH
	CAREER	CCMDO
SOUTH	FACILITY	SOUTH
	HR_03	SOUTH
	CAREER	CCMDO