NSPB SuitePeople - Saved Searches

The following table shows the names and IDs of the saved searches included in this group:

Saved Search Name	Saved Search ID
NSPB (Data) SuitePeople - Employee Payroll	customsearch_nspb_pr_emp_payroll_sp
NSPB (Data) SuitePeople - HR Employee Values	customsearch_nspb_hr_emp_values_sp
NSPB (Metadata) SuitePeople - Employee	customsearch_nspb_sync_emp_sp
NSPB (Metadata) SuitePeople - HR Employee Location	customsearch_nspb_sync_hr_emp_loc_sp
NSPB (Metadata) SuitePeople - HR Job Codes	customsearch_nspb_sync_hr_job_codes_sp

Saved Search Name

Saved Search ID

NSPB (Data) SuitePeople - Employee Payroll

customsearch_nspb_pr_emp_payroll_sp

NSPB (Data) SuitePeople - HR Employee Values

customsearch_nspb_hr_emp_values_sp

NSPB (Metadata) SuitePeople - Employee

customsearch_nspb_sync_emp_sp

NSPB (Metadata) SuitePeople - HR Employee Location

customsearch_nspb_sync_hr_emp_loc_sp

NSPB (Metadata) SuitePeople - HR Job Codes

customsearch_nspb_sync_hr_job_codes_sp

The following table describes the NSPB SuitePeople saved searches:

Saved Search Name	SuitePeople Field Label	Planning and Budgeting Mapped Field Label	Saved Search Description	Source
NSPB (Data) SuitePeople - Employee Payroll	Subsidiary Department Class Location Employee Year Month WF Category CompensationCurrency Amount Version Check Date Hours Payroll Item Payroll Item Type Master Pay Code Pay Frequency Earning Subject Wages Taxable Wages Deduction Employee Paid Tax Net Pay Employer Contribution Employer Paid Tax Internal ID Employee Type	Subsidiary Department Class Location Employee Year Period Account Currency Amount Version	Collects paycheck records and maps them to various workforce categories in your Planning and Budgeting Account dimension. A workforce category refers to members in the Account dimension related to employee properties.	SuitePeople Payroll
NSPB (Data) SuitePeople - HR Employee Values	Subsidiary Department Location Employee Version HireDate ReleaseDate JobCode BaseWageType BaseWage WorkLocation Allocation% Period CompensationCurrency	Subsidiary Department Location Employee Version Account (Emp Properties) HireDate ReleaseDate JobCode BaseWageType BaseWage WorkLocation Allocation%	Collects the bulk of content for this integration, including the employee's subsidiary, department, hire date, release date (if there is one), and job.	SuitePeople HR
NSPB (Metadata) SuitePeople - Employee	Employee ID Last Name, First Name Last name	Employee Alias Parent	Collects all the employee names, including their employee IDs, and maps them to the Alias and Parent metadata in your Planning and Budgeting.	NetSuite standard fields
NSPB (Metadata) SuitePeople - HR Employee Location	Child Alias: Default	Smart Lists : WF_WorkLocation Name Label	Collects the location of each employee, and maps it to the Location ID metadata in your Planning and Budgeting.	SuitePeople HR
NSPB (Metadata) SuitePeople - HR Job Codes	Account Alias: Default	Smart Lists : WF_JobTitle Name Label	Collects the Job ID of each employee, and maps it to the Account metadata in your Planning and Budgeting.	SuitePeople HR

Saved Search Name

SuitePeople Field Label

Planning and Budgeting Mapped Field Label

Saved Search Description

Source

NSPB (Data) SuitePeople - Employee Payroll

Subsidiary
Department
Class
Location
Employee
Year
Month
WF Category
CompensationCurrency
Amount
Version
Check Date
Hours
Payroll Item
Payroll Item Type
Master Pay Code
Pay Frequency
Earning
Subject Wages
Taxable Wages
Deduction
Employee Paid Tax
Net Pay
Employer Contribution
Employer Paid Tax
Internal ID
Employee Type

Subsidiary
Department
Class
Location
Employee
Year
Period
Account
Currency
Amount
Version

Collects paycheck records and maps them to various workforce categories in your Planning and Budgeting Account dimension.

A workforce category refers to members in the Account dimension related to employee properties.

SuitePeople Payroll

NSPB (Data) SuitePeople - HR Employee Values

Subsidiary
Department
Location
Employee
Version
HireDate
ReleaseDate
JobCode
BaseWageType
BaseWage
WorkLocation
Allocation%
Period
CompensationCurrency

Subsidiary
Department
Location
Employee
Version
Account (Emp Properties)
- HireDate
- ReleaseDate
- JobCode
- BaseWageType
- BaseWage
- WorkLocation
- Allocation%

Collects the bulk of content for this integration, including the employee's subsidiary, department, hire date, release date (if there is one), and job.

SuitePeople HR

NSPB (Metadata) SuitePeople - Employee

Employee ID
Last Name, First Name
Last name

Employee
Alias
Parent

Collects all the employee names, including their employee IDs, and maps them to the Alias and Parent metadata in your Planning and Budgeting.

NetSuite standard fields

NSPB (Metadata) SuitePeople - HR Employee Location

Child
Alias: Default

Smart Lists : WF_WorkLocation
- Name
- Label

Collects the location of each employee, and maps it to the Location ID metadata in your Planning and Budgeting.

SuitePeople HR

NSPB (Metadata) SuitePeople - HR Job Codes

Account
Alias: Default

Smart Lists : WF_JobTitle
- Name
- Label

Collects the Job ID of each employee, and maps it to the Account metadata in your Planning and Budgeting.

SuitePeople HR

To use the NSPB SuitePeople saved searches, do the following:

Enable the features required in your NetSuite account for saved search creation. See Prerequisites for Creating the NSPB SuitePeople Saved Searches.
Assign the NSPB SuitePeople Integration role to users so they can run NetSuite SuitePeople saved searches to load data into Planning and Budgeting. See Setting Up the NSPB SuitePeople Integration Role with Planning and Budgeting Sync.
Create the saved searches in NetSuite for your integration with Planning and Budgeting. You can then review or customize the saved searches in NetSuite. For information, see Managing the Planning and Budgeting Sync Saved Searches.
If you want to customize the NSPB (Data) SuitePeople - Employee Payroll saved search, review the default mapping between SuitePeople payroll items and workforce categories. See Customizing the NSPB (Data) SuitePeople - Employee Payroll Saved Search.

Related Topics