TMPL_ID |
Base Object | TEMPLATE |
Attribute Name | TMPL_ID |
ColumnName | TMPL_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
TMPL_ID Column Properties |
Datatype | VARCHAR2(50) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
TMPL_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 15 |
Percent Null | 0 |
TMPL_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TMPL_ID Security Types |
Name | Current Value |
TMPL_ID Bound Attachments |
Name | Current Value |
TMPL_ID Data Movement Rules |
Name | Type | Rule Text/Value |
TMPL_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Template TMPL_ID |
NO | ||
EPICS (Oracle) TEMPLATE TMPL_ID |
NO |
TMPL_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TMPL_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TMPL_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TMPL_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TMPL_DESC |
Base Object | TEMPLATE |
Attribute Name | TMPL_DESC |
ColumnName | TMPL_DESC |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
TMPL_DESC Column Properties |
Datatype | VARCHAR2(255) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
TMPL_DESC Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 100 |
TMPL_DESC Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TMPL_DESC Security Types |
Name | Current Value |
TMPL_DESC Bound Attachments |
Name | Current Value |
TMPL_DESC Data Movement Rules |
Name | Type | Rule Text/Value |
TMPL_DESC Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Template TMPL_DESC |
NO | ||
EPICS (Oracle) TEMPLATE TMPL_DESC |
NO |
TMPL_DESC Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TMPL_DESC Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TMPL_DESC Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TMPL_DESC Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EXT_SRC_FILE_NM |
Base Object | TEMPLATE |
Attribute Name | EXT_SRC_FILE_NM |
ColumnName | EXT_SRC_FILE_NM |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
EXT_SRC_FILE_NM Column Properties |
Datatype | VARCHAR2(100) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
EXT_SRC_FILE_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 81 |
Percent Null | 0 |
EXT_SRC_FILE_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EXT_SRC_FILE_NM Security Types |
Name | Current Value |
EXT_SRC_FILE_NM Bound Attachments |
Name | Current Value |
EXT_SRC_FILE_NM Data Movement Rules |
Name | Type | Rule Text/Value |
EXT_SRC_FILE_NM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Template EXT_SRC_FILE_NM |
NO | ||
EPICS (Oracle) TEMPLATE EXT_SRC_FILE_NM |
NO |
EXT_SRC_FILE_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EXT_SRC_FILE_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EXT_SRC_FILE_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EXT_SRC_FILE_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EXT_SRC_FILE_MOD_DTE |
Base Object | TEMPLATE |
Attribute Name | EXT_SRC_FILE_MOD_DTE |
ColumnName | EXT_SRC_FILE_MOD_DTE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
EXT_SRC_FILE_MOD_DTE Column Properties |
Datatype | DATE |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
EXT_SRC_FILE_MOD_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
EXT_SRC_FILE_MOD_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
EXT_SRC_FILE_MOD_DTE Security Types |
Name | Current Value |
EXT_SRC_FILE_MOD_DTE Bound Attachments |
Name | Current Value |
EXT_SRC_FILE_MOD_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
EXT_SRC_FILE_MOD_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Template EXT_SRC_FILE_MOD_DTE |
NO | ||
EPICS (Oracle) TEMPLATE EXT_SRC_FILE_MOD_DTE |
NO |
EXT_SRC_FILE_MOD_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EXT_SRC_FILE_MOD_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EXT_SRC_FILE_MOD_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EXT_SRC_FILE_MOD_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |