Results for “weighting_scale_id”

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

Overview

PER_ASSESSMENT_TYPES is the HR schema table that stores the definition of an assessment template within Oracle E-Business Suite Human Resources (PER module). Each row describes a reusable assessment construct — its rating scale, weighting scale, scoring formulas, and behavioral classification — that is subsequently instantiated against employees, appraisals, and competence elements. Because appraisals, assessments, and competence definitions all draw their scoring semantics from a shared template definition, this table acts as the semantic anchor for the entire performance-management scoring model in EBS 12.1.1 and 12.2.2.

From a Data Vault modeling perspective, the ETRM metadata classifies this object as satellite-leaning. The heuristic reflects that PER_ASSESSMENT_TYPES carries descriptive, time-bounded attributes (DATE_FROM, DATE_TO, formulas, instructions) attached to a business concept, and that its identity is anchored by a surrogate key rather than by a purely transactional relationship. Analysts modeling an EDW around EBS HR should therefore treat it as a descriptive satellite keyed to an assessment-type hub, with the rating and weighting scales resolved as separate referenced satellites.

Key Information Stored

The table is documented with 48 columns in the 12.2.2 physical schema. The most consequential for integration and reporting are:

• ASSESSMENT_TYPE_ID — surrogate primary key (PER_ASSESSMENT_TYPES_PK); the join key from all dependent transactional tables.
• NAME and BUSINESS_GROUP_ID — together form the unique business key (PER_ASSESSMENT_TYPES_UK1). NAME is the user-visible template label; BUSINESS_GROUP_ID scopes the definition to an HR business group.
• ASSESSMENT_CLASSIFICATION and TYPE — classify what kind of assessment the template represents (for example, competency versus objective scoring behavior).
• RATING_SCALE_ID and WEIGHTING_SCALE_ID — foreign keys to PER_RATING_SCALES defining the rating and weighting scales applied when the template is used.
• WEIGHTING_CLASSIFICATION — controls how item weights are aggregated.
• LINE_SCORE_FORMULA_ID, LINE_SCORE_FORMULA, and TOTAL_SCORE_FORMULA — the calculation logic used to derive line-level and total scores.
• DATE_FROM and DATE_TO — effective-dating window for the template definition.
• AVAILABLE_FLAG — indicates whether the template is selectable by end users.
• DISPLAY_ASSESSMENT_COMMENTS, RATING_SCALE_COMMENT, WEIGHTING_SCALE_COMMENT, INSTRUCTIONS, DESCRIPTION, and COMMENTS — presentation and guidance text surfaced to appraisers and appraises.
• DEFAULT_JOB_COMPETENCIES — controls defaulting behavior for job-linked competencies.
• OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — standard EBS concurrency and audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20 — the descriptive flexfield segment set.

Common Use Cases and Queries

Typical reporting needs center on template inventories, template-to-scale traceability, and detecting unused or expired definitions.

Inventory of active templates for a business group:

• SELECT assessment_type_id, name, assessment_classification, available_flag, date_from, date_to FROM per_assessment_types WHERE business_group_id = :p_bg_id AND TRUNC(SYSDATE) BETWEEN NVL(date_from, TRUNC(SYSDATE)) AND NVL(date_to, TRUNC(SYSDATE));

Resolving the scales used by each template:

• SELECT a.name, r.name rating_scale, w.name weighting_scale FROM per_assessment_types a, per_rating_scales r, per_rating_scales w WHERE a.rating_scale_id = r.rating_scale_id(+) AND a.weighting_scale_id = w.rating_scale_id(+) AND a.assessment_type_id = :p_id;

Impact analysis — which appraisal templates and competence elements reference a given assessment type:

• SELECT 'APPRAISAL' src, template_id id FROM per_appraisal_templates WHERE assessment_type_id = :p_id UNION ALL SELECT 'OBJECTIVE', template_id FROM per_appraisal_templates WHERE objective_asmnt_type_id = :p_id UNION ALL SELECT 'COMPETENCE', competence_element_id FROM per_competence_elements WHERE assessment_type_id = :p_id;

Usage volumetrics, to identify templates never instantiated:

• SELECT a.name, COUNT(s.assessment_id) uses FROM per_assessment_types a, per_assessments s WHERE a.assessment_type_id = s.assessment_type_id(+) GROUP BY a.name ORDER BY uses DESC;

Related Objects

• HR_ALL_ORGANIZATION_UNITS — referenced by PER_ASSESSMENT_TYPES.BUSINESS_GROUP_ID; provides the business group owning each template.
• PER_RATING_SCALES — referenced twice, via RATING_SCALE_ID and WEIGHTING_SCALE_ID, supplying the scoring and weighting scales.
• PER_APPRAISAL_TEMPLATES — references PER_ASSESSMENT_TYPES twice, through ASSESSMENT_TYPE_ID and OBJECTIVE_ASMNT_TYPE_ID, binding appraisal layouts to scoring templates.
• PER_ASSESSMENTS — references ASSESSMENT_TYPE_ID; stores the actual assessment instances created from a template.
• PER_COMPETENCE_ELEMENTS — references ASSESSMENT_TYPE_ID; links competence definitions to their scoring template.

These five tables constitute the complete documented dependency set for PER_ASSESSMENT_TYPES in ETRM 12.2.2, defining both its reference context and its downstream transactional footprint.