| DATA_DEF_ID |
| Base Object | CHART_DATA_DEF |
| Attribute Name | Data Definition Identifer |
| ColumnName | DATA_DEF_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Data Definition Identifer: Identifer for the data retrieval source. |
| Note |
| DATA_DEF_ID Column Properties |
| Datatype | VARCHAR2(25) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DATA_DEF_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 25 |
| Percent Null | 0 |
| DATA_DEF_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DATA_DEF_ID Security Types |
| Name | Current Value |
| DATA_DEF_ID Bound Attachments |
| Name | Current Value |
| DATA_DEF_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| DATA_DEF_ID 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_DEF_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DATA_DEF_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DATA_DEF_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DATA_DEF_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DESCR |
| Base Object | CHART_DATA_DEF |
| Attribute Name | Description |
| ColumnName | DESCR |
| Logical Rolename | |
| RoleName | |
| Domain | Description |
| Physical Only | NO |
| Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
| Note |
| DESCR Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DESCR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| DESCR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DESCR Security Types |
| Name | Current Value |
| DESCR Bound Attachments |
| Name | Current Value |
| DESCR Data Movement Rules |
| Name | Type | Rule Text/Value |
| DESCR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Chart Data Definition Description |
NO | ||
| Watchman (Oracle) CHART_DATA_DEF DESCR |
NO |
| DESCR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DESCR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DESCR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DESCR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SRC_TYPE |
| Base Object | CHART_DATA_DEF |
| Attribute Name | Source Type |
| ColumnName | SRC_TYPE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Source Type: The method of data retrieval, SQL or a stored procedure. |
| Note |
| SRC_TYPE Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SRC_TYPE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| SRC_TYPE Domain Restrictions |
| CheckConstraint | src_type in ('S','F') |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'S' |
| Bound Default |
| SRC_TYPE Security Types |
| Name | Current Value |
| SRC_TYPE Bound Attachments |
| Name | Current Value |
| SRC_TYPE Data Movement Rules |
| Name | Type | Rule Text/Value |
| SRC_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 |
| SRC_TYPE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SRC_TYPE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SRC_TYPE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SRC_TYPE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SRC |
| Base Object | CHART_DATA_DEF |
| Attribute Name | Source |
| ColumnName | SRC |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Source: The acutal SQL statement or function call. |
| Note |
| SRC Column Properties |
| Datatype | VARCHAR2(4000) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SRC Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4000 |
| Percent Null | 0 |
| SRC Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SRC Security Types |
| Name | Current Value |
| SRC Bound Attachments |
| Name | Current Value |
| SRC Data Movement Rules |
| Name | Type | Rule Text/Value |
| SRC Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Chart Data Definition Source |
NO | ||
| Watchman (Oracle) CHART_DATA_DEF SRC |
NO |
| SRC Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SRC Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SRC Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SRC Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |