The Oracle Business Analytics Warehouse uses suffixes to indicate fields that must contain specific values.
| Suffix | Description | In Table Types |
|---|---|---|
|
_CODE |
Code field. (Especially used for domain codes.) |
_D, _DS, _FS, _G, _GS |
|
_DT |
Date field. |
_D, _DS, _FS, _G, _DHL, _DHLS |
|
_ID |
Correspond to the _WID columns of the corresponding _F table. |
_FS, _DS |
|
_FLG |
Indicator or Flag. |
_D, _DHL, _DS, _FS, _F, _G, _DHLS |
|
_WID |
Identifier generated by Oracle Business Intelligence linking dimension and fact tables, except for ROW_WID. |
_F, _A, _DHL |
|
_NAME |
A multi-language support column that holds the name associated with an attribute in all languages supported by the data warehouse. |
_TL |
|
_DESCR |
A multi-language support column that holds the description associated with an attribute in all languages supported by the data warehouse |
_TL |