Return to Navigation

Understanding Data Sharing Among Business Units

The PeopleSoft system uses business units to separate organizations within the institution. Although each business unit represents a separate organization, there is data that is shared throughout the institution. Business units can share data by using tableset sharing, which is a way to share control table information among business units to minimize redundant data and system maintenance tasks.

This section discusses:

Tableset sharing is the sharing of common control tables among business units. There are two types of tables in the PeopleSoft system that are used to store data.

Field or Control


Control Tables

These tables store master lists of information; for example, department names and account codes. This data is maintained centrally by the institution and is generally entered once at implementation, and it changes little over time.

The structure and processing rules for each of the PeopleSoft applications you are using are defined in a series of control tables.

Control tables are usually keyed by tableset ID and are usually effective-dated.

Transaction Tables

These tables store day-to-day business activity and are updated frequently. They are keyed by business unit.

Control tables enable you to use tableset IDs, which make tableset sharing possible. The tableset ID indicates which of the rows in the control table a particular business unit can access. Each row in the control table has a tableset ID associated with it and business units are associated with tableset IDs through record groups:

Image: Business units and tableset IDs associated through record groups

Business units pass data through record groups to tableset IDs.

Business units and tableset IDs associated through record groups

Note: The tableset ID is also referred to as the setID. These terms are interchangeable.

If much of the control table data is the same from business unit to business unit, tableset sharing enables you to share that information among business units instead of having to enter the same data multiple times. For example, suppose that an institution has 10 business units and they all use the same accounts. Instead of having to enter all of the accounts 10 times, you could enter them once and set up tableset sharing to enable all of the business units to access them.

Tableset sharing also enables you to manage exceptions within the organization. For example, suppose that 9 of the 10 business units use the same accounts, but the tenth business unit uses entirely different accounts. This is easily accommodated through tableset sharing.

The two following tables show how different business units access a centralized control table based on tableset ID. In the example, there are three tableset IDs—MAINC, EASTC, and WESTC—representing three campuses. The account number information for all campuses is contained in a single control table. Allowing access to certain tableset IDs can restrict access to the account number information. For example, East Campus (EASTC) can view only its two account numbers when it accesses the control table.

Here are the accounts for all three campuses:

Tableset ID

Account Number













This view shows only the accounts for East Campus:

Tableset ID

Account Number








See PeopleTools: Data Management, "PeopleTools Utilities."

Here are some examples of the control tables keyed by tableset ID for each application in Campus Solutions. This information can help you decide how the data can be segmented, so that you make the correct decisions when setting up the tableset IDs and assign the correct tableset IDs to record groups.

Note: This list is not exhaustive.

This table lists some examples of control tables keyed by tableset ID:

PeopleSoft Application

Control Tables Keyed by Tableset ID

PeopleSoft Student Records



GRADESCHEME_TBL - Grading Schemes

LVL_LD_RULE_TBL - Level/Load Rules

PROG_RSN_TBL - Program Action Reasons

REPEAT_SCHM_TBL - Repeat Schemes

TIME_PERIOD_TBL - Time Periods

UNIT_CONVR_TBL - Unit Conversions

PeopleSoft Student Financials

ACCT_TYP_TBL_SF - Account Types

ACC_AGE_FEE_TBL - Aging Late Fee table

ACC_AGING_TBL - Account Aging table

ADJ_CODE_TBL - Adjustment Code table

ADJ_REASON_TBL - Adjustment Reason table

ADJ_TERM_CD_TBL - Adjustment Term Code table

ADJ_TERM_TBL - Adjustment Term table

AGING_CAT_TBL - Aging Category table

AGING_TBL - Aging table

APP_FEE_CD_TBL - App Fee Code table

APP_FEE_TBL - Application Fee table

APP_FEE_TND_TBL - App Fee Tender and Item Types

APP_SF_CD_TBL - App Sub-Fee Code table

APP_SUBFEE_TBL - App Sub Fee table

