Creating SetIDs

After you prepare for sharing your table, you define the setIDs that logically group information. When you define setIDs, you create groups that might naturally share more than one table. For example, although CCB and VNB are planning to share only the ACCT_CD_TBL now, the setIDs that you set up might define logical divisions in the organization that serve as the basis for sharing all accounting-related tables. Describe your sets to give them as broad an application as is practical in your organization.

If possible, use descriptions that denote the shared table and set control field. For example, for CCB and VNB, we added two tableset IDs, identifying them as related to accounting codes for companies:

setID	Description	Short Description
USA	Accounting Codes - USA Co.s	AcctCd USA
CAN	Accounting Codes - CAN Co.s	AcctCd CAN

You create setIDs on the TableSet ID page in PeopleTools, and then Utilities, and then Administration, and then Maintain TableSet IDs.