Data Definition Identifer |
Base Entity | Chart Data Definition |
Attribute Name | Data Definition Identifer |
Logical Rolename | |
ColumnName | DATA_DEF_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Data Definition Identifer: Identifer for the data retrieval source. |
Note |
Data Definition Identifer Logical Attribute Properties |
Logical Attribute Name | Data Definition Identifer |
Datatype | VARCHAR(25) |
Nullable | NO |
Data Definition Identifer Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Data Definition Identifer Security Types |
Name | Current Value |
Data Definition Identifer Bound Attachments |
Name | Current Value |
Data Definition Identifer Data Movement Rules |
Name | Type | Rule Text/Value |
Data Definition Identifer Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Chart Data Definition Data Definition Identifer |
NO | ||
Watchman (Oracle) CHART_DATA_DEF DATA_DEF_ID |
NO |
Data Definition Identifer Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Data Definition Identifer Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Data Definition Identifer Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Data Definition Identifer Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Description |
Base Entity | Chart Data Definition |
Attribute Name | Description |
Logical Rolename | |
ColumnName | DESCR |
RoleName | |
Domain | Description |
Logical Only | NO |
Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
Note |
Description Logical Attribute Properties |
Logical Attribute Name | Description |
Datatype | VARCHAR(255) |
Nullable | NO |
Description Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Description Security Types |
Name | Current Value |
Description Bound Attachments |
Name | Current Value |
Description Data Movement Rules |
Name | Type | Rule Text/Value |
Description Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Chart Data Definition Description |
NO | ||
Watchman (Oracle) CHART_DATA_DEF DESCR |
NO |
Description Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Description Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Description Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Description Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Source Type |
Base Entity | Chart Data Definition |
Attribute Name | Source Type |
Logical Rolename | |
ColumnName | SRC_TYPE |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Source Type: The method of data retrieval, SQL or a stored procedure. |
Note |
Source Type Logical Attribute Properties |
Logical Attribute Name | Source Type |
Datatype | CHAR(1) |
Nullable | NO |
Source Type Domain Restrictions |
CheckConstraint | src_type in ('S','F') | ||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | 'S' | ||
Bound Default |
Source Type Security Types |
Name | Current Value |
Source Type Bound Attachments |
Name | Current Value |
Source Type Data Movement Rules |
Name | Type | Rule Text/Value |
Source Type Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Chart Data Definition Source Type |
NO | ||
Watchman (Oracle) CHART_DATA_DEF SRC_TYPE |
NO |
Source Type Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Source Type Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Source Type Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Source Type Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Source |
Base Entity | Chart Data Definition |
Attribute Name | Source |
Logical Rolename | |
ColumnName | SRC |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Source: The acutal SQL statement or function call. |
Note |
Source Logical Attribute Properties |
Logical Attribute Name | Source |
Datatype | VARCHAR(4000) |
Nullable | NO |
Source Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Source Security Types |
Name | Current Value |
Source Bound Attachments |
Name | Current Value |
Source Data Movement Rules |
Name | Type | Rule Text/Value |
Source Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Chart Data Definition Source |
NO | ||
Watchman (Oracle) CHART_DATA_DEF SRC |
NO |
Source Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Source Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Source Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Source Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |