Results for “pa_work_types_b”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PA_WORK_TYPES_B is the base-language definition table for work types in Oracle Projects (PA). A work type describes the category of work performed on a project or task — for example, billable vs. non-billable labor, capitalized effort, training activity, or unassigned time. The table stores the implementation-defined attributes that determine how expenditure associated with a given work type is costed, distributed, capitalized, and reported. Records are maintained in the base (installation) language; translated names and descriptions are held separately in PA_WORK_TYPES_TL, which joins back to this table on WORK_TYPE_ID.
Because the table holds the durable, descriptive master data for each work type — while the transactional consequences appear in expenditure, cost distribution, and project assignment tables — the ETRM Data Vault classification of hub-leaning is appropriate. In a Data Vault model, PA_WORK_TYPES_B would be modelled as a hub keyed on WORK_TYPE_ID, with its descriptive flags and percentages (billable/capitalizable, utilization percentages, effective dates) carried on a companion satellite. The numerous inbound foreign keys from transactional and association tables reinforce this hub role.
Key Information Stored
The table is documented with 33 columns in ETRM 12.2.2. The most operationally significant are described below.
- WORK_TYPE_ID — the surrogate primary key, defined by the unique index PA_WORK_TYPES_B_PK. This is the value stored in all dependent tables. The unique index PA_WORK_TYPES_B_U1 also exists on this column and serves as the primary business-key candidate.
- BILLABLE_CAPITALIZABLE_FLAG — determines whether work of this type is treated as billable, capitalizable, or both, driving revenue and asset generation.
- REDUCE_CAPACITY_FLAG — indicates whether the work type reduces project or resource capacity.
- RES_UTILIZATION_PERCENTAGE and ORG_UTILIZATION_PERCENTAGE — the shares of resource and organization capacity consumed by this work type.
- ORG_UTIL_CATEGORY_ID and RES_UTIL_CATEGORY_ID — utilization categories for organization and resource, both referencing PA_UTIL_CATEGORIES_B.
- START_DATE_ACTIVE and END_DATE_ACTIVE — the date range during which the work type is valid for use.
- TRAINING_FLAG — marks the work type as training-related.
- TP_AMT_TYPE_CODE — the transfer price amount type code, relevant to transfer pricing configurations.
- UNASSIGNED_FLAG — identifies the work type used for unassigned or default time.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle flexfield (descriptive) columns.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — who-created/who-updated auditing columns.
Common Use Cases and Queries
The most frequent reporting need is to resolve a WORK_TYPE_ID appearing on expenditure, cost distribution, or project records into a human-readable name by joining to the translation table:
- Joining PA_EXPENDITURE_ITEMS_ALL or PA_COST_DISTRIBUTION_LINES_ALL to PA_WORK_TYPES_B on WORK_TYPE_ID, then to PA_WORK_TYPES_TL for the displayed name.
- Reporting billable and capitalizable expenditure by filtering on BILLABLE_CAPITALIZABLE_FLAG.
- Restricting a lookup to currently active work types using START_DATE_ACTIVE and END_DATE_ACTIVE.
- Determining utilization treatment by joining ORG_UTIL_CATEGORY_ID and RES_UTIL_CATEGORY_ID to PA_UTIL_CATEGORIES_B.
- Identifying default/unassigned work type rows via UNASSIGNED_FLAG.
Typical SQL resolves a work type from a transactional line and returns its name and flags:
SELECT b.WORK_TYPE_ID, t.NAME, b.BILLABLE_CAPITALIZABLE_FLAG, b.REDUCE_CAPACITY_FLAG FROM PA_WORK_TYPES_B b, PA_WORK_TYPES_TL t WHERE b.WORK_TYPE_ID = t.WORK_TYPE_ID AND t.LANGUAGE = USERENV('LANG');
Related Objects
The ETRM relationship data shows PA_WORK_TYPES_B as a heavily referenced hub. The most significant dependencies are:
- PA_WORK_TYPES_TL — translation table joined on WORK_TYPE_ID; supplies display names and descriptions.
- PA_PROJECTS_ALL — references WORK_TYPE_ID to set the default work type for a project.
- PA_PROJECT_ASSIGNMENTS — references WORK_TYPE_ID for project-to-organization assignments.
- PA_TASKS — references WORK_TYPE_ID for task-level work type defaults.
- PA_EXPENDITURE_ITEMS_ALL — references WORK_TYPE_ID on expenditure transactions.
- PA_COST_DISTRIBUTION_LINES_ALL — references WORK_TYPE_ID on cost distribution lines.
- PA_OBJECTS — references WORK_TYPE_ID within the generic project object model.
- PA_UTIL_CATEGORIES_B — referenced by this table via ORG_UTIL_CATEGORY_ID and RES_UTIL_CATEGORY_ID.
- PJI_RM_RES_WT_F and PJI_RM_WORK_TYPE_INFO — resource-management work type information, both referencing WORK_TYPE_ID.
These relationships confirm that PA_WORK_TYPES_B functions as a shared reference hub, supporting expenditure capture, costing, resource utilization, and project setup across the Oracle Projects suite.
-
This table stores implementation-defined types of work being carried out in Projects in the base language.
-
This table stores implementation-defined types of work being carried out in Projects in the base language.
-
TABLE: PA.PA_WORK_TYPES_B 12.2.2
-
TABLE: PA.PA_WORK_TYPES_B 12.1.1