PROJECT MODULE TABLES

PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects at which funding can be allocated and at which revenue, invoices, unbilled receivables, and unearned revenue are generated and maintained. At the project level, users can specify the methods to be used for revenue accrual and billing, and the invoice formats to be used for invoicing. A project is broken down into one or more tasks. All projects can be funded by one or more agreements.

PA_TASKS PA_TASKS stores user–defined subdivisions of project work. Tasks can be broken down into multiple levels of subtasks. The depth and width of the work breakdown structure (WBS) are unlimited. The WBS is held using the TASK_ID and PARENT_TASK_ID columns. Two columns related to the WBS are denormalized: TOP_TASK_ID and WBS_LEVEL.

PA_PERIODS_ALL stores implementation–defined periods in Oracle Projects by which project performance is measured. PA Periods can be different from your general ledger accounting periods (GL Periods). You can define PA Periods as weekly periods, while GL periods are monthly. In Oracle Projects, costs and revenue can be reported by PA Period as well as by GL Period. You define a PA period or periods in the GL calendar associated with the set of books used in PA_IMPLEMENTATIONS_ALL. You then copy the PA periods from the GL calendar to this table. You maintain the status of the period in this table.

PA_PROJECT_TYPES_ALL stores implementation–defined classifications of projects that specify whether a project burdens labor costs and whether the project is contract, capital or indirect (based on PROJECT_TYPE_CLASS_CODE). Project types are also used during project entry to specify default information such as invoice formats, standard bill rate schedules, and task service types

PA_PROJ_INVOICES_VIEW displays all project invoices in Oracle Projects. You can use this view to easily report project invoice information. This view displays one record per project invoice.

PA_PROJ_INVOICE_DETAILS_VIEW displays the detailed expenditure items that make up a project invoice. You can use this view to easily report the expenditure item information for an invoice backup report.

PA_PROJ_INVOICE_EVENTS_VIEW displays detailed event information for events included on a project invoice. You can use this view to easily report event details for a project invoice backup report.

PA_PROJ_INVOICE_SUMMARY_VIEW displays summary totals for a project which include baselined budget revenue amount, total revenue amount, total invoice amounts, and amounts on hold. This view displays one record per project. You can use this information when reviewing project status, particularly when reviewing invoices for a project.

PA_PROJ_MEMBERS_VIEW displays project members for a project. This view displays one record per project key member. You can use this view when reporting projects by project member. You can easily find all projects to which a project member is assigned.

PA_PROJ_RELEASED_INVOICES_VIEW displays released project
invoices. This view displays one record per project invoice. You can easily use this view when reporting released invoices.

PA_PROJ_REVENUE_VIEW is a view of the draft revenue information for a project that can be used for management reporting and online queries. The view displays one record per project revenue. For optimum performance in your reports and online queries, always include PROJECT_ID in your selection criteria.

PA_PROJ_UNBILLED_EXPEND_VIEW displays billable expenditure items that are unbilled. You can review the unbilled expenditure items for your projects using this view.

PA_PROJ_UNBILLED_SUMMARY_VIEW shows summary unbilled amounts for a project. These amounts include items that are unbilled, items on hold, and events that are unbilled. You can easily review the unbilled summary status of your project using this view.

PA_PROJ_WBS_VIEW displays project tasks as part of the project work breakdown structure. The task name and numbers are indented to illustrate the task level and position in the work breakdown structure. The view also displays basic task information, including task start and completion dates, task description, and the task manager.