Functionality in the FSCM Database

Most PeopleSoft Pay/Bill Management pages and processes are part of the FSCM database. PeopleSoft Pay/Bill Management leverages the FSCM database so that you can perform these business processes:

  • Create customer records.

  • Create contact records.

  • Add applicants and hire them as employees or non-employees.

  • Create, manage, and process orders and assignments.

  • Process payroll for employees.

  • Create and track customer purchase orders.

  • Manage staffing suppliers.

  • Create vouchers from contractor time.

  • Process billing.

When PeopleSoft Pay/Bill Management creates customer and contact records, the information is stored in the same FSCM database tables used by other applications such as PeopleSoft Contracts, PeopleSoft Billing, and PeopleSoft Receivables. However, some information, specific only to staffing is stored in additional tables (beginning with the letters FO) which are used only by PeopleSoft Pay/Bill Management and PeopleSoft Staffing Front Office.

The same applies to applicants and employees added through PeopleSoft Pay/Bill Management. Most of the information is stored in the same FSCM database tables used by other applications such as PeopleSoft Resource Management and PeopleSoft Expenses. However, some information, specific only to staffing is stored in additional tables (beginning with FO) which are used only by PeopleSoft Pay/Bill Management and PeopleSoft Staffing Front Office.

Similarly, order and assignment information is stored in the same tables used by PeopleSoft Resource Management and PeopleSoft Staffing Front Office. Information specific to PeopleSoft Pay/Bill Management and PeopleSoft Staffing Front Office is stored in additional tables prefixed with FO.