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

12 Employment Information

Most static information about an employee’s tenure with an organization is stored on the employment table, PS_EMPLOYMENT. This information rarely changes, and if it does, the old values are not stored. This chapter will describe each field in detail, especially the various employment dates.

THE EMPLOYMENT TABLE

Let’s look at the structure of the employment table in Table 12-1.

Table 12-1 Employment: PS_EMPLOYMENT

image

The employee ID and employment record number fields form the unique keys for the employment table. The employment record number indicates the job the employment record pertains to. Each is a separate entity. ...

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