pa tables
DESCRIPTION
PA TABLESTRANSCRIPT
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