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 |