Results for “ghr_perf_cert”

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

Overview

GHR_PERF_CERT is a transactional table owned by the HR schema within the GHR – US Federal Human Resources product family in Oracle EBS 12.1.1 and 12.2.2. It stores performance certification records that support federal performance management and appraisal processes, allowing agencies to define certification periods, groups, and organizational scopes against which employee performance is validated. The table is documented as a Performance Certification table and is classified as VALID in the ETRM metadata.

From a heuristic Data Vault modeling perspective, GHR_PERF_CERT is classified as standalone. This classification, mined from its foreign key structure, suggests it functions effectively as a hub-like entity holding the unique certification identity, with its descriptive attributes (name, agency, group, type, dates) acting as satellite content attached to that business key. The only outbound foreign key relationship is CERT_ID referencing WF_DIG_CERTS, indicating a dependency on the workflow digital certificate infrastructure.

Key Information Stored

The table contains 16 documented columns. The surrogate primary key is CERT_ID, a system-generated identifier for each certification record. Business-key uniqueness is enforced by the unique index GHR_PERF_CERT_U1, which spans CERT_AGENCY, CERT_GROUP, CERT_START_DATE, CERT_END_DATE, and BUSINESS_GROUP_ID — meaning a certification is uniquely identified within an agency and group across a defined date range and business group.

• CERT_ID – Surrogate primary key; also the FK to WF_DIG_CERTS.
• CERT_NAME – Descriptive name of the performance certification.
• CERT_AGENCY – Federal agency associated with the certification; part of the business key.
• CERT_AGENCY_SUB_CODE – Agency sub-code for finer organizational granularity.
• CERT_ORGANIZATION – Organization to which the certification applies.
• CERT_GROUP – Grouping identifier within the agency; part of the business key.
• CERT_TYPE – Category or type of certification.
• CERT_START_DATE / CERT_END_DATE – Validity window of the certification; both are business-key components.
• BUSINESS_GROUP_ID – Multi-tenant partition key; part of the unique index.
• OBJECT_VERSION_NUMBER – Optimistic locking version for concurrent updates.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard WHO audit columns.

Common Use Cases and Queries

Typical scenarios include listing active certifications for an agency, validating certification coverage for a performance appraisal cycle, and reconciling certification records against workflow digital certificates. A representative query listing current certifications:

• SELECT cert_id, cert_name, cert_agency, cert_group, cert_start_date, cert_end_date FROM ghr_perf_cert WHERE TRUNC(SYSDATE) BETWEEN cert_start_date AND cert_end_date AND business_group_id = :p_bg_id;
• Join to WF_DIG_CERTS for certificate metadata: SELECT p.cert_name, d.* FROM ghr_perf_cert p, wf_dig_certs d WHERE p.cert_id = d.cert_id;
• Reporting by agency and group: SELECT cert_agency, cert_group, COUNT(*) FROM ghr_perf_cert GROUP BY cert_agency, cert_group;

Related Objects

• WF_DIG_CERTS – Referenced via CERT_ID; supplies digital certificate details for each performance certification.
• HR_ALL_ORGANIZATION_UNITS – Provides organization context for CERT_ORGANIZATION.
• HR_OPERATING_UNITS / BUSINESS_GROUP_ID consumers – BUSINESS_GROUP_ID aligns records with the multi-tenant HR business group model.
• PER_* performance appraisal tables – Integration point where certifications validate appraisal eligibility.
• FND_USER / audit consumers – WHO columns integrate with standard EBS auditing.