Professional Services

This ERD (see the following figure) illustrates how Siebel Business Applications support the planning and execution of Professional Services projects. Projects can be defined for an external or internal client, as the responsibility of one or more internal organizations, subcontracted to one or more partners, associated with a required skill set, and made accessible to one or more positions. The definition of required project team roles allows project billings to be estimated based on the billing rate and the number of hours required from the resource. An employee, a sub-contractor employee or a contact can ultimately fill a team role from the client, but until then, a list of potential project resources can be stored for the project or a specific project team role. Positions and project team roles can be associated with a service billing product to define the billing rate for that entity from a billing rate list. Project issues can be tracked for a project, assigned to a project team role, and detailed as a series of activities. Receivable Invoices billed to the client or payable invoices from subcontractors can be associated with the project.

The following table lists the entities in this ERD and their corresponding tables.

Entity	Table
Activity	S_EVT_ACT
Address	S_ADDR_ORG (Siebel Cross-Industry Applications) S_ADDR_PER (Siebel Industry Applications)
Billing Rate List	S_PRI_LST
Employee/Agent	S_EMP_PER, S_CONTACT, S_PARTY
Internal/Partner Organization	S_ORG_EXT, S_PARTY
Invoice	S_INVOICE
Lead Source	S_SRC
Opportunity	S_OPTY
Organization Unit	S_ORG_EXT, S_PARTY
Person	S_CONTACT, S_PARTY
Position	S_POSTN, S_PARTY
Potential Project Resource	S_PROJ_PTL_RSRC
Project	S_PROJ
Project Contact	S_PROJ_CON
Project Issue	S_PROJ_ISS
Project Team Role	S_PROJ_RSRC
Skill	S_PROJRSRC_SKL