pa tables

2
Table PA_PROJECTS_ALL PA_PROJECT_ASSETS_ALL PA_PROJECT_ASSIGNMENTS PA_PROJECT_CLASSES PA_PROJECT_ROLE_TYPES PA_PROJECT_STATUSES PA_PROJECT_TYPES_ALL PA_TASKS PA_TASK_TYPES PA_TRANSACTION_INTERFACE_ALL PA_TRANSACTION_SOURCES PA_IMPLEMENTATIONS_ALL PA_ACTION_SETS PA_ACTION_SET_LINES PA_ACTION_SET_TYPES PA_AGREEMENTS_ALL PA_AGREEMENT_TYPES PA_BILL_RATES_ALL PA_BUDGETS PA_BUDGET_LINES PA_BUDGET_TYPES PA_CLASS_CATEGORIES PA_CLASS_CODES PA_EVENTS PA_EVENT_TYPES PA_EXPENDITURES_ALL PA_EXPENDITURE_CATEGORIES PA_EXPENDITURE_ITEMS_ALL PA_EXPENDITURE_TYPES PA_PERIODS_ALL PA_RBS_DENORM PA_RBS_ELEMENTS PA_RESOURCES PA_ROLE_LISTS PA_SCHEDULES

Upload: ad-elou

Post on 26-Sep-2015

7 views

Category:

Documents


2 download

DESCRIPTION

PA TABLES

TRANSCRIPT

Feuil1TableDescriptionPA_PROJECTS_ALLIt stores the highest units of work defined in Oracle Projects.PA_PROJECT_ASSETS_ALLIt contains assets information defined for capital projects.PA_PROJECT_ASSIGNMENTSIt stores details of all Assignments for a project.PA_PROJECT_CLASSESIt contains the class codes of class categories that are used to classify projects.PA_PROJECT_ROLE_TYPESImplementation-defined responsibilities or positions assigned to employees on projects are stored here.PA_PROJECT_STATUSESIt stores valid project status codes.PA_PROJECT_TYPES_ALLIt stores implementation-defined project classifications that supply default information and drive some project processing.PA_TASKSIt contains user-defined subdivisions of project work.PA_TASK_TYPESIt stores implementation-defined classifications of task.PA_TRANSACTION_INTERFACE_ALLIt is an interface table to import transactions from external sources into Oracle Projects.PA_TRANSACTION_SOURCESIt stores implementation-defined sources of imported transactions originating in an external system.PA_IMPLEMENTATIONS_ALLIt contains information about the configuration of an Oracle Projects installation.PA_ACTION_SETSIt stores action set templates as well as action sets belonging to an object, such as projects, requirements, etc.PA_ACTION_SET_LINESIt stores action set lines that belong to an action set or an action set template.PA_ACTION_SET_TYPESIt stores attributes of action set types.PA_AGREEMENTS_ALLIt has customer contracts that serve as the basis for work authorization.PA_AGREEMENT_TYPESImplementation-defined classifications of customer agreements.PA_BILL_RATES_ALLInformation about bill rates and markups of standard bill rate schedules.PA_BUDGETSIt stores budgets information.PA_BUDGET_LINESIt stores detail lines of project and task budgets.PA_BUDGET_TYPESIt contains implementation-defined classifications of types of budgets used for different business purposes.PA_CLASS_CATEGORIESIt stores implementation-defined categories for classifying projects.PA_CLASS_CODESIt stores implementation-defined values within class categories that can be used to classify projects.PA_EVENTSIt stores entries assigned to tasks that generate revenue and/or billing but are not directly related to expenditure items.PA_EVENT_TYPESIt stores implementation-defined classifications of events.PA_EXPENDITURES_ALLGroups of expenditure items incurred by employees or organizations for an expenditure period.PA_EXPENDITURE_CATEGORIESImplementation-defined groupings of expenditure types by type of cost.PA_EXPENDITURE_ITEMS_ALLIt contains the smallest units of expenditure charged to projects and tasks.PA_EXPENDITURE_TYPESImplementation-defined classifications of expenditures charged to projects and tasks.PA_PERIODS_ALLImplementation-defined periods against which project performance is measured.PA_RBS_DENORMThis table stores normalized resource breakdown structure information.PA_RBS_ELEMENTSThis table stores the RBS element information and the parent-child relationship.PA_RESOURCESIt contains resources used in budgeting and project summary amounts.PA_ROLE_LISTSIt stores lists of roles defined with the system.PA_SCHEDULES It displays the schedule details for requirements and assignments. It also displays calendar schedules.

Feuil2

Feuil3