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:
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:
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.