Project Data Tables Database > td Schema : td.BUSINESS_VIEWS Table |
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
BV_ID | The record ID. | int | 4 | ||||
BV_LOGICAL_NAME | The string ID of the record. The logical name is used internally in ALM or ALM extensions. | varchar | 64 | ||||
BV_NAME | The name of the record. | varchar | 255 | ||||
BV_LABEL | The display label text. The display label text. | varchar | 255 | ||||
BV_IS_PUBLISHED | A value of Y indicates that the business view is published and can be used by grpahs or reports. | varchar | 1 | ||||
BV_DESCRIPTION | A description of the business view. | varchar | 16 | ||||
BV_DQL | The Data Query Language string that represents the view. | varchar | 16 | ||||
BV_COLUMN_LABEL_MAPPING | The column display label configuration of the business view. | varchar | 16 | ||||
BV_KEYWORDS | The keyword of the business view for searching and tagging. For future use. | varchar | 4000 |
Index | Description | Primary | Unique |
---|---|---|---|
BUSINESS_VIEWS_IX3 | |||
BUSINESS_VIEWS_LOGICAL_NAME | |||
BUSINESS_VIEWS_PK |