August 5, 2012

PeopleSoft HCM Setup tables

Business units, tablesets and setIDs

PeopleSoft regulates HRMS system data through the use of business units, tablesets, and setIDs.

Business Units
  • Business units are logical units that you create to track and report specific business information. Business units have no predetermined restrictions or requirements; they are a flexible structuring device that enable you to implement PeopleSoft HRMS based on how your business is organized.
  • You must define at least one business unit. The BUSINESS_UNIT field is included on all transaction tables.

Tablesets and SetIDs
  • Tablesets and setIDs are devices that enable you to share – or restrict – information across business units. For example, with tablesets and setIDs you can centralize redundant information such as country codes while keeping information such as departments and job codes decentralized. The overall goal of tablesets and setIDs is to minimize data redundancy, maintain data consistency, and reduce system maintenance tasks.
  • You must define at least one tableset/setID. The SETID key field is included on all control tables.

7 comments:

  1. Thanks for providing information on people soft adminpeople-softadmin

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. Hi,There are two kinds of partnerships for Business setup in Qatar; general partnerships and limited partnerships. In a general partnership, there are only a few formalities involved.Thanks.....

    ReplyDelete
  4. Hello Chandra, Good Information Thank you!

    Should We run all default programs after creating the user profile ? Like -- Refresh SJT Class All ; Trans SJT tables
    My client wants to implement SSOgen for Peoplesoft SSO..

    1. Peoplesoft SSO
    2. SSOGEN

    Any recommendations please?

    ReplyDelete
  5. Really enjoyed your article as its highly informative

    ReplyDelete