BANK_ACCT_MTHD - Bank Account Payment Method

BI_ACCT_STD_REQ - Accounts for Std Req

BI_ACDPROG_STAT - Std Req Academic Prog Status

BI_ADMPROG_STAT - Std Req Admissions Prog Status

BI_BILL_MSG_TBL - Billing Msg table for SF

BI_CAR_STD_REQ - Career for Std Req

BI_COM_STD_REQ - Communication Std. Request

BI_IVC_FIELDS - Billing Invoice Field table

BI_IVC_LAYOUT - Billing Invoice Layout

BI_MSG_CAT_TBL - Billing Message Cat table

BI_PRINT_RQST - Billing Standard Print Request

BI_REQ_MSG - Billing Request Message

BI_STD_REQ_GRP - Billing Student Groups

BI_STD_REQ_TBL - Billing Standard Request table

BI_TERM_STD_REQ - Terms for Std Req

BI_TYPE_TBL - Billing Type table

BNK_RCN_INP_LAY - Bank Recon Input File Layout

PeopleSoft Student Financials (cont.)

BNK_RCN_INP_TRN - Bank Transaction Code

CALC_CNTL_SESS - Tuition Calc Control Sessions

CALC_CNTL_TBL - Tuition Calculation Controls

CALC_CNTL_TERM - Tuition Calc Control Terms

CALC_ON_REFUND - Calc on Refund Control

CLASS_FEE_TBL - Class Fee table

CLASS_SBFEE_TBL - Class Sub Fee table

CLST_FEE_TBL - Course Fee table

CLST_SUBFEE_TBL - Course Sub Fee table

CLS_CANCEL_SF - Class Cancellation Code table

COLL_LTRITM_TBL - Collection Letter Item table

COLL_LTRTMP_TBL - Collection Letter Template table

CO_VOID_RSN_TBL - Void Reasons

CREDIT_CARD_TYP - Credit Card Type

CRSE_FEE_ID_TBL - Course Fee ID table

CRSE_FEE_TBL - Course Fee table

CRSE_LST_DTL_SF - Course List Detail

CRSE_LST_HDR_SF - Course List Header

CRSE_RATE_TBL - Course Rate table

CRSE_RT_ID_TBL - Course Rate ID table

CRSE_SUBFEE_TBL - Course Sub Fee table

DEP_DUE_DT_TBL - Deposit Date table

DEP_FEE_CD_TBL - Deposit Fee Code table

DEP_FEE_TBL - Deposit Fee table

DEP_FEE_TRM_TBL - Deposit Fee Term table

DISP_ERR_CNTL - Display Error/Warn Control

DUE_CODE_TBL - Due Date Code table

DUE_DATE_CD_TBL - Due Date Code table

DUE_DATE_TBL - Due Date table

PeopleSoft Student Financials (cont.)

EG_PROJECT - E&G Operational Projects

FEE_CLASS_TBL - Fee Class table

FEE_TBL - Fee table

FINCODE_TBL - FinCode table

GL_INTERFACE - General Ledger Interface

GL_INT_CD_TBL - General Ledger Dummy Parent

GL_INT_DT_TBL - General Ledger Dummy Parent II

GROUP_TYPE_SF - Group Type


ITEM_ACCT_TYPE - Valid Account Types

ITEM_AGG_TBL - Item Aggregate table

ITEM_FA_CD_TBL - Item Type Code table

ITEM_GROUP_DTL - Item Type Group Details

ITEM_GROUP_TBL - Item Type Group table

ITEM_TYPE_1_TBL - Item Type Control table

ITEM_TYPE_FISCL - Fiscal Item Type table

ITEM_TYPE_FNOTE - Fiscal Item Type Notes table

ITEM_TYPE_TBL - Item Type table

JRNLGEN_DEFN - Journal Generator Definition

LATE_FEE_AGING - Late Fee Aging Category table

LATE_FEE_CD_TBL - Late Fee Code table

LATE_FEE_LOAD - Late Fee Acad Program table

