Record Definitions

When extending the Oracle Health Insurance table, extend a free field, or a detailed entity. To set up that detail entity, first, configure a dynamic record definition. A dynamic record definition specifies what those details look like.

Dynamic record has the following attributes:

Table 1. Record Definitions

Field	Description
Code	The unique identifier of the dynamic record definition
Description	The description visible in, for example, pull down menus
Reference Sheet?	Is the dynamic record definition to be used by a reference sheet?

Record Field Usages define the columns in a dynamic record. A record field usage has the following attributes:

Table 2. Record Field Attributes

Field	Description
Name	The unique column name (within the record) in the object model
Field	Specifies the date type, length, decimals and other applicable validations
Code Definition	Specifies the domain of allowable values
Display Name	The column header for the field when the record is displayed in a table view
Sequence	The default column position when the record displayed in table view
Key?	The key field of this record. A key field must have a unique value for all records. For time valid records, the key field must have a unique value at any point in time
Mandatory?	The column must have a value
PII?	The field contains Personal Identifiable Information (PII)
Table	Specifies the table that can be used as a pick list when inserting values through the UI.

A record field usage specifies either a field definition or a code definition. The code definition is used for menus with pre-defined set of values and the field definition is used for free format fields. A code definition is used for a menu with pre-defined values, For example, Yes and No and a field definition is used for free fields like a simple character string or a date.

The following business rules apply:

• Only one of the record definitions can represent the key value.

• The key value must be a free field.