Results for “mth_personnel_d”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

MTH_PERSONNEL_D is a denormalized personnel master table owned by the MTH schema and delivered as part of the Oracle Manufacturing Operations Center (MTH) product in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the shop-floor and plant workforce records that MOC uses for personnel assignment, labor tracking, and production reporting against resources, systems, and organizations. The table exposes the referenced EBS person and organization identifiers (EBS_PERSONNEL_ID, EBS_ORGANIZATION_ID) alongside locally maintained MOC attributes, effectively acting as a staging and caching layer between Oracle HR and the MOC runtime schema. The table contains 38 documented columns and is marked VALID in the ETRM 12.2.2 physical schema.

The heuristic Data Vault classification derived from the foreign-key structure is standalone. In dimensional or Data Vault terms this suggests the object behaves as a reference or lookup entity rather than a hub, link, or satellite. It is not modeled with outbound FK dependencies on other MOC facts, so it may be treated as a degenerate dimension or a slowly-changing reference set depending on the reporting requirement.

Key Information Stored

The surrogate primary key is PERSONNEL_PK, enforced by the unique index MTH_PERSONNEL_D_U1; PERSONNEL_PK_KEY is the associated surrogate key field typically used for internal stitching. The principal business-key candidate is therefore PERSONNEL_PK itself, with EBS_PERSONNEL_ID and EBS_ORGANIZATION_ID serving as the natural keys linking back to Oracle HR and its business groups.

• EBS_PERSONNEL_ID — the Oracle HR person identifier of the employee or contingent worker.
• EBS_ORGANIZATION_ID — the HR organization or business group the person belongs to.
• FIRST_NAME, MIDDLE_NAME, LAST_NAME, FULL_NAME, KNOWN_AS — the person's name components as displayed in MOC screens.
• PERSONNEL_DESCRIPTION, TITLE — descriptive role and job title used in reports.
• EMAIL_ADDRESS, WORK_TELEPHONE, MOBILE_PHONE_NUMBER — contact attributes for shop-floor notifications.
• SEX — demographic attribute for HR-style reporting.
• PLANT_FK_KEY, SOURCE_ORG_CODE — plant and source organization linkage for a personnel assignment scope.
• SYSTEM_FK_KEY, RESOURCE_FK_KEY — foreign-key-style references to MOC system and resource records used when a person is assigned to equipment or a cell.
• EFFECTIVE_START_DATE, EFFECTIVE_END_DATE — date-effectivity for the personnel record.
• CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns.
• USER_ATTR1–USER_ATTR5, USER_MEASURE1–USER_MEASURE5 — extensible attribute and measure columns populated during implementation.

Common Use Cases and Queries

Typical use cases include populating MOC personnel pick lists, resolving an HR person to a plant assignment, and generating workforce rosters for a production line. A join to Oracle HR is performed on the EBS columns:

• List active personnel for a plant: SELECT FULL_NAME, TITLE, EMAIL_ADDRESS FROM MTH.MTH_PERSONNEL_D WHERE PLANT_FK_KEY = :plant AND SYSDATE BETWEEN EFFECTIVE_START_DATE AND NVL(EFFECTIVE_END_DATE, SYSDATE + 1);
• Resolve an HR employee to MOC personnel: SELECT PERSONNEL_PK, FULL_NAME FROM MTH.MTH_PERSONNEL_D WHERE EBS_PERSONNEL_ID = :person_id AND EBS_ORGANIZATION_ID = :org_id;
• People assigned to a resource: SELECT FULL_NAME FROM MTH.MTH_PERSONNEL_D WHERE RESOURCE_FK_KEY = :resource_pk;
• Extensibility-driven reporting: group by USER_ATTR1 or aggregate USER_MEASURE1–USER_MEASURE5 for skill or certification metrics.

Related Objects

Because MTH_PERSONNEL_D is standalone in its mined FK structure, the relationships to other objects are logical rather than physical and must be joined manually on the columns documented above.

• PER_ALL_PEOPLE_F / PER_ALL_ASSIGNMENTS_F — HR source, joined on PERSON_ID = EBS_PERSONNEL_ID and ORGANIZATION_ID = EBS_ORGANIZATION_ID.
• HR_ALL_ORGANIZATION_UNITS — joined on ORGANIZATION_ID = EBS_ORGANIZATION_ID to resolve department or business group.
• MTH_RESOURCE_D — MOC resource master, joined on RESOURCE_FK_KEY.
• MTH_SYSTEM_D — MOC system/integration entity, joined on SYSTEM_FK_KEY.
• MTH_PLANT_D — MOC plant reference, joined on PLANT_FK_KEY.
• MTH_PERSONNEL_RESOURCE_ASSN — MOC personnel-to-resource assignment table that consumes PERSONNEL_PK.
• MOC Runtime / MTH transaction tables — production, labor, and OEE facts that reference personnel via PERSONNEL_PK_KEY.

In summary, MTH_PERSONNEL_D is a reference-style master table supporting MOC workforce visibility, bridging Oracle HR person and organization keys to plant, system, and resource scopes through its surrogate PERSONNEL_PK.