LATE_FEE_PROG - Late Fee Acad Program table

LATE_FEE_SCHEME - Late Fee Scheme table

LATE_FEE_TBL - Late Fee Setup table

LED_FLDS_SF_TBL - ChartFields

LED_FLDS_TBL - ChartFields

LED_SF_TBL - ChartFields Parent Rec

LINE_REASON_TBL - Line Reason table

PeopleSoft Student Financials (cont.)

MAX_FEE_ADM_TRM - Max fee for Admit Term

MIN_MAX_FEE - Min/Max fee table

MIN_MAX_FEE_CAR - Min/Max fee for Acad Career

MIN_MAX_FEE_PGM - Min/Max Fee for Acad Program

MIN_MAX_FEE_SES - Min/Max Fee for Session

MIN_MAX_FEE_TRM - Min/Max Fee for Term

MIN_MAX_FEE_YR - Min/Max Fee for Academic Year

OPT_FEE_CAR - Optional Fee Careers

OPT_FEE_CD_TBL - Optional Fee Codes table

OPT_FEE_TBL - Optional Fees table

OPT_FEE_TERM - Optional Fee Terms

OPT_FEE_TRM_EF - Optional Fee Effdts for a Term

OPT_FEE_TRM_LD - Optional Fee Academic Loads

OPT_FEE_TRM_VAL - Optional Fee Values for a Term

OPT_FEE_VAL - Optional Fee Values

ORIGIN_TBL - Group & Deposit Origins

PAY_PRIOR_ALL - Payment Priority Overall

PMT_CHRG_PRIOR - Payment Charge Priority

PMT_CHRG_TBL - Payment Charge Priority table



SEC_ITEM_CLS - Item Security - Perm List

SEC_ITEM_OPR - Item Security - User Data

SEC_SETID_CLS - User ID Access to SetIDs

SEC_SETID_OPR - User ID Access to SetID

SEL_VALID_FIELD - Selector Group Valid Fields

SEL_VALID_RECS - Selector Group Valid Records

SEL_VALUE_OLD - Selector Values table

SF_ACCT_CLASS - SF Account Class

SPEEDTYP_TBL - Speed Types

SPEED_USER_TBL - Work Table for Speed Types

PeopleSoft Student Financials (cont.)

TAX_AUTHORITY - Tax Authority Detail Info

TAX_AUTH_HDR - Tax Authority Header Info

TAX_CD - Tax Authorities in a Tax Code

TAX_HEADER_TBL - Tax Code Header Information

TERM_FEE_RES - Term Fee Resident table

TERM_FEE_TBL - Term Fee table

TERM_FE_CD_TBL - Term Fee Code table

TERM_SF_CD_TBL - Term Sub Fee Code table

TERM_SUBFEE_TBL - Term Sub Fee table

TP_STATUS_TBL - Third-party Contract Status

TRANS_FEE_HDR - Transaction Fees Header

TRANS_FEE_TBL - Transaction Fees

TRANS_FE_CD_TBL - Transaction Fee Codes

VALID_RECORD_SF - Valid Records for Selectors

VENDOR_SF_TBL - SF to Vendor interface table

WAIVER_CODE_TBL - Waiver Code table

WAIVER_FORM_TBL - Student Waivers

WAIVER_GRP_DTL - Waiver Group Detail table

WAIVER_GRP_TBL - Waiver Group table

WAIVER_TBL - Waiver table

WVR_GRP_CD_TBL - Waiver Group Code table

PeopleSoft Recruiting and Admissions

PSTREEDEFN - PeopleTools table used in the creation of the Region Tree

PeopleSoft Financial Aid

AWD_MESSAGE_TBL - Award Messages/Comments

BDGT_REGION_TBL - Budget Region table

ITEM_TP_FA_DISB - Item Type Disb Plan/Split Cd

ITEM_TYPE_FA - Item Type Table SFAG

ITEM_TYP_FA_FEE - Item Type Fee table

