5        User Defined Properties

The User Defined Properties (UDP) is a key-value pair that can be assigned at both the Table level and Column level. To the UDPs, the values assigned must always be 0 or 1, Yes or No, Y or N. Oracle recommends that you extend the OFSAA data model, start a new UDP field to track whether a new table or column added is Customer site-specific or not. This ensures a seamless way to identify site-specific changes.

NOTE:   

When creating a new UDP, follow these suggestions:

·        Ensure that the UDP name represents the customer name.

·        Use the default value for this UDP as N or No or 0 to ensure that you edit only the newly added and modified and that the rest of the data model contains the default standard value.

·        Use this UDP when generating erwin reports to identify site-specific changes.

Topics:

·        Table UDP Names and Table UDP Definitions

·        Column UDP Names and Column UDP Definitions

Table UDP Names and Table UDP Definitions

This section provides information about the Table UDP names and Table UDP definitions in the OFSDF and OIDF data models.

Topics:

·        Table UDP Names and Definitions in the OFSDF Data Model

·        Table UDP Names and Definitions in the OIDF Data Model

Table UDP Names and Definitions in OFSDF Data Model

This section provides information about the Table UDP names and Table UDP definitions in the OFSDF data model.

NOTE:   

For the OFSAA application specific UDPs, see the application specific User Guide and related product documents.

Table UDP Names and Definitions in the OIDF Data Model

This section provides information about the Table UDP names and Table UDP definitions in the OIDF data model.

Column UDP Names and Column UDP Definitions

This section provides information about the Column UDP names and Column UDP definitions in the OFSDF and OIDF data models.

Topics:

·        Column UDP Names and Definitions in the OFSDF Data Model

·        Column UDP Names and Definitions in the OIDF Data Model

Column UDP Names and Definitions in OFSDF Data Model

This section provides information about the Column UDP names and Column UDP definitions in the OFSDF data model.

Column UDP Names and Definitions in the OIDF Data Model

This section provides information about the Column UDP names and Column UDP definitions in the OIDF data model.