Search Results hr_canvas_properties_b_uk

Overview

HR.HR_CANVAS_PROPERTIES is a Human Resources (PER) product table that stores canvas properties for configurable forms in Oracle E-Business Suite. In the Oracle EBS configurable forms framework, a "canvas" is the runtime presentation surface on which fields, regions, and information blocks are rendered. This table persists the presentation attributes — dimensions, positioning, visibility, and supplementary information slots — that govern how each canvas is displayed to the end user. It is a core metadata component of the extensibility layer that allows administrators to tailor standard HR forms without modifying the underlying form definitions.

From a dimensional modeling perspective, the ETRM metadata classifies this object heuristically as a link table. This classification is a modeling suggestion: the table's two foreign keys to HR_FORM_CANVASES_B and HR_TEMPLATE_CANVASES_B position it as an associative entity that resolves relationships between form-level canvases and template-level canvases. It should not be treated as an independent hub of business entities.

Key Information Stored

The table carries 46 documented columns. The most operationally significant are:

• CANVAS_PROPERTY_ID — the surrogate primary key column, defining the HR_CANVAS_PROPERTIES_PK index (composite with ZD_EDITION_NAME in 12.2.2).
• FORM_CANVAS_ID — foreign key to HR_FORM_CANVASES_B, identifying the form-specific canvas instance.
• TEMPLATE_CANVAS_ID — foreign key to HR_TEMPLATE_CANVASES_B, identifying the source template canvas from which the form canvas derives.
• HEIGHT, WIDTH, X_POSITION, Y_POSITION — geometric attributes controlling canvas size and on-screen placement.
• VISIBLE — display flag governing whether the canvas is rendered.
• INFORMATION_CATEGORY — categorical descriptor classifying the canvas information block.
• INFORMATION1 through INFORMATION30 — thirty generic descriptor columns holding configurable attribute values.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.
• OBJECT_VERSION_NUMBER — optimistic locking control.
• ZD_EDITION_NAME — editioning discriminator supporting Online Patching in 12.2.x.

Two unique indexes are documented: the business-key candidate HR_CANVAS_PROPERTIES_B_UK over (FORM_CANVAS_ID, TEMPLATE_CANVAS_ID, CANVAS_PROPERTY_ID, ZD_EDITION_NAME), and the primary key HR_CANVAS_PROPERTIES_PK over (CANVAS_PROPERTY_ID, ZD_EDITION_NAME).

Common Use Cases and Queries

Typical usage centers on inspecting, auditing, or migrating configurable form layouts. Administrators may query canvas geometry for a given form to diagnose display problems, compare template and form canvases to detect customization drift, or extract property configurations for documentation and change control.

A representative query joining the canvas property row to its form and template parents:

• SELECT cp.CANVAS_PROPERTY_ID, cp.HEIGHT, cp.WIDTH, cp.X_POSITION, cp.Y_POSITION, cp.VISIBLE, fb.FORM_CANVAS_NAME, tb.TEMPLATE_CANVAS_NAME FROM HR.HR_CANVAS_PROPERTIES cp JOIN HR.HR_FORM_CANVASES_B fb ON fb.FORM_CANVAS_ID = cp.FORM_CANVAS_ID JOIN HR.HR_TEMPLATE_CANVASES_B tb ON tb.TEMPLATE_CANVAS_ID = cp.TEMPLATE_CANVAS_ID WHERE cp.VISIBLE = 'Y';
• Reporting on layout coverage: a count of properties grouped by INFORMATION_CATEGORY to validate consistent configuration across canvases.
• Migration comparison: a self-join or set operation contrasting properties between two editions using ZD_EDITION_NAME.

Because the INFORMATION1–30 columns are generically typed, reporting queries should pair them with the form and template parent records to give the values interpretive context.

Related Objects

• HR_FORM_CANVASES_B — parent table; joined on FORM_CANVAS_ID.
• HR_TEMPLATE_CANVASES_B — parent table; joined on TEMPLATE_CANVAS_ID.
• HR_CANVAS_PROPERTIES_PK — primary key index on CANVAS_PROPERTY_ID and ZD_EDITION_NAME.
• HR_CANVAS_PROPERTIES_B_UK — business-key unique index governing the (FORM_CANVAS_ID, TEMPLATE_CANVAS_ID, CANVAS_PROPERTY_ID) combination.
• Related configurable-form metadata tables in the HR schema that share the template and form canvas lineage, used together when resolving full canvas definitions.

Dependencies on this table flow upward into the configurable forms runtime, which reads canvas properties to render HR forms dynamically for each user session.