| project_Context_Item_ID |
| Base Entity | Project_Context_Item |
| Attribute Name | project_Context_Item_ID |
| Logical Rolename | |
| ColumnName | project_Context_Item_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| project_Context_Item_ID Logical Attribute Properties |
| Logical Attribute Name | project_Context_Item_ID |
| Datatype | BIGINT |
| Nullable | NO |
| project_Context_Item_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| project_Context_Item_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Project_Context_Item project_Context_Item_ID |
NO | ||
| BARD_Dev (Oracle) Project_Context_Item project_Context_Item_ID |
NO |
| Project_Context_ID |
| Base Entity | Project_Context_Item |
| Attribute Name | Project_Context_ID |
| Logical Rolename | |
| ColumnName | Project_Context_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Project_Context_ID Logical Attribute Properties |
| Logical Attribute Name | Project_Context_ID |
| Datatype | BIGINT |
| Nullable | NO |
| Project_Context_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Project_Context_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Project_Context_Item Project_Context_ID |
NO | ||
| BARD_Dev (Oracle) Project_Context_Item PROJECT_CONTEXT_ID |
NO |
| Attribute_ID |
| Base Entity | Project_Context_Item |
| Attribute Name | Element_ID |
| Logical Rolename | Attribute_ID |
| ColumnName | Attribute_ID |
| RoleName | Attribute_ID |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Attribute_ID Logical Attribute Properties |
| Logical Attribute Name | Element_ID |
| Datatype | BIGINT |
| Nullable | NO |
| Attribute_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attribute_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Project_Context_Item Element_ID |
NO | ||
| BARD_Dev (Oracle) Project_Context_Item ATTRIBUTE_ID |
NO |
| Display_order |
| Base Entity | Project_Context_Item |
| Attribute Name | Display_order |
| Logical Rolename | |
| ColumnName | Display_order |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Display_order Logical Attribute Properties |
| Logical Attribute Name | Display_order |
| Datatype | NUMERIC(5, 0) |
| Nullable | NO |
| Display_order Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Display_order Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Project_Context_Item Display_order |
NO | ||
| BARD_Dev (Oracle) Project_Context_Item DISPLAY_ORDER |
NO |
| Value_ID |
| Base Entity | Project_Context_Item |
| Attribute Name | Element_ID |
| Logical Rolename | Value_ID |
| ColumnName | Value_ID |
| RoleName | Value_ID |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Value_ID Logical Attribute Properties |
| Logical Attribute Name | Element_ID |
| Datatype | BIGINT |
| Nullable | YES |
| Value_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Value_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Project_Context_Item Element_ID |
NO | ||
| BARD_Dev (Oracle) Project_Context_Item VALUE_ID |
NO |
| Ext_Value_ID |
| Base Entity | Project_Context_Item |
| Attribute Name | Ext_Value_ID |
| Logical Rolename | |
| ColumnName | Ext_Value_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Ext_Value_ID Logical Attribute Properties |
| Logical Attribute Name | Ext_Value_ID |
| Datatype | VARCHAR(60) |
| Nullable | YES |
| Ext_Value_ID Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Ext_Value_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Project_Context_Item Ext_Value_ID |
NO | ||
| BARD_Dev (Oracle) Project_Context_Item EXT_VALUE_ID |
NO |
| Qualifier |
| Base Entity | Project_Context_Item |
| Attribute Name | Qualifier |
| Logical Rolename | |
| ColumnName | Qualifier |
| RoleName | |
| Domain | qualifier |
| Logical Only | NO |
| Definition | |
| Note |
| Qualifier Logical Attribute Properties |
| Logical Attribute Name | Qualifier |
| Datatype | CHAR(2) |
| Nullable | YES |
| Qualifier Domain Restrictions |
| CheckConstraint | @var IN ('= ', '< ', '<=', '> ', '>=', '<<', '>>', '~ ') |
| Check Constraint Name | CK_PRJCT_CNTXT_ITEM_QUALIFIER |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Qualifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Project_Context_Item Qualifier |
NO | ||
| BARD_Dev (Oracle) Project_Context_Item QUALIFIER |
NO |
| Value_Display |
| Base Entity | Project_Context_Item |
| Attribute Name | Value_Display |
| Logical Rolename | |
| ColumnName | Value_Display |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | This is not a general text entry field, rather it is an easily displayable text version of the other value columns |
| Note |
| Value_Display Logical Attribute Properties |
| Logical Attribute Name | Value_Display |
| Datatype | VARCHAR(500) |
| Nullable | YES |
| Value_Display Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Value_Display Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Project_Context_Item Value_Display |
NO | ||
| BARD_Dev (Oracle) Project_Context_Item VALUE_DISPLAY |
NO |
| Value_num |
| Base Entity | Project_Context_Item |
| Attribute Name | Value_num |
| Logical Rolename | |
| ColumnName | Value_num |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Value_num Logical Attribute Properties |
| Logical Attribute Name | Value_num |
| Datatype | NUMERIC(30, 15) |
| Nullable | YES |
| Value_num Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Value_num Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Project_Context_Item Value_num |
NO | ||
| BARD_Dev (Oracle) Project_Context_Item VALUE_NUM |
NO |
| Value_Min |
| Base Entity | Project_Context_Item |
| Attribute Name | Value_Min |
| Logical Rolename | |
| ColumnName | Value_Min |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Value_Min Logical Attribute Properties |
| Logical Attribute Name | Value_Min |
| Datatype | NUMERIC(30, 15) |
| Nullable | YES |
| Value_Min Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Value_Min Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Project_Context_Item Value_Min |
NO | ||
| BARD_Dev (Oracle) Project_Context_Item VALUE_MIN |
NO |
| Value_Max |
| Base Entity | Project_Context_Item |
| Attribute Name | Value_Max |
| Logical Rolename | |
| ColumnName | value_Max |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Value_Max Logical Attribute Properties |
| Logical Attribute Name | Value_Max |
| Datatype | NUMERIC(30, 15) |
| Nullable | YES |
| Value_Max Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Value_Max Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Project_Context_Item Value_Max |
NO | ||
| BARD_Dev (Oracle) Project_Context_Item VALUE_MAX |
NO |
| Version |
| Base Entity | Project_Context_Item |
| Attribute Name | Version |
| Logical Rolename | |
| ColumnName | Version |
| RoleName | |
| Domain | Version |
| Logical Only | NO |
| Definition | |
| Note |
| Version Logical Attribute Properties |
| Logical Attribute Name | Version |
| Datatype | INTEGER |
| Nullable | NO |
| Version Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 0 |
| Bound Default |
| Version Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Project_Context_Item Version |
NO | ||
| BARD_Dev (Oracle) Project_Context_Item VERSION |
NO |
| Date_Created |
| Base Entity | Project_Context_Item |
| Attribute Name | Date_Created |
| Logical Rolename | |
| ColumnName | Date_Created |
| RoleName | |
| Domain | Date_Created |
| Logical Only | NO |
| Definition | |
| Note |
| Date_Created Logical Attribute Properties |
| Logical Attribute Name | Date_Created |
| Datatype | TIMESTAMP/DATE |
| Nullable | NO |
| Date_Created Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Date_Created Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Project_Context_Item Date_Created |
NO | ||
| BARD_Dev (Oracle) Project_Context_Item DATE_CREATED |
NO |
| Last_Updated |
| Base Entity | Project_Context_Item |
| Attribute Name | Last_Updated |
| Logical Rolename | |
| ColumnName | Last_Updated |
| RoleName | |
| Domain | Last_Updated |
| Logical Only | NO |
| Definition | |
| Note |
| Last_Updated Logical Attribute Properties |
| Logical Attribute Name | Last_Updated |
| Datatype | DATETIME |
| Nullable | YES |
| Last_Updated Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Last_Updated Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Project_Context_Item Last_Updated |
NO | ||
| BARD_Dev (Oracle) Project_Context_Item LAST_UPDATED |
NO |
| Modified_by |
| Base Entity | Project_Context_Item |
| Attribute Name | Modified_by |
| Logical Rolename | |
| ColumnName | Modified_by |
| RoleName | |
| Domain | Modified_by |
| Logical Only | NO |
| Definition | |
| Note |
| Modified_by Logical Attribute Properties |
| Logical Attribute Name | Modified_by |
| Datatype | VARCHAR(40) |
| Nullable | YES |
| Modified_by Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Modified_by Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Project_Context_Item Modified_by |
NO | ||
| BARD_Dev (Oracle) Project_Context_Item MODIFIED_BY |
NO |
| VALUE_TYPE |
| Base Entity | Project_Context_Item |
| Attribute Name | VALUE_TYPE |
| Logical Rolename | |
| ColumnName | VALUE_TYPE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| VALUE_TYPE Logical Attribute Properties |
| Logical Attribute Name | VALUE_TYPE |
| Datatype | VARCHAR(25) |
| Nullable | YES |
| VALUE_TYPE Domain Restrictions |
| CheckConstraint | value_type in ('numeric', 'element', 'external ontology', 'free text', 'range') | ||
| Check Constraint Name | CK_PCI_VALUE_TYPE | ||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| VALUE_TYPE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Project_Context_Item VALUE_TYPE |
NO | ||
| BARD_Dev (Oracle) Project_Context_Item VALUE_TYPE |
NO |