ITM_TP_TERM_LMT - Award Limits by Term Type

LN_FEE_TBL - Loan Fee table

LN_ITEM_FEE - Loan Item Type Fee table

LN_ITEM_TBL - Loan Item Type table

RSTRC_AID_ITEM - Restricted Aid IDs/Item Type

PeopleSoft Contributor Relations

AV_ACCOUNT_TBL - Designation Funds

AV_INST_TYP_TBL - Designation Types

AV_ITEM_TBL - Donor Appreciation Items

AV_MBR_CAT_TBL - Membership Categories

AV_MBR_TYP_TBL - Membership Types

AV_MTVTN_INTV - Appeals linked to Initiative Codes

AV_MTVTN_TBL - Appeal Codes

AV_ORIG_DNR_TBL - Original Donors to Designation Funds

AV_TENDER_TBL - Tender Types

AV_TRIB_TBL - Tributes on Designation Funds

A record group is a set of functionally or logically related records or views based on how the records are used in the system. A record group can contain a single record or view, or it can contain many records and views. Record groups are delivered as part of the PeopleSoft system and should not be altered.

When you create a business unit, that business unit is automatically linked to each record group in the system that you are using.

Record groups exist for two purposes:

  • To save time in data entry.

    With record groups, tableset sharing can be accomplished quickly and easily instead of requiring redundant data entry.

  • To provide consistency in the data.

    Record groups ensure that tableset sharing is applied consistently across all related tables and views in the system.

When you create and then save a business unit, a new tableset ID with the same name as the business unit is created. The system automatically assigns that tableset ID to each record group for the new business unit.

Note: PeopleSoft suggests that you create tableset IDs and business unit names that are five characters long. A performance degradation occurs if the tableset IDs or business units have fewer than five characters.

This diagram illustrates the relationship between business unit, record group, and tableset ID:

Image: Relationship between business unit, record group, and tableset ID

This example shows how data can pass from a business unit through three record groups and into tableset IDs.

Relationship between business unit, record group, and tableset ID

Tableset IDs are the labels that the system uses to identify tablesets. You can have as many tableset IDs as you like, but the more you have, the more complex tableset sharing becomes. You always have the same number of tableset IDs as tablesets.

Warning! You must define at least one complete set of these tables—a tableset—for the Campus Solutions system to function.

Note: You must create at least one tableset ID, even if you are not taking advantage of tableset sharing. Some institutions need only one tableset ID and one business unit.

When you set up the control tables in the system, you'll notice that the tableset ID, or additional primary key, enables the sharing of control table information across business units. If you prefer, you can create a unique set of tables for each new business unit. Either way, tablesets form the building blocks of the system. You populate the individual tables in the tableset according to your particular business rules.

You can also rearrange tablesets by updating tableset assignments for a business unit in the Utilities - TableSet Controls component. A tableset is a group of control table rows identified by the same tableset ID.

You are not required to share all tables in a tableset. With Campus Solutions, you can share any combination of tables with any number of business units, according to your needs. Use the pages in the component to identify, for each business unit, which data is shared and how it is shared.

Tableset sharing can be extremely easy for an organization to design. In fact, it is almost entirely set up by the time you have finished creating the business units.

When defining tableset IDs for Contributor Relations, you must manually create a setID in the tableset ID record, if one does not already exist that matches the Contributor Relations business unit.

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


North Campus


West Campus


Far South Campus


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






























With tableset sharing, you can specify the control table data that the system uses for each business unit. If much of the control table data is the same from business unit to business unit, tableset sharing enables you to share that information, instead of having to enter the same data multiple times.

To understand how this works in the PeopleSoft system, consider what happens when a user makes a selection from the available options. The list that appears contains all of the valid entries that can be entered in the field based on the relevant business unit.

This series of questions outlines the online process that occurs:

Image: Tableset sharing process

These five questions step users through the tableset sharing process.

Tableset sharing process

Note: Record groups and setIDs for a set control value have a one-to-one relationship.