Defining Your Operational Structure

This chapter provides an overview of the PeopleSoft table setup procedure and discusses how to:

Click to jump to parent topicUnderstanding PeopleSoft Table Setup

PeopleSoft applications rely on tables to store your business transactions as well as the structure and processing rules that drive your system. Before you start, set up your basic framework using the pages in PeopleTools . If you are integrating with PeopleSoft Pay/Bill Management, some of this framework should be defined first in other core Financials or HCM applications. You should work closely with administrators from your human resource and financials areas as you prepare to populate these tables.

Because of the relational design of PeopleSoft applications, the order in which you make important decisions about using the application is not necessarily the order in which you use the online pages to set up the database tables. Certain tables work as a group when you make processing or implementation decisions; therefore, you must establish data in some tables before others.

Click to jump to parent topicSetting Up Your General Business Environment

To set up your business environment, use the TableSet Control (SETID_TBL) and Staffing Branch (FO_BRANCH_TBL) components.

Your implementation team must decide how to classify your organization's data in Staffing Front Office. This involves determining how to define your TableSet sharing. This section provides an overview of TableSet sharing and discusses how to:

See Also

Defining Staffing Installation Options

Click to jump to top of pageClick to jump to parent topicUnderstanding TableSet Sharing

TableSet sharing is a way to share common information among business units. The key to sharing that information is defining what data is available under specific circumstances. To do this, PeopleSoft uses setIDs. TableSet sharing consists of assigning setIDs to specific record groups.

PeopleSoft Staffing Front Office provides several record groups for business unit and setID functionality.

Record groups ensure that TableSet sharing is applied consistently across related tables and views in your system. A record group can contain a single table or many tables and views. Because table sharing is defined by a record group and not by individual tables, you do not need to know every table that is involved in a particular function, such as establishing customers.

For example, mapping a new setID to record group FO_01 links that setID to all views and tables that are contained in that record group. PeopleSoft delivers your Staffing Front Office system with all tables and views assigned to record groups.

Note. Set up TableSet controls if you are sharing data across business units. If you are integrating with PeopleSoft Pay/Bill Management, the setIDs used for customers, vendors, departments, and rates must match the setIDs used within the Financials and HRMS databases.

Branches

Branches offer your organization a structuring device through which you can implement PeopleSoft Staffing Front Office based on how your business is organized. Your branches might be companies, subsidiaries, divisions, departments, or branch offices within your organization.

Each branch is actually a separate part of your organization. For example, you might have a southwest staffing branch and a southeast staffing branch for temporary resources.

When you establish branches in Staffing Front Office, be aware that no predefined definitions exist; use the branch organizational level in the ways most useful to you.

URL Maintenance

Staffing Front Office enables you to interact with your intranet and the Internet. Some functions in Staffing Front Office draw upon stored uniform resource locators (URLs) or web site addresses. URLs are used, for example, by the attachment function and to check stock quotes. You can add other URLs to accommodate future enhancements.

Click to jump to top of pageClick to jump to parent topicPages Used to Set Up Your General Business Environment

Page Name

Definition Name

Navigation

Usage

TableSet Control

SETID_TBL

PeopleTools, Utilities, Administration, TableSet IDs

Establish TableSet IDs to share within your environment.

URL Maintenance

URL_TABLE

PeopleTools, Utilities, Administration, URLs

Set up URLs to interact with your intranet and the Internet.

Staffing Branch

FO_BRANCH_TBL

Set Up Financials/Supply Chain, Product Related, Staffing, General, Branch/BU Mapping

Define branch information and business unit mapping.

Click to jump to top of pageClick to jump to parent topicEstablishing TableSet IDs

Access the TableSet Control page (PeopleTools, Utilities, Administration, TableSet IDs).

Description

Enter a name to identify the TableSet control.

Short Description

Enter a short name to identify the TableSet control.

Warning! TableSet IDs must be five characters long to avoid affecting system performance.

Click to jump to top of pageClick to jump to parent topicSetting Up URLs

Access the URL Maintenance page (PeopleTools, Utilities, Administration, URLs).

URL Identifier

Displays the URL identifier that you entered. Define two values on this page for PeopleSoft Staffing Front Office. Values are:

ATTACHMENTS: Defines the file transfer protocol (FTP) that specifies where in your network to store files that are attached to records in your Staffing Front Office components. For example, the path that is specified in the URL field is where you store resumes that are attached to an applicant's data. Be sure to use the exact value.

STOCK_SYMBOL: Specifies the website in which to find stock quotes for a company. You can find a customer's current stock value by clicking the stock quote link in the Customer component. Be sure to use the exact value.

Description

Enter a name to identify the URL.

URL

Enter the URL of the web link or FTP server that you are setting up.

Note. URLs must be preceded by http:// to function properly.

Click to jump to top of pageClick to jump to parent topicSetting Up Branches

Access the Staffing Branch page (Set Up Financials/Supply Chain, Product Related, Staffing, General, Branch/BU Mapping).

Branch

Select the ID of the staffing branch.

Description and Short Description

Enter the name of the branch or region. The system uses this value on reports, and on your internal website if you publish orders.

Fixed Cost Margin

Enter the average overhead percentage rate for this branch, not including workers' compensation. The system uses this percentage to calculate the margin for your assignments. This value appears by default in the Order Margin estimator.

Rate Type

Select the rate type that you want to use for this branch.

Note. You must set up TableSet controls if you share data across business units.

Business Unit Mapping

Contracts Business Unit

Displays the PeopleSoft Contracts business unit associated with the branch.

Note. This field appears only if you have Pay/Bill Management installed. When an order is first saved with a status different than Draft, PeopleSoft Pay/Bill Management automatically creates a contract in the PeopleSoft Contracts application using the contract business unit associated with the staffing branch specified in the job order.

PC Business Unit

Displays the PeopleSoft Project Costing business unit associated with the branch.

Note. This field appears even if you do not have PeopleSoft Pay/Bill Management installed since a PeopleSoft Project Costing business unit is part of the key of the order transaction. If PeopleSoft Pay/Bill Management is installed, however, when an order is first saved with a status different than Draft, the system automatically creates a project in the PeopleSoft Project Costing application using the projects business unit associated with the staffing branch specified in the job order.

AP Business Unit

The PeopleSoft Payables business unit associated with the branch.

Note. This field appears only if you have PeopleSoft Pay/Bill Management installed. When temporary assignments are created for non-employees, PeopleSoft Pay/Bill Management provides functionality to automatically create a voucher in the PeopleSoft Payables application using the non-employee time reported in PeopleSoft Time and Labor. PeopleSoft Pay/Bill Management creates this voucher using the AP Business Unit associated with the staffing branch specified in the order.

Location Code

Enter the physical address of the branch.

Click to jump to top of pageClick to jump to parent topicSetting Up PeopleSoft Project Costing Business Units

Staffing orders are keyed by PeopleSoft Project Costing business units—even if you are not using PeopleSoft Project Costing. You must set up PeopleSoft Project Costing business units and map the staffing branches to the corresponding PeopleSoft Project Costing business unit. If you have PeopleSoft Staffing Front Office without PeopleSoft Pay/Bill Management, this is the only PeopleSoft Project Costing related configuration you must complete.

See Defining Project Business Units.

Click to jump to parent topicDefining Common Definitions

This section discusses how to:

Click to jump to top of pageClick to jump to parent topicPages Used to Define Common Definitions

Page Name

Definition Name

Navigation

Usage

Auto Numbering

AUTO_NUM_PNL

Set Up Financials/Supply Chain, Common Definitions, Codes and Auto Numbering, Auto Numbering

Set up automatic numbering for customers, contacts, and affiliate vendors.

Note. Orders and assignments do not use the autonumbering table, but instead use the Last EmpliD Used field on the Installation Options - Staffing page. Affiliate vendor autonumbering is only applicable if you have PeopleSoft Staffing Front Office installed without PeopleSoft Pay/Bill Management.

See Defining Additional Common Information.

Market Rate Type

RT_TYPE_TBL

Set Up Financials/Supply Chain, Common Definitions, Market Rates, Market Rate Type

Define rate types to further categorize market rates.

See Defining Market Rate Types.

Country Description

COUNTRY_DEFN

Set Up Financials/Supply Chain, Common Definitions, Location, Country

Add or review country descriptions.

See Reviewing Country Descriptions.

State

STATE_DEFN

Set Up Financials/Supply Chain, Common Definitions, Location, State

Add or review a state or province codes.

See Reviewing State and Province Descriptions.

Note. PeopleSoft HCM has additional state codes for the United States that begin with special characters. These State codes are used by PeopleSoft Payroll. Therefore, you should not synchronize the HCM and Financials state tables.

Currency Code

CURRENCY_CD_TABLE

Set Up Financials/Supply Chain, Common Definitions, Currency, Currency Code

Add or update currency codes.

See Maintaining Currency Tables.

National ID Types

NID_TYPE_TABLE

Set Up Financials/Supply Chain, Product Related, Staffing, Resources, National ID Types

Assign a national ID type to a country code and provide a default national ID value.

Note. This configuration component is used only for Staffing Front Office when implemented without PeopleSoft Pay/Bill Management. If you have implemented PeopleSoft Pay/Bill Management along with PeopleSoft Staffing Front Office, synchronize this table from the HCM configuration.

The Default field is used for synchronization with PeopleSoft back-office applications only. The system does not automatically enter national IDs with a default value in PeopleSoft Staffing Front Office. PeopleSoft Staffing Front Office uses a blank for the default value.

Click to jump to parent topicSetting Up User Preferences

To set up user preferences, use the Staffing (OPR_DEF_TABLE_FO) component.

User preferences are a way to set up default values that facilitate faster data entry into transaction tables. The users can override these default values on the application pages.

This section discusses how to:

Click to jump to top of pageClick to jump to parent topicPages Used to Set Up Staffing User Preferences

Page Name

Definition Name

Navigation

Usage

Staffing - General Preferences

OPR_DEF_TABLE_FO1

Set Up Financials/Supply Chain, Common Definitions, User Preferences, Define User Preferences

Click the Staffing - General Preferences link.

Set up general user preferences.

See Defining Staffing General Preferences.

Staffing - Job Data

OPR_DEF_TABLE_FO2

Set Up Financials/Supply Chain, Common Definitions, User Preferences, Define User Preferences

Click the Staffing - Job Data link.

Define PeopleSoft Staffing Front Office default values for the Job Data section of the Applicant setup pages.

See Defining Staffing Job Data Preferences.

Click to jump to parent topicSetting Up Security

To set up security, use the following components:

You can grant access to a department, setID, or business unit using permission lists or user IDs. The pages that you use to define security using permission lists or user IDs work the same way. We discuss security for setIDs and business units in the PeopleSoft Enterprise Application Fundamentals 9.1 PeopleBook. Department security is specific to PeopleSoft Staffing Front Office.

This section provides an overview of security and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Security

This section discusses:

Department Security

You must assign every applicant and employee who is entered in PeopleSoft Staffing Front Office to a department. Associating a department with an employee is necessary for payroll processing and data security. All PeopleSoft users have individual security profiles that define the data that they can view or update.

You cannot access information about applicants or employees if you have not completed department security correctly.

These items must be set up for department security to work correctly:

Your security administrator should set up the department security tree using PeopleSoft Tree Manager and department security tables. Departments are setID-driven.

To enable data entry for applicants and employees, assign the user permission lists to the appropriate level in the security tree. The users with a particular permission list have access to that department's data and all data that falls underneath the department in the department tree.

Place departments on a department tree in your organization's appropriate reporting structure. You do so to ensure that the correct people at each level access the correct data.

To enter and retrieve applicant and employee data in PeopleSoft Staffing Front Office, add all active departments to the tree manager table that is linked to your PeopleSoft logon.

Note. To gain access to an applicant or employee, add the department to the department tree under PeopleSoft Tree Manager. In addition, you must add the node (or a higher level node) to the permission list for that user under Department Security in Set Up Staffing. When you select a department for the applicant, all departments appear regardless of security. Consequently, you can mistakenly add an applicant for which no access exists.

See PeopleTools PeopleBook: PeopleSoft Tree Manager PeopleBook

Business Unit and SetID Security

You maintain business unit and setIDs in edit tables. You can use them as primary keys throughout the system. When a field uses an edit table to select values, you can select only the values that have been defined for that table. When PeopleSoft row-level application security is activated, you can specify values from the edit table so that only those values are available in a particular view.

Views are a means to access data horizontally across more than one table. Views are Structured Query Language (SQL) statements that filter out data rows whose key values are not needed as valid access parameters. The result is that users with the authority to access setIDs and business units see only a subset of the values from these edit tables.

After views are set up, you can specify which users or permission lists can access the pages that contain secured field values.

PeopleSoft delivers its applications with security views that apply to the key fields in your system. You can alter these views or build views of your own. A view name has one of these three file extensions to reflect the type of security for the view:

After you select your security options and set up security view names, you can define the actual secured field values that are used by each user or permission list. The page that you use to secure fields in your application depends on your level of system security. If you select operator-level security, you utilize user security pages. If you select class-level security, you use the permission list security pages.

See Also

PeopleTools PeopleBook: PeopleTools Security, "Understanding PeopleSoft Security"

Click to jump to top of pageClick to jump to parent topicPages Used to Set Up Security

Page Name

Definition Name

Navigation

Usage

Department

DEPARTMENT

Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Define Values, ChartField Values, Department

Create a departmental reporting structure.

Note. If you have PeopleSoft Staffing Front Office and PeopleSoft Pay/Bill Management you can set up departments in either HCM or in Financials and application messaging will synchronize the information. If you add departments in Financials and the information is sent by application messaging to HCM, you must populate extra fields in the HCM department component that are not visible in the Financials department component.

See Adding Department Values.

Department Security

SCRTY_TABL_DEPT

Set Up Financials/Supply Chain, Security, Staffing Department Security

Assign users permission lists to the appropriate department in the tree structure.

Department Security

FO_APPLY_SCTY

Set Up Financials/Supply Chain, Security, Staffing Apply Security Tree

Update security entries for security trees.

Business Unit Security by Permission List

SEC_BU_CLS

Set Up Financials/Supply Chain, Security, Unit by Permission List

Set up the information that an operator can access when prompting for business units. Accessed by permission list, this page displays all the business units that are accessible by the operators associated with a given permission list.

See Defining Row-Level Security.

Business Unit Security By User ID

SEC_BU_OPR

Set Up Financials/Supply Chain, Security, Unit by User ID

Grant access to business units using user IDs.

See Defining Row-Level Security.

TableSet Security by Permission List

SEC_SETID_CLS

Set Up Financials/Supply Chain, Security, TableSet by Permission List

Grant access to setIDs using permission lists.

See Defining Row-Level Security.

TableSet Security by User ID

SEC_SETID_OPR

Set Up Financials/Supply Chain, Security, TableSet by User ID

Grant access to setIDs using user IDs.

See Defining Row-Level Security.

Security Views

SECURITY_VIEWS

Set Up Financials/Supply Chain, Security, Security View Names

Define the type of security for each view of your system.

See Defining Security Views.

Apply Security Setups

RUN_FIN9001

Set Up Financials/Supply Chain, Security, Apply Security Setups

Run the process to apply your security options.

See Specifying System Security Options.

Click to jump to top of pageClick to jump to parent topicCreating a Departmental Reporting Structure

Access the Department page (Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Define Values, ChartField Values, Department).

Status

Select the current status of the department. Values are Active or Inactive.

Description and Short Description

Enter a description and short description. These fields appear on pages and in reports.

Manager ID and Manager Name

Enter the manager ID and name for this department.

Company

Select the payroll company into which the department reports. The system uses the payroll company to calculate workers' compensation. The system also uses the department on the order in conjunction with the state to look up the appropriate workers' compensation rate.

Note. If PeopleSoft Staffing Front Office is installed with PeopleSoft Pay/Bill Management, this table will be populated by either the HCM or core Financials users (thus PeopleSoft Staffing Front Office users do not need to configure it).

Click to jump to top of pageClick to jump to parent topicAssigning Users Permission Lists

Access the Department Security page (Set Up Financials/Supply Chain, Security, Staffing Department Security).

Row Security Permission List

Displays the row security permission list that you selected. This is established under Maintain Security.

SetID

Enter the set control value on which the system is to base your department structure.

Dept (department)

Enter the department ID that you entered on the department security tree. Users with this permission list have access to the department and any child departments that are associated with it.

Access Code

Specify which type of access the permission list has to the department ID: No Access or Read/Write.

Update security entries for security trees as necessary by accessing the second Department Security page.

Click to jump to parent topicSetting Up the Verity Search Engine

The Verity search engine is a third-party product that PeopleSoft has embedded into PeopleTools. Five search types — PeopleMatch, PeopleSearch, Order Search, Customer Search, and Contact Search— use the Verity search engine.

Detailed information about the Verity search engine, including configuring and using the engine, is contained in the Understanding the Verity Search Engine section of the Searching Staffing Front Office chapter.

See Understanding the Verity Search Engine.