Oracle Project Tables

Table Name	Description
PA_PROJECTS_ALL	Information about projects
PA_AGREEMENTS_ALL	Customer contracts that serve as the basis for work authorization
PA_BILL_RATES_ALL	Information about bill rates and markups of standard bill rate schedules
PA_BILLING_ASSIGNMENTS_ALL	Assignments of billing extensions to a project type, project, or task
PA_COST_DISTRIBUTION_LINES_ALL	Information about expenditure item cost distribution
PA_CUST_REV_DIST_LINES_ALL	Information about expenditure item revenue distribution
PA_DRAFT_INVOICE_DETAILS_ALL	Intercompany invoice details for cross charged transactions
PA_DRAFT_INVOICES_ALL	Information about draft invoices generated for projects
PA_DRAFT_REVENUES_ALL	Information about draft revenue generated for projects
PA_EXPENDITURE_COST_RATES_ALL	Cost rates for non-labor expenditure types
PA_EXPENDITURE_GROUPS_ALL	Groups of pre-approved expenditures
PA_EXPENDITURE_ITEMS_ALL	The smallest units of expenditure charged to projects and tasks
PA_EXPENDITURES_ALL	Groups of expenditure items incurred by employees or organizations for an expenditure period
PA_PERIODS_ALL	Implementation-defined periods against which project performance is measured
PA_PROJECT_ASSET_LINES_ALL	Summarized project CIP costs
PA_PROJECT_ASSETS_ALL	Assets defined for capital projects
PA_EXPENDITURE_TYPES	Implementation-defined classifications of expenditures charged to projects and tasks
PA_EXPENDITURE_CATEGORIES	Implementation-defined groupings of expenditure types by type of cost
PA_CLASS_CATEGORIES	Implementation-defined categories for classifying projects
PA_CLASS_CODES	Implementation-defined values within class categories that can be used to classify projects
PA_PROJECT_CLASSES	Class codes of class categories that are used to classify projects
PA_BUDGET_VERSIONS	Versions of project budgets
PA_BUDGET_LINES	Detail lines