Early Access: The content on this website is provided for informational purposes only in connection with pre-General Availability Qlik Products.
All content is subject to change and is provided without warranty.
Skip to main content
Qlik Resources

Reserved column names

The following section lists the reserved column names. If the any of the discovered tables contain columns with these names, you need to rename them in Compose. For information on renaming columns, see Managing attributes.

  • BIR_MAPPING_NR - internal mapping identifier used in staging tables for ETL
  • ROWNR - internal row identifier used in staging tables for ETL
  • RUNNO_INSERT - The task run number for INSERT operations.
  • RUNNO_UPDATE - The task run number for UPDATE operations.
  • OBSOLETE__INDICATION - Used to mark OBSOLETE records in data mart objects. See also: The "Obsolete" indicator
  • TR_ID - The unique Transaction ID for a fact table record.
  • BID_OCCS - Internal column used in ETL processing.

  • FD - This column is added to tables that contain attributes (columns) with a History Type 2. The column is used to delimit the range of dates for a given record version. The column name can be changed in the project settings.

    Information noteIf you change the "From Date" name in the project settings, the new name will become a reserved word.

  • TD - This column is added to tables that contain attributes (columns) with a History Type 2. The column is used to delimit the range of dates for a given record version. The column name can be changed in the project settings.

    Information noteIf you change the "To Date" name in the project settings, the new name will become a reserved word.
  • FKNR - Foreign key number column used in logging tables to report missing references captured via the data warehouse ETL

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here