O'Reilly logo

PeopleSoft HRMS Reporting by Adam T. Bromwich

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

7 The Job Table

The PS_JOB table is the core record of the PeopleSoft HR database. This table drives every major process in PeopleSoft HRMS. In general, PS_JOB is the source of the following information:

• employee status

• compensation/Salary

• employee job/position

• employee department/location

• payroll settings

• benefits status

Job is an extremely dense and complex table. It is organized according to certain rules, and these rules are usually completely different from other legacy HR systems. PS_JOB drives many of the business process changes PeopleSoft requires of an organization.

This chapter will look at each of these categories and most of the fields that are found on the PS_JOB table. There are many important concepts surrounding ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required