Search Results per_medical_assessments




Overview
Explore in AI Chat

Overview

The PER_MEDICAL_ASSESSMENTS table is a core data object within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically under the product family PER. Its primary function is to serve as the central repository for storing medical assessment records associated with individuals in the enterprise. This table is critical for managing occupational health data, enabling organizations to track medical evaluations, which are often related to pre-employment screenings, periodic health checks, or assessments following workplace incidents. As a validated table in the HR schema, it forms an integral part of the comprehensive workforce management system in both EBS releases 12.1.1 and 12.2.2, supporting compliance and employee wellness tracking.

Key Information Stored

The table is structured to capture essential details of a medical assessment. The primary key, MEDICAL_ASSESSMENT_ID, uniquely identifies each assessment record. A critical piece of information stored is the ORGANIZATION_ID, which links the assessment to a specific business unit or department defined in HR_ALL_ORGANIZATION_UNITS. Furthermore, the INCIDENT_ID column is pivotal for associating a medical assessment with a specific work-related incident recorded in the PER_WORK_INCIDENTS table, thereby connecting health outcomes directly to workplace safety events. While the provided metadata does not list all columns, typical data stored would include assessment dates, medical practitioner details, assessment type, findings, fitness-for-work conclusions, and next review dates.

Common Use Cases and Queries

This table is primarily utilized for occupational health reporting and compliance monitoring. Common scenarios include generating reports on medical assessments due for renewal, analyzing trends in work-related injuries by correlating incident data with medical outcomes, and ensuring regulatory compliance for roles requiring specific health clearances. A typical query might involve joining with the PER_WORK_INCIDENTS table to list all medical assessments for incidents occurring within a specific period:

  • SELECT pma.MEDICAL_ASSESSMENT_ID, pwi.INCIDENT_NUMBER, pma.ASSESSMENT_DATE FROM HR.PER_MEDICAL_ASSESSMENTS pma JOIN HR.PER_WORK_INCIDENTS pwi ON pma.INCIDENT_ID = pwi.INCIDENT_ID WHERE pma.ASSESSMENT_DATE > SYSDATE - 365;

Another frequent use case is integrating this data with employee information (via the PER_ALL_PEOPLE_F table, though not explicitly listed in the provided FKs) to create comprehensive employee health profiles.

Related Objects

The PER_MEDICAL_ASSESSMENTS table has defined relationships with other key HR tables, as documented in the provided metadata. Its foreign keys establish important data integrity links:

  • HR_ALL_ORGANIZATION_UNITS: Linked via the ORGANIZATION_ID column. This relationship ties each medical assessment to the organizational unit responsible for or associated with the employee's assessment.
  • PER_WORK_INCIDENTS: Linked via the INCIDENT_ID column. This is a crucial relationship for workplace health and safety, allowing the system to directly connect a medical assessment to the specific work incident that necessitated it.

The table itself is referenced by its primary key constraint, PER_MEDICAL_ASSESSMENTS_PK, on the MEDICAL_ASSESSMENT_ID column. It may also be referenced by other HRMS APIs, forms, and reports that manage employee health data.