FUNC_ID |
Base Object | DIAG_CHART_MATH_FUNC_ASGN |
Attribute Name | Function Identifier |
ColumnName | FUNC_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
Note |
FUNC_ID Column Properties |
Datatype | VARCHAR2(255) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
FUNC_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
FUNC_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
FUNC_ID Security Types |
Name | Current Value |
FUNC_ID Bound Attachments |
Name | Current Value |
FUNC_ID Data Movement Rules |
Name | Type | Rule Text/Value |
FUNC_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Diagnostics Chart Math Function Assignment Function Identifier |
NO | ||
Watchman (Oracle) DIAG_CHART_MATH_FUNC_ASGN FUNC_ID |
NO |
FUNC_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
FUNC_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
FUNC_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
FUNC_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CHART_ID |
Base Object | DIAG_CHART_MATH_FUNC_ASGN |
Attribute Name | Chart Identifier |
ColumnName | CHART_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
CHART_ID Column Properties |
Datatype | VARCHAR2(50) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CHART_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 50 |
Percent Null | 0 |
CHART_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CHART_ID Security Types |
Name | Current Value |
CHART_ID Bound Attachments |
Name | Current Value |
CHART_ID Data Movement Rules |
Name | Type | Rule Text/Value |
CHART_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Diagnostics Chart Math Function Assignment Chart Identifier |
NO | ||
Watchman (Oracle) DIAG_CHART_MATH_FUNC_ASGN CHART_ID |
NO |
CHART_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CHART_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CHART_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CHART_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
FUNC_VAL1 |
Base Object | DIAG_CHART_MATH_FUNC_ASGN |
Attribute Name | Function Value 1 |
ColumnName | FUNC_VAL1 |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
FUNC_VAL1 Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
FUNC_VAL1 Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
FUNC_VAL1 Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
FUNC_VAL1 Security Types |
Name | Current Value |
FUNC_VAL1 Bound Attachments |
Name | Current Value |
FUNC_VAL1 Data Movement Rules |
Name | Type | Rule Text/Value |
FUNC_VAL1 Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Diagnostics Chart Math Function Assignment Function Value 1 |
NO | ||
Watchman (Oracle) DIAG_CHART_MATH_FUNC_ASGN FUNC_VAL1 |
NO |
FUNC_VAL1 Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
FUNC_VAL1 Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
FUNC_VAL1 Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
FUNC_VAL1 Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
FUNC_VAL2 |
Base Object | DIAG_CHART_MATH_FUNC_ASGN |
Attribute Name | Function Value 2 |
ColumnName | FUNC_VAL2 |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
FUNC_VAL2 Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
FUNC_VAL2 Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
FUNC_VAL2 Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
FUNC_VAL2 Security Types |
Name | Current Value |
FUNC_VAL2 Bound Attachments |
Name | Current Value |
FUNC_VAL2 Data Movement Rules |
Name | Type | Rule Text/Value |
FUNC_VAL2 Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Diagnostics Chart Math Function Assignment Function Value 2 |
NO | ||
Watchman (Oracle) DIAG_CHART_MATH_FUNC_ASGN FUNC_VAL2 |
NO |
FUNC_VAL2 Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
FUNC_VAL2 Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
FUNC_VAL2 Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
FUNC_VAL2 Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
APP_ORD |
Base Object | DIAG_CHART_MATH_FUNC_ASGN |
Attribute Name | Application Order |
ColumnName | APP_ORD |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Application Order: Should the data need to be transformed by more than one function indicate in what order they functions should be applied. |
Note |
APP_ORD Column Properties |
Datatype | NUMBER(1, 0) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
APP_ORD Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
APP_ORD Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 1 |
Bound Default |
APP_ORD Security Types |
Name | Current Value |
APP_ORD Bound Attachments |
Name | Current Value |
APP_ORD Data Movement Rules |
Name | Type | Rule Text/Value |
APP_ORD Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Diagnostics Chart Math Function Assignment Application Order |
NO | ||
Watchman (Oracle) DIAG_CHART_MATH_FUNC_ASGN APP_ORD |
NO |
APP_ORD Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
APP_ORD Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
APP_ORD Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
APP_ORD Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |