Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | USER_PREFERENCE |
| Short Name | UPR |
| View Name | CI_USER_PREFERENCES |
| Description | A user preference, also known as a "non-default user preference" |
| is the new value for a generator preference assigned by the user | |
| where he or she has a requirement it to be different to its | |
| shipped value. | |
| The element types for which user preferences can be created can be | |
| determined from the valid values of the property PREFERENCE_FOR | |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| 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 PREFERENCE_SET 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_NAME PREFERENCE_FOR |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_UPR |
| Changes: | Summary of changes to USER_PREFERENCE 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 | 124 |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| FROZEN_FLAG | VARCHAR2(1) | N | Indicates whether or not this preference value is frozen
Prompt: Frozen ? Uppercase | YESNO | N |
| PREFERENCE_FOR | VARCHAR2(6) | N | Arc 124 discriminator. Internal property indicating the type of element (GEM, MCO, ITE etc) the preference is for
Not displayed Uppercase Updatable only if null | PREFERENCE_FOR | |
| PREFERENCE_NAME | VARCHAR2(6) | N | Part 1 of 2-part foreign key to SYSCASE table CDI_DFLT_USER_PREF_USAGES. Joins to DUP_SNAME.
Prompt: Preference Name | ||
| PREFERENCE_VALUE | VARCHAR2(240) | Y | Value assigned to the preference by the user
Prompt: Value | ||
| PRODUCT_FLAVOR | VARCHAR2(10) | N | Part 2 of 2-part foreign key to SYSCASE table CDI_DFLT_USER_PREF_USAGES. Joins to P_SNAME
Not displayed Uppercase | PRODUCT_FLAVOR | |
| PARENT_IVID | NUMBER(38, 0) | Y | Internal use only. Exists on "secondary" element types from a versioning viewpoint. Contains the IVID of the primary element type (not necessarily a PAC) forming the basis of the "versionable object" to which this element type belongs
Not displayed System maintained Updatable only if null Defined on SAC supertype | ||
| PAC_REFERENCE | NUMBER(38, 0) | Y | Internal use only. Exists on "secondary" element types from a structural viewpoint. Contains the IRID of the PAC forming the basis of the "logical object" to which this element type belongs
Not displayed System maintained Not updatable by user Defined on SAC 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 USER_PREFERENCE:
Note: