Results for “per_assessments”

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

Overview

PER_ASSESSMENTS is a core Human Resources (PER) table in Oracle E-Business Suite 12.1.1 and 12.2.2, owned by the HR schema. In the ETRM documentation, it is described as the grouping of a set of assessment elements. Each row represents a single assessment event or instance — an evaluation of a person, conducted by an assessor, against a defined assessment type — and acts as the parent grouping under which individual competence elements are recorded. Because it holds descriptive state (dates, status, scores, comments, and audit columns) and is keyed by a surrogate ASSESSMENT_ID rather than by a natural composite business key, the heuristic Data Vault classification mined from the FK structure is satellite-leaning. This should be treated as a modeling suggestion: the table behaves primarily as a descriptive satellite attached to the person, appraisal, and assessment-type dimensions it references.

Key Information Stored

The table contains 42 documented columns. The most significant are:

• ASSESSMENT_ID — the surrogate primary key defined by PER_ASSESSMENTS_PK, uniquely identifying each assessment row.
• PERSON_ID — the person being assessed; the central subject of the record.
• ASSESSOR_PERSON_ID — the person performing the assessment.
• ASSESSMENT_TYPE_ID — foreign key to PER_ASSESSMENT_TYPES, defining the kind of assessment.
• ASSESSMENT_GROUP_ID — foreign key to PER_ASSESSMENT_GROUPS, linking the assessment to a broader grouping.
• APPRAISAL_ID — foreign key to PER_APPRAISALS, tying the assessment to an appraisal cycle where applicable.
• BUSINESS_GROUP_ID — foreign key to HR_ALL_ORGANIZATION_UNITS, enforcing multi-tenant business group separation.
• ASSESSMENT_DATE, ASSESSMENT_PERIOD_START_DATE, and ASSESSMENT_PERIOD_END_DATE — the effective date of the assessment and the period it covers.
• GROUP_DATE and GROUP_INITIATOR_ID — the date and initiator associated with grouping; GROUP_DATE participates in the unique index PER_ASSESSMENTS_UK1 alongside ASSESSMENT_TYPE_ID, PERSON_ID, ASSESSMENT_DATE, and ASSESSOR_PERSON_ID, making these the documented business-key candidates.
• STATUS and TOTAL_SCORE — workflow state and aggregated scoring outcome.
• COMMENTS — free-text narrative.
• OBJECT_VERSION_NUMBER plus the WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and the 20 ATTRIBUTE flex columns for extensibility.

Common Use Cases and Queries

PER_ASSESSMENTS supports competency and appraisal reporting, assessor workload analysis, and integration with talent management extracts. Typical queries join to referenced dimensions and to the dependent competence elements. For example, retrieving all assessments for a person with their type and assessor:

• Assessments for a person: SELECT a.assessment_id, a.assessment_date, a.status, a.total_score FROM per_assessments a WHERE a.person_id = :person_id ORDER BY a.assessment_date DESC;
• Joining type and assessor: SELECT a.assessment_id, t.name, a.assessor_person_id, a.assessment_period_start_date FROM per_assessments a, per_assessment_types t WHERE a.assessment_type_id = t.assessment_type_id;
• Aggregating to competence elements: SELECT a.assessment_id, COUNT(c.assessment_id) FROM per_assessments a, per_competence_elements c WHERE c.assessment_id = a.assessment_id GROUP BY a.assessment_id;

Business-group filtering via BUSINESS_GROUP_ID should be applied in multi-org reporting contexts.

Related Objects

• PER_ASSESSMENT_TYPES — referenced via ASSESSMENT_TYPE_ID; defines assessment categories.
• PER_ASSESSMENT_GROUPS — referenced via ASSESSMENT_GROUP_ID; groups assessments together.
• PER_APPRAISALS — referenced via APPRAISAL_ID; links assessments to appraisal cycles.
• HR_ALL_ORGANIZATION_UNITS — referenced via BUSINESS_GROUP_ID; provides business group scoping.
• PER_COMPETENCE_ELEMENTS — references PER_ASSESSMENTS via ASSESSMENT_ID; holds the individual scored competence lines beneath each assessment.