Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | PREFERENCE_SET_USAGE |
| Short Name | PRU |
| View Name | CI_PREFERENCE_SET_USAGES |
| Description | A preference set usage indicates that a specific set of generator |
| preferences (PREFERENCE_SET) is used by a particular element. | |
| The subset of element types to which a preference set usage can | |
| refer are DOMAIN, TABLE_DEFINITION, CONSTRAINT, COLUMN, MODULE, | |
| MODULE_DETAILED_TABLE_USAGE, CONSTRAINT_USAGE, ITEM_GROUP and | |
| MODULE_DETAILED_COLUMN_USAGE and APPLICATION_SYSTEM. | |
| Sub-type of | INTERSECTION |
| Versioning: | Belongs to: APPLICATION_SYSTEM versionable object BATCH versionable object DOMAIN versionable object FOLDER versionable object GENERAL_MODULE versionable object ORACLE_OBJECT_TYPE versionable object RECORD versionable object REUSABLE_LOV versionable object REUSABLE_MCO versionable object SNAPSHOT_DEFINITION versionable object TABLE_DEFINITION versionable object VIEW_DEFINITION versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
PREFERENCE_SET_REFERENCE PREFERENCE_SET_USAGE_FOR |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_PRU |
| Changes: | Summary of changes to PREFERENCE_SET_USAGE in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| CIELEMENT_REFERENCE | N |
Prompt: Element
Transferable only if null |
Must be for one and only one CIELEMENT | 128 |
| PREFERENCE_SET_REFERENCE | N |
Prompt: Preference Set
Transferable only if null |
Must be of one and only one PREFERENCE_SET | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| PREFERENCE_SET_USAGE_FOR | VARCHAR2(6) | N | Arc 128 discriminator. Internal property indicating type of element that this preference set usage is for (DOM, MCO, ITE etc)
Not displayed Uppercase Updatable only if null | PREFERENCE_SET_USAGE_FOR | |
| PARENT_IVID | NUMBER(38, 0) | Y | Internal use only. Common repository version identifier of owning PAC
Not displayed System maintained Updatable only if null Defined on SE supertype | ||
| PAC_REFERENCE | NUMBER(38, 0) | Y | Internal use only. Contains the IRID of the PAC for the "versionable object" to which this element belongs
Not displayed System maintained Not updatable by user Defined on SE supertype | ||
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| Other Properties |
|---|
The following 'standard' properties are also inherited by all element types:
|
Other element types that reference PREFERENCE_SET_USAGE:
Note: