NOTIF_ID |
Base Object | TEXT_MSG_NOTIF |
Attribute Name | NOTIF_ID |
ColumnName | NOTIF_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
NOTIF_ID Column Properties |
Datatype | NUMBER |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
NOTIF_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
NOTIF_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
NOTIF_ID Security Types |
Name | Current Value |
NOTIF_ID Bound Attachments |
Name | Current Value |
NOTIF_ID Data Movement Rules |
Name | Type | Rule Text/Value |
NOTIF_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
NS_OPER (Oracle) TEXT_MSG_NOTIF NOTIF_ID |
NO |
NOTIF_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
NOTIF_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
NOTIF_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
NOTIF_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
STATUS_CD |
Base Object | TEXT_MSG_NOTIF |
Attribute Name | STATUS_CD |
ColumnName | STATUS_CD |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
STATUS_CD Column Properties |
Datatype | VARCHAR2(1) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
STATUS_CD Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
STATUS_CD Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
STATUS_CD Security Types |
Name | Current Value |
STATUS_CD Bound Attachments |
Name | Current Value |
STATUS_CD Data Movement Rules |
Name | Type | Rule Text/Value |
STATUS_CD Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
NS_OPER (Oracle) TEXT_MSG_NOTIF STATUS_CD |
NO |
STATUS_CD Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
STATUS_CD Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
STATUS_CD Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
STATUS_CD Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SUBJ |
Base Object | TEXT_MSG_NOTIF |
Attribute Name | SUBJ |
ColumnName | SUBJ |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
SUBJ Column Properties |
Datatype | VARCHAR2(30) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SUBJ Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 30 |
Percent Null | 0 |
SUBJ Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SUBJ Security Types |
Name | Current Value |
SUBJ Bound Attachments |
Name | Current Value |
SUBJ Data Movement Rules |
Name | Type | Rule Text/Value |
SUBJ Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
NS_OPER (Oracle) TEXT_MSG_NOTIF SUBJ |
NO |
SUBJ Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SUBJ Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SUBJ Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SUBJ Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MSG_TXT |
Base Object | TEXT_MSG_NOTIF |
Attribute Name | MSG_TXT |
ColumnName | MSG_TXT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
MSG_TXT Column Properties |
Datatype | VARCHAR2(160) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
MSG_TXT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 160 |
Percent Null | 0 |
MSG_TXT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MSG_TXT Security Types |
Name | Current Value |
MSG_TXT Bound Attachments |
Name | Current Value |
MSG_TXT Data Movement Rules |
Name | Type | Rule Text/Value |
MSG_TXT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
NS_OPER (Oracle) TEXT_MSG_NOTIF MSG_TXT |
NO |
MSG_TXT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MSG_TXT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MSG_TXT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MSG_TXT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CREATE_DTE |
Base Object | TEXT_MSG_NOTIF |
Attribute Name | CREATE_DTE |
ColumnName | CREATE_DTE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
CREATE_DTE Column Properties |
Datatype | DATE |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CREATE_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
CREATE_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CREATE_DTE Security Types |
Name | Current Value |
CREATE_DTE Bound Attachments |
Name | Current Value |
CREATE_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
CREATE_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
NS_OPER (Oracle) TEXT_MSG_NOTIF CREATE_DTE |
NO |
CREATE_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CREATE_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CREATE_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CREATE_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CREATE_USR |
Base Object | TEXT_MSG_NOTIF |
Attribute Name | CREATE_USR |
ColumnName | CREATE_USR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
CREATE_USR Column Properties |
Datatype | VARCHAR2(30) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CREATE_USR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 30 |
Percent Null | 0 |
CREATE_USR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CREATE_USR Security Types |
Name | Current Value |
CREATE_USR Bound Attachments |
Name | Current Value |
CREATE_USR Data Movement Rules |
Name | Type | Rule Text/Value |
CREATE_USR Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
NS_OPER (Oracle) TEXT_MSG_NOTIF CREATE_USR |
NO |
CREATE_USR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CREATE_USR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CREATE_USR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CREATE_USR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
FACIL_ID |
Base Object | TEXT_MSG_NOTIF |
Attribute Name | FACIL_ID |
ColumnName | FACIL_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
FACIL_ID Column Properties |
Datatype | VARCHAR2(10) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
FACIL_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
FACIL_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
FACIL_ID Security Types |
Name | Current Value |
FACIL_ID Bound Attachments |
Name | Current Value |
FACIL_ID Data Movement Rules |
Name | Type | Rule Text/Value |
FACIL_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
NS_OPER (Oracle) TEXT_MSG_NOTIF FACIL_ID |
NO |
FACIL_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
FACIL_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
FACIL_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
FACIL